1Z0-071 Free Practice Test

You must display details of all users whose username contains the string 'ch_'. (Choose the best answer.) Which query generates the required output?

1. A. SELECT * FROM users Where user_name LIKE \'%ch_\';
2. B. SELECT * FROM usersWhere user_name LIKE \'%ch_%\'ESCAPE\'%\';
3. C. SELECT * FROM users Where user_name LIKE \'ch\\_%\' ESCAPE \'_\';
4. D. SELECT * FROM users Where user_name LIKE \'%ch\\_%\' ESCAPE \'\\\';

Correct Answer: B

The first DROP operation is performed on PRODUCTS table using the following command: DROP TABLE products PURGE;
Then you performed the FLASHBACK operation by using the following command: FLASHBACK TABLE products TO BEFORE DROP;
Which statement describes the outcome of the FLASHBACK command?

1. A. It recovers only the table structure.
2. B. It recovers the table structure, data, and the indexes.
3. C. It recovers the table structure and data but not the related indexes.
4. D. It is not possible to recover the table structure, data, or the related indexes.

Correct Answer: D
References:
https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9003.htm

View the Exhibit and examine the structure of the ORDERS table. The ORDER_ID column is the PRIMARY KEY in the ORDERS table.
<>>>>

1. A. The NEW_ODRDERS table would not get created because the DEFAULT value cannot be specified in the column definition.
2. B. The NEW_ODRDERS table would get created and only the NOT NULL constraint defined on the specified columns would be passed to the new table.
3. C. The NEW_ODRDERS table would not get created because the column names in the CREATE TABLE command and the SELECT clause do not match.
4. D. The NEW_ODRDERS table would get created and all the constraints defined on the specified columns in the ORDERS table would be passed to the new table.

Correct Answer: B

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

View the exhibit and examine the description of the EMPLOYEES table. (Choose two.)
<>>

1. A. The values in the SALARY column would be returned in descending order for all employees having the same value in the DEPARTMENT_ID and FIRST_NAME column.
2. B. The values in the FIRST_NAME column would be returned in ascending order for all employees having the same value in the DEPARTMENT_ID column.
3. C. The values in the SALARY column would be returned in descending order for all employees having the same value in the DEPARTMENT_ID column.
4. D. The values in the all columns would be returned in descending order.
5. E. The values in the FIRST_NAME column would be returned in descending order for all employees having the same value in the DEPARTMENT_ID column.

Correct Answer: AB