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. Descending
Aggregate Functions
Logical Operators
WHERE
DESC

2. The container - usually a file or set of files - to store organized data
Database
IN
Always define Primary Keys
LIKE

3. A popular open source database
INSERT INTO
Aggregate Functions
Row
mysql

4. Denotes that the search condition is TRUE for at least one element that the subquery returns.
Nested Subquery
UPDATE
SQL (Structured Query Language)
ANY

5. Multiple SQL statements must be separated by semicolons.
char(size)
Logical Operators
Terminating Statements
DISTINCT

6. Lets you use a single- or multiple-character wildcards. Also - this command does not function in Microsoft Access.
Aggregate Functions
LIKE
Self-Join
Use of Whitespace

7. _______ column name FROM table name
SELECT
Primary Key
char(size)
ANY

8. A language designed specifically for communicating with databases.
SQL (Structured Query Language)
Nested Subquery
SQL Statement and Case
MIN()

9. 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.
AVG()
char(size)
application
Row

10. SQL statements are case- insensitive
Commas
Nested Subquery
SQL Statement and Case
Keyword

11. A reserved word that is part of the SQL language. Never name a table or column using a keyword.
Row
Aggregate Functions
Keyword
Datatype

12. Allows you to correlate information between different rows of the same table and combine this information in rows of a result table.
number(size -d)
Self-Join
Logical Operators
Row

13. Lets you change the values in one or more selected rows of a table.
MAX()
Logical Operators
UPDATE
AVG()

14. Method used to copy multiple records at one time using a SELECT statement
COUNT()
INSERT INTO
UPDATE
number(size -d)

15. Alias
Aggregate Functions
Simple Subquery
AS
SQL Statement and Case

16. Combines rows from a SELECT statement's results table into groups in which specified columns have the same value.
mysql
GROUP BY
Database
ASC

17. Specify one or more columns on which to order the display.
ORDER BY
SELECT
SQL (Structured Query Language)
Comparison Operators

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

19. Ascending
MAX()
SELECT *
Commas
ASC

20. SQL is a language NOT an _______
SQL extensions
application
SELECT *
ASC

21. Provides a numerical tally of how many rows meet a specific set of criteria.
SELECT *
Row
COUNT()
GROUP BY

22. COUNT() - MAX() - MIN() - SUM() and AVG()
Keyword
Aggregate Functions
DELETE
AVG()

23. Prevents duplicate values witihin a table or group of rows from being used in the evaluation of the function's result
DISTINCT
LIKE
Primary Key
INSERT INTO

24. Number value with a maximum number of digits of "size" total - with a maximum number of "d" digits to the right of the decimal.
Breaking up data
Datatype
number(size -d)
ASC

25. Simplest type of subquery.
Simple Subquery
SELECT
WHERE
Comparison Operators

26. Specifies the tables or views from which rows and columns are retrieved
WHERE
MAX()
FROM
SQL extensions

27. = Equals - < Less Than - > Greater Than - <= Less Than or Equal To - >= Greater Than or Equal To - <> Not Equal - ! Negation of
char(size)
Always define Primary Keys
Comparison Operators
DELETE

28. A structured list of data of a specific type
Table
SELECT Statement
DBMS - Database Management System
Keyword

29. Fixed-length character string. Size is specified in parenthesis. Max 255 bytes.
WHERE
Logical Operators
char(size)
varchar(size)

30. A column or set of columns whose values uniquely identify every row in a table.
Primary Key
Aggregate Functions
INSERT INTO
AS

31. Used to select all the information in a specified column.
Logical Operators
SELECT *
UPDATE
mysql

32. When selecting multiple columns be sure to specify a _____ BETWEEN each column name but NOT after the last column name.
FROM
SUM()
INSERT INTO
Commas

33. NOT - AND - OR
UPDATE
SQL Statement and Case
Breaking up data
Logical Operators

34. Limits the output of the established groups into the derived result group.
AVG()
Database
HAVING
Commas

35. Primary way to do a query in SQL
char(size)
SELECT Statement
SELECT *
INSERT INTO

36. Limits the rows that appear in the result to those matching a specified condition
MAX()
WHERE
SUM()
UPDATE

37. Takes all of the values in that column and adds them together. Only works on columns containing numeric data.
DISTINCT
SQL Statement and Case
DELETE
SUM()

38. Database software (an application)
GROUP BY
DBMS - Database Management System
Logical Operators
SELECT Statement

39. A record in a table
SELECT Statement
AVG()
Row
number(size -d)

40. Allows a comparison with multiple values from a list.
SELECT Statement
INSERT INTO
IN
HAVING

41. Usually DBMS specific - these can provide extra functionality or simplified ways to perform specific operations.
DESC
SQL extensions
Primary Key
Row

42. Data must be broken into multiple columns correctly. For example - city - state - and zip should always separate columns.
Logical Operators
SQL (Structured Query Language)
Breaking up data
FROM

43. Takes a single numeric or alphabetic cloumn and finds the HIGHEST constant value within it.
DISTINCT
SQL Statement and Case
Row
MAX()

44. Takes a single numeric or alphabetic cloumn and finds the LOWEST constant value within it.
Primary Key
SELECT *
MIN()
AS

45. Allows you to delete selected rows.
DELETE
MAX()
SQL extensions
IN

46. Used to nest subqueries within another subquery.
Self-Join
SUM()
Nested Subquery
WHERE

47. Variable-length character string. Max size is specified in parenthesis.
INSERT INTO
varchar(size)
Terminating Statements
COUNT()

48. All extra whitespace within a SQL statement is is ignored when that statement is processed.
SELECT Statement
char(size)
Self-Join
Use of Whitespace

49. A single field in a table. All tables are made up of one or more columns.
Nested Subquery
Column
DELETE
DESC

50. 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.
SQL extensions
Always define Primary Keys
SQL (Structured Query Language)
SUM()