SQL Database

Which character always appears at the end of a SQL statement?

• ;

• :

• ,

• .

SQL query to find all the cities whose humidity is 95.

• SELECT city WHERE humidity = 95

• SELECT city FROM weather WHERE humidity = 95

• SELECT humidity = 89 FROM weather

• SELECT city FROM weather

If you don’t specify ASC or DESC after a SQL ORDER BY clause, the following is used by default

• ASC

• DESC

• There is no default value

• None of the mentioned

An SQL command used to add record in a table.

• Insert

• Create

• Update

• Add

The SQL statement being run is:

SELECT player_name, score FROM leaderboard;

How many columns of results will be shown when this query is run?

• 0

• 1

• 2

• 3

SQL is

• Structured Query Language

• Simple Query Language

• Structured Question Language

• Structure Quality Language

DML

What does SQL stand for?

• Structured Query Language   

• Strong Question Language

• Structured Question Language

What does SQL stands for?

• Standard Query Language

• Structured Query Language

• Structured Query Link

• Standard Query Link

The UPDATE SQL clause can _____________

• update only one row at a time

• update more than one row at a time

• delete more than one row at a time

• delete only one row at a time