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. Allows a comparison with multiple values from a list.
DELETE
IN
Table
Simple Subquery

2. SQL is a language NOT an _______
DESC
application
Database
IN

3. Alias
mysql
Nested Subquery
Use of Whitespace
AS

4. Lets you use a single- or multiple-character wildcards. Also - this command does not function in Microsoft Access.
LIKE
Column
SELECT *
Use of Whitespace

5. Takes a single numeric or alphabetic cloumn and finds the HIGHEST constant value within it.
ASC
SQL Statement and Case
MAX()
mysql

6. Used to select all the information in a specified column.
Primary Key
HAVING
SELECT *
INSERT INTO

7. Limits the rows that appear in the result to those matching a specified condition
WHERE
number(size -d)
Comparison Operators
UPDATE

8. Used to nest subqueries within another subquery.
ANY
Nested Subquery
Self-Join
Row

9. Usually DBMS specific - these can provide extra functionality or simplified ways to perform specific operations.
MIN()
SQL extensions
Terminating Statements
Keyword

10. Database software (an application)
LIKE
COUNT()
Primary Key
DBMS - Database Management System

11. = Equals - < Less Than - > Greater Than - <= Less Than or Equal To - >= Greater Than or Equal To - <> Not Equal - ! Negation of
Use of Whitespace
MIN()
Keyword
Comparison Operators

12. Variable-length character string. Max size is specified in parenthesis.
SUM()
FROM
DELETE
varchar(size)

13. Multiple SQL statements must be separated by semicolons.
Terminating Statements
number(size -d)
SQL Statement and Case
INSERT INTO

14. A popular open source database
Terminating Statements
mysql
DBMS - Database Management System
Self-Join

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

16. A single field in a table. All tables are made up of one or more columns.
Comparison Operators
IN
FROM
Column

17. Primary way to do a query in SQL
UPDATE
GROUP BY
SELECT Statement
FROM

18. Descending
char(size)
DESC
LIKE
Simple Subquery

19. COUNT() - MAX() - MIN() - SUM() and AVG()
Primary Key
Aggregate Functions
ANY
Comparison Operators

20. Allows you to correlate information between different rows of the same table and combine this information in rows of a result table.
Column
IN
SQL Statement and Case
Self-Join

21. Ascending
ASC
Breaking up data
Comparison Operators
ANY

22. Fixed-length character string. Size is specified in parenthesis. Max 255 bytes.
SELECT *
Breaking up data
number(size -d)
char(size)

23. Allows you to delete selected rows.
DELETE
Aggregate Functions
FROM
AVG()

24. Lets you change the values in one or more selected rows of a table.
SELECT
Terminating Statements
UPDATE
Simple Subquery

25. Combines rows from a SELECT statement's results table into groups in which specified columns have the same value.
Breaking up data
Keyword
HAVING
GROUP BY

26. Specifies the tables or views from which rows and columns are retrieved
MIN()
Comparison Operators
FROM
DBMS - Database Management System

27. _______ column name FROM table name
SELECT
ANY
ASC
Row

28. A record in a table
char(size)
Row
DESC
Database

29. Data must be broken into multiple columns correctly. For example - city - state - and zip should always separate columns.
IN
LIKE
Breaking up data
application

30. Specify one or more columns on which to order the display.
SQL extensions
LIKE
Keyword
ORDER BY

31. A type of allowed data. Every table column has a datatype that restricts specific data in that column.
Simple Subquery
Always define Primary Keys
COUNT()
Datatype

32. SQL statements are case- insensitive
Breaking up data
INSERT INTO
Column
SQL Statement and Case

33. NOT - AND - OR
Logical Operators
HAVING
UPDATE
Breaking up data

34. 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.
Keyword
Always define Primary Keys
SUM()
SQL extensions

35. The container - usually a file or set of files - to store organized data
FROM
Simple Subquery
Database
Terminating Statements

36. Limits the output of the established groups into the derived result group.
HAVING
Breaking up data
Aggregate Functions
IN

37. Method used to copy multiple records at one time using a SELECT statement
Use of Whitespace
application
INSERT INTO
varchar(size)

38. A structured list of data of a specific type
MAX()
DISTINCT
Table
ORDER BY

39. All extra whitespace within a SQL statement is is ignored when that statement is processed.
LIKE
Use of Whitespace
WHERE
Comparison Operators

40. 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.
ANY
Commas
AVG()
MAX()

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

42. Provides a numerical tally of how many rows meet a specific set of criteria.
INSERT INTO
SELECT Statement
COUNT()
DESC

43. A column or set of columns whose values uniquely identify every row in a table.
UPDATE
application
Primary Key
SUM()

44. Simplest type of subquery.
GROUP BY
Simple Subquery
DBMS - Database Management System
Aggregate Functions

45. Takes a single numeric or alphabetic cloumn and finds the LOWEST constant value within it.
MIN()
Row
LIKE
SQL Statement and Case

46. Number value with a maximum number of digits of "size" total - with a maximum number of "d" digits to the right of the decimal.
COUNT()
number(size -d)
Row
UPDATE

47. Denotes that the search condition is TRUE for at least one element that the subquery returns.
Comparison Operators
ANY
GROUP BY
AVG()

48. A language designed specifically for communicating with databases.
Nested Subquery
SQL (Structured Query Language)
Use of Whitespace
Always define Primary Keys

49. Prevents duplicate values witihin a table or group of rows from being used in the evaluation of the function's result
DISTINCT
Always define Primary Keys
Comparison Operators
WHERE

50. When selecting multiple columns be sure to specify a _____ BETWEEN each column name but NOT after the last column name.
GROUP BY
IN
Database
Commas