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. Database software (an application)
DBMS - Database Management System
FROM
Logical Operators
Simple Subquery

2. = Equals - < Less Than - > Greater Than - <= Less Than or Equal To - >= Greater Than or Equal To - <> Not Equal - ! Negation of
WHERE
DESC
SELECT *
Comparison Operators

3. All extra whitespace within a SQL statement is is ignored when that statement is processed.
DELETE
MAX()
Use of Whitespace
Comparison Operators

4. Usually DBMS specific - these can provide extra functionality or simplified ways to perform specific operations.
application
AS
SQL extensions
mysql

5. 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.
UPDATE
Row
IN
AVG()

6. Number value with a maximum number of digits of "size" total - with a maximum number of "d" digits to the right of the decimal.
SELECT *
number(size -d)
Database
MIN()

7. Denotes that the search condition is TRUE for at least one element that the subquery returns.
ORDER BY
ANY
Terminating Statements
Keyword

8. Lets you change the values in one or more selected rows of a table.
SELECT
Keyword
UPDATE
Aggregate Functions

9. Fixed-length character string. Size is specified in parenthesis. Max 255 bytes.
MIN()
Aggregate Functions
char(size)
SUM()

10. Allows a comparison with multiple values from a list.
IN
mysql
char(size)
Logical Operators

11. Allows you to delete selected rows.
Always define Primary Keys
COUNT()
AS
DELETE

12. SQL statements are case- insensitive
application
Logical Operators
SQL Statement and Case
IN

13. Allows you to correlate information between different rows of the same table and combine this information in rows of a result table.
Table
MAX()
Self-Join
SELECT

14. Used to select all the information in a specified column.
MAX()
SQL extensions
SELECT *
AS

15. SQL is a language NOT an _______
Use of Whitespace
FROM
SELECT Statement
application

16. Multiple SQL statements must be separated by semicolons.
Simple Subquery
Terminating Statements
mysql
Nested Subquery

17. Method used to copy multiple records at one time using a SELECT statement
MIN()
DESC
INSERT INTO
ASC

18. Used to nest subqueries within another subquery.
Use of Whitespace
Nested Subquery
DISTINCT
Logical Operators

19. A language designed specifically for communicating with databases.
FROM
SQL (Structured Query Language)
SQL extensions
varchar(size)

20. Alias
DESC
ORDER BY
AS
Commas

21. Limits the output of the established groups into the derived result group.
DESC
HAVING
Database
SELECT *

22. _______ column name FROM table name
Primary Key
SELECT
Datatype
HAVING

23. A single field in a table. All tables are made up of one or more columns.
SELECT *
AS
Column
Simple Subquery

24. Limits the rows that appear in the result to those matching a specified condition
WHERE
UPDATE
Breaking up data
DISTINCT

25. Takes a single numeric or alphabetic cloumn and finds the LOWEST constant value within it.
Nested Subquery
Database
Keyword
MIN()

26. A record in a table
MIN()
Always define Primary Keys
Row
LIKE

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.
Commas
Always define Primary Keys
MAX()
Keyword

28. Takes all of the values in that column and adds them together. Only works on columns containing numeric data.
Keyword
Terminating Statements
SUM()
char(size)

29. A structured list of data of a specific type
mysql
Logical Operators
Table
Column

30. NOT - AND - OR
WHERE
SUM()
LIKE
Logical Operators

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

32. Takes a single numeric or alphabetic cloumn and finds the HIGHEST constant value within it.
Self-Join
MIN()
DISTINCT
MAX()

33. Specify one or more columns on which to order the display.
Primary Key
ORDER BY
SUM()
ASC

34. Combines rows from a SELECT statement's results table into groups in which specified columns have the same value.
Datatype
DBMS - Database Management System
GROUP BY
Keyword

35. Data must be broken into multiple columns correctly. For example - city - state - and zip should always separate columns.
SELECT *
DBMS - Database Management System
application
Breaking up data

36. Descending
Self-Join
WHERE
DESC
MIN()

37. Primary way to do a query in SQL
AS
SELECT Statement
UPDATE
varchar(size)

38. Simplest type of subquery.
Simple Subquery
mysql
ANY
char(size)

39. A column or set of columns whose values uniquely identify every row in a table.
FROM
DISTINCT
AVG()
Primary Key

40. When selecting multiple columns be sure to specify a _____ BETWEEN each column name but NOT after the last column name.
LIKE
SELECT *
Commas
SQL extensions

41. COUNT() - MAX() - MIN() - SUM() and AVG()
char(size)
Aggregate Functions
Keyword
Breaking up data

42. Provides a numerical tally of how many rows meet a specific set of criteria.
WHERE
Table
DBMS - Database Management System
COUNT()

43. Lets you use a single- or multiple-character wildcards. Also - this command does not function in Microsoft Access.
LIKE
Always define Primary Keys
ASC
DISTINCT

44. Specifies the tables or views from which rows and columns are retrieved
Table
Always define Primary Keys
FROM
DISTINCT

45. A type of allowed data. Every table column has a datatype that restricts specific data in that column.
Datatype
SELECT Statement
SQL (Structured Query Language)
INSERT INTO

46. The container - usually a file or set of files - to store organized data
Always define Primary Keys
SQL extensions
AVG()
Database

47. Ascending
ASC
mysql
INSERT INTO
DBMS - Database Management System

48. Variable-length character string. Max size is specified in parenthesis.
DESC
application
varchar(size)
Comparison Operators

49. A reserved word that is part of the SQL language. Never name a table or column using a keyword.
Keyword
DELETE
GROUP BY
WHERE

50. A popular open source database
AVG()
mysql
Logical Operators
Commas