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. Lets you use a single- or multiple-character wildcards. Also - this command does not function in Microsoft Access.
MAX()
DESC
INSERT INTO
LIKE

2. Allows you to correlate information between different rows of the same table and combine this information in rows of a result table.
ANY
Nested Subquery
Self-Join
Column

3. Limits the output of the established groups into the derived result group.
SQL (Structured Query Language)
Simple Subquery
AS
HAVING

4. Combines rows from a SELECT statement's results table into groups in which specified columns have the same value.
GROUP BY
mysql
Nested Subquery
SQL extensions

5. A popular open source database
number(size -d)
Aggregate Functions
mysql
Always define Primary Keys

6. The container - usually a file or set of files - to store organized data
Breaking up data
Database
AVG()
INSERT INTO

7. COUNT() - MAX() - MIN() - SUM() and AVG()
Aggregate Functions
HAVING
SQL (Structured Query Language)
SELECT Statement

8. A structured list of data of a specific type
Table
FROM
DISTINCT
DESC

9. Descending
SQL (Structured Query Language)
DESC
Comparison Operators
Self-Join

10. Takes a single numeric or alphabetic cloumn and finds the LOWEST constant value within it.
Comparison Operators
Row
LIKE
MIN()

11. Takes all of the values in that column and adds them together. Only works on columns containing numeric data.
Column
Simple Subquery
SUM()
number(size -d)

12. Takes a single numeric or alphabetic cloumn and finds the HIGHEST constant value within it.
Row
DISTINCT
MAX()
IN

13. Lets you change the values in one or more selected rows of a table.
UPDATE
Logical Operators
ANY
MAX()

14. 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.
Primary Key
Table
Aggregate Functions
Always define Primary Keys

15. A column or set of columns whose values uniquely identify every row in a table.
AVG()
Database
Primary Key
char(size)

16. Primary way to do a query in SQL
Always define Primary Keys
ASC
SELECT Statement
Breaking up data

17. _______ column name FROM table name
SELECT
Breaking up data
ORDER BY
DBMS - Database Management System

18. Alias
Breaking up data
MAX()
Column
AS

19. A type of allowed data. Every table column has a datatype that restricts specific data in that column.
Row
Terminating Statements
Column
Datatype

20. Data must be broken into multiple columns correctly. For example - city - state - and zip should always separate columns.
Self-Join
Logical Operators
DESC
Breaking up data

21. Used to select all the information in a specified column.
Table
FROM
Logical Operators
SELECT *

22. Prevents duplicate values witihin a table or group of rows from being used in the evaluation of the function's result
DISTINCT
INSERT INTO
AS
WHERE

23. Fixed-length character string. Size is specified in parenthesis. Max 255 bytes.
GROUP BY
Column
Self-Join
char(size)

24. SQL is a language NOT an _______
UPDATE
Breaking up data
Terminating Statements
application

25. Allows a comparison with multiple values from a list.
LIKE
Always define Primary Keys
IN
SELECT *

26. Method used to copy multiple records at one time using a SELECT statement
Commas
SQL (Structured Query Language)
AS
INSERT INTO

27. Usually DBMS specific - these can provide extra functionality or simplified ways to perform specific operations.
Database
SQL extensions
ANY
SELECT

28. Allows you to delete selected rows.
Row
AVG()
DELETE
AS

29. Limits the rows that appear in the result to those matching a specified condition
WHERE
Table
application
Breaking up data

30. A reserved word that is part of the SQL language. Never name a table or column using a keyword.
Keyword
DESC
DISTINCT
SQL Statement and Case

31. 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.
ORDER BY
AVG()
SQL (Structured Query Language)
UPDATE

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

33. A language designed specifically for communicating with databases.
Table
HAVING
IN
SQL (Structured Query Language)

34. When selecting multiple columns be sure to specify a _____ BETWEEN each column name but NOT after the last column name.
Commas
Column
Comparison Operators
DESC

35. Provides a numerical tally of how many rows meet a specific set of criteria.
COUNT()
Always define Primary Keys
DISTINCT
Primary Key

36. = Equals - < Less Than - > Greater Than - <= Less Than or Equal To - >= Greater Than or Equal To - <> Not Equal - ! Negation of
MAX()
Primary Key
Comparison Operators
Terminating Statements

37. Ascending
SELECT
INSERT INTO
Logical Operators
ASC

38. Database software (an application)
DBMS - Database Management System
IN
GROUP BY
ASC

39. A record in a table
Use of Whitespace
Breaking up data
ASC
Row

40. NOT - AND - OR
AVG()
SELECT Statement
Logical Operators
Terminating Statements

41. Specify one or more columns on which to order the display.
ORDER BY
Database
application
WHERE

42. Variable-length character string. Max size is specified in parenthesis.
SELECT *
Logical Operators
AS
varchar(size)

43. Specifies the tables or views from which rows and columns are retrieved
SQL Statement and Case
DESC
FROM
HAVING

44. Used to nest subqueries within another subquery.
Nested Subquery
SELECT *
ORDER BY
GROUP BY

45. Denotes that the search condition is TRUE for at least one element that the subquery returns.
FROM
SELECT Statement
Self-Join
ANY

46. All extra whitespace within a SQL statement is is ignored when that statement is processed.
Use of Whitespace
Datatype
MIN()
AS

47. Number value with a maximum number of digits of "size" total - with a maximum number of "d" digits to the right of the decimal.
Simple Subquery
Column
Primary Key
number(size -d)

48. SQL statements are case- insensitive
Primary Key
Use of Whitespace
INSERT INTO
SQL Statement and Case

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

50. Simplest type of subquery.
COUNT()
SUM()
Simple Subquery
SQL (Structured Query Language)