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. Denotes that the search condition is TRUE for at least one element that the subquery returns.
SQL extensions
ANY
MAX()
Table

2. SQL statements are case- insensitive
SQL Statement and Case
Self-Join
UPDATE
Breaking up data

3. Used to select all the information in a specified column.
MAX()
Table
Commas
SELECT *

4. COUNT() - MAX() - MIN() - SUM() and AVG()
AVG()
Breaking up data
Nested Subquery
Aggregate Functions

5. Multiple SQL statements must be separated by semicolons.
SELECT
Terminating Statements
char(size)
SQL Statement and Case

6. A reserved word that is part of the SQL language. Never name a table or column using a keyword.
ASC
GROUP BY
Keyword
SQL extensions

7. A language designed specifically for communicating with databases.
number(size -d)
INSERT INTO
SQL extensions
SQL (Structured Query Language)

8. Simplest type of subquery.
ASC
Row
Simple Subquery
Primary Key

9. Number value with a maximum number of digits of "size" total - with a maximum number of "d" digits to the right of the decimal.
LIKE
Commas
Keyword
number(size -d)

10. = Equals - < Less Than - > Greater Than - <= Less Than or Equal To - >= Greater Than or Equal To - <> Not Equal - ! Negation of
Column
SELECT Statement
varchar(size)
Comparison Operators

11. Specifies the tables or views from which rows and columns are retrieved
FROM
Primary Key
Breaking up data
SELECT Statement

12. Fixed-length character string. Size is specified in parenthesis. Max 255 bytes.
ORDER BY
Logical Operators
char(size)
mysql

13. Used to nest subqueries within another subquery.
AVG()
Terminating Statements
Nested Subquery
Aggregate Functions

14. NOT - AND - OR
AS
SELECT
Logical Operators
SUM()

15. Provides a numerical tally of how many rows meet a specific set of criteria.
COUNT()
ASC
Breaking up data
Use of Whitespace

16. Limits the output of the established groups into the derived result group.
ANY
char(size)
AVG()
HAVING

17. Allows you to delete selected rows.
DELETE
LIKE
varchar(size)
Datatype

18. A single field in a table. All tables are made up of one or more columns.
MAX()
char(size)
Breaking up data
Column

19. Primary way to do a query in SQL
DBMS - Database Management System
Commas
SELECT Statement
DESC

20. 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
ORDER BY
ASC
DESC

21. When selecting multiple columns be sure to specify a _____ BETWEEN each column name but NOT after the last column name.
DBMS - Database Management System
UPDATE
Keyword
Commas

22. Allows you to correlate information between different rows of the same table and combine this information in rows of a result table.
Keyword
ANY
Simple Subquery
Self-Join

23. Allows a comparison with multiple values from a list.
Table
IN
SELECT Statement
ASC

24. _______ column name FROM table name
UPDATE
Logical Operators
SELECT
SQL extensions

25. Prevents duplicate values witihin a table or group of rows from being used in the evaluation of the function's result
Simple Subquery
ANY
DISTINCT
HAVING

26. A type of allowed data. Every table column has a datatype that restricts specific data in that column.
application
Aggregate Functions
Datatype
SQL Statement and Case

27. Takes a single numeric or alphabetic cloumn and finds the LOWEST constant value within it.
Database
application
MIN()
mysql

28. Data must be broken into multiple columns correctly. For example - city - state - and zip should always separate columns.
Row
Self-Join
Breaking up data
application

29. Alias
SELECT *
AS
DBMS - Database Management System
Simple Subquery

30. Ascending
DBMS - Database Management System
Primary Key
ASC
Row

31. Variable-length character string. Max size is specified in parenthesis.
Always define Primary Keys
Simple Subquery
varchar(size)
Row

32. Usually DBMS specific - these can provide extra functionality or simplified ways to perform specific operations.
INSERT INTO
FROM
SQL extensions
AS

33. Limits the rows that appear in the result to those matching a specified condition
Primary Key
WHERE
Terminating Statements
LIKE

34. 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.
Primary Key
Commas
Breaking up data
AVG()

35. Combines rows from a SELECT statement's results table into groups in which specified columns have the same value.
DBMS - Database Management System
GROUP BY
Commas
AVG()

36. A column or set of columns whose values uniquely identify every row in a table.
Primary Key
Comparison Operators
mysql
Use of Whitespace

37. Descending
DESC
Datatype
mysql
SQL (Structured Query Language)

38. A structured list of data of a specific type
application
SUM()
ORDER BY
Table

39. Lets you change the values in one or more selected rows of a table.
Column
UPDATE
number(size -d)
Aggregate Functions

40. Takes all of the values in that column and adds them together. Only works on columns containing numeric data.
SUM()
DBMS - Database Management System
mysql
SELECT *

41. The container - usually a file or set of files - to store organized data
varchar(size)
Database
MIN()
SUM()

42. A record in a table
Row
IN
Terminating Statements
Aggregate Functions

43. Lets you use a single- or multiple-character wildcards. Also - this command does not function in Microsoft Access.
Self-Join
AVG()
varchar(size)
LIKE

44. Database software (an application)
DESC
DBMS - Database Management System
Aggregate Functions
Simple Subquery

45. Takes a single numeric or alphabetic cloumn and finds the HIGHEST constant value within it.
SQL Statement and Case
Use of Whitespace
MAX()
Commas

46. All extra whitespace within a SQL statement is is ignored when that statement is processed.
SQL (Structured Query Language)
Always define Primary Keys
Use of Whitespace
Database

47. SQL is a language NOT an _______
AVG()
ORDER BY
application
MIN()

48. Method used to copy multiple records at one time using a SELECT statement
INSERT INTO
MIN()
Commas
DELETE

49. Specify one or more columns on which to order the display.
mysql
Primary Key
DBMS - Database Management System
ORDER BY

50. A popular open source database
mysql
Simple Subquery
COUNT()
SELECT *