SQL MCQ Questions and answers

1.
What is the full form of SQL?

A. Structured Query Language

B. Structured Query List

C. Simple Query Language

D. None of these

Answer & Solution Discuss in Board Save for Later

2.
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

A. Data Definition Language(DDL)

B. Data Manipulation Language(DML)

C. Both of above

D. None

Answer & Solution Discuss in Board Save for Later

3.
Which operator performs pattern matching?

A. BETWEEN operator

B. LIKE operator

C. EXISTS operator

D. None of these

Answer & Solution Discuss in Board Save for Later

4.
What operator tests column for the absence of data?

A. EXISTS operator

B. NOT operator

C. IS NULL operator

D. None of these

Answer & Solution Discuss in Board Save for Later

5.
In SQL, which command(s) is(are) used to change a table's storage characteristics?

A. ALTER TABLE

B. MODIFY TABLE

C. CHANGE TABLE

D. All of the above

Answer & Solution Discuss in Board Save for Later

6.
In SQL, which of the following is not a data definition language commands?

A. RENAME

B. REVOKE

C. GRANT

D. UPDATE

Answer & Solution Discuss in Board Save for Later

7.
In SQL, which command is used to SELECT only one copy of each set of duplicable rows

A. SELECT DISTINCT

B. SELECT UNIQUE

C. SELECT DIFFERENT

D. All of the above

Answer & Solution Discuss in Board Save for Later

8.
A command that lets you change one or more fields in a record is

A. Insert

B. Modify

C. Look-up

D. All of the above

Answer & Solution Discuss in Board Save for Later

9.
Which of the SQL statements is correct?

A. SELECT Username AND Password FROM Users

B. SELECT Username, Password FROM Users

C. SELECT Username, Password WHERE Username = 'user1'

D. None of these

Answer & Solution Discuss in Board Save for Later

10.
The FROM SQL clause is used to...

A. specify what table we are selecting or deleting data FROM

B. specify range for search condition

C. specify search condition

D. None of these

Answer & Solution Discuss in Board Save for Later

SQL MCQ Questions and answers

1. What is the full form of SQL?

Answer & Solution

2. Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

Answer & Solution

3. Which operator performs pattern matching?

Answer & Solution

4. What operator tests column for the absence of data?

Answer & Solution

5. In SQL, which command(s) is(are) used to change a table's storage characteristics?

Answer & Solution

6. In SQL, which of the following is not a data definition language commands?

Answer & Solution

7. In SQL, which command is used to SELECT only one copy of each set of duplicable rows

Answer & Solution

8. A command that lets you change one or more fields in a record is

Answer & Solution

9. Which of the SQL statements is correct?

Answer & Solution

10. The FROM SQL clause is used to...

Answer & Solution

1.
What is the full form of SQL?

2.
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

3.
Which operator performs pattern matching?

4.
What operator tests column for the absence of data?

5.
In SQL, which command(s) is(are) used to change a table's storage characteristics?

6.
In SQL, which of the following is not a data definition language commands?

7.
In SQL, which command is used to SELECT only one copy of each set of duplicable rows

8.
A command that lets you change one or more fields in a record is

9.
Which of the SQL statements is correct?

10.
The FROM SQL clause is used to...