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. Number value with a maximum number of digits of "size" total - with a maximum number of "d" digits to the right of the decimal.
SELECT
DELETE
number(size -d)
Database

2. When selecting multiple columns be sure to specify a _____ BETWEEN each column name but NOT after the last column name.
COUNT()
Commas
Database
Breaking up data

3. = Equals - < Less Than - > Greater Than - <= Less Than or Equal To - >= Greater Than or Equal To - <> Not Equal - ! Negation of
Comparison Operators
AS
DBMS - Database Management System
DELETE

4. A single field in a table. All tables are made up of one or more columns.
Breaking up data
Column
Use of Whitespace
SELECT *

5. _______ column name FROM table name
Row
number(size -d)
SELECT
SQL extensions

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

7. Method used to copy multiple records at one time using a SELECT statement
INSERT INTO
varchar(size)
Always define Primary Keys
SELECT Statement

8. Used to select all the information in a specified column.
Table
Nested Subquery
SELECT *
UPDATE

9. Denotes that the search condition is TRUE for at least one element that the subquery returns.
SQL extensions
Always define Primary Keys
FROM
ANY

10. Specify one or more columns on which to order the display.
Use of Whitespace
ORDER BY
DISTINCT
SUM()

11. Multiple SQL statements must be separated by semicolons.
DESC
GROUP BY
Terminating Statements
Commas

12. A column or set of columns whose values uniquely identify every row in a table.
Primary Key
UPDATE
SELECT
Terminating Statements

13. A popular open source database
DELETE
mysql
DISTINCT
Simple Subquery

14. SQL is a language NOT an _______
MIN()
DELETE
Nested Subquery
application

15. COUNT() - MAX() - MIN() - SUM() and AVG()
Aggregate Functions
FROM
Datatype
SQL (Structured Query Language)

16. 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.
DBMS - Database Management System
SQL (Structured Query Language)
Breaking up data
Always define Primary Keys

17. Limits the rows that appear in the result to those matching a specified condition
SELECT Statement
INSERT INTO
WHERE
SQL (Structured Query Language)

18. Lets you use a single- or multiple-character wildcards. Also - this command does not function in Microsoft Access.
WHERE
Simple Subquery
SELECT Statement
LIKE

19. Allows you to delete selected rows.
SQL extensions
DELETE
WHERE
Terminating Statements

20. Used to nest subqueries within another subquery.
ORDER BY
SUM()
Nested Subquery
GROUP BY

21. Prevents duplicate values witihin a table or group of rows from being used in the evaluation of the function's result
Primary Key
ANY
DISTINCT
SQL Statement and Case

22. Specifies the tables or views from which rows and columns are retrieved
Logical Operators
FROM
mysql
MAX()

23. Database software (an application)
DBMS - Database Management System
SQL extensions
Primary Key
varchar(size)

24. A reserved word that is part of the SQL language. Never name a table or column using a keyword.
Keyword
WHERE
SQL extensions
Use of Whitespace

25. Data must be broken into multiple columns correctly. For example - city - state - and zip should always separate columns.
Breaking up data
Use of Whitespace
Logical Operators
Terminating Statements

26. Limits the output of the established groups into the derived result group.
DELETE
HAVING
ANY
SUM()

27. Alias
ASC
AS
DISTINCT
Commas

28. Fixed-length character string. Size is specified in parenthesis. Max 255 bytes.
Logical Operators
Keyword
char(size)
ASC

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

30. All extra whitespace within a SQL statement is is ignored when that statement is processed.
number(size -d)
Comparison Operators
Use of Whitespace
SQL extensions

31. Provides a numerical tally of how many rows meet a specific set of criteria.
Database
Terminating Statements
SELECT *
COUNT()

32. NOT - AND - OR
ASC
Logical Operators
Commas
ANY

33. Allows you to correlate information between different rows of the same table and combine this information in rows of a result table.
Row
UPDATE
Self-Join
Terminating Statements

34. Usually DBMS specific - these can provide extra functionality or simplified ways to perform specific operations.
Self-Join
varchar(size)
SQL extensions
INSERT INTO

35. A structured list of data of a specific type
Table
SELECT *
MIN()
HAVING

36. Takes a single numeric or alphabetic cloumn and finds the HIGHEST constant value within it.
Commas
Datatype
MAX()
Aggregate Functions

37. Primary way to do a query in SQL
Breaking up data
SELECT Statement
SELECT
SQL extensions

38. Variable-length character string. Max size is specified in parenthesis.
MAX()
DISTINCT
Table
varchar(size)

39. Ascending
Datatype
Simple Subquery
Use of Whitespace
ASC

40. Allows a comparison with multiple values from a list.
IN
COUNT()
char(size)
SELECT *

41. Lets you change the values in one or more selected rows of a table.
Column
SELECT *
SUM()
UPDATE

42. Takes a single numeric or alphabetic cloumn and finds the LOWEST constant value within it.
SELECT Statement
Always define Primary Keys
DISTINCT
MIN()

43. SQL statements are case- insensitive
number(size -d)
Self-Join
SQL Statement and Case
Keyword

44. A type of allowed data. Every table column has a datatype that restricts specific data in that column.
UPDATE
Self-Join
MIN()
Datatype

45. Simplest type of subquery.
DESC
Table
Simple Subquery
MIN()

46. Takes all of the values in that column and adds them together. Only works on columns containing numeric data.
MIN()
SUM()
Nested Subquery
varchar(size)

47. A language designed specifically for communicating with databases.
Aggregate Functions
SQL (Structured Query Language)
Database
INSERT INTO

48. Descending
DESC
ORDER BY
Primary Key
Aggregate Functions

49. A record in a table
IN
Row
MAX()
DESC

50. 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.
Simple Subquery
Keyword
AVG()
COUNT()