Examine this query:

SELECT employee_id, first_name, salary

FROM employees

WHERE hiredate > 61*

Which two methods should yours to prevent prompting for hire date value when this queries executed?

A. Execute the SET VERIFY ON command before executing the query.

B. Execute the SET VERIFY OFF command before executing the query.

C. Store the query in a script and pass the substitution value to the script when executing it.

D. Replace 's1' with and1'in the query:

E. Use the UNDEFINE command before executing the query.

F. Use the DEFINE command before executing the query

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

A. A role can be granted to itself.

B. A role can be granted to PUBLIC.

C. A user can be granted only one role at any point of time.

D. The REVOKE command can be used to remove privileges but not roles from other users.

E. Roles are named groups of related privileges that can be granted to users or other roles.

View the exhibit and examine the ORDERS table.

The ORDERS table contains data and all orders have been assigned a customer ID. Which statement would add a NOT NULL constraint to the CUSTOMER_ID column?

A. ALTER TABLE orders MODIFY CONSTRAINT orders_cust_id_nn NOT NULL (customer_id);

B. ALTER TABLE orders ADD CONSTRAINT orders_cust_id_nn NOT NULL (customer_id);

C. ALTER TABLE orders MODIFY customer_id CONSTRAINT orders_cust_nn NOT NULL (customer_id);

D. ALTER TABLE orders ADD customer_id NUMBER(6)CONSTRAINT orders_cust_id_nn NOT NULL;

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

A. DML automatically disables foreign ley constraints when modifying primary key values in the parent table.

B. Each DML statement forms a transaction by default.

C. A transaction can consist of one or more DML statements.

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.

Examine the data in the COLORS table:

Examine the data in the BRICKS table:

Which three privileges can be restricted to a subset of columns in a taS?

A. SELECT. FROM bricks b RIGHT JOIN colors c ON b. color _rgb_ hex_ value = c. rgb hex_ value;

B. SELECT EROM colors C LEFT JOIN bricks USING (rgb _ hex_ value) ;

C. SELECT FROM bricks b FULL JOIN colors C ON b. color rgb _ hex_ value = c. rgb _hex_ value;

D. SELECT * EROM bricks | b JOIN colors C ON b. color_ rgb_ hex_ value =c. rgb _hex value;

E. SELECT EROM colors C LEET JOIN bricks b ON b. color_ rgb_ hex value = c. rgb. hex. value WHERE b. brick_ id > 0;