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. SQL statements are case- insensitive
mysql
SQL Statement and Case
SELECT *
UPDATE

2. Fixed-length character string. Size is specified in parenthesis. Max 255 bytes.
DELETE
Column
Terminating Statements
char(size)

3. = Equals - < Less Than - > Greater Than - <= Less Than or Equal To - >= Greater Than or Equal To - <> Not Equal - ! Negation of
Comparison Operators
HAVING
mysql
Commas

4. A reserved word that is part of the SQL language. Never name a table or column using a keyword.
Keyword
Row
number(size -d)
Terminating Statements

5. A single field in a table. All tables are made up of one or more columns.
SELECT
MIN()
Column
HAVING

6. Allows you to correlate information between different rows of the same table and combine this information in rows of a result table.
Self-Join
Always define Primary Keys
Table
LIKE

7. Takes a single numeric or alphabetic cloumn and finds the LOWEST constant value within it.
Comparison Operators
MIN()
Commas
Breaking up data

8. Number value with a maximum number of digits of "size" total - with a maximum number of "d" digits to the right of the decimal.
varchar(size)
Datatype
SUM()
number(size -d)

9. Specifies the tables or views from which rows and columns are retrieved
HAVING
FROM
mysql
DESC

10. Usually DBMS specific - these can provide extra functionality or simplified ways to perform specific operations.
Aggregate Functions
ASC
MIN()
SQL extensions

11. Prevents duplicate values witihin a table or group of rows from being used in the evaluation of the function's result
DISTINCT
Row
SUM()
Terminating Statements

12. Alias
Always define Primary Keys
AS
MIN()
MAX()

13. Lets you use a single- or multiple-character wildcards. Also - this command does not function in Microsoft Access.
LIKE
DBMS - Database Management System
WHERE
AS

14. Used to select all the information in a specified column.
MIN()
SELECT *
Row
Breaking up data

15. A record in a table
Row
SQL extensions
Primary Key
Simple Subquery

16. Takes all of the values in that column and adds them together. Only works on columns containing numeric data.
SUM()
SQL Statement and Case
char(size)
AVG()

17. Allows you to delete selected rows.
DESC
DELETE
SELECT
ANY

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
Database
Terminating Statements
IN

19. NOT - AND - OR
LIKE
Logical Operators
Always define Primary Keys
Aggregate Functions

20. Descending
ASC
Nested Subquery
DESC
Keyword

21. Lets you change the values in one or more selected rows of a table.
number(size -d)
DESC
UPDATE
Primary Key

22. All extra whitespace within a SQL statement is is ignored when that statement is processed.
DESC
Table
Use of Whitespace
SELECT *

23. Provides a numerical tally of how many rows meet a specific set of criteria.
SUM()
varchar(size)
COUNT()
DISTINCT

24. Simplest type of subquery.
Simple Subquery
DISTINCT
DELETE
MAX()

25. Variable-length character string. Max size is specified in parenthesis.
Aggregate Functions
LIKE
Terminating Statements
varchar(size)

26. Combines rows from a SELECT statement's results table into groups in which specified columns have the same value.
AS
DISTINCT
SQL Statement and Case
GROUP BY

27. Takes a single numeric or alphabetic cloumn and finds the HIGHEST constant value within it.
MAX()
Always define Primary Keys
Self-Join
number(size -d)

28. A popular open source database
IN
Keyword
mysql
char(size)

29. Allows a comparison with multiple values from a list.
AS
INSERT INTO
Logical Operators
IN

30. A language designed specifically for communicating with databases.
SQL (Structured Query Language)
Row
FROM
Breaking up data

31. Database software (an application)
DBMS - Database Management System
Nested Subquery
Terminating Statements
ORDER BY

32. Specify one or more columns on which to order the display.
Use of Whitespace
Keyword
ORDER BY
WHERE

33. Data must be broken into multiple columns correctly. For example - city - state - and zip should always separate columns.
SQL (Structured Query Language)
Breaking up data
Column
number(size -d)

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

35. COUNT() - MAX() - MIN() - SUM() and AVG()
Aggregate Functions
Simple Subquery
ORDER BY
Use of Whitespace

36. Limits the rows that appear in the result to those matching a specified condition
WHERE
Comparison Operators
Row
Keyword

37. Method used to copy multiple records at one time using a SELECT statement
Datatype
SQL (Structured Query Language)
FROM
INSERT INTO

38. Limits the output of the established groups into the derived result group.
IN
HAVING
application
Aggregate Functions

39. Primary way to do a query in SQL
SELECT *
SELECT Statement
AS
MIN()

40. Denotes that the search condition is TRUE for at least one element that the subquery returns.
ANY
Logical Operators
UPDATE
SUM()

41. A column or set of columns whose values uniquely identify every row in a table.
SQL Statement and Case
Primary Key
Keyword
Self-Join

42. A type of allowed data. Every table column has a datatype that restricts specific data in that column.
Comparison Operators
Terminating Statements
Datatype
WHERE

43. Ascending
Self-Join
ASC
SQL Statement and Case
Keyword

44. _______ column name FROM table name
Row
SELECT
SELECT Statement
number(size -d)

45. 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.
AVG()
UPDATE
Table
DISTINCT

46. Multiple SQL statements must be separated by semicolons.
Table
Terminating Statements
Datatype
MAX()

47. SQL is a language NOT an _______
mysql
Aggregate Functions
SELECT
application

48. Used to nest subqueries within another subquery.
Row
Nested Subquery
MAX()
SELECT *

49. A structured list of data of a specific type
SQL (Structured Query Language)
Self-Join
Table
WHERE

50. When selecting multiple columns be sure to specify a _____ BETWEEN each column name but NOT after the last column name.
Commas
Self-Join
DELETE
DISTINCT