Evaluate The Create Table Statementp Pre Langsql #109
Evaluate the CREATE TABLE statement:</p> <pre><code class="language-sql">CREATE TABLE products (product_id NUMBER(6) CONSTRAINT prod_id_pk PRIMARY KEY, product_name VARCHAR2(15));</code></pre> <p>Which statement is true regarding the PROD_ID_PK constraint?
This multiple choice question (MCQ) is related to the book/course gs gs117 Database Management System. It can also be found in gs gs117 Concurrency Control - Snapshot Isolation - Quiz No.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?
It would be created only if a unique index is manually created first
It would be created and would use an automatically created unique index
It would be created and would use an automatically created no unique index
It would be created and remains in a disabled state because no index is specified in the command
Similar question(s) are as followings:
Online Quizzes of gs117 Database Management System
Indexing and Hashing - Bitmap Indices - Quiz No.1
gs gs117 Database Management System
Online Quizzes