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. The container - usually a file or set of files - to store organized data
Database
Terminating Statements
HAVING
FROM

2. Provides a numerical tally of how many rows meet a specific set of criteria.
AS
Database
HAVING
COUNT()

3. A reserved word that is part of the SQL language. Never name a table or column using a keyword.
Row
Keyword
ANY
COUNT()

4. _______ column name FROM table name
Nested Subquery
Keyword
SELECT Statement
SELECT

5. A structured list of data of a specific type
Table
SQL (Structured Query Language)
Use of Whitespace
SELECT Statement

6. Multiple SQL statements must be separated by semicolons.
SQL Statement and Case
Terminating Statements
Breaking up data
application

7. Specifies the tables or views from which rows and columns are retrieved
FROM
Commas
Table
AS

8. Denotes that the search condition is TRUE for at least one element that the subquery returns.
GROUP BY
Commas
SELECT *
ANY

9. A type of allowed data. Every table column has a datatype that restricts specific data in that column.
DELETE
Datatype
DESC
WHERE

10. 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.
Always define Primary Keys
DELETE
SQL Statement and Case
SUM()

11. Database software (an application)
Comparison Operators
Row
Always define Primary Keys
DBMS - Database Management System

12. Combines rows from a SELECT statement's results table into groups in which specified columns have the same value.
SELECT *
GROUP BY
SQL extensions
application

13. A popular open source database
SELECT
mysql
COUNT()
DELETE

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

15. = Equals - < Less Than - > Greater Than - <= Less Than or Equal To - >= Greater Than or Equal To - <> Not Equal - ! Negation of
GROUP BY
Primary Key
Comparison Operators
DESC

16. Allows you to delete selected rows.
Comparison Operators
DELETE
ORDER BY
FROM

17. Allows you to correlate information between different rows of the same table and combine this information in rows of a result table.
Table
Comparison Operators
Self-Join
Use of Whitespace

18. 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.
FROM
DISTINCT
AVG()
Logical Operators

19. Takes a single numeric or alphabetic cloumn and finds the HIGHEST constant value within it.
Column
char(size)
MAX()
WHERE

20. SQL statements are case- insensitive
Datatype
DISTINCT
AS
SQL Statement and Case

21. Limits the output of the established groups into the derived result group.
SQL (Structured Query Language)
HAVING
AVG()
Datatype

22. A column or set of columns whose values uniquely identify every row in a table.
MAX()
SQL extensions
Primary Key
application

23. Used to nest subqueries within another subquery.
ANY
Nested Subquery
number(size -d)
UPDATE

24. Simplest type of subquery.
number(size -d)
Simple Subquery
MAX()
Use of Whitespace

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

26. Fixed-length character string. Size is specified in parenthesis. Max 255 bytes.
Table
char(size)
Breaking up data
MIN()

27. NOT - AND - OR
Logical Operators
WHERE
Comparison Operators
DBMS - Database Management System

28. SQL is a language NOT an _______
application
IN
Datatype
Aggregate Functions

29. Lets you use a single- or multiple-character wildcards. Also - this command does not function in Microsoft Access.
IN
FROM
LIKE
Comparison Operators

30. All extra whitespace within a SQL statement is is ignored when that statement is processed.
SQL (Structured Query Language)
SELECT *
Use of Whitespace
Keyword

31. Descending
Keyword
DESC
LIKE
SQL (Structured Query Language)

32. COUNT() - MAX() - MIN() - SUM() and AVG()
Datatype
ORDER BY
Aggregate Functions
varchar(size)

33. Used to select all the information in a specified column.
SQL extensions
SELECT *
LIKE
AVG()

34. Takes a single numeric or alphabetic cloumn and finds the LOWEST constant value within it.
Database
Self-Join
MIN()
GROUP BY

35. A language designed specifically for communicating with databases.
SQL (Structured Query Language)
IN
Use of Whitespace
Breaking up data

36. Usually DBMS specific - these can provide extra functionality or simplified ways to perform specific operations.
UPDATE
SELECT Statement
SQL extensions
Use of Whitespace

37. Alias
AS
Use of Whitespace
SUM()
Primary Key

38. Limits the rows that appear in the result to those matching a specified condition
Logical Operators
WHERE
Database
DELETE

39. A single field in a table. All tables are made up of one or more columns.
Always define Primary Keys
number(size -d)
INSERT INTO
Column

40. Lets you change the values in one or more selected rows of a table.
Aggregate Functions
UPDATE
application
Always define Primary Keys

41. Variable-length character string. Max size is specified in parenthesis.
GROUP BY
Simple Subquery
Column
varchar(size)

42. Ascending
Comparison Operators
WHERE
Column
ASC

43. Prevents duplicate values witihin a table or group of rows from being used in the evaluation of the function's result
DISTINCT
COUNT()
Datatype
FROM

44. Number value with a maximum number of digits of "size" total - with a maximum number of "d" digits to the right of the decimal.
mysql
AS
UPDATE
number(size -d)

45. Specify one or more columns on which to order the display.
number(size -d)
Comparison Operators
ORDER BY
IN

46. Primary way to do a query in SQL
ASC
ORDER BY
SELECT Statement
varchar(size)

47. Data must be broken into multiple columns correctly. For example - city - state - and zip should always separate columns.
SELECT *
Breaking up data
Comparison Operators
mysql

48. When selecting multiple columns be sure to specify a _____ BETWEEN each column name but NOT after the last column name.
SQL Statement and Case
Nested Subquery
SELECT
Commas

49. A record in a table
Database
SQL Statement and Case
SQL (Structured Query Language)
Row

50. Method used to copy multiple records at one time using a SELECT statement
Use of Whitespace
INSERT INTO
GROUP BY
Always define Primary Keys