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
SQL Statement and Case
Aggregate Functions
SELECT *
Database

2. Multiple SQL statements must be separated by semicolons.
Primary Key
varchar(size)
Terminating Statements
Simple Subquery

3. SQL is a language NOT an _______
Commas
Comparison Operators
SELECT *
application

4. Usually DBMS specific - these can provide extra functionality or simplified ways to perform specific operations.
Table
Breaking up data
SQL extensions
ANY

5. Allows you to correlate information between different rows of the same table and combine this information in rows of a result table.
Self-Join
ASC
FROM
Keyword

6. Data must be broken into multiple columns correctly. For example - city - state - and zip should always separate columns.
Breaking up data
char(size)
UPDATE
Aggregate Functions

7. Used to select all the information in a specified column.
Datatype
Terminating Statements
SELECT *
COUNT()

8. Prevents duplicate values witihin a table or group of rows from being used in the evaluation of the function's result
IN
DISTINCT
Column
mysql

9. A type of allowed data. Every table column has a datatype that restricts specific data in that column.
Datatype
MAX()
Primary Key
number(size -d)

10. A column or set of columns whose values uniquely identify every row in a table.
varchar(size)
number(size -d)
Primary Key
GROUP BY

11. Denotes that the search condition is TRUE for at least one element that the subquery returns.
ASC
ANY
Logical Operators
char(size)

12. Specify one or more columns on which to order the display.
SQL extensions
char(size)
SQL (Structured Query Language)
ORDER BY

13. Descending
mysql
ANY
HAVING
DESC

14. NOT - AND - OR
Datatype
DBMS - Database Management System
Self-Join
Logical Operators

15. Method used to copy multiple records at one time using a SELECT statement
AVG()
Simple Subquery
GROUP BY
INSERT INTO

16. A reserved word that is part of the SQL language. Never name a table or column using a keyword.
mysql
Commas
Database
Keyword

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.
LIKE
Always define Primary Keys
ORDER BY
Keyword

18. Used to nest subqueries within another subquery.
Aggregate Functions
Nested Subquery
application
Always define Primary Keys

19. Database software (an application)
Column
varchar(size)
DBMS - Database Management System
SELECT

20. Provides a numerical tally of how many rows meet a specific set of criteria.
application
Table
COUNT()
MAX()

21. Takes all of the values in that column and adds them together. Only works on columns containing numeric data.
DESC
UPDATE
SUM()
MIN()

22. _______ column name FROM table name
SELECT
Comparison Operators
Logical Operators
Simple Subquery

23. Number value with a maximum number of digits of "size" total - with a maximum number of "d" digits to the right of the decimal.
Commas
DELETE
number(size -d)
SQL Statement and Case

24. Variable-length character string. Max size is specified in parenthesis.
Logical Operators
Row
GROUP BY
varchar(size)

25. Specifies the tables or views from which rows and columns are retrieved
INSERT INTO
FROM
SQL extensions
Commas

26. Allows a comparison with multiple values from a list.
Commas
IN
SELECT
INSERT INTO

27. Simplest type of subquery.
Nested Subquery
Simple Subquery
varchar(size)
Use of Whitespace

28. A record in a table
Nested Subquery
Row
ORDER BY
DELETE

29. A structured list of data of a specific type
Column
Table
Nested Subquery
SQL extensions

30. Primary way to do a query in SQL
SELECT
SQL (Structured Query Language)
FROM
SELECT Statement

31. Lets you change the values in one or more selected rows of a table.
UPDATE
Row
Use of Whitespace
Database

32. Limits the output of the established groups into the derived result group.
SQL extensions
SUM()
HAVING
Database

33. Takes a single numeric or alphabetic cloumn and finds the LOWEST constant value within it.
Table
SUM()
MIN()
number(size -d)

34. When selecting multiple columns be sure to specify a _____ BETWEEN each column name but NOT after the last column name.
DISTINCT
Nested Subquery
Commas
GROUP BY

35. The container - usually a file or set of files - to store organized data
Database
MAX()
DISTINCT
Primary Key

36. = Equals - < Less Than - > Greater Than - <= Less Than or Equal To - >= Greater Than or Equal To - <> Not Equal - ! Negation of
Comparison Operators
ANY
Nested Subquery
Database

37. A single field in a table. All tables are made up of one or more columns.
Comparison Operators
SQL extensions
varchar(size)
Column

38. COUNT() - MAX() - MIN() - SUM() and AVG()
Keyword
INSERT INTO
Aggregate Functions
SELECT Statement

39. Allows you to delete selected rows.
DELETE
Keyword
UPDATE
SUM()

40. A language designed specifically for communicating with databases.
ASC
Primary Key
SQL (Structured Query Language)
Breaking up data

41. A popular open source database
Nested Subquery
ORDER BY
DESC
mysql

42. Limits the rows that appear in the result to those matching a specified condition
SUM()
SQL Statement and Case
WHERE
Logical Operators

43. Alias
Comparison Operators
HAVING
MIN()
AS

44. Fixed-length character string. Size is specified in parenthesis. Max 255 bytes.
number(size -d)
ANY
Use of Whitespace
char(size)

45. Lets you use a single- or multiple-character wildcards. Also - this command does not function in Microsoft Access.
ORDER BY
number(size -d)
LIKE
DBMS - Database Management System

46. Takes a single numeric or alphabetic cloumn and finds the HIGHEST constant value within it.
MAX()
WHERE
Table
FROM

47. All extra whitespace within a SQL statement is is ignored when that statement is processed.
INSERT INTO
ORDER BY
Use of Whitespace
DELETE

48. Ascending
Table
Terminating Statements
ASC
Column

49. 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.
COUNT()
MAX()
AVG()
ORDER BY

50. Combines rows from a SELECT statement's results table into groups in which specified columns have the same value.
varchar(size)
GROUP BY
number(size -d)
LIKE