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. Allows a comparison with multiple values from a list.
IN
SUM()
Nested Subquery
Row

2. Multiple SQL statements must be separated by semicolons.
Logical Operators
Simple Subquery
Terminating Statements
SELECT

3. Takes all of the values in that column and adds them together. Only works on columns containing numeric data.
SUM()
Column
IN
application

4. Alias
mysql
Primary Key
ORDER BY
AS

5. A record in a table
DELETE
Row
varchar(size)
LIKE

6. Takes a single numeric or alphabetic cloumn and finds the HIGHEST constant value within it.
number(size -d)
UPDATE
MAX()
application

7. Lets you change the values in one or more selected rows of a table.
Row
UPDATE
FROM
HAVING

8. Method used to copy multiple records at one time using a SELECT statement
Aggregate Functions
LIKE
INSERT INTO
AVG()

9. Specifies the tables or views from which rows and columns are retrieved
ORDER BY
DESC
FROM
DELETE

10. Combines rows from a SELECT statement's results table into groups in which specified columns have the same value.
SELECT *
GROUP BY
char(size)
AVG()

11. Used to select all the information in a specified column.
SELECT *
Breaking up data
Column
Nested Subquery

12. _______ column name FROM table name
SELECT
MIN()
DISTINCT
Self-Join

13. A popular open source database
Always define Primary Keys
SELECT Statement
AS
mysql

14. All extra whitespace within a SQL statement is is ignored when that statement is processed.
Use of Whitespace
UPDATE
SELECT Statement
AS

15. The container - usually a file or set of files - to store organized data
AVG()
SELECT *
Database
Self-Join

16. A column or set of columns whose values uniquely identify every row in a table.
Column
LIKE
Terminating Statements
Primary Key

17. A structured list of data of a specific type
AS
Table
WHERE
char(size)

18. Allows you to delete selected rows.
DELETE
Table
Use of Whitespace
Column

19. Used to nest subqueries within another subquery.
Nested Subquery
Keyword
GROUP BY
ASC

20. 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.
application
Always define Primary Keys
SELECT
Keyword

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

22. A reserved word that is part of the SQL language. Never name a table or column using a keyword.
INSERT INTO
Keyword
Self-Join
Column

23. Limits the output of the established groups into the derived result group.
LIKE
HAVING
Nested Subquery
Logical Operators

24. Denotes that the search condition is TRUE for at least one element that the subquery returns.
ASC
Use of Whitespace
ANY
application

25. A language designed specifically for communicating with databases.
mysql
ORDER BY
HAVING
SQL (Structured Query Language)

26. Primary way to do a query in SQL
Datatype
SQL Statement and Case
SELECT Statement
MAX()

27. Fixed-length character string. Size is specified in parenthesis. Max 255 bytes.
Breaking up data
Terminating Statements
char(size)
AVG()

28. Ascending
Simple Subquery
ASC
FROM
Table

29. Prevents duplicate values witihin a table or group of rows from being used in the evaluation of the function's result
Terminating Statements
Datatype
DISTINCT
Comparison Operators

30. SQL statements are case- insensitive
DESC
Aggregate Functions
SQL Statement and Case
MIN()

31. NOT - AND - OR
Row
ANY
char(size)
Logical Operators

32. SQL is a language NOT an _______
application
SELECT Statement
HAVING
DBMS - Database Management System

33. Descending
INSERT INTO
DBMS - Database Management System
DESC
Logical Operators

34. Variable-length character string. Max size is specified in parenthesis.
Always define Primary Keys
LIKE
varchar(size)
Simple Subquery

35. 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)
GROUP BY
Commas
DESC

36. Allows you to correlate information between different rows of the same table and combine this information in rows of a result table.
Database
Self-Join
DELETE
Keyword

37. Data must be broken into multiple columns correctly. For example - city - state - and zip should always separate columns.
Logical Operators
COUNT()
SQL Statement and Case
Breaking up data

38. Database software (an application)
application
HAVING
DBMS - Database Management System
Always define Primary Keys

39. = Equals - < Less Than - > Greater Than - <= Less Than or Equal To - >= Greater Than or Equal To - <> Not Equal - ! Negation of
WHERE
SQL Statement and Case
Terminating Statements
Comparison Operators

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.
SQL extensions
SQL Statement and Case
AVG()
SELECT *

41. Limits the rows that appear in the result to those matching a specified condition
UPDATE
WHERE
Column
Logical Operators

42. A single field in a table. All tables are made up of one or more columns.
Table
Column
Always define Primary Keys
Commas

43. Provides a numerical tally of how many rows meet a specific set of criteria.
Aggregate Functions
AS
COUNT()
ORDER BY

44. When selecting multiple columns be sure to specify a _____ BETWEEN each column name but NOT after the last column name.
DESC
varchar(size)
Self-Join
Commas

45. Simplest type of subquery.
Commas
Aggregate Functions
Simple Subquery
SQL (Structured Query Language)

46. Takes a single numeric or alphabetic cloumn and finds the LOWEST constant value within it.
AVG()
MIN()
INSERT INTO
Primary Key

47. Specify one or more columns on which to order the display.
MIN()
WHERE
ORDER BY
DELETE

48. Usually DBMS specific - these can provide extra functionality or simplified ways to perform specific operations.
SELECT Statement
SQL extensions
AVG()
MIN()

49. COUNT() - MAX() - MIN() - SUM() and AVG()
SUM()
Aggregate Functions
Keyword
ANY

50. A type of allowed data. Every table column has a datatype that restricts specific data in that column.
Aggregate Functions
Table
Datatype
ANY