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. Limits the output of the established groups into the derived result group.
HAVING
varchar(size)
ASC
Datatype

2. A structured list of data of a specific type
SQL (Structured Query Language)
Row
AS
Table

3. Used to select all the information in a specified column.
char(size)
SELECT
IN
SELECT *

4. Simplest type of subquery.
Simple Subquery
mysql
COUNT()
HAVING

5. Ascending
ASC
SQL Statement and Case
Commas
ANY

6. NOT - AND - OR
LIKE
DBMS - Database Management System
DELETE
Logical Operators

7. Specify one or more columns on which to order the display.
SQL Statement and Case
MAX()
ORDER BY
FROM

8. When selecting multiple columns be sure to specify a _____ BETWEEN each column name but NOT after the last column name.
char(size)
Commas
Comparison Operators
Logical Operators

9. 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
Terminating Statements
Aggregate Functions

10. A column or set of columns whose values uniquely identify every row in a table.
MAX()
Primary Key
application
SELECT *

11. Primary way to do a query in SQL
WHERE
SUM()
DBMS - Database Management System
SELECT Statement

12. All extra whitespace within a SQL statement is is ignored when that statement is processed.
Aggregate Functions
WHERE
Database
Use of Whitespace

13. Specifies the tables or views from which rows and columns are retrieved
DISTINCT
FROM
number(size -d)
Primary Key

14. Number value with a maximum number of digits of "size" total - with a maximum number of "d" digits to the right of the decimal.
Aggregate Functions
IN
number(size -d)
Always define Primary Keys

15. Alias
WHERE
Column
Terminating Statements
AS

16. Takes a single numeric or alphabetic cloumn and finds the LOWEST constant value within it.
DBMS - Database Management System
ORDER BY
Always define Primary Keys
MIN()

17. A single field in a table. All tables are made up of one or more columns.
SQL (Structured Query Language)
SELECT
Column
AVG()

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
COUNT()
Table
Breaking up data

19. Allows a comparison with multiple values from a list.
Primary Key
IN
Datatype
SUM()

20. SQL statements are case- insensitive
LIKE
SQL Statement and Case
GROUP BY
varchar(size)

21. Method used to copy multiple records at one time using a SELECT statement
INSERT INTO
DISTINCT
MAX()
char(size)

22. Lets you use a single- or multiple-character wildcards. Also - this command does not function in Microsoft Access.
Database
SELECT
LIKE
Comparison Operators

23. A reserved word that is part of the SQL language. Never name a table or column using a keyword.
Column
Keyword
ASC
MIN()

24. Data must be broken into multiple columns correctly. For example - city - state - and zip should always separate columns.
mysql
WHERE
Breaking up data
application

25. Allows you to delete selected rows.
Row
Use of Whitespace
application
DELETE

26. The container - usually a file or set of files - to store organized data
SQL (Structured Query Language)
Database
SQL extensions
UPDATE

27. Denotes that the search condition is TRUE for at least one element that the subquery returns.
Column
Use of Whitespace
char(size)
ANY

28. Limits the rows that appear in the result to those matching a specified condition
MAX()
WHERE
ASC
number(size -d)

29. = Equals - < Less Than - > Greater Than - <= Less Than or Equal To - >= Greater Than or Equal To - <> Not Equal - ! Negation of
Terminating Statements
SQL (Structured Query Language)
Comparison Operators
WHERE

30. Combines rows from a SELECT statement's results table into groups in which specified columns have the same value.
ANY
Commas
GROUP BY
COUNT()

31. A record in a table
Row
SELECT *
UPDATE
Keyword

32. Provides a numerical tally of how many rows meet a specific set of criteria.
COUNT()
SELECT Statement
DISTINCT
Keyword

33. A language designed specifically for communicating with databases.
SQL (Structured Query Language)
SELECT
MIN()
WHERE

34. A type of allowed data. Every table column has a datatype that restricts specific data in that column.
SELECT
MIN()
Datatype
Keyword

35. _______ column name FROM table name
ASC
SELECT
Nested Subquery
HAVING

36. Used to nest subqueries within another subquery.
Nested Subquery
ASC
INSERT INTO
LIKE

37. Prevents duplicate values witihin a table or group of rows from being used in the evaluation of the function's result
Use of Whitespace
HAVING
DISTINCT
AS

38. A popular open source database
char(size)
GROUP BY
AVG()
mysql

39. SQL is a language NOT an _______
Keyword
application
SELECT Statement
SQL extensions

40. Lets you change the values in one or more selected rows of a table.
Keyword
Datatype
UPDATE
WHERE

41. Takes a single numeric or alphabetic cloumn and finds the HIGHEST constant value within it.
SUM()
Simple Subquery
MAX()
Logical Operators

42. Fixed-length character string. Size is specified in parenthesis. Max 255 bytes.
ASC
char(size)
FROM
Commas

43. Multiple SQL statements must be separated by semicolons.
Column
DISTINCT
UPDATE
Terminating Statements

44. Descending
DESC
Row
Use of Whitespace
MIN()

45. Usually DBMS specific - these can provide extra functionality or simplified ways to perform specific operations.
SQL extensions
UPDATE
Commas
Use of Whitespace

46. 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.
Simple Subquery
FROM
AVG()
mysql

47. COUNT() - MAX() - MIN() - SUM() and AVG()
varchar(size)
Aggregate Functions
SELECT
HAVING

48. Database software (an application)
Breaking up data
DBMS - Database Management System
SQL extensions
INSERT INTO

49. Takes all of the values in that column and adds them together. Only works on columns containing numeric data.
Breaking up data
SUM()
SELECT
Always define Primary Keys

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