← Database Management System 🟡 Medium 📋 Sanfoundry

Evaluate the CREATE TABLE statement: CREATE TABLE products (product_id NUMBER(6) CONSTRAINT prod_id_…

Question #1677 of 749+ in Database Management System

📝 Question #1677

Evaluate the CREATE TABLE statement: CREATE TABLE products (product_id NUMBER(6) CONSTRAINT prod_id_pk PRIMARY KEY, product_name VARCHAR2(15));

⌨️ Press A B C D to select

All Options & Correct Answer

A It would be created only if a unique index is manually created first Correct
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

📋 Question Details

🎯
Difficulty
Medium
📅
Year
📋
Source
Sanfoundry

📤 Share This MCQ

📚 Want More?

Practice Database Management System MCQs

749+ questions with detailed answers