Query Quest

What does SQL stand for?

• Structured Query Language

• Standard Query Language

• Simple Query Language

• Sequential Query Language

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

• SELECT

• DELETE

• WHERE

• INCLUDE

Which of the following operators is used to compare two values in SQL?

• +

• =

• <>

• &

Which SQL keyword is used to retrieve a maximum value?

• MOST

• TOP

• MAX

• UPPER

_____removes all rows from a table without logging the individual row deletions.

• DELETE

• REMOVE

• DROP

• TRUNCATE

What type of SQL command is INSERT INTO?

• Data Definition Language

• Data Manipulation Language

• Data Control Language

• Transaction Control Language

In SQL, which command is used to make changes made by a transaction permanent in a database?

• SAVE

• SAVEPOINT

• COMMIT

• HOLD

Find all the tuples having a temperature greater than ‘Paris’.

• SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = ‘Paris’

• SELECT FROM weather WHERE temperature > (SELECT FROM weather WHERE city = ‘Paris’)

• SELECT * FROM weather WHERE temperature > (SELECT city FROM weather WHERE city = ‘Paris’)

• SELECT * FROM weather WHERE temperature > ‘Paris’ temperature

The command to remove rows from a table ‘CUSTOMER’ is ______

• DROP FROM CUSTOMER

• UPDATE FROM CUSTOMER

• REMOVE FROM CUSTOMER

• DELETE FROM CUSTOMER WHERE

A UNION query is which of the following?

• Combines the output from no more than two queries and must include the same number of columns

• Combines the output from no more than two queries and does not include the same number of columns

• Combines the output from multiple queries and must include the same number of columns

• Combines the output from multiple queries and does not include the same number of columns