My SQL

What is the full form of SQL?

• Structured Query Language

• Structured Query List

• Simple Query Lnaguage

• None of these

which operator performs matching?

• Between operator

• Like operator

• Exists operator

• None of these

What operator tests for the absence of data?

• Exists operator

• Not operator

• Is NULL operator

• None of these

In SQL, which command is used to SELECT only one copy of each set of duplicate rows?

• SELECT DISTINCT

• SELECT UNIQUE

• SELECT DIFFERENT

• All of the above

Which of the SQL statements is correct?

• SELECT Username AND Password FROM Users

• SELECT Username, Password FROM Users

• SELECT Username, Password WHERE Username = ‘user1’

• None of these

The FROM clause is used to...

• specify what table we are selecting or deleting data FROM

• specify range for search condition

• specify search condition

• None of these

Which SQL keyword is used to retrieve only unique values?

• DISTINCTIVE

• UNIQUE

• DISTINCT

• DIFFERENT

Which of the following SQL commands us used to retrieve data?

• DELETE

• INSERT

• SELECT

• JOIN

Which of the following is a SQL aggregate function?

• LEFT

• AVG

• JOIN

• LEN

Which SQL statement is used to delete data FROM a database?

• COLLAPSE

• REMOVE

• ALTER

• DELETE