READ Free Dumps For Oracle- 1z0-001
Question ID 1561 | Which script would you use to query the data dictionary to view only the name of the primary key constraints by using a substitution parameter for the table name? |
Option A | A. ACCEPT table PROMPT 'Table to view primary key constraint: ' SELECT constraint_name |
Option B | B. ACCEPT table PROMPT 'Table to view primary key constraint: ' SELECT constraint_name |
Option C | C. ACCEPT table PROMPT 'Table to view primary key constraint: ' SELECT constraint_name, constraint_type |
Option D | D. ACCEPT table PROMPT 'Table to view primary key constraint: ' SELECT constraint_name |
Correct Answer | D |
Question ID 1562 | The EMPLOYEE table contains these columns: ID NUMBER(9) PK |
Option A | A. Remove the ampersand. |
Option B | B. Use the ACCEPT command. |
Option C | C. Add single quotation marks. |
Option D | D. No change is needed |
Correct Answer | D |