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
IN
FROM
SELECT
SUM()

2. A language designed specifically for communicating with databases.
Simple Subquery
Self-Join
SQL (Structured Query Language)
Comparison Operators

3. Primary way to do a query in SQL
Always define Primary Keys
SQL (Structured Query Language)
SUM()
SELECT Statement

4. Prevents duplicate values witihin a table or group of rows from being used in the evaluation of the function's result
DISTINCT
Aggregate Functions
SELECT *
varchar(size)

5. Used to select all the information in a specified column.
SELECT *
Comparison Operators
Row
varchar(size)

6. Lets you change the values in one or more selected rows of a table.
varchar(size)
Always define Primary Keys
Use of Whitespace
UPDATE

7. = Equals - < Less Than - > Greater Than - <= Less Than or Equal To - >= Greater Than or Equal To - <> Not Equal - ! Negation of
SELECT Statement
ORDER BY
Comparison Operators
UPDATE

8. A type of allowed data. Every table column has a datatype that restricts specific data in that column.
LIKE
Datatype
SQL extensions
Comparison Operators

9. Allows a comparison with multiple values from a list.
Comparison Operators
AS
WHERE
IN

10. Used to nest subqueries within another subquery.
SELECT Statement
LIKE
SQL extensions
Nested Subquery

11. Number value with a maximum number of digits of "size" total - with a maximum number of "d" digits to the right of the decimal.
INSERT INTO
SELECT *
number(size -d)
Self-Join

12. Takes a single numeric or alphabetic cloumn and finds the HIGHEST constant value within it.
Use of Whitespace
MAX()
varchar(size)
GROUP BY

13. Lets you use a single- or multiple-character wildcards. Also - this command does not function in Microsoft Access.
ANY
LIKE
SQL extensions
COUNT()

14. Simplest type of subquery.
Simple Subquery
AS
SQL extensions
MAX()

15. A column or set of columns whose values uniquely identify every row in a table.
Aggregate Functions
Comparison Operators
SQL Statement and Case
Primary Key

16. SQL statements are case- insensitive
Comparison Operators
COUNT()
SQL Statement and Case
Use of Whitespace

17. 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.
INSERT INTO
SQL Statement and Case
DBMS - Database Management System
Always define Primary Keys

18. Alias
ANY
SQL extensions
Self-Join
AS

19. Data must be broken into multiple columns correctly. For example - city - state - and zip should always separate columns.
Simple Subquery
ORDER BY
DISTINCT
Breaking up data

20. All extra whitespace within a SQL statement is is ignored when that statement is processed.
IN
COUNT()
Use of Whitespace
Commas

21. A structured list of data of a specific type
Row
Table
IN
Commas

22. Denotes that the search condition is TRUE for at least one element that the subquery returns.
Breaking up data
LIKE
ANY
Datatype

23. Ascending
HAVING
ANY
ASC
Row

24. Provides a numerical tally of how many rows meet a specific set of criteria.
number(size -d)
SELECT Statement
COUNT()
AVG()

25. A popular open source database
Row
Terminating Statements
Simple Subquery
mysql

26. Takes all of the values in that column and adds them together. Only works on columns containing numeric data.
Keyword
SUM()
ORDER BY
Use of Whitespace

27. SQL is a language NOT an _______
SELECT
application
Primary Key
LIKE

28. Usually DBMS specific - these can provide extra functionality or simplified ways to perform specific operations.
ASC
Column
SQL extensions
SELECT Statement

29. 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.
SQL (Structured Query Language)
AVG()
Table
Terminating Statements

30. Specify one or more columns on which to order the display.
Self-Join
HAVING
COUNT()
ORDER BY

31. When selecting multiple columns be sure to specify a _____ BETWEEN each column name but NOT after the last column name.
Commas
DBMS - Database Management System
Column
Self-Join

32. Limits the output of the established groups into the derived result group.
COUNT()
Database
HAVING
SELECT Statement

33. Allows you to correlate information between different rows of the same table and combine this information in rows of a result table.
Self-Join
Simple Subquery
Logical Operators
Table

34. Multiple SQL statements must be separated by semicolons.
Always define Primary Keys
Terminating Statements
INSERT INTO
DESC

35. Variable-length character string. Max size is specified in parenthesis.
varchar(size)
application
SELECT *
SUM()

36. Method used to copy multiple records at one time using a SELECT statement
WHERE
Nested Subquery
INSERT INTO
Row

37. Limits the rows that appear in the result to those matching a specified condition
Comparison Operators
WHERE
application
INSERT INTO

38. COUNT() - MAX() - MIN() - SUM() and AVG()
Aggregate Functions
ORDER BY
mysql
SQL extensions

39. A reserved word that is part of the SQL language. Never name a table or column using a keyword.
HAVING
GROUP BY
Self-Join
Keyword

40. NOT - AND - OR
SQL extensions
Always define Primary Keys
char(size)
Logical Operators

41. Database software (an application)
MAX()
DBMS - Database Management System
Keyword
Breaking up data

42. Takes a single numeric or alphabetic cloumn and finds the LOWEST constant value within it.
DESC
MAX()
MIN()
mysql

43. Combines rows from a SELECT statement's results table into groups in which specified columns have the same value.
IN
LIKE
GROUP BY
Column

44. Allows you to delete selected rows.
AVG()
DELETE
Database
Nested Subquery

45. The container - usually a file or set of files - to store organized data
Nested Subquery
Datatype
Database
char(size)

46. A record in a table
Aggregate Functions
SQL extensions
Row
UPDATE

47. _______ column name FROM table name
ORDER BY
Aggregate Functions
SELECT
Keyword

48. Descending
Self-Join
char(size)
MAX()
DESC

49. Fixed-length character string. Size is specified in parenthesis. Max 255 bytes.
GROUP BY
IN
SELECT Statement
char(size)

50. A single field in a table. All tables are made up of one or more columns.
LIKE
INSERT INTO
Column
SELECT *