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. Combines rows from a SELECT statement's results table into groups in which specified columns have the same value.
HAVING
GROUP BY
MIN()
COUNT()

2. The container - usually a file or set of files - to store organized data
Database
Always define Primary Keys
HAVING
Breaking up data

3. A structured list of data of a specific type
ANY
WHERE
Table
ASC

4. Usually DBMS specific - these can provide extra functionality or simplified ways to perform specific operations.
Keyword
SQL extensions
ORDER BY
INSERT INTO

5. Lets you use a single- or multiple-character wildcards. Also - this command does not function in Microsoft Access.
SQL extensions
LIKE
Keyword
Nested Subquery

6. NOT - AND - OR
DISTINCT
Keyword
Logical Operators
SUM()

7. Method used to copy multiple records at one time using a SELECT statement
SELECT
DBMS - Database Management System
INSERT INTO
number(size -d)

8. A type of allowed data. Every table column has a datatype that restricts specific data in that column.
Row
Use of Whitespace
Datatype
DESC

9. A language designed specifically for communicating with databases.
application
ANY
DBMS - Database Management System
SQL (Structured Query Language)

10. Descending
Primary Key
DESC
char(size)
MIN()

11. A column or set of columns whose values uniquely identify every row in a table.
IN
SQL (Structured Query Language)
Primary Key
Aggregate Functions

12. Alias
Commas
WHERE
AS
Aggregate Functions

13. Used to nest subqueries within another subquery.
Primary Key
char(size)
Database
Nested Subquery

14. Takes all of the values in that column and adds them together. Only works on columns containing numeric data.
SUM()
AVG()
LIKE
ANY

15. Ascending
Database
ASC
UPDATE
AVG()

16. Limits the rows that appear in the result to those matching a specified condition
Aggregate Functions
mysql
WHERE
number(size -d)

17. A reserved word that is part of the SQL language. Never name a table or column using a keyword.
FROM
Breaking up data
Keyword
Use of Whitespace

18. 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
Breaking up data
HAVING
Datatype

19. Limits the output of the established groups into the derived result group.
HAVING
Terminating Statements
Column
DESC

20. All extra whitespace within a SQL statement is is ignored when that statement is processed.
UPDATE
DBMS - Database Management System
MIN()
Use of Whitespace

21. Database software (an application)
DBMS - Database Management System
Aggregate Functions
SQL Statement and Case
ORDER BY

22. Specify one or more columns on which to order the display.
ORDER BY
Logical Operators
DBMS - Database Management System
Breaking up data

23. Multiple SQL statements must be separated by semicolons.
ANY
Always define Primary Keys
Keyword
Terminating Statements

24. _______ column name FROM table name
varchar(size)
Commas
SELECT
Datatype

25. Used to select all the information in a specified column.
Comparison Operators
SELECT *
SELECT Statement
Breaking up data

26. Prevents duplicate values witihin a table or group of rows from being used in the evaluation of the function's result
DISTINCT
SELECT Statement
ANY
LIKE

27. Data must be broken into multiple columns correctly. For example - city - state - and zip should always separate columns.
Nested Subquery
SQL extensions
Breaking up data
Self-Join

28. Lets you change the values in one or more selected rows of a table.
GROUP BY
FROM
UPDATE
SELECT Statement

29. Denotes that the search condition is TRUE for at least one element that the subquery returns.
ANY
Logical Operators
SQL Statement and Case
GROUP BY

30. Takes a single numeric or alphabetic cloumn and finds the HIGHEST constant value within it.
MAX()
WHERE
IN
DBMS - Database Management System

31. SQL is a language NOT an _______
application
HAVING
SELECT *
Commas

32. SQL statements are case- insensitive
Row
SQL Statement and Case
Datatype
DESC

33. Fixed-length character string. Size is specified in parenthesis. Max 255 bytes.
MAX()
char(size)
mysql
Always define Primary Keys

34. Provides a numerical tally of how many rows meet a specific set of criteria.
char(size)
varchar(size)
COUNT()
Aggregate Functions

35. Specifies the tables or views from which rows and columns are retrieved
Row
AS
Use of Whitespace
FROM

36. Allows you to correlate information between different rows of the same table and combine this information in rows of a result table.
Self-Join
SELECT *
Aggregate Functions
Datatype

37. A popular open source database
SQL Statement and Case
LIKE
mysql
Commas

38. Variable-length character string. Max size is specified in parenthesis.
varchar(size)
WHERE
MIN()
LIKE

39. Allows a comparison with multiple values from a list.
SELECT
ORDER BY
IN
WHERE

40. Takes a single numeric or alphabetic cloumn and finds the LOWEST constant value within it.
Database
MIN()
WHERE
DISTINCT

41. When selecting multiple columns be sure to specify a _____ BETWEEN each column name but NOT after the last column name.
MAX()
Commas
DISTINCT
Row

42. Allows you to delete selected rows.
MAX()
ORDER BY
DELETE
WHERE

43. Number value with a maximum number of digits of "size" total - with a maximum number of "d" digits to the right of the decimal.
AVG()
ANY
SQL extensions
number(size -d)

44. COUNT() - MAX() - MIN() - SUM() and AVG()
Always define Primary Keys
Aggregate Functions
FROM
ASC

45. A record in a table
Breaking up data
Row
AVG()
SQL (Structured Query Language)

46. Simplest type of subquery.
Simple Subquery
ANY
Terminating Statements
Nested Subquery

47. 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.
HAVING
UPDATE
ANY
AVG()

48. A single field in a table. All tables are made up of one or more columns.
DBMS - Database Management System
Column
SUM()
AS

49. = Equals - < Less Than - > Greater Than - <= Less Than or Equal To - >= Greater Than or Equal To - <> Not Equal - ! Negation of
mysql
ANY
Logical Operators
Comparison Operators

50. Primary way to do a query in SQL
Always define Primary Keys
DISTINCT
Nested Subquery
SELECT Statement