Which two statements are true about the SET VERIFY ON command? (Choose two.)
Examine this list of requirements for a sequence:1. Name: EMP_SEQ2. First value returned: 13. Duplicates are never permitted.4. Provide values to be inserted into the EMPLOYEES.EMPLOYEE_ID column.5. Reduce the chances of gaps in the values.Which two statements will satisfy these requirements? (Choose two.)
Which three queries execute successfully? (Choose three.)
Which two are true about granting object privileges on tables, views, and sequences? (Choose two.)
Examine the description of the BOOKS table:The table has 100 rows.Examine this sequence of statements issued in a new session:INSERT INTO books VALUES ('ADV112', 'Adventures of Tom Sawyer', NULL, NULL);SAVEPOINT a;DELETE FROM books;ROLLBACK TO SAVEPOINT a;ROLLBACK;Which two statements are true? (Choose two.)
Examine the description of the PROMOTIONS table:You want to display the unique promotion costs in each promotion category.Which two queries can be used? (Choose two.)
