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. Limits the output of the established groups into the derived result group.
HAVING
FROM
SELECT Statement
SQL Statement and Case

2. Allows a comparison with multiple values from a list.
FROM
Datatype
DESC
IN

3. Specifies the tables or views from which rows and columns are retrieved
SUM()
char(size)
FROM
Comparison Operators

4. Alias
AS
FROM
Comparison Operators
mysql

5. COUNT() - MAX() - MIN() - SUM() and AVG()
Primary Key
Aggregate Functions
WHERE
varchar(size)

6. Prevents duplicate values witihin a table or group of rows from being used in the evaluation of the function's result
application
DESC
SUM()
DISTINCT

7. 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.
SELECT *
Keyword
HAVING
Always define Primary Keys

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

9. Provides a numerical tally of how many rows meet a specific set of criteria.
SELECT *
ORDER BY
COUNT()
UPDATE

10. A language designed specifically for communicating with databases.
application
Commas
SQL (Structured Query Language)
Simple Subquery

11. All extra whitespace within a SQL statement is is ignored when that statement is processed.
Breaking up data
Use of Whitespace
DBMS - Database Management System
Comparison Operators

12. Takes all of the values in that column and adds them together. Only works on columns containing numeric data.
Database
SUM()
SQL Statement and Case
number(size -d)

13. Multiple SQL statements must be separated by semicolons.
MAX()
DISTINCT
Terminating Statements
mysql

14. _______ column name FROM table name
Keyword
SQL (Structured Query Language)
SELECT
GROUP BY

15. 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.
Terminating Statements
AVG()
SELECT
MIN()

16. Takes a single numeric or alphabetic cloumn and finds the LOWEST constant value within it.
MIN()
Logical Operators
SQL extensions
Comparison Operators

17. Combines rows from a SELECT statement's results table into groups in which specified columns have the same value.
varchar(size)
Always define Primary Keys
DELETE
GROUP BY

18. Allows you to correlate information between different rows of the same table and combine this information in rows of a result table.
Self-Join
Nested Subquery
Logical Operators
MIN()

19. The container - usually a file or set of files - to store organized data
DISTINCT
Breaking up data
Database
Commas

20. Fixed-length character string. Size is specified in parenthesis. Max 255 bytes.
INSERT INTO
DESC
char(size)
HAVING

21. Simplest type of subquery.
Simple Subquery
Keyword
UPDATE
IN

22. 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)
Breaking up data
Keyword
UPDATE

23. Takes a single numeric or alphabetic cloumn and finds the HIGHEST constant value within it.
varchar(size)
SUM()
MAX()
SQL extensions

24. SQL statements are case- insensitive
UPDATE
FROM
SQL Statement and Case
application

25. Lets you change the values in one or more selected rows of a table.
Logical Operators
DISTINCT
number(size -d)
UPDATE

26. SQL is a language NOT an _______
application
LIKE
ANY
Column

27. Method used to copy multiple records at one time using a SELECT statement
Datatype
SQL Statement and Case
HAVING
INSERT INTO

28. Descending
DESC
mysql
char(size)
Commas

29. A type of allowed data. Every table column has a datatype that restricts specific data in that column.
UPDATE
SQL (Structured Query Language)
Datatype
AVG()

30. Data must be broken into multiple columns correctly. For example - city - state - and zip should always separate columns.
FROM
Breaking up data
Commas
AS

31. Variable-length character string. Max size is specified in parenthesis.
DBMS - Database Management System
number(size -d)
varchar(size)
Logical Operators

32. NOT - AND - OR
Logical Operators
Keyword
GROUP BY
ANY

33. Denotes that the search condition is TRUE for at least one element that the subquery returns.
ANY
ORDER BY
varchar(size)
SELECT Statement

34. Database software (an application)
DBMS - Database Management System
Database
Always define Primary Keys
Use of Whitespace

35. Specify one or more columns on which to order the display.
number(size -d)
ORDER BY
ASC
INSERT INTO

36. A popular open source database
varchar(size)
MAX()
AS
mysql

37. Primary way to do a query in SQL
Comparison Operators
SELECT Statement
application
char(size)

38. A structured list of data of a specific type
Self-Join
Datatype
Table
COUNT()

39. = Equals - < Less Than - > Greater Than - <= Less Than or Equal To - >= Greater Than or Equal To - <> Not Equal - ! Negation of
Comparison Operators
varchar(size)
SQL extensions
SELECT *

40. Used to nest subqueries within another subquery.
Breaking up data
SUM()
Nested Subquery
WHERE

41. Limits the rows that appear in the result to those matching a specified condition
LIKE
Comparison Operators
WHERE
MAX()

42. A record in a table
Row
Table
Datatype
mysql

43. When selecting multiple columns be sure to specify a _____ BETWEEN each column name but NOT after the last column name.
Commas
Logical Operators
Self-Join
ANY

44. Ascending
ASC
AVG()
SUM()
char(size)

45. Used to select all the information in a specified column.
SELECT *
DELETE
Use of Whitespace
Breaking up data

46. Allows you to delete selected rows.
application
SELECT Statement
DESC
DELETE

47. Usually DBMS specific - these can provide extra functionality or simplified ways to perform specific operations.
AS
ASC
SQL extensions
COUNT()

48. A single field in a table. All tables are made up of one or more columns.
COUNT()
FROM
SELECT
Column

49. A column or set of columns whose values uniquely identify every row in a table.
SQL (Structured Query Language)
Primary Key
Self-Join
application

50. A reserved word that is part of the SQL language. Never name a table or column using a keyword.
Keyword
HAVING
Commas
GROUP BY