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. A single field in a table. All tables are made up of one or more columns.
Column
application
Logical Operators
ASC

2. Multiple SQL statements must be separated by semicolons.
Database
Nested Subquery
ASC
Terminating Statements

3. Prevents duplicate values witihin a table or group of rows from being used in the evaluation of the function's result
DISTINCT
application
Datatype
Always define Primary Keys

4. Takes a single numeric or alphabetic cloumn and finds the LOWEST constant value within it.
MIN()
SQL extensions
Primary Key
Column

5. NOT - AND - OR
ANY
UPDATE
application
Logical Operators

6. Specify one or more columns on which to order the display.
SUM()
ORDER BY
DISTINCT
INSERT INTO

7. Alias
Comparison Operators
AS
Database
AVG()

8. The container - usually a file or set of files - to store organized data
Database
Logical Operators
SQL extensions
Datatype

9. COUNT() - MAX() - MIN() - SUM() and AVG()
Aggregate Functions
ASC
Table
Nested Subquery

10. Fixed-length character string. Size is specified in parenthesis. Max 255 bytes.
UPDATE
Nested Subquery
char(size)
WHERE

11. Limits the rows that appear in the result to those matching a specified condition
Breaking up data
Terminating Statements
WHERE
SQL Statement and Case

12. A popular open source database
ASC
DELETE
mysql
SQL (Structured Query Language)

13. A type of allowed data. Every table column has a datatype that restricts specific data in that column.
Datatype
DELETE
Nested Subquery
SELECT *

14. A record in a table
SQL Statement and Case
Row
Self-Join
Commas

15. Limits the output of the established groups into the derived result group.
Row
application
INSERT INTO
HAVING

16. Descending
application
DISTINCT
DESC
IN

17. A language designed specifically for communicating with databases.
AVG()
Aggregate Functions
COUNT()
SQL (Structured Query Language)

18. Data must be broken into multiple columns correctly. For example - city - state - and zip should always separate columns.
Nested Subquery
number(size -d)
Breaking up data
Logical Operators

19. A reserved word that is part of the SQL language. Never name a table or column using a keyword.
Keyword
WHERE
Row
SELECT Statement

20. _______ column name FROM table name
Self-Join
DESC
IN
SELECT

21. Takes a single numeric or alphabetic cloumn and finds the HIGHEST constant value within it.
application
LIKE
Primary Key
MAX()

22. Used to select all the information in a specified column.
SELECT
SELECT *
WHERE
COUNT()

23. A structured list of data of a specific type
varchar(size)
SELECT *
Self-Join
Table

24. SQL is a language NOT an _______
application
LIKE
Self-Join
ASC

25. Lets you change the values in one or more selected rows of a table.
UPDATE
HAVING
Keyword
number(size -d)

26. Lets you use a single- or multiple-character wildcards. Also - this command does not function in Microsoft Access.
LIKE
MIN()
number(size -d)
WHERE

27. 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.
SELECT
DISTINCT
AVG()
Always define Primary Keys

28. = Equals - < Less Than - > Greater Than - <= Less Than or Equal To - >= Greater Than or Equal To - <> Not Equal - ! Negation of
Datatype
IN
number(size -d)
Comparison Operators

29. Used to nest subqueries within another subquery.
FROM
Nested Subquery
ANY
Database

30. SQL statements are case- insensitive
Datatype
Terminating Statements
Database
SQL Statement and Case

31. Denotes that the search condition is TRUE for at least one element that the subquery returns.
WHERE
MAX()
ANY
Logical Operators

32. Allows you to delete selected rows.
mysql
MIN()
DELETE
Aggregate Functions

33. Usually DBMS specific - these can provide extra functionality or simplified ways to perform specific operations.
FROM
SQL extensions
Column
Terminating Statements

34. Combines rows from a SELECT statement's results table into groups in which specified columns have the same value.
char(size)
GROUP BY
SQL extensions
MAX()

35. When selecting multiple columns be sure to specify a _____ BETWEEN each column name but NOT after the last column name.
MAX()
AVG()
FROM
Commas

36. A column or set of columns whose values uniquely identify every row in a table.
ORDER BY
Primary Key
SQL Statement and Case
Column

37. Simplest type of subquery.
Simple Subquery
Table
AS
SUM()

38. Allows you to correlate information between different rows of the same table and combine this information in rows of a result table.
SELECT *
Self-Join
LIKE
SUM()

39. Provides a numerical tally of how many rows meet a specific set of criteria.
COUNT()
DESC
Datatype
Database

40. Number value with a maximum number of digits of "size" total - with a maximum number of "d" digits to the right of the decimal.
Simple Subquery
Terminating Statements
MAX()
number(size -d)

41. Allows a comparison with multiple values from a list.
Comparison Operators
SQL extensions
IN
varchar(size)

42. Takes all of the values in that column and adds them together. Only works on columns containing numeric data.
Use of Whitespace
Primary Key
char(size)
SUM()

43. Method used to copy multiple records at one time using a SELECT statement
INSERT INTO
AS
Row
Primary Key

44. Database software (an application)
UPDATE
Nested Subquery
Comparison Operators
DBMS - Database Management System

45. Primary way to do a query in SQL
SELECT Statement
Terminating Statements
INSERT INTO
WHERE

46. All extra whitespace within a SQL statement is is ignored when that statement is processed.
WHERE
Aggregate Functions
Breaking up data
Use of Whitespace

47. Specifies the tables or views from which rows and columns are retrieved
Simple Subquery
FROM
Database
Use of Whitespace

48. Variable-length character string. Max size is specified in parenthesis.
varchar(size)
SELECT Statement
AS
SQL Statement and Case

49. Ascending
varchar(size)
ASC
Datatype
AS

50. 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.
SUM()
AVG()
mysql
Logical Operators