195 questions, 3 without answers
* update 11/2017, 197 questions now
#1 Question:
Which SQL keyword is used to retrieve only unique values?
DIFFERENT
DISTINCT
DISTINCTIVE
UNION
UNIQUE
Answer: DISTINCT
#2 Question:
SQL statements are terminated with _______.
a colon
a period
a semicolon
a server reboot
the END keyword
Answer: a semicolon
#3 Question:
Which SQL function is used to count the number of rows in a SQL query?
COUNT()
MAX()
NUMBER()
SUM()
TOTAL()
Answer: COUNT()
#4 Question:
Which cannot be done using SQL?
Create a database
Create a new procedure
Create a new table
Insert rows
Update server environment variables
Answer:
#5 Question:
Views are created using what SQL command?
BUILD VIEW
CONSTRUCT VIEW
CREATE VIEW
INIT VIEW
MAKE VIEW
Answer:
#6 Question:
Which keyword is used to get the average value of a single column of values?
AVERAGE()
AVERAGE_VALUE()
AVG()
AVG_VALUE()
MEAN()
Answer:
#7 Question:
Which of the following SQL statements does count the rows in the 'Sales' table?
SELECT COUNT(#) IN Sales
SELECT COUNT(*) FROM Sales
SELECT COUNT(*) IN Sales
SELECT COUNTER(*) FROM Sales
SELECT NUM() FROM Sales
Answer:
etc.
