CS403P Quiz 10

Q1. Which of the following commands is used to create a database table and its structure?

1. DCL
2. DQL
3. DDL
4. DML

Correct answer: DDL

Q2. Which of the following is a correct syntax for creating a Database named employee?

1. CREATE MYSQL Database employee
2. CREATE DATABASE employee;
3. CREATE TABLE employee;
4. CREATE SQL DATABASE employee;

Correct answer: CREATE DATABASE employee;

Q3. Which of the following is NOT related to CREATE TABLE command?

1. Constraints
2. Attributes
3. Records
4. Data types

Correct answer: Records

Q4. Which of the following is the correct syntax for creating a database table?

1. TABLE name CREATE;
2. CREATE TABLE;
3. CREATE TABLE name;
4. CREATE MYSQL TABLE name;

Correct answer: CREATE TABLE name;

Q5. Which of the following command is used to insert data into tables?

1. DDL
2. DML
3. DQL
4. DDL

Correct answer: DML

Q6. Which of the following is the correct syntax for inserting some values into the employee table?

1. INSERT into (col1, col2, col3) VALUES (val1, val2, val3)
2. INSERT into employee COLUMN (col1, col2, col3) VALUES (val1, val2, val3)
3. INSERT into employee (col1, col2, col3) VALUES (val1, val2, val3)
4. INSERT into employee (col1, col2, col3), (val1, val2, val3)

Correct answer: INSERT into employee (col1, col2, col3) VALUES (val1, val2, val3)