Test your basic knowledge |

SQL: Structured Query Language

Subject : it-skills

Instructions:

Answer 50 questions in 15 minutes.
If you are not ready to take this test, you can study here.
Match each statement with the correct term.
Don't refresh. All questions and answers are randomly picked and ordered every time you load a test.

This is a study tool. The 3 wrong answers for each question are randomly chosen from answers to other questions. So, you might find at times the answers obvious, but you will see it re-enforces your understanding as you take the test each time.

1. Used to nest subqueries within another subquery.
INSERT INTO
DISTINCT
Nested Subquery
SELECT *

2. Allows you to delete selected rows.
Breaking up data
LIKE
Database
DELETE

3. Method used to copy multiple records at one time using a SELECT statement
INSERT INTO
SQL extensions
WHERE
SELECT

4. Lets you use a single- or multiple-character wildcards. Also - this command does not function in Microsoft Access.
Aggregate Functions
Primary Key
INSERT INTO
LIKE

5. A popular open source database
AVG()
SQL extensions
mysql
DELETE

6. Variable-length character string. Max size is specified in parenthesis.
varchar(size)
DELETE
INSERT INTO
SUM()

7. A reserved word that is part of the SQL language. Never name a table or column using a keyword.
DELETE
HAVING
SQL extensions
Keyword

8. Allows you to correlate information between different rows of the same table and combine this information in rows of a result table.
Commas
Comparison Operators
Keyword
Self-Join

9. Provides a numerical tally of how many rows meet a specific set of criteria.
MIN()
SQL Statement and Case
COUNT()
DESC

10. Takes a single numeric or alphabetic cloumn and finds the LOWEST constant value within it.
INSERT INTO
MIN()
Simple Subquery
AVG()

11. SQL is a language NOT an _______
Breaking up data
application
LIKE
Row

12. Ascending
COUNT()
FROM
Table
ASC

13. = Equals - < Less Than - > Greater Than - <= Less Than or Equal To - >= Greater Than or Equal To - <> Not Equal - ! Negation of
Datatype
mysql
SQL Statement and Case
Comparison Operators

14. A language designed specifically for communicating with databases.
Comparison Operators
Always define Primary Keys
SQL (Structured Query Language)
SQL Statement and Case

15. Limits the output of the established groups into the derived result group.
char(size)
application
Simple Subquery
HAVING

16. Takes all of the values in that column and adds them together. Only works on columns containing numeric data.
Self-Join
Column
Always define Primary Keys
SUM()

17. Multiple SQL statements must be separated by semicolons.
Simple Subquery
FROM
Terminating Statements
Breaking up data

18. Prevents duplicate values witihin a table or group of rows from being used in the evaluation of the function's result
Use of Whitespace
DISTINCT
WHERE
GROUP BY

19. A record in a table
FROM
char(size)
Row
Datatype

20. Fixed-length character string. Size is specified in parenthesis. Max 255 bytes.
COUNT()
IN
DISTINCT
char(size)

21. Used to select all the information in a specified column.
SELECT *
varchar(size)
SQL (Structured Query Language)
mysql

22. A column or set of columns whose values uniquely identify every row in a table.
number(size -d)
DELETE
Primary Key
Aggregate Functions

23. Alias
Row
AS
DELETE
MAX()

24. A structured list of data of a specific type
DELETE
Table
AS
ORDER BY

25. Combines rows from a SELECT statement's results table into groups in which specified columns have the same value.
WHERE
GROUP BY
IN
AVG()

26. Primary way to do a query in SQL
Breaking up data
HAVING
SELECT Statement
MAX()

27. Denotes that the search condition is TRUE for at least one element that the subquery returns.
AS
Always define Primary Keys
Terminating Statements
ANY

28. The container - usually a file or set of files - to store organized data
Database
Column
INSERT INTO
Aggregate Functions

29. Specifies the tables or views from which rows and columns are retrieved
AS
SQL extensions
SQL (Structured Query Language)
FROM

30. When selecting multiple columns be sure to specify a _____ BETWEEN each column name but NOT after the last column name.
Commas
MIN()
Keyword
AVG()

31. Number value with a maximum number of digits of "size" total - with a maximum number of "d" digits to the right of the decimal.
number(size -d)
Keyword
Terminating Statements
SUM()

32. Usually DBMS specific - these can provide extra functionality or simplified ways to perform specific operations.
Simple Subquery
SQL extensions
Self-Join
HAVING

33. Lets you change the values in one or more selected rows of a table.
UPDATE
Use of Whitespace
ANY
Breaking up data

34. NOT - AND - OR
Datatype
Keyword
IN
Logical Operators

35. SQL statements are case- insensitive
SQL Statement and Case
SELECT *
LIKE
Use of Whitespace

36. All extra whitespace within a SQL statement is is ignored when that statement is processed.
Nested Subquery
Commas
Use of Whitespace
MAX()

37. A type of allowed data. Every table column has a datatype that restricts specific data in that column.
IN
Datatype
WHERE
DESC

38. Database software (an application)
DBMS - Database Management System
Commas
Primary Key
FROM

39. Limits the rows that appear in the result to those matching a specified condition
SQL (Structured Query Language)
WHERE
Simple Subquery
DBMS - Database Management System

40. Takes average of each of the numeric values in the column.Can only be used in conjuction with the DISTINCT keyword and only works on numeric columns.
INSERT INTO
AVG()
COUNT()
ASC

41. Specify one or more columns on which to order the display.
application
ORDER BY
ASC
INSERT INTO

42. A single field in a table. All tables are made up of one or more columns.
Database
Column
WHERE
DESC

43. Data must be broken into multiple columns correctly. For example - city - state - and zip should always separate columns.
HAVING
Row
Breaking up data
ORDER BY

44. Simplest type of subquery.
GROUP BY
IN
SQL extensions
Simple Subquery

45. Descending
Column
DESC
Terminating Statements
SELECT Statement

46. COUNT() - MAX() - MIN() - SUM() and AVG()
Datatype
Comparison Operators
Aggregate Functions
DISTINCT

47. Allows a comparison with multiple values from a list.
Row
IN
AS
Terminating Statements

48. _______ column name FROM table name
Breaking up data
SELECT
Self-Join
Column

49. Although primary keys are not specifically required - most database designers make certain that every table they create has a primary key so that future data manipulation is possible.
Always define Primary Keys
Datatype
IN
SELECT Statement

50. Takes a single numeric or alphabetic cloumn and finds the HIGHEST constant value within it.
MAX()
Database
SQL (Structured Query Language)
DBMS - Database Management System