Online 1Z0-071 Practice TestMore Oracle Products >

Free Oracle 1Z0-071 Exam Dumps Questions

Oracle 1Z0-071: Oracle Database 12c SQL

- Get instant access to 1Z0-071 practice exam questions

- Get ready to pass the Oracle Database 12c SQL exam right now using our Oracle 1Z0-071 exam package, which includes Oracle 1Z0-071 practice test plus an Oracle 1Z0-071 Exam Simulator.

- The best online 1Z0-071 exam study material and preparation tool is here.

4.5

(450 ratings)

Question 1

Evaluate the following statement. INSERT ALL
WHEN order_total < 10000>WHEN order_total > 10000 AND order_total < 20000>WHEN order_total > 200000 AND order_total < 20000>SELECT order_id, order_total, customer_id FROM orders;
Which statement is true regarding the evaluation of rows returned by the subquery in the INSERT statement?

A. They are evaluated by all the three WHEN clauses regardless of the results of the evaluation of any other WHEN clause.

B. They are evaluated by the first WHEN claus

C. If the condition is true, then the row would be evaluated by the subsequent WHEN clauses.

D. They are evaluated by the first WHEN claus

E. If the condition is false, then the row would be evaluated by the subsequent WHEN clauses.

F. The insert statement would give an error because the ELSE clause is not present for support in case none of WHEN clauses are true.

Correct Answer:A
References:
http://psoug.org/definition/WHEN.htm

Question 2

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

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

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

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

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

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

Correct Answer:A

Question 3

Examine the structure of the BOOKS_ TRANSACTIONS table:
1Z0-071 dumps exhibit
Examine the SQL statement:

Which statement is true about the outcome?

A. It displays details only for members who have borrowed before today with RM as TRANSACTION_TYPE.

B. It displays details for members who have borrowed before today's date with either RM asTRANSACTION_TYPE or MEMBER_ID as A101 and A102.

C. It displays details for only members A101and A102 who have borrowed before today with RM as TRANSACTION_TYPE.

D. It displays details for members who have borrowed before today with RM as TRANSACTION_TYPE and the details for members A101 or A102.

Correct Answer:A

Question 4

Which three statements are true regarding group functions? (Choose three.)

A. They can be used on columns or expressions.

B. They can be passed as an argument to another group function.

C. They can be used only with a SQL statement that has the GROUP BY clause.

D. They can be used on only one column in the SELECT clause of a SQL statement.

E. They can be used along with the single-row function in the SELECT clause of a SQL statement.

Correct Answer:ABE
References:
https://www.safaribooksonline.com/library/view/mastering-oracle-sql/0596006322/ch04.html

Question 5

You issued this command:
CHOOSE THREE
SQL > DROP TABLE employees; Which three statements are true?

A. Sequences used in the EMPLOYEES table become invalid.

B. If there is an uncommitted transaction in the session, it is committed.

C. All indexes and constraints defined on the table being dropped are also dropped.

D. The space used by the EMPLOYEES table is always reclaimed immediately.

E. The EMPLOYEES table can be recovered using the ROLLBACK command.

F. The EMPLOYEES table may be moved to the recycle bin.

Correct Answer:BCF

Question 6

Which statement is true about transactions?

A. A set of Data Manipulation Language (DML) statements executed in a sequence ending with a SAVEPOINT forms a single transaction.

B. Each Data Definition Language (DDL) statement executed forms a single transaction.

C. A set of DDL statements executed in a sequence ending with a COMMIT forms a single transaction.

D. A combination of DDL and DML statements executed in a sequence ending with a COMMIT forms a single transaction.

Correct Answer:B
References:
https://docs.oracle.com/database/121/CNCPT/transact.htm#CNCPT038

START 1Z0-071 EXAM