Create Next App

Exam contains 339 questions

Page 15 of 57

Question 85 🔥

Which view should a user query to display the columns associated with the constraints on a table owned by the user?

Which database solution meets these requirements?

A. USER_CONSTRAINTS

Highly voted

B. USER_OBJECTS

Highly voted

C. ALL_CONSTRAINTS

Highly voted

D. USER_CONS_COLUMNS

Highly voted

E. USER_COLUMNS

Highly voted

Discussion of the question

Question 86 🔥

The COMMISSION column shows the monthly commission earned by the employee.Exhibit -Which two tasks would require sub queries or joins in order to be performed in a single step? (Choose two.)

Which database solution meets these requirements?

A. listing the employees who earn the same amount of commission as employee 3

Highly voted

B. finding the total commission earned by the employees in department 10

Highly voted

C. finding the number of employees who earn a commission that is higher than the average commission of the company

Highly voted

D. listing the departments whose average commission is more that 600

Highly voted

E. listing the employees who do not earn commission and who are working for department 20 in descending order of the employee ID

Highly voted

F. listing the employees whose annual commission is more than 6000

Highly voted

Discussion of the question

Question 87 🔥

Examine the structure of the STUDENTS table: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?

Which database solution meets these requirements?

A. SELECT . student_ id, marks, ROWNUM "Rank" FROM . students WHERE . ROWNUM <= 10 AND . finish_date BETWEEN '01-JAN-99' AND '31-DEC-99 AND . course_id = 'INT_SQL' ORDER BY . marks DESC;

Highly voted

B. SELECT . student_id, marks, ROWID "Rank" . FROM . students . WHERE . ROWID <= 10 . AND . finish_date BETWEEN '01-JAN-99' AND '31-DEC-99' . AND . course_id = 'INT_SQL' . ORDER BY . marks;

Highly voted

C. SELECT . student_id, marks, ROWNUM "Rank" . FROM . (SELECT student_id, marks . FROM . students . WHERE . ROWNUM <= 10 . AND . finish_date BETWEEN '01-JAN-99' AND '31-DEC- . 99' . AND . course_id = 'INT_SQL' . ORDER BY . marks DESC);

Highly voted

D. SELECT . student_id, marks, ROWNUM "Rank" . FROM . (SELECT student_id, marks . FROM . students . WHERE (finish_date BETWEEN 01-JAN-99 AND 31-DEC-99 . AND course_id = INT_SQL . ORDER BY marks DESC) . WHERE . ROWNUM <= 10 ; .

Highly voted

E. SELECT. student id, marks, ROWNUM "Rank" . FROM. (SELECT student_id, marks . FROM students . ORDER BY marks) . WHER ROWNUM <= 10 . AND. finish date BETWEEN 01-JAN-99 AND 31-DEC-99 . AND. course_id = INT_SQL;

Highly voted

Discussion of the question

Question 88 🔥

Evaluate the following SQL statements:Exhibit:Exhibit:The above command fails when executed. What could be the reason?

Which database solution meets these requirements?

A. The BETWEEN clause cannot be used for the CHECK constraint

Highly voted

B. SYSDATE cannot be used with the CHECK constraint

Highly voted

C. ORD_NO and ITEM_NO cannot be used as a composite primary key because ORD_NO is also the FOREIGN KEY

Highly voted

D. The CHECK constraint cannot be placed on columns having the DATE data type

Highly voted

Discussion of the question

Question 89 🔥

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?

Which database solution meets these requirements?

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

Highly voted

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

Highly voted

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

Highly voted

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

Highly voted

Discussion of the question

Question 90 🔥

Evaluate the following SQL statement:Which statement is true regarding the outcome of the above query?

Which database solution meets these requirements?

A. It executes successfully and displays rows in the descending order of PROMO_CATEGORY.

Highly voted

B. It produces an error because positional notation cannot be used in the order by clause with set operators.

Highly voted

C. It executes successfully but ignores the order by clause because it is not located at the end of the compound statement.

Highly voted

D. It produces an error because the order by clause should appear only at the end of a compound query-that is, with the last select statement.

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_061

Exam contains 339 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us