SQL Basic

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

SQL query to find the temperature in increasing order of all cities.

• SELECT city FROM weather ORDER BY temperature

• SELECT city, temperature FROM weather

• SELECT city, temperature FROM weather ORDER BY temperature

• SELECT city, temperature FROM weather ORDER BY city

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

• DROP FROM CUSTOMER

• UPDATE FROM CUSTOMER

• REMOVE FROM CUSTOMER

• DELETE FROM CUSTOMER WHERE

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

• COUNT NUMBER()

• NUMBER()

• SUM()

• COUNT(*)

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

With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” ends with an “a”?

• SELECT * FROM Persons WHERE FirstName=’a’

• SELECT * FROM Persons WHERE FirstName LIKE ‘a%’

• SELECT * FROM Persons WHERE FirstName LIKE ‘%a’

• SELECT * FROM Persons WHERE FirstName=’%a%’

What does the "S" in SQL stand for?

• Several

• Structured

• Syntax

• Semi-precise

How could we choose only unique values in a query?

• SELECT UNIQUE

• SELECT DISTINCT

• SELECT SPECIAL

• SELECT WITH NO DUPLICATE

What is the syntax to enter a new record into the "Sales" table?

• INSERT INTO Sales VALUES

• ALTER SALES NEW VALUES

• SALES = SALES + NEW VALUES

• SALES.ALTER.EDIT.CHANGE

Which two constraints apply to PRIMARY KEY?

• Unique

• Non-null

• Alphanumeric

• ASCII