1z0-071 Practice Test

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


You executed this SQL statement:
SELECT first_name, department_id, salary
FROM employees
ORDER BY department_id, first_name, salary desc;
Which two statements are true regarding the result?

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.

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.

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.

D.

The values in the all columns would be returned in descending order.

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.

Evaluate the following ALTER TABLE statement:
ALTER TABLE orders
SET UNUSED (order_date);
Which statement is true?

A.

After executing the ALTER TABLE command, you can add a new column called
ORDER_DATE to the ORDERS table.

B.

The ORDER_DATE column should be empty for the ALTER TABLE command to
execute succsessfully.

C.

ROLLBACK can be used to get back the ORDER_DATE column in the ORDERS table.

D.

The DESCRIBE command would still display the ORDER_DATE column.

Which three statements are true reading subquenes?

A.

A Main query can have many subqueries.

B.

A subquery can have more than one main query.

C.

The subquery and main query must retrieve date from the same table.

D.

The subquery and main query can retrieve data from different tables.

E.

Only one column or expression can be compared between the subquery and main
query.

F.

Multiple columns or expressions can be compared between the subquery and main
query.

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

A.

SELECT * FROM users Where user_name LIKE '%ch_';

B.

SELECT * FROM usersWhere user_name LIKE '%ch_%'ESCAPE'%';

C.

SELECT * FROM users Where user_name LIKE 'ch\_%' ESCAPE '_';

D.

SELECT * FROM users Where user_name LIKE '%ch\_%' ESCAPE '\';

Which two statements are true regarding constraints? (Choose two.)

A.

All constraints can be defined at the column level and at the table level.

B.

A constraint can be disabled even if the constraint column contains data.

C.

A column with the UNIQUE constraint can contain NULLS.

D.

A foreign key column cannot contain NULLS.

E.

A constraint is enforced only for INSERT operations.