CLASS XI - MYSQL QUIZ

What is the full form of SQL?

• Structured Query Language

• Structured Query List

• Simple QueryLanguage

• None of these

Which operator performs pattern matching?

• Between Operator

• Like Operator

• Exists Operator

• None of these

Which operator test the column for absence of data?

• Not operator

• and operator

• is null operator

• None of these

In MySQL, which command is used to modify the table values

• Select

• Update

• Modify

• Alter

In a table there are 3 rows and 5 columns. what is the degree of the table?

• 5

• 3

• 0

• none of these

Which SQL keyword is used to retrieve only unique values?

• Distinctive

• Unique

• Distinct

• Different

Which of the following is not a DML command?

• Update

• Insert into

• Delete

• Create Table

Which SQL keyword is used to sort the result-set?

• Sort by

• order by

• sort

• none of these

Which SQL command is used to remove rows from the table customer?

• Drop from customer ;

• Update from customer;

• remove from customer ;

• Delete from customer where condition ;

Which of the following must be enclosed in double quotes?

• Date

• Column alias

• String

• All of the above