1Z0_061 questions • Exam prepare

Exam contains 339 questions

Page 16 of 57

Question 91 🔥

Which two statements are true about sequences created in a single instance database? (Choose two.)

Which database solution meets these requirements?

A. CURRVAL is used to refer to the last sequence number that has been generated

B. DELETE <sequencename> would remove a sequence from the database

C. The numbers generated by a sequence can be used only for one table

D. When the MAXVALUE limit for a sequence is reached, you can increase the MAXVALUE limit by using the ALTER SEQUENCE statement

E. When a database instance shuts down abnormally, the sequence numbers that have been cached but not used would be available once again when the database instance is restarted

Discussion of the question

Question 92 🔥

The ORDERS TABLE belongs to the user OE. OE has granted the SELECT privilege on the ORDERS table to the user HR.Which statement would create a synonym ORD so that HR can execute the following query successfully?SELECT * FROM ord;

Which database solution meets these requirements?

A. CREATE SYNONYM ord FOR orders; This command is issued by OE.

B. CREATE PUBLIC SYNONYM ord FOR orders; This command is issued by OE.

C. CREATE SYNONYM ord FOR oe.orders; This command is issued by the database administrator.

D. CREATE PUBLIC SYNONYM ord FOR oe.orders; This command is issued by the database administrator.

Highly voted

Discussion of the question

Question 93 🔥

Evaluate this SQL statement:SELECT e.emp_name, d.dept_name -FROM employees e -JOIN departments d -USING (department_id)WHERE d.department_id NOT IN (10, 40)ORDER BY dept_name;The statement fails when executed. Which change fixes the error?

Which database solution meets these requirements?

A. remove the ORDER BY clause

B. remove the table alias prefix from the WHERE clause

C. remove the table alias from the SELECT clause

Highly voted

D. prefix the column in the USING clause with the table alias

E. prefix the column in the ORDER BY clause with the table alias

Highly voted

F. replace the condition "d.department_id NOT IN (10, 40)" in the WHERE clause with "d.department_id <> 10 AND d.department_id <> 40"

Discussion of the question

Question 94 🔥

Examine the statement:Create synonym emp for hr.employees;What happens when you issue the statement?

Which database solution meets these requirements?

A. An error is generated.

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

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

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

Discussion of the question

Question 95 🔥

Which two statements are true regarding single row functions? (Choose two.)

Which database solution meets these requirements?

A. They can be nested only to two levels

B. They always return a single result row for every row of a queried table

C. Arguments can only be column values or constant

D. They can return a data type value different from the one that is referenced

E. They accept only a single argument

Discussion of the question

Question 96 🔥

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.

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

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

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