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. Specify one or more columns on which to order the display.
mysql
ASC
ORDER BY
SUM()

2. COUNT() - MAX() - MIN() - SUM() and AVG()
DESC
number(size -d)
Aggregate Functions
Simple Subquery

3. Multiple SQL statements must be separated by semicolons.
Database
COUNT()
Terminating Statements
GROUP BY

4. A popular open source database
Row
mysql
Nested Subquery
FROM

5. Takes a single numeric or alphabetic cloumn and finds the LOWEST constant value within it.
Use of Whitespace
Terminating Statements
MIN()
SELECT *

6. 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.
Database
IN
AVG()
MIN()

7. Ascending
MIN()
Self-Join
ASC
SUM()

8. Lets you change the values in one or more selected rows of a table.
Always define Primary Keys
SQL extensions
IN
UPDATE

9. Data must be broken into multiple columns correctly. For example - city - state - and zip should always separate columns.
Breaking up data
SELECT
Simple Subquery
AVG()

10. A record in a table
mysql
Nested Subquery
Datatype
Row

11. Fixed-length character string. Size is specified in parenthesis. Max 255 bytes.
SQL (Structured Query Language)
AS
SUM()
char(size)

12. Alias
Simple Subquery
Breaking up data
AS
SELECT *

13. Specifies the tables or views from which rows and columns are retrieved
FROM
Table
COUNT()
SQL (Structured Query Language)

14. Limits the rows that appear in the result to those matching a specified condition
Datatype
Logical Operators
WHERE
Terminating Statements

15. A structured list of data of a specific type
SQL (Structured Query Language)
Table
Always define Primary Keys
Column

16. Takes a single numeric or alphabetic cloumn and finds the HIGHEST constant value within it.
DISTINCT
varchar(size)
WHERE
MAX()

17. SQL statements are case- insensitive
SQL Statement and Case
Simple Subquery
DBMS - Database Management System
Database

18. All extra whitespace within a SQL statement is is ignored when that statement is processed.
Table
mysql
UPDATE
Use of Whitespace

19. Used to nest subqueries within another subquery.
DESC
AVG()
Self-Join
Nested Subquery

20. Lets you use a single- or multiple-character wildcards. Also - this command does not function in Microsoft Access.
number(size -d)
LIKE
DISTINCT
Column

21. = Equals - < Less Than - > Greater Than - <= Less Than or Equal To - >= Greater Than or Equal To - <> Not Equal - ! Negation of
ORDER BY
Column
Comparison Operators
Row

22. Descending
DESC
HAVING
SQL extensions
Use of Whitespace

23. Method used to copy multiple records at one time using a SELECT statement
SELECT Statement
UPDATE
INSERT INTO
FROM

24. SQL is a language NOT an _______
Row
varchar(size)
WHERE
application

25. Provides a numerical tally of how many rows meet a specific set of criteria.
Terminating Statements
COUNT()
varchar(size)
Database

26. Takes all of the values in that column and adds them together. Only works on columns containing numeric data.
Comparison Operators
Column
UPDATE
SUM()

27. Database software (an application)
SELECT Statement
ORDER BY
DBMS - Database Management System
LIKE

28. 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.
ANY
Always define Primary Keys
Logical Operators
ASC

29. When selecting multiple columns be sure to specify a _____ BETWEEN each column name but NOT after the last column name.
Commas
Breaking up data
Keyword
SELECT *

30. A column or set of columns whose values uniquely identify every row in a table.
Primary Key
application
ORDER BY
SQL (Structured Query Language)

31. A language designed specifically for communicating with databases.
INSERT INTO
SQL (Structured Query Language)
LIKE
SQL Statement and Case

32. NOT - AND - OR
Column
varchar(size)
Logical Operators
WHERE

33. The container - usually a file or set of files - to store organized data
AS
Database
Table
number(size -d)

34. Denotes that the search condition is TRUE for at least one element that the subquery returns.
HAVING
Nested Subquery
ANY
Primary Key

35. Variable-length character string. Max size is specified in parenthesis.
char(size)
Datatype
AS
varchar(size)

36. Allows you to delete selected rows.
Comparison Operators
Keyword
DELETE
SQL Statement and Case

37. Combines rows from a SELECT statement's results table into groups in which specified columns have the same value.
SQL extensions
COUNT()
GROUP BY
Commas

38. A type of allowed data. Every table column has a datatype that restricts specific data in that column.
MIN()
Datatype
DBMS - Database Management System
Database

39. Used to select all the information in a specified column.
AVG()
varchar(size)
INSERT INTO
SELECT *

40. Allows you to correlate information between different rows of the same table and combine this information in rows of a result table.
Self-Join
ORDER BY
WHERE
Keyword

41. Allows a comparison with multiple values from a list.
IN
FROM
char(size)
AVG()

42. Prevents duplicate values witihin a table or group of rows from being used in the evaluation of the function's result
DISTINCT
HAVING
Use of Whitespace
Database

43. Usually DBMS specific - these can provide extra functionality or simplified ways to perform specific operations.
AVG()
Primary Key
SQL extensions
Logical Operators

44. Simplest type of subquery.
Self-Join
Keyword
varchar(size)
Simple Subquery

45. A reserved word that is part of the SQL language. Never name a table or column using a keyword.
LIKE
Keyword
Simple Subquery
SELECT *

46. Number value with a maximum number of digits of "size" total - with a maximum number of "d" digits to the right of the decimal.
SQL extensions
LIKE
Comparison Operators
number(size -d)

47. _______ column name FROM table name
mysql
Table
SQL Statement and Case
SELECT

48. Limits the output of the established groups into the derived result group.
mysql
DELETE
HAVING
ANY

49. Primary way to do a query in SQL
GROUP BY
SUM()
SELECT Statement
Nested Subquery

50. A single field in a table. All tables are made up of one or more columns.
Column
DBMS - Database Management System
WHERE
varchar(size)