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. Takes a single numeric or alphabetic cloumn and finds the HIGHEST constant value within it.
MAX()
number(size -d)
Breaking up data
Column

2. A language designed specifically for communicating with databases.
AS
SQL (Structured Query Language)
Simple Subquery
WHERE

3. A record in a table
Breaking up data
Nested Subquery
SQL Statement and Case
Row

4. Specifies the tables or views from which rows and columns are retrieved
number(size -d)
Commas
Database
FROM

5. All extra whitespace within a SQL statement is is ignored when that statement is processed.
SELECT Statement
Database
Use of Whitespace
Table

6. Method used to copy multiple records at one time using a SELECT statement
INSERT INTO
Primary Key
Terminating Statements
number(size -d)

7. Denotes that the search condition is TRUE for at least one element that the subquery returns.
DESC
ANY
Comparison Operators
WHERE

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

9. Ascending
SQL (Structured Query Language)
ANY
MIN()
ASC

10. SQL is a language NOT an _______
Table
application
FROM
DISTINCT

11. Allows a comparison with multiple values from a list.
SELECT *
Logical Operators
IN
MIN()

12. _______ column name FROM table name
SQL (Structured Query Language)
Comparison Operators
SELECT
Database

13. A single field in a table. All tables are made up of one or more columns.
IN
Column
HAVING
char(size)

14. Used to select all the information in a specified column.
GROUP BY
Logical Operators
INSERT INTO
SELECT *

15. The container - usually a file or set of files - to store organized data
MAX()
Database
SELECT
UPDATE

16. Alias
DESC
AS
SELECT *
Always define Primary Keys

17. COUNT() - MAX() - MIN() - SUM() and AVG()
Row
MIN()
Aggregate Functions
Use of Whitespace

18. Allows you to correlate information between different rows of the same table and combine this information in rows of a result table.
Row
DISTINCT
Commas
Self-Join

19. = Equals - < Less Than - > Greater Than - <= Less Than or Equal To - >= Greater Than or Equal To - <> Not Equal - ! Negation of
AVG()
Comparison Operators
Terminating Statements
SELECT

20. NOT - AND - OR
mysql
Logical Operators
IN
INSERT INTO

21. Prevents duplicate values witihin a table or group of rows from being used in the evaluation of the function's result
SELECT *
SELECT
SELECT Statement
DISTINCT

22. A type of allowed data. Every table column has a datatype that restricts specific data in that column.
INSERT INTO
Aggregate Functions
Nested Subquery
Datatype

23. Database software (an application)
UPDATE
DBMS - Database Management System
SELECT Statement
Aggregate Functions

24. Takes all of the values in that column and adds them together. Only works on columns containing numeric data.
WHERE
SUM()
DELETE
Simple Subquery

25. A column or set of columns whose values uniquely identify every row in a table.
Primary Key
SELECT
number(size -d)
Use of Whitespace

26. Number value with a maximum number of digits of "size" total - with a maximum number of "d" digits to the right of the decimal.
mysql
Keyword
number(size -d)
Always define Primary Keys

27. Lets you use a single- or multiple-character wildcards. Also - this command does not function in Microsoft Access.
DISTINCT
INSERT INTO
LIKE
Self-Join

28. Combines rows from a SELECT statement's results table into groups in which specified columns have the same value.
Comparison Operators
GROUP BY
AVG()
Column

29. Limits the output of the established groups into the derived result group.
HAVING
char(size)
Breaking up data
Nested Subquery

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

31. Multiple SQL statements must be separated by semicolons.
Comparison Operators
GROUP BY
Terminating Statements
ANY

32. Used to nest subqueries within another subquery.
Nested Subquery
MIN()
GROUP BY
Logical Operators

33. Takes a single numeric or alphabetic cloumn and finds the LOWEST constant value within it.
COUNT()
MIN()
Datatype
Primary Key

34. 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
Logical Operators
AVG()
ASC

35. Simplest type of subquery.
mysql
SQL (Structured Query Language)
application
Simple Subquery

36. A structured list of data of a specific type
number(size -d)
UPDATE
Table
MAX()

37. Allows you to delete selected rows.
Primary Key
Datatype
DBMS - Database Management System
DELETE

38. Usually DBMS specific - these can provide extra functionality or simplified ways to perform specific operations.
ORDER BY
Terminating Statements
application
SQL extensions

39. Provides a numerical tally of how many rows meet a specific set of criteria.
application
DELETE
Keyword
COUNT()

40. When selecting multiple columns be sure to specify a _____ BETWEEN each column name but NOT after the last column name.
number(size -d)
mysql
Commas
char(size)

41. SQL statements are case- insensitive
AVG()
SELECT
SQL Statement and Case
HAVING

42. Data must be broken into multiple columns correctly. For example - city - state - and zip should always separate columns.
Breaking up data
SELECT Statement
DELETE
Comparison Operators

43. Lets you change the values in one or more selected rows of a table.
Simple Subquery
DISTINCT
UPDATE
MIN()

44. Specify one or more columns on which to order the display.
IN
AS
ORDER BY
HAVING

45. Primary way to do a query in SQL
SELECT Statement
Database
Column
ANY

46. A popular open source database
COUNT()
Datatype
Table
mysql

47. 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.
Logical Operators
Always define Primary Keys
Breaking up data
Primary Key

48. Variable-length character string. Max size is specified in parenthesis.
ORDER BY
Breaking up data
varchar(size)
application

49. Limits the rows that appear in the result to those matching a specified condition
WHERE
ASC
SELECT *
AS

50. Descending
DISTINCT
UPDATE
Terminating Statements
DESC