SQL Create
1.What is the primary purpose of the CREATE statement in SQL?
-
A. To insert data into a table
-
B. To update existing rows
-
C. To define and create new database objects
-
D. To delete tables permanently
To define and create new database objects
To define and create new database objects
2.Which of the following correctly creates a table named students?
-
A. CREATE students TABLE (...);
-
B. TABLE students CREATE (...);
-
C. CREATE TABLE students (...);
-
D. CREATE TABLE = students (...);
CREATE TABLE students (...);
CREATE TABLE students (...);
3.What does this SQL command do?
CREATE DATABASE school;
-
A. Creates a table named school
-
B. Inserts data into school
-
C. Creates a new database named school
-
D. Deletes the school database
Creates a new database named school
Creates a new database named school
4.Which clause in the CREATE TABLE statement defines the primary key?
-
A. KEY
-
B. PRIMARY
-
C. CONSTRAINT
-
D. PRIMARY KEY
PRIMARY KEY
PRIMARY KEY
5.What happens if you try to create a table that already exists without handling the condition?
-
A. The table is recreated
-
B. An error occurs
-
C. It appends new columns
-
D. Nothing happens
An error occurs
An error occurs