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. SQL statements are case- insensitive
mysql
Terminating Statements
ORDER BY
SQL Statement and Case

2. A structured list of data of a specific type
Aggregate Functions
Self-Join
Table
number(size -d)

3. Specify one or more columns on which to order the display.
ORDER BY
Logical Operators
Datatype
MIN()

4. When selecting multiple columns be sure to specify a _____ BETWEEN each column name but NOT after the last column name.
DELETE
Self-Join
Row
Commas

5. Usually DBMS specific - these can provide extra functionality or simplified ways to perform specific operations.
number(size -d)
Nested Subquery
SQL extensions
COUNT()

6. Used to nest subqueries within another subquery.
WHERE
Nested Subquery
UPDATE
char(size)

7. Simplest type of subquery.
SQL Statement and Case
DBMS - Database Management System
SELECT *
Simple Subquery

8. Used to select all the information in a specified column.
SELECT *
Breaking up data
Database
GROUP BY

9. Allows you to correlate information between different rows of the same table and combine this information in rows of a result table.
HAVING
Self-Join
Row
GROUP BY

10. Alias
Logical Operators
COUNT()
AS
Self-Join

11. A column or set of columns whose values uniquely identify every row in a table.
Primary Key
WHERE
SQL extensions
GROUP BY

12. All extra whitespace within a SQL statement is is ignored when that statement is processed.
DELETE
Column
Use of Whitespace
Primary Key

13. Limits the output of the established groups into the derived result group.
FROM
Simple Subquery
DBMS - Database Management System
HAVING

14. Lets you change the values in one or more selected rows of a table.
SUM()
MIN()
Row
UPDATE

15. Takes a single numeric or alphabetic cloumn and finds the LOWEST constant value within it.
MIN()
mysql
SQL Statement and Case
SELECT *

16. SQL is a language NOT an _______
SQL extensions
INSERT INTO
Breaking up data
application

17. Combines rows from a SELECT statement's results table into groups in which specified columns have the same value.
ORDER BY
DISTINCT
GROUP BY
Aggregate Functions

18. _______ column name FROM table name
SQL extensions
Aggregate Functions
SELECT
AS

19. A language designed specifically for communicating with databases.
SQL (Structured Query Language)
WHERE
DBMS - Database Management System
SELECT *

20. Lets you use a single- or multiple-character wildcards. Also - this command does not function in Microsoft Access.
Simple Subquery
ORDER BY
Column
LIKE

21. A single field in a table. All tables are made up of one or more columns.
SUM()
UPDATE
Use of Whitespace
Column

22. Allows a comparison with multiple values from a list.
Keyword
DELETE
IN
DISTINCT

23. A popular open source database
mysql
ANY
Always define Primary Keys
Breaking up data

24. COUNT() - MAX() - MIN() - SUM() and AVG()
Database
Primary Key
number(size -d)
Aggregate Functions

25. Denotes that the search condition is TRUE for at least one element that the subquery returns.
GROUP BY
ANY
IN
Database

26. Number value with a maximum number of digits of "size" total - with a maximum number of "d" digits to the right of the decimal.
SQL extensions
Column
number(size -d)
MAX()

27. A record in a table
Commas
Aggregate Functions
Row
Self-Join

28. Fixed-length character string. Size is specified in parenthesis. Max 255 bytes.
DBMS - Database Management System
SELECT
char(size)
COUNT()

29. Specifies the tables or views from which rows and columns are retrieved
FROM
DELETE
Use of Whitespace
SQL extensions

30. 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 Statement and Case
Database
Always define Primary Keys
Simple Subquery

31. Primary way to do a query in SQL
SQL extensions
ASC
LIKE
SELECT Statement

32. Database software (an application)
LIKE
AVG()
mysql
DBMS - Database Management System

33. Allows you to delete selected rows.
application
MAX()
DELETE
SQL (Structured Query Language)

34. Variable-length character string. Max size is specified in parenthesis.
DBMS - Database Management System
LIKE
varchar(size)
Database

35. The container - usually a file or set of files - to store organized data
DESC
IN
Database
ORDER BY

36. Multiple SQL statements must be separated by semicolons.
MAX()
WHERE
Terminating Statements
varchar(size)

37. Limits the rows that appear in the result to those matching a specified condition
SELECT *
Use of Whitespace
WHERE
Commas

38. A reserved word that is part of the SQL language. Never name a table or column using a keyword.
number(size -d)
Use of Whitespace
Keyword
ASC

39. = Equals - < Less Than - > Greater Than - <= Less Than or Equal To - >= Greater Than or Equal To - <> Not Equal - ! Negation of
MAX()
Comparison Operators
MIN()
Breaking up data

40. A type of allowed data. Every table column has a datatype that restricts specific data in that column.
Datatype
WHERE
AS
GROUP BY

41. Data must be broken into multiple columns correctly. For example - city - state - and zip should always separate columns.
Primary Key
MIN()
Table
Breaking up data

42. Descending
HAVING
SUM()
DESC
DBMS - Database Management System

43. Prevents duplicate values witihin a table or group of rows from being used in the evaluation of the function's result
AS
Breaking up data
DISTINCT
DESC

44. 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.
DBMS - Database Management System
GROUP BY
AVG()
SQL extensions

45. Takes a single numeric or alphabetic cloumn and finds the HIGHEST constant value within it.
Primary Key
Use of Whitespace
Simple Subquery
MAX()

46. Method used to copy multiple records at one time using a SELECT statement
Self-Join
COUNT()
MAX()
INSERT INTO

47. NOT - AND - OR
LIKE
DISTINCT
Logical Operators
SQL extensions

48. Takes all of the values in that column and adds them together. Only works on columns containing numeric data.
SUM()
Database
Comparison Operators
varchar(size)

49. Ascending
Use of Whitespace
Comparison Operators
Column
ASC

50. Provides a numerical tally of how many rows meet a specific set of criteria.
DESC
DELETE
COUNT()
GROUP BY