SQL Quiz session -1

What does SQL stand for?

• Standard Query Language
• Simple Query Language
• Structured Query List
• Structured Query language

Which of the following is NOT a valid keyword in SQL?

• SELECT

• DELETE

• FETCHALL
• WHERE

Which SQL statement is used to update existing records in a table?

• CHANGE

• ALTER

• MODIFY

• UPDATE

What does the SQL command 'DROP' do?

• Deletes a table

• Removes a column

• Clears all data from a table

• Creates a new table

Which of the following SQL commands is used to retrieve data from a database?

• GET

• RETRIEVE

• SELECT

• FETCH

Which SQL function is used to count the number of rows in a table?

• SUM()

• COUNT()

• AVG()

• MAX()

What is the purpose of the SQL keyword “DISTINCT” in a SELECT statement?

• To retrieve unique values from a TABLE/ column

• To filter NULL values

• To delete duplicate records

• To sort the result set

Which of the following is basis for SQL?

• Object-oriented model
• Hierarchical model
• Network model
• Relational model

Which statement(s) are mandatory in a simple SQL SELECT statement?

• SELECT and GROUP BY
• FROM and WHERE
• SELECT and WHERE
• SELECT and FROM.

Which of the following SQL statement selects only unique values from ‘section’ column of table ‘school’?

• SELECT section FROM school

• SELECT * FROM school

• SELECT DISTINCT section FROM school

• SELECT ALL section FROM school