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 is a language NOT an _______
application
varchar(size)
WHERE
Self-Join

2. Database software (an application)
HAVING
ASC
SELECT *
DBMS - Database Management System

3. When selecting multiple columns be sure to specify a _____ BETWEEN each column name but NOT after the last column name.
Column
Commas
COUNT()
LIKE

4. A language designed specifically for communicating with databases.
SQL (Structured Query Language)
HAVING
Commas
Table

5. A column or set of columns whose values uniquely identify every row in a table.
INSERT INTO
Primary Key
Keyword
DESC

6. Limits the rows that appear in the result to those matching a specified condition
DESC
SELECT Statement
DISTINCT
WHERE

7. Number value with a maximum number of digits of "size" total - with a maximum number of "d" digits to the right of the decimal.
ANY
Use of Whitespace
number(size -d)
AVG()

8. Specify one or more columns on which to order the display.
ORDER BY
ASC
INSERT INTO
char(size)

9. Lets you use a single- or multiple-character wildcards. Also - this command does not function in Microsoft Access.
LIKE
Column
Commas
DESC

10. Data must be broken into multiple columns correctly. For example - city - state - and zip should always separate columns.
Breaking up data
Row
Use of Whitespace
SQL (Structured Query Language)

11. A popular open source database
DISTINCT
mysql
SELECT *
SELECT

12. = Equals - < Less Than - > Greater Than - <= Less Than or Equal To - >= Greater Than or Equal To - <> Not Equal - ! Negation of
Column
ASC
mysql
Comparison Operators

13. Primary way to do a query in SQL
Terminating Statements
SELECT Statement
IN
SUM()

14. NOT - AND - OR
GROUP BY
Logical Operators
SELECT *
Table

15. Takes all of the values in that column and adds them together. Only works on columns containing numeric data.
Breaking up data
ASC
SUM()
SQL extensions

16. A record in a table
IN
Row
Column
SUM()

17. A reserved word that is part of the SQL language. Never name a table or column using a keyword.
Primary Key
Keyword
SQL Statement and Case
AS

18. 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
SELECT
LIKE
WHERE

19. Simplest type of subquery.
Simple Subquery
ANY
AVG()
Logical Operators

20. COUNT() - MAX() - MIN() - SUM() and AVG()
Table
Aggregate Functions
MIN()
SQL Statement and Case

21. Method used to copy multiple records at one time using a SELECT statement
SUM()
INSERT INTO
Commas
UPDATE

22. Descending
DESC
number(size -d)
SELECT
Table

23. Combines rows from a SELECT statement's results table into groups in which specified columns have the same value.
ORDER BY
GROUP BY
SQL (Structured Query Language)
varchar(size)

24. A structured list of data of a specific type
Table
LIKE
SUM()
Simple Subquery

25. A type of allowed data. Every table column has a datatype that restricts specific data in that column.
Datatype
varchar(size)
number(size -d)
SELECT *

26. Variable-length character string. Max size is specified in parenthesis.
Aggregate Functions
varchar(size)
DBMS - Database Management System
GROUP BY

27. Takes a single numeric or alphabetic cloumn and finds the HIGHEST constant value within it.
AVG()
SELECT Statement
MAX()
ANY

28. Takes a single numeric or alphabetic cloumn and finds the LOWEST constant value within it.
COUNT()
SQL Statement and Case
MIN()
DISTINCT

29. Limits the output of the established groups into the derived result group.
HAVING
GROUP BY
ASC
IN

30. Allows you to delete selected rows.
DELETE
INSERT INTO
DESC
WHERE

31. Allows you to correlate information between different rows of the same table and combine this information in rows of a result table.
Breaking up data
Self-Join
GROUP BY
SELECT Statement

32. Prevents duplicate values witihin a table or group of rows from being used in the evaluation of the function's result
Row
DESC
Database
DISTINCT

33. Specifies the tables or views from which rows and columns are retrieved
FROM
SQL Statement and Case
Nested Subquery
DISTINCT

34. Usually DBMS specific - these can provide extra functionality or simplified ways to perform specific operations.
COUNT()
DESC
Self-Join
SQL extensions

35. All extra whitespace within a SQL statement is is ignored when that statement is processed.
Datatype
number(size -d)
Use of Whitespace
LIKE

36. Used to select all the information in a specified column.
Keyword
Always define Primary Keys
char(size)
SELECT *

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

38. Lets you change the values in one or more selected rows of a table.
IN
UPDATE
GROUP BY
Use of Whitespace

39. _______ column name FROM table name
Self-Join
SELECT
SUM()
ORDER BY

40. Allows a comparison with multiple values from a list.
ORDER BY
SUM()
application
IN

41. Provides a numerical tally of how many rows meet a specific set of criteria.
Self-Join
IN
COUNT()
Use of Whitespace

42. Denotes that the search condition is TRUE for at least one element that the subquery returns.
Always define Primary Keys
ANY
SQL Statement and Case
FROM

43. Multiple SQL statements must be separated by semicolons.
COUNT()
Terminating Statements
char(size)
Nested Subquery

44. SQL statements are case- insensitive
DELETE
SQL Statement and Case
GROUP BY
Column

45. 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()
SQL Statement and Case
Nested Subquery
MAX()

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

47. Fixed-length character string. Size is specified in parenthesis. Max 255 bytes.
SELECT *
MIN()
AVG()
char(size)

48. Ascending
Primary Key
ASC
AVG()
SELECT *

49. Alias
Nested Subquery
AS
ORDER BY
Datatype

50. Used to nest subqueries within another subquery.
ORDER BY
Nested Subquery
Logical Operators
Terminating Statements