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. Descending
DESC
varchar(size)
Aggregate Functions
Terminating Statements

2. Limits the output of the established groups into the derived result group.
ORDER BY
HAVING
DELETE
Table

3. 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 Statement
number(size -d)
SQL (Structured Query Language)
ASC

4. A column or set of columns whose values uniquely identify every row in a table.
application
HAVING
FROM
Primary Key

5. Specify one or more columns on which to order the display.
ORDER BY
INSERT INTO
Always define Primary Keys
MIN()

6. A type of allowed data. Every table column has a datatype that restricts specific data in that column.
COUNT()
number(size -d)
Datatype
ASC

7. SQL is a language NOT an _______
UPDATE
Primary Key
application
WHERE

8. Primary way to do a query in SQL
Row
DISTINCT
SELECT Statement
Logical Operators

9. Specifies the tables or views from which rows and columns are retrieved
Terminating Statements
INSERT INTO
ANY
FROM

10. Allows you to delete selected rows.
Aggregate Functions
SELECT *
DELETE
MIN()

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

12. Takes a single numeric or alphabetic cloumn and finds the LOWEST constant value within it.
MIN()
HAVING
SELECT *
AS

13. A structured list of data of a specific type
Column
ASC
Table
SQL extensions

14. All extra whitespace within a SQL statement is is ignored when that statement is processed.
Use of Whitespace
Nested Subquery
SELECT
UPDATE

15. Lets you use a single- or multiple-character wildcards. Also - this command does not function in Microsoft Access.
LIKE
SQL extensions
Database
AVG()

16. A single field in a table. All tables are made up of one or more columns.
Column
Terminating Statements
varchar(size)
AVG()

17. Multiple SQL statements must be separated by semicolons.
Primary Key
mysql
Terminating Statements
SELECT Statement

18. Lets you change the values in one or more selected rows of a table.
Breaking up data
Simple Subquery
char(size)
UPDATE

19. Usually DBMS specific - these can provide extra functionality or simplified ways to perform specific operations.
Primary Key
Column
SQL extensions
LIKE

20. 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.
Column
AS
Always define Primary Keys
DISTINCT

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

22. A popular open source database
IN
Table
mysql
DISTINCT

23. Allows a comparison with multiple values from a list.
Aggregate Functions
FROM
IN
SUM()

24. Alias
mysql
WHERE
AS
Breaking up data

25. = Equals - < Less Than - > Greater Than - <= Less Than or Equal To - >= Greater Than or Equal To - <> Not Equal - ! Negation of
HAVING
Self-Join
Simple Subquery
Comparison Operators

26. Prevents duplicate values witihin a table or group of rows from being used in the evaluation of the function's result
MAX()
ANY
ORDER BY
DISTINCT

27. Denotes that the search condition is TRUE for at least one element that the subquery returns.
Breaking up data
INSERT INTO
ANY
mysql

28. A reserved word that is part of the SQL language. Never name a table or column using a keyword.
Keyword
SELECT Statement
DBMS - Database Management System
MAX()

29. The container - usually a file or set of files - to store organized data
Database
IN
SELECT Statement
application

30. NOT - AND - OR
Logical Operators
SELECT
DESC
Simple Subquery

31. Variable-length character string. Max size is specified in parenthesis.
varchar(size)
DISTINCT
ORDER BY
MIN()

32. Data must be broken into multiple columns correctly. For example - city - state - and zip should always separate columns.
SELECT Statement
MIN()
Breaking up data
SELECT *

33. Fixed-length character string. Size is specified in parenthesis. Max 255 bytes.
char(size)
IN
GROUP BY
ASC

34. Database software (an application)
SQL Statement and Case
mysql
varchar(size)
DBMS - Database Management System

35. A language designed specifically for communicating with databases.
SQL (Structured Query Language)
application
Table
UPDATE

36. Provides a numerical tally of how many rows meet a specific set of criteria.
Row
Commas
COUNT()
IN

37. COUNT() - MAX() - MIN() - SUM() and AVG()
DELETE
Comparison Operators
DISTINCT
Aggregate Functions

38. A record in a table
COUNT()
ASC
Row
number(size -d)

39. Used to nest subqueries within another subquery.
Nested Subquery
Datatype
ANY
char(size)

40. Limits the rows that appear in the result to those matching a specified condition
Simple Subquery
WHERE
Commas
mysql

41. Takes all of the values in that column and adds them together. Only works on columns containing numeric data.
DBMS - Database Management System
SUM()
ASC
DELETE

42. _______ column name FROM table name
varchar(size)
IN
Primary Key
SELECT

43. Allows you to correlate information between different rows of the same table and combine this information in rows of a result table.
Database
Terminating Statements
Self-Join
IN

44. Method used to copy multiple records at one time using a SELECT statement
Simple Subquery
INSERT INTO
SELECT Statement
mysql

45. Simplest type of subquery.
UPDATE
SELECT *
COUNT()
Simple Subquery

46. Ascending
ASC
Primary Key
char(size)
Breaking up data

47. Used to select all the information in a specified column.
FROM
Row
SELECT *
COUNT()

48. 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.
GROUP BY
AVG()
Self-Join
number(size -d)

49. When selecting multiple columns be sure to specify a _____ BETWEEN each column name but NOT after the last column name.
ASC
SQL Statement and Case
FROM
Commas

50. SQL statements are case- insensitive
SQL Statement and Case
SQL extensions
DBMS - Database Management System
char(size)