[Free] 2019(Nov) EnsurePass Oracle 1z0-061 Dumps with VCE and PDF 131-140

Get Full Version of the Exam
http://www.EnsurePass.com/1z0-061.html

Question No.131

Examine the structure of the STUDENTS table:

image

You need to create a report of the 10 students who achieved the highest ranking in the course INT SQL and who completed the course in the year 1999.

Which SQL statement accomplishes this task?

  1. SELECT . student_ id, marks, ROWNUM quot;Rankquot;FROM . studentsWHERE . ROWNUM lt;= 10AND

    . finish_date BETWEEN #39;01-JAN-99#39; AND #39;31-DEC-99AND . course_id = #39;INT_SQL#39;ORDER BY .

    marks DESC;

  2. SELECT . student_id, marks, ROWID quot;Rankquot;. FROM . students. WHERE . ROWID lt;= 10. AND . finish_date BETWEEN #39;01-JAN-99#39; AND #39;31-DEC-99#39;. AND . course_id = #39;INT_SQL#39;. ORDER BY . marks;

  3. SELECT . student_id, marks, ROWNUM quot;Rankquot;. FROM . (SELECT student_id, marks. FROM . students. WHERE . ROWNUM lt;= 10. AND . finish_date BETWEEN #39;01-JAN-99#39; AND #39;31-DEC-. 99#39;. AND . course_id = #39;INT_SQL#39;. ORDER BY . marks DESC);

  4. SELECT . student_id, marks, ROWNUM quot;Rank鈥? FROM . (SELECT student_id, marks. FROM . students. WHERE (finish_date BETWEEN 鈥?1-JAN-99 AND 鈥?1-DEC-99鈥? AND course_id = 鈥業NT_SQL鈥? ORDER BY marks DESC). WHERE . ROWNUM lt;= 10 ;.

  5. SELECT. student id, marks, ROWNUM 鈥淩ank鈥? FROM. (SELECT student_id, marks. FROM students. ORDER BY marks). WHERE. ROWNUM lt;= 10. AND. finish date BETWEEN 鈥?1-JAN- 99鈥?AND 鈥?1-DEC-99鈥? AND. course_id = 鈥業NT_SQL鈥?

Correct Answer: D

Question No.132

Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

  1. By default, EM express is available for a database after database creation.

  2. You can use EM express to manage multiple databases running on the same server.

  3. You can perform basic administrative tasks for pluggable databases by using the EM express interface.

  4. You cannot start up or shut down a database Instance by using EM express.

  5. You can create and configure pluggable databases by using EM express.

Correct Answer: D

Explanation:

Enterprise Manager Database Express is available only when the database is open so Enterprise Manager Database Express cannot be used to start up the database. Other operations that require that the database change state, such as enable or disable ARCHIVELOG mode, are also not available in Enterprise Manager Database Express.

Question No.133

Which is an iSQL*Plus command?

  1. INSERT

  2. UPDATE

  3. SELECT

  4. DESCRIBE

  5. DELETE

  6. RENAME

Correct Answer: D

Explanation:

The only SQL*Plus command in this list: DESCRIBE. It cannot be used as SQL command. This command returns a description of tablename, including all columns in that table, the datatype for each column and an indication of whether the column permits storage of NULL values.

Incorrect answer:

  1. INSERT is not a SQL*PLUS command

  2. UPDATE is not a SQL*PLUS command

  3. SELECT is not a SQL*PLUS command

  1. DELETE is not a SQL*PLUS command

  2. RENAME is not a SQL*PLUS command

Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 7

Question No.134

Examine the statement:

Create synonym emp for hr.employees;

What happens when you issue the statement?

  1. An error is generated.

  2. You will have two identical tables in the HR schema with different names.

  3. You create a table called employees in the HR schema based on you EMP table.

  4. You create an alternative name for the employees table in the HR schema in your own schema.

Correct Answer: D

Question No.135

Evaluate the following SQL statements: DELETE FROM sales;

There are no other uncommitted transactions on the SALES table. Which statement is true about the DELETE statement?

  1. It removes all the rows as well as the structure of the table

  2. It removes all the rows in the table and deleted rows cannot be rolled back

  3. It removes all the rows in the table and deleted rows can be rolled back

  4. It would not remove the rows if the table has a primary key

Correct Answer: C

Question No.136

Examine the structure of the EMPLOYEES table:

image

You want to create a SQL script file that contains an INSERT statement. When the script is run, the INSERT statement should insert a row with the specified values into the EMPLOYEES table. The INSERT statement should pass values to the table columns as specified below:

image

Which INSERT statement meets the above requirements?

  1. INSERT INTO employees VALUES (emp_id_seq.NEXTVAL, #39;amp;ename#39;, #39;amp;jobid#39;, 2000, NULL,

    amp;did);

  2. INSERT INTO employees VALUES (emp_id_seq.NEXTVAL, #39;amp;ename#39;, #39;amp;jobid#39;, 2000, NULL, amp;did IN (20, 50));

  3. INSERT INTO (SELECT * FROM employees WHERE department_id IN (20, 50)) VALUES (emp_id_seq.NEXTVAL, #39;amp;ename#39;, #39;amp;jobid#39;, 2000, NULL, amp;did);

  4. INSERT INTO (SELECT * FROM employees WHERE department_id IN (20, 50) WITH CHECK OPTION)VALUES (emp_id_seq.NEXTVAL, #39;amp;ename#39;, #39;amp;jobid#39;, 2000, NULL, amp;did);

  5. INSERT INTO (SELECT * FROM employees WHERE (department_id = 20 AND department_id =

50) WITH CHECK OPTION ) VALUES (emp_id_seq.NEXTVAL, #39;amp;ename#39;, #39;amp;jobid#39;, 2000, NULL,

amp;did);

Correct Answer: D

Question No.137

Which statement is true regarding synonyms?

  1. Synonyms can be created only for a table

  2. Synonyms are used to reference only those tables that are owned by another user

  3. The DROP SYNONYM statement removes the synonym and the table on which the synonym has been created becomes invalid

  4. A public synonym and a private synonym can exist with the same name for the same table

Correct Answer: D

Question No.138

The STUDENT_GRADES table has these columns: STUDENT_ID. NUMBER(12)

SEMESTER_END. DATE GPA. NUMBER(4, 3)

The registrar has asked for a report on the average grade point average (GPA), sorted from the highest grade point average to each semester, starting from the earliest date.

Which statement accomplish this?

  1. SELECT student_id, semester_end, gpaFROM student_gradesORDER BY semester_end DESC, gpa DESC;

  2. SELECT student_id, semester_end, gpaFROM student_gradesORDER BY semester_end, gpa ASC

  3. SELECT student_id, semester_end, gpaFROM student_gradesORDER BY gpa DESC, semester_end ASC;

  4. SELECT student_id, semester_end, gpaFROM student_gradesORDER BY gpa DESC, semester_end DESC;

  5. SELECT student_id, semester_end, gpaFROM student_gradesORDER BY gpa DESC, semester_end ASC;

  6. SELECT student_id, semester_end, gpaFROM student_gradesORDER BY semester_end, gpa DESC

Correct Answer: F

Question No.139

View the Exhibit and examine the structure of the CUSTOMERS table.

image

you issue the following SQL statement on the CUSTOMERS table to display the customers who are in the same country as customers with the last name #39;king#39; and whose credit limit is less than the maximum credit limit in countries that have customers with the last name #39;king#39;.

image

Which statement is true regarding the outcome of the above query?

  1. It produces an error and the lt; operator should be replaced by lt; ANY to get the required output

  2. It produces an error and the IN operator should be replaced by = in the WHERE clause of the main query to get the required output

  3. It executes and shows the required result

  4. It produces an error and the lt; operator should be replaced by lt; ALL to get the required output

Correct Answer: C

Question No.140

You work as a database administrator at ABC.com. You study the exhibit carefully.

image

You want to create a SALE_PROD view by executing the following SQL statements:

image

Which statement is true regarding the execution of the above statement?

  1. The view will be created and you can perform DLM operations on the view

  2. The view will not be created because the join statements are not allowed for creating a view

  3. The view will not be created because the GROUP BY clause is not allowed for creating a view

  4. The view will be created but no DML operations will be allowed on the view

Correct Answer: D

Explanation:

Rules for Performing DML Operations on a View

You cannot add data through a view if the view includes:

Group functions

A GROUP BY clause The DISTINCT keyword

The pseudocolumn ROWNUM keyword Columns defined by expressions

NOT NULL columns in the base tables that are not selected by the view

Get Full Version of the Exam
1z0-061 Dumps
1z0-061 VCE and PDF

Leave a Reply