1Z0-071 Free Practice Test

Which two statements are true about sequences crated in a single instance Oracle database?

1. A. The numbers generated by an explicitly defined sequence can only be used to insert data in one table.
2. B. DELETE would remove a sequence from the database.
3. C. CURRVAL is used to refer to the most recent sequence number that has been generated for a particular sequence.
4. D. When the MAXVALUE limit for a sequence is reached, it can be increased by using the ALTER SEQUENCE statement.
5. E. When the database instance shuts down abnormally, sequence numbers that have been cached but not used are available again when the instance is restarted.

Correct Answer: CD

Which two tasks can be performed by using Oracle SQL statements?

1. A. changing the password for an existing database user
2. B. connecting to a database instance
3. C. querying data from tables across databases
4. D. starting up a database instance
5. E. executing operating system (OS) commands in a session

Correct Answer: AC
References:
http://www.techonthenet.com/oracle/password.php
https://docs.oracle.com/cd/B28359_01/server.111/b28324/tdpii_distdbs.htm

View the Exhibit and examine the structure of the ORDERS table. (Choose the best answer.)

You must select ORDER_ID and ORDER_DATE for all orders that were placed after the last order placed by CUSTOMER_ID 101.
Which query would give you the desired result?

1. A. SELECT order_id, order_date FROM ordersWHERE order_date > ANY(SELECT order_date FROM orders WHERE customer_id = 101);
2. B. SELECT order_id, order_date FROM ordersWHERE order_date > ALL(SELECT MAX(order_date) FROM orders ) AND customer_id = 101;
3. C. SELECT order_id, order_date FROM ordersWHERE order_date > ALL(SELECT order_date FROM orders WHERE customer_id = 101);
4. D. SELECT order_id, order_date FROM ordersWHERE order_date > IN(SELECT order_date FROM orders WHERE customer_id = 101);

Correct Answer: C

Which statement is true about Data Manipulation Language (DML)?

1. A. DML automatically disables foreign ley constraints when modifying primary key values in the parent table.
2. B. Each DML statement forms a transaction by default.
3. C. A transaction can consist of one or more DML statements.
4. D. DML disables foreign key constraints when deleting primary key values in the parent table, only when the ON DELETE CASCADE option is set for the foreign key constraint.

Correct Answer: C

Which two are the minimal requirements for a self-join? (Choose two.)

1. A. Only equijoin conditions may be used in the query.
2. B. Outer joins must not be used in the query.
3. C. There must be a condition on which the self-join is performed.
4. D. No other condition except the self-join may be specified.
5. E. The table used for the self-join must have two different alias names in the query.

Correct Answer: CE