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. Specifies the tables or views from which rows and columns are retrieved
Keyword
Row
FROM
SELECT

2. Database software (an application)
Table
DBMS - Database Management System
Comparison Operators
Commas

3. Simplest type of subquery.
HAVING
Comparison Operators
Simple Subquery
MAX()

4. Descending
WHERE
DESC
Column
Use of Whitespace

5. Specify one or more columns on which to order the display.
SELECT Statement
ORDER BY
DBMS - Database Management System
HAVING

6. All extra whitespace within a SQL statement is is ignored when that statement is processed.
Use of Whitespace
Primary Key
Commas
Table

7. The container - usually a file or set of files - to store organized data
Database
Nested Subquery
SQL extensions
ANY

8. Allows a comparison with multiple values from a list.
UPDATE
IN
GROUP BY
mysql

9. A column or set of columns whose values uniquely identify every row in a table.
UPDATE
SELECT
Primary Key
SUM()

10. A reserved word that is part of the SQL language. Never name a table or column using a keyword.
AVG()
UPDATE
application
Keyword

11. Method used to copy multiple records at one time using a SELECT statement
application
Nested Subquery
AS
INSERT INTO

12. = Equals - < Less Than - > Greater Than - <= Less Than or Equal To - >= Greater Than or Equal To - <> Not Equal - ! Negation of
LIKE
WHERE
INSERT INTO
Comparison Operators

13. Limits the output of the established groups into the derived result group.
HAVING
IN
Nested Subquery
Datatype

14. Used to nest subqueries within another subquery.
IN
DBMS - Database Management System
DISTINCT
Nested Subquery

15. NOT - AND - OR
Primary Key
Self-Join
SQL Statement and Case
Logical Operators

16. Takes a single numeric or alphabetic cloumn and finds the LOWEST constant value within it.
Datatype
Breaking up data
MIN()
Terminating Statements

17. Denotes that the search condition is TRUE for at least one element that the subquery returns.
application
LIKE
Database
ANY

18. COUNT() - MAX() - MIN() - SUM() and AVG()
Aggregate Functions
Nested Subquery
Table
DESC

19. Used to select all the information in a specified column.
SUM()
SELECT *
AVG()
Database

20. Lets you change the values in one or more selected rows of a table.
UPDATE
Column
Comparison Operators
WHERE

21. Lets you use a single- or multiple-character wildcards. Also - this command does not function in Microsoft Access.
LIKE
number(size -d)
ASC
Use of Whitespace

22. Provides a numerical tally of how many rows meet a specific set of criteria.
Always define Primary Keys
MAX()
COUNT()
SELECT Statement

23. Prevents duplicate values witihin a table or group of rows from being used in the evaluation of the function's result
varchar(size)
SELECT Statement
DISTINCT
Simple Subquery

24. A language designed specifically for communicating with databases.
SQL (Structured Query Language)
Comparison Operators
MIN()
Table

25. SQL statements are case- insensitive
DESC
SQL Statement and Case
FROM
Primary Key

26. Data must be broken into multiple columns correctly. For example - city - state - and zip should always separate columns.
WHERE
Breaking up data
ANY
Table

27. 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.
UPDATE
Column
AVG()
ANY

28. Primary way to do a query in SQL
Column
DBMS - Database Management System
Table
SELECT Statement

29. Allows you to delete selected rows.
DELETE
Row
Logical Operators
Simple Subquery

30. A record in a table
Keyword
LIKE
UPDATE
Row

31. A type of allowed data. Every table column has a datatype that restricts specific data in that column.
Self-Join
SELECT Statement
mysql
Datatype

32. Ascending
ASC
Keyword
INSERT INTO
SQL extensions

33. Variable-length character string. Max size is specified in parenthesis.
varchar(size)
Use of Whitespace
GROUP BY
WHERE

34. Combines rows from a SELECT statement's results table into groups in which specified columns have the same value.
Commas
UPDATE
GROUP BY
Self-Join

35. Multiple SQL statements must be separated by semicolons.
DESC
Keyword
Terminating Statements
Aggregate Functions

36. A structured list of data of a specific type
Table
UPDATE
char(size)
SUM()

37. Number value with a maximum number of digits of "size" total - with a maximum number of "d" digits to the right of the decimal.
Keyword
SELECT Statement
Aggregate Functions
number(size -d)

38. _______ column name FROM table name
SELECT Statement
Nested Subquery
SELECT
Breaking up data

39. Fixed-length character string. Size is specified in parenthesis. Max 255 bytes.
Nested Subquery
GROUP BY
Commas
char(size)

40. SQL is a language NOT an _______
Row
application
Keyword
Use of Whitespace

41. 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.
WHERE
Comparison Operators
Always define Primary Keys
MAX()

42. A popular open source database
mysql
char(size)
number(size -d)
Always define Primary Keys

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

44. Alias
DELETE
char(size)
AS
AVG()

45. Limits the rows that appear in the result to those matching a specified condition
WHERE
SQL (Structured Query Language)
Datatype
LIKE

46. Allows you to correlate information between different rows of the same table and combine this information in rows of a result table.
Commas
COUNT()
FROM
Self-Join

47. Takes a single numeric or alphabetic cloumn and finds the HIGHEST constant value within it.
Comparison Operators
WHERE
MAX()
Self-Join

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

49. When selecting multiple columns be sure to specify a _____ BETWEEN each column name but NOT after the last column name.
Comparison Operators
SQL extensions
Commas
DELETE

50. A single field in a table. All tables are made up of one or more columns.
Datatype
AVG()
Column
SELECT *