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. Number value with a maximum number of digits of "size" total - with a maximum number of "d" digits to the right of the decimal.
number(size -d)
char(size)
HAVING
DISTINCT

2. Usually DBMS specific - these can provide extra functionality or simplified ways to perform specific operations.
Always define Primary Keys
SQL extensions
WHERE
GROUP BY

3. Alias
GROUP BY
Commas
AS
varchar(size)

4. A popular open source database
mysql
Commas
varchar(size)
UPDATE

5. SQL is a language NOT an _______
Commas
application
Datatype
Row

6. Database software (an application)
Keyword
DBMS - Database Management System
application
char(size)

7. Used to nest subqueries within another subquery.
Aggregate Functions
Use of Whitespace
Simple Subquery
Nested Subquery

8. A structured list of data of a specific type
MAX()
WHERE
SELECT Statement
Table

9. All extra whitespace within a SQL statement is is ignored when that statement is processed.
mysql
Use of Whitespace
Terminating Statements
Comparison Operators

10. Allows you to delete selected rows.
DELETE
AVG()
MAX()
Row

11. SQL statements are case- insensitive
SQL Statement and Case
Use of Whitespace
Keyword
Datatype

12. Method used to copy multiple records at one time using a SELECT statement
Comparison Operators
ASC
MAX()
INSERT INTO

13. A reserved word that is part of the SQL language. Never name a table or column using a keyword.
Self-Join
Datatype
Breaking up data
Keyword

14. Allows a comparison with multiple values from a list.
ANY
IN
Datatype
FROM

15. Multiple SQL statements must be separated by semicolons.
mysql
Terminating Statements
Simple Subquery
ORDER BY

16. Lets you change the values in one or more selected rows of a table.
UPDATE
mysql
WHERE
GROUP BY

17. When selecting multiple columns be sure to specify a _____ BETWEEN each column name but NOT after the last column name.
Logical Operators
Terminating Statements
Commas
AVG()

18. Limits the output of the established groups into the derived result group.
HAVING
Row
SUM()
INSERT INTO

19. Lets you use a single- or multiple-character wildcards. Also - this command does not function in Microsoft Access.
MAX()
Self-Join
LIKE
DELETE

20. Allows you to correlate information between different rows of the same table and combine this information in rows of a result table.
INSERT INTO
Self-Join
Database
Use of Whitespace

21. A record in a table
Row
ANY
IN
COUNT()

22. 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.
DISTINCT
FROM
mysql
Always define Primary Keys

23. Prevents duplicate values witihin a table or group of rows from being used in the evaluation of the function's result
Database
DISTINCT
varchar(size)
HAVING

24. Takes a single numeric or alphabetic cloumn and finds the HIGHEST constant value within it.
Terminating Statements
MAX()
SELECT
DESC

25. The container - usually a file or set of files - to store organized data
char(size)
SQL extensions
Database
Table

26. Takes a single numeric or alphabetic cloumn and finds the LOWEST constant value within it.
LIKE
Logical Operators
AS
MIN()

27. A single field in a table. All tables are made up of one or more columns.
SQL Statement and Case
Column
Aggregate Functions
varchar(size)

28. A type of allowed data. Every table column has a datatype that restricts specific data in that column.
Datatype
SELECT *
Simple Subquery
SQL (Structured Query Language)

29. Variable-length character string. Max size is specified in parenthesis.
varchar(size)
Primary Key
Logical Operators
Row

30. Fixed-length character string. Size is specified in parenthesis. Max 255 bytes.
SQL Statement and Case
FROM
char(size)
Table

31. Simplest type of subquery.
SQL extensions
Simple Subquery
Row
Commas

32. 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.
varchar(size)
AVG()
GROUP BY
SQL Statement and Case

33. Specify one or more columns on which to order the display.
ORDER BY
Table
AVG()
SELECT

34. Combines rows from a SELECT statement's results table into groups in which specified columns have the same value.
Comparison Operators
GROUP BY
Commas
INSERT INTO

35. Used to select all the information in a specified column.
varchar(size)
SELECT *
char(size)
ORDER BY

36. Ascending
ASC
DBMS - Database Management System
SELECT Statement
Self-Join

37. Primary way to do a query in SQL
application
SELECT Statement
Breaking up data
SELECT

38. Specifies the tables or views from which rows and columns are retrieved
Commas
ORDER BY
FROM
Logical Operators

39. Data must be broken into multiple columns correctly. For example - city - state - and zip should always separate columns.
DBMS - Database Management System
Breaking up data
mysql
COUNT()

40. = Equals - < Less Than - > Greater Than - <= Less Than or Equal To - >= Greater Than or Equal To - <> Not Equal - ! Negation of
SQL (Structured Query Language)
Aggregate Functions
SUM()
Comparison Operators

41. Descending
Primary Key
DESC
AS
SELECT Statement

42. A column or set of columns whose values uniquely identify every row in a table.
SQL extensions
INSERT INTO
Primary Key
char(size)

43. Provides a numerical tally of how many rows meet a specific set of criteria.
COUNT()
SELECT *
IN
MIN()

44. NOT - AND - OR
Database
ORDER BY
Keyword
Logical Operators

45. COUNT() - MAX() - MIN() - SUM() and AVG()
DESC
Column
SELECT
Aggregate Functions

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

47. _______ column name FROM table name
SELECT
LIKE
Breaking up data
Always define Primary Keys

48. Denotes that the search condition is TRUE for at least one element that the subquery returns.
ANY
GROUP BY
SUM()
AS

49. Takes all of the values in that column and adds them together. Only works on columns containing numeric data.
GROUP BY
SUM()
Primary Key
mysql

50. Limits the rows that appear in the result to those matching a specified condition
AS
WHERE
SELECT Statement
Always define Primary Keys