SQL Quiz

Question 1

Question

The SQL select statement is used to select data from tables. Which of the following is the correct syntax of retrieving all records from all columns in a table called employees?

Answer

A) employees.select(all)
B) set select = employees
C) SELECT * FROM employees

Question 2

Question

If I am concerned about the particular order in which the results from a select statement are returned, which keywords should I use to achieve this?

Answer

A) ORDER BY
B) SORT BY
C) ARRANGE BY

Question 3

Question

I need to retrieve related data from more than one table. Which of these would be required to link the tables when I perform a select operation?

Answer

A) JOIN
B) CONNECT
C) MERGE

Question 4

Question

I have the data and now I need to make a table to store my data. What SQL statement would I use for this?

Answer

A) SELECT statement
B) CREATE statement
C) MAKE statement

Question 5

Question

How can you populate a database table with data using SQL?

Answer

A) By using an INSERT statement
B) By using a SELECT
C) By using an ADD statement

Question 6

Question

I just discovered my table needs an additional column, what should I do to make this change?

Answer

A) Delete your table and recreate it
B) There is nothing you can do
C) Use the ALTER TABLE statement

Question 7

Question

Now that my data is corrupted I want to remove it all from the table. What should I do?

Answer

A) use CLEAN
B) use SELECT EMPTY
C) use TRUNCATE

Question 8

Question

How about if I just want to delete the table, what should I do?

Answer

A) You cannot delete tables
B) Use the DROP TABLE statement
C) Use the DELETE statement

Question 9

Question

How do I set a certain criteria when selecting data from my table?

Answer

A) Use FILTER keyword
B) Use the CRITERIA keyword
C) Use the WHERE clause

Question 10

Question

Sometimes it may be difficult to test whether a column is void of data or has some non printable data. Visually they look the same, how can I verify this using SQL?

Answer

A) Use IS NULL or IS NOT NULL clauses
B) Use = ''
C) There is no such thing as empty space in a table

Question 11

Question

Retrieving data from my table using a SELECT statement is extremely slow, how can I solve this problem?

Answer

A) Break your table into several smaller ones
B) Upgrade you computer hardware
C) INDEX your table columns

Question 12

Question

I have noticed on occasion that I need to place a selection criteria in one statement based on indefinite information stored in another table. Is there an efficient way to go about it? If yes, what should I do?

Answer

A) Use a subquery
B) Run the SELECT statement in a loop;
C) There is no efficient way

Question 13

Question

How do I use SQL to perform math calculations?

Answer

A) Use the CALCULATE clause
B) Use the MATH statement
C) Use the SELECT statement

Question 14

Question

While we are still thinking about calculations, how would I find the average of values in a certain column in SQL?

Answer

A) Use SELECT AVERAGE
B) Use AVG() built in function
C) You need a third party application

Question 15

Question

What if I need to make changes to the data in a database without affecting the table structure, what would I use?

Answer

A) Data in a table cannot be edited
B) TRUNCATE the table and INSERT the correct data
C) Use the UPDATE statement

Next up

Description

Resource summary

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

Question 15

Similar

	Created by Chris Cronin almost 9 years ago