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. A structured list of data of a specific type
Table
ANY
SELECT
ORDER BY

2. Variable-length character string. Max size is specified in parenthesis.
varchar(size)
Database
DISTINCT
Row

3. _______ column name FROM table name
SELECT
DISTINCT
SQL extensions
Datatype

4. A column or set of columns whose values uniquely identify every row in a table.
application
Use of Whitespace
Primary Key
MAX()

5. Data must be broken into multiple columns correctly. For example - city - state - and zip should always separate columns.
SELECT
SELECT Statement
Column
Breaking up data

6. Database software (an application)
Self-Join
DBMS - Database Management System
application
SELECT *

7. Takes all of the values in that column and adds them together. Only works on columns containing numeric data.
AVG()
GROUP BY
DESC
SUM()

8. The container - usually a file or set of files - to store organized data
ASC
Database
Self-Join
Nested Subquery

9. COUNT() - MAX() - MIN() - SUM() and AVG()
Comparison Operators
Aggregate Functions
WHERE
varchar(size)

10. A record in a table
ASC
Row
mysql
INSERT INTO

11. Ascending
MIN()
SELECT *
ASC
DELETE

12. Allows you to delete selected rows.
MIN()
AVG()
Always define Primary Keys
DELETE

13. Used to nest subqueries within another subquery.
SUM()
Nested Subquery
number(size -d)
Database

14. When selecting multiple columns be sure to specify a _____ BETWEEN each column name but NOT after the last column name.
Commas
SUM()
char(size)
Row

15. Prevents duplicate values witihin a table or group of rows from being used in the evaluation of the function's result
Logical Operators
IN
DISTINCT
Row

16. Simplest type of subquery.
ANY
Simple Subquery
char(size)
mysql

17. Usually DBMS specific - these can provide extra functionality or simplified ways to perform specific operations.
Logical Operators
Simple Subquery
MAX()
SQL extensions

18. Specifies the tables or views from which rows and columns are retrieved
AS
GROUP BY
Logical Operators
FROM

19. A reserved word that is part of the SQL language. Never name a table or column using a keyword.
Logical Operators
Keyword
MIN()
Simple Subquery

20. Allows you to correlate information between different rows of the same table and combine this information in rows of a result table.
ANY
mysql
Self-Join
MAX()

21. Descending
varchar(size)
DESC
Aggregate Functions
application

22. A popular open source database
DBMS - Database Management System
Self-Join
mysql
LIKE

23. Lets you use a single- or multiple-character wildcards. Also - this command does not function in Microsoft Access.
Row
Column
AVG()
LIKE

24. 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.
number(size -d)
Nested Subquery
UPDATE
Always define Primary Keys

25. Used to select all the information in a specified column.
SELECT *
Nested Subquery
Datatype
MIN()

26. A language designed specifically for communicating with databases.
Keyword
SQL (Structured Query Language)
Terminating Statements
COUNT()

27. All extra whitespace within a SQL statement is is ignored when that statement is processed.
SELECT Statement
Logical Operators
Use of Whitespace
LIKE

28. NOT - AND - OR
Commas
Logical Operators
ANY
COUNT()

29. = Equals - < Less Than - > Greater Than - <= Less Than or Equal To - >= Greater Than or Equal To - <> Not Equal - ! Negation of
Comparison Operators
Column
FROM
Datatype

30. Specify one or more columns on which to order the display.
GROUP BY
DBMS - Database Management System
ORDER BY
varchar(size)

31. Alias
Column
AS
Primary Key
FROM

32. A single field in a table. All tables are made up of one or more columns.
Table
Self-Join
Column
INSERT INTO

33. Provides a numerical tally of how many rows meet a specific set of criteria.
AVG()
COUNT()
Self-Join
number(size -d)

34. Number value with a maximum number of digits of "size" total - with a maximum number of "d" digits to the right of the decimal.
FROM
Datatype
SELECT Statement
number(size -d)

35. Allows a comparison with multiple values from a list.
IN
INSERT INTO
MIN()
Use of Whitespace

36. Takes a single numeric or alphabetic cloumn and finds the LOWEST constant value within it.
MIN()
Commas
Column
char(size)

37. SQL is a language NOT an _______
application
IN
Always define Primary Keys
SQL (Structured Query Language)

38. Takes a single numeric or alphabetic cloumn and finds the HIGHEST constant value within it.
Terminating Statements
ORDER BY
MAX()
LIKE

39. A type of allowed data. Every table column has a datatype that restricts specific data in that column.
DISTINCT
SELECT
mysql
Datatype

40. SQL statements are case- insensitive
AVG()
Logical Operators
ANY
SQL Statement and Case

41. Multiple SQL statements must be separated by semicolons.
Self-Join
Breaking up data
Terminating Statements
varchar(size)

42. Denotes that the search condition is TRUE for at least one element that the subquery returns.
char(size)
IN
ANY
DESC

43. Combines rows from a SELECT statement's results table into groups in which specified columns have the same value.
AVG()
GROUP BY
DELETE
SQL Statement and Case

44. 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.
AVG()
Always define Primary Keys
MAX()
HAVING

45. Fixed-length character string. Size is specified in parenthesis. Max 255 bytes.
char(size)
Nested Subquery
application
ANY

46. Lets you change the values in one or more selected rows of a table.
SUM()
number(size -d)
UPDATE
SELECT Statement

47. Limits the rows that appear in the result to those matching a specified condition
char(size)
WHERE
Logical Operators
ASC

48. Primary way to do a query in SQL
Aggregate Functions
SELECT Statement
DELETE
SQL extensions

49. Limits the output of the established groups into the derived result group.
Simple Subquery
UPDATE
HAVING
Column

50. Method used to copy multiple records at one time using a SELECT statement
INSERT INTO
application
UPDATE
Simple Subquery