MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
| 1. |
Evaluate the CREATE TABLE statement:CREATE TABLE products(product_id NUMBER(6) CONSTRAINT prod_id_pk PRIMARY KEY, product_name VARCHAR2(15));Which statement is true regarding the PROD_ID_PK constraint? |
| A. | It would be created only if a unique index is manually created first |
| B. | It would be created and would use an automatically created unique index |
| C. | It would be created and would use an automatically created no unique index |
| D. | It would be created and remains in a disabled state because no index is specified in the command |
| Answer» C. It would be created and would use an automatically created no unique index | |