Quiz for CREATE

Q1: What does the CREATE command do in SQL?

A. Deletes data B. Adds a new column C. Creates new database objects D. Modifies existing data

Q2: What is the purpose of the CREATE TABLE statement in SQL?

A. To delete a table B. To modify a table C. To create a new table D. To update table data

Q3: Which keyword is used to define a primary key while creating a table?

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

Q4: Which of the following creates a table with an auto-incrementing ID?

A. CREATE TABLE emp (id INT) B. CREATE TABLE emp (id INT AUTO) C. CREATE TABLE emp (id INT AUTO_INCREMENT) D. CREATE TABLE emp (id INT INCREMENT)

Q5: How do you create a new database in SQL?

A. CREATE DATABASE db_name; B. NEW DATABASE db_name; C. ADD DATABASE db_name; D. MAKE DATABASE db_name;

Q6: Which statement creates a table named students with id and name columns?

A. CREATE students TABLE (id INT, name TEXT); B. TABLE students (id INT, name TEXT); C. CREATE TABLE students (id INT, name TEXT); D. NEW TABLE students (id, name);

Q7: What is the correct data type to store date in SQL?

A. DATETIME B. DATE C. TIME D. TIMESTAMP

Q8: Which clause is used to ensure a column cannot have NULL values?

A. DEFAULT B. NOT NULL C. UNIQUE D. NO NULL

Q9: What does the UNIQUE constraint ensure?

A. Each value is not repeated in a column B. Only one value is allowed C. Values must be positive D. Column is optional

Q10: How do you define a foreign key in CREATE TABLE?

A. KEY FOREIGN B. ADD FOREIGN KEY C. FOREIGN KEY REFERENCES table(column) D. PRIMARY FOREIGN KEY

Q11: Which command is used to create a view?

A. CREATE SCREEN B. CREATE VIEW C. NEW VIEW D. VIEW CREATE

Q12: Which keyword is used to create a user-defined function?

A. CREATE FUNCTION B. NEW FUNCTION C. MAKE FUNCTION D. FUNCTION CREATE

Q13: What is the default length of VARCHAR if not specified?

A. 0 B. 1 C. Undefined D. Error occurs

Q14: What does the DEFAULT constraint do?

A. Deletes NULL values B. Inserts random values C. Specifies a default value for a column D. Forces a column to be NULL

Q15: Which command creates an index on a table?

A. CREATE INDEX B. ADD INDEX C. MAKE INDEX D. INDEX TABLE

Q16: Which constraint ensures data integrity between two tables?

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

Q17: Can you create a table without any columns?

A. Yes B. No C. Only with default column D. Only temporary tables

Q18: Which of the following creates a temporary table?

A. CREATE TEMP TABLE emp B. CREATE TABLE TEMP emp C. CREATE TEMPORARY TABLE emp D. CREATE TABLE emp TEMP

Q19: Which SQL statement creates a new sequence?

A. CREATE SEQUENCE seq1 B. NEW SEQUENCE seq1 C. MAKE SEQUENCE seq1 D. ADD SEQUENCE seq1

Q20: Which data type is best for fixed-length strings?

A. TEXT B. VARCHAR C. CHAR D. BLOB

Q21: Which keyword is used to prevent table creation if it already exists?

A. IF PRESENT B. IGNORE IF EXISTS C. IF NOT EXISTS D. NO IF