Quiz for CREATE Table

Q1: Which SQL command is used to create a new table?

A. INSERT B. CREATE C. UPDATE D. SELECT

Q2: Which SQL keyword is used to define a new table?

A. NEW B. TABLE C. CREATE D. INSERT

Q3: Which of the following is correct syntax to create a table?

A. CREATE TABLE table_name; B. CREATE table; C. TABLE CREATE name; D. NEW TABLE name;

Q4: How do you define a primary key while creating a table?

A. PRIMARY table key B. KEY PRIMARY C. PRIMARY KEY (column_name) D. KEY (column_name)

Q5: Which constraint ensures a column cannot have NULL values?

A. PRIMARY KEY B. CHECK C. NOT NULL D. DEFAULT

Q6: To create a table with a default value for a column, you use:

A. SET DEFAULT B. DEFAULT value C. DEFAULT = value D. COLUMN DEFAULT

Q7: Which data type is used to store variable-length strings in SQL?

A. VARCHAR B. CHAR C. INT D. STRING

Q8: Which of the following is NOT a valid SQL data type?

A. BOOLEAN B. DATE C. STRING D. INT

Q9: What does the AUTO_INCREMENT attribute do in MySQL?

A. Automatically increases the column value B. Auto-links tables C. Automatically creates tables D. Sets default value to 1

Q10: Which SQL command is used to ensure a column has unique values?

A. NOT NULL B. CHECK C. UNIQUE D. FOREIGN KEY

Q11: Which command creates a table only if it does not already exist?

A. CREATE TABLE table_name B. CREATE NEW TABLE C. CREATE TABLE IF NOT EXISTS table_name D. TABLE CREATE

Q12: What is the maximum length of a VARCHAR in MySQL?

A. 255 B. 65535 C. 1024 D. None of the above

Q13: Which keyword is used to set a column as the primary key?

A. INDEX B. UNIQUE C. PRIMARY KEY D. CONSTRAINT

Q14: How many primary keys can a table have?

A. One B. Two C. Unlimited D. Depends on DBMS

Q15: Which of the following allows a column to have NULL values?

A. NOT NULL B. DEFAULT NULL C. UNIQUE D. PRIMARY KEY

Q16: What is the purpose of the FOREIGN KEY constraint?

A. Creates a new column B. Links two tables C. Ensures value uniqueness D. Assigns default value

Q17: Which clause is used to define constraints while creating a table?

A. WITH B. CONSTRAINT C. DEFINE D. SET

Q18: Which of these defines a composite primary key?

A. PRIMARY KEY (col1) B. KEY (col1, col2) C. PRIMARY KEY (col1, col2) D. UNIQUE (col1, col2)

Q19: Which SQL command creates a copy of an existing table’s structure?

A. CREATE TABLE new_table AS old_table B. CLONE TABLE old_table C. COPY TABLE old_table D. CREATE TABLE new_table LIKE old_table

Q20: Which column constraint automatically fills in a column value?

A. NOT NULL B. DEFAULT C. UNIQUE D. PRIMARY KEY

Q21: Which of these is a valid SQL syntax to create a table with an integer column?

A. CREATE TABLE t (id TEXT); B. CREATE TABLE t (id INT); C. CREATE TABLE t {id: INT}; D. CREATE t (id INTEGER);