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. 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
SELECT
mysql
HAVING

2. 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()
Self-Join
SELECT *
ANY

3. Primary way to do a query in SQL
SQL extensions
SELECT Statement
DELETE
Comparison Operators

4. Ascending
SUM()
ORDER BY
Row
ASC

5. Takes a single numeric or alphabetic cloumn and finds the LOWEST constant value within it.
Row
DBMS - Database Management System
SELECT *
MIN()

6. Limits the output of the established groups into the derived result group.
HAVING
MAX()
GROUP BY
mysql

7. Takes a single numeric or alphabetic cloumn and finds the HIGHEST constant value within it.
Datatype
Simple Subquery
Breaking up data
MAX()

8. Alias
Row
AS
Nested Subquery
SUM()

9. Lets you use a single- or multiple-character wildcards. Also - this command does not function in Microsoft Access.
Breaking up data
Keyword
LIKE
SQL Statement and Case

10. Denotes that the search condition is TRUE for at least one element that the subquery returns.
Simple Subquery
Row
IN
ANY

11. A single field in a table. All tables are made up of one or more columns.
Column
Datatype
DISTINCT
Terminating Statements

12. Limits the rows that appear in the result to those matching a specified condition
char(size)
Terminating Statements
WHERE
Always define Primary Keys

13. A reserved word that is part of the SQL language. Never name a table or column using a keyword.
char(size)
WHERE
DBMS - Database Management System
Keyword

14. Specifies the tables or views from which rows and columns are retrieved
Breaking up data
SQL extensions
FROM
IN

15. A record in a table
ANY
Row
COUNT()
Nested Subquery

16. Used to select all the information in a specified column.
ASC
Simple Subquery
INSERT INTO
SELECT *

17. SQL is a language NOT an _______
application
Commas
MIN()
GROUP BY

18. Allows you to delete selected rows.
AVG()
INSERT INTO
DELETE
Terminating Statements

19. A column or set of columns whose values uniquely identify every row in a table.
MIN()
SELECT Statement
Primary Key
Comparison Operators

20. All extra whitespace within a SQL statement is is ignored when that statement is processed.
Use of Whitespace
char(size)
INSERT INTO
SQL Statement and Case

21. Used to nest subqueries within another subquery.
Nested Subquery
number(size -d)
DBMS - Database Management System
WHERE

22. Allows a comparison with multiple values from a list.
SELECT *
Use of Whitespace
IN
Keyword

23. Database software (an application)
Keyword
AVG()
HAVING
DBMS - Database Management System

24. Data must be broken into multiple columns correctly. For example - city - state - and zip should always separate columns.
SQL Statement and Case
Breaking up data
Aggregate Functions
Terminating Statements

25. A popular open source database
Commas
SQL (Structured Query Language)
SQL extensions
mysql

26. Variable-length character string. Max size is specified in parenthesis.
AS
Terminating Statements
Primary Key
varchar(size)

27. Allows you to correlate information between different rows of the same table and combine this information in rows of a result table.
Self-Join
Primary Key
AVG()
SQL Statement and Case

28. Method used to copy multiple records at one time using a SELECT statement
WHERE
INSERT INTO
application
DESC

29. Simplest type of subquery.
COUNT()
Database
Table
Simple Subquery

30. A language designed specifically for communicating with databases.
Breaking up data
SQL (Structured Query Language)
char(size)
DESC

31. When selecting multiple columns be sure to specify a _____ BETWEEN each column name but NOT after the last column name.
Commas
Aggregate Functions
Primary Key
Comparison Operators

32. COUNT() - MAX() - MIN() - SUM() and AVG()
LIKE
Aggregate Functions
WHERE
Terminating Statements

33. A type of allowed data. Every table column has a datatype that restricts specific data in that column.
SELECT *
Comparison Operators
FROM
Datatype

34. = Equals - < Less Than - > Greater Than - <= Less Than or Equal To - >= Greater Than or Equal To - <> Not Equal - ! Negation of
Database
GROUP BY
Row
Comparison Operators

35. Descending
number(size -d)
DESC
MIN()
IN

36. The container - usually a file or set of files - to store organized data
Keyword
IN
Database
SUM()

37. NOT - AND - OR
Datatype
ORDER BY
Logical Operators
SELECT Statement

38. Takes all of the values in that column and adds them together. Only works on columns containing numeric data.
SUM()
Self-Join
Simple Subquery
IN

39. SQL statements are case- insensitive
Always define Primary Keys
DBMS - Database Management System
Logical Operators
SQL Statement and Case

40. Lets you change the values in one or more selected rows of a table.
COUNT()
Always define Primary Keys
SQL extensions
UPDATE

41. Usually DBMS specific - these can provide extra functionality or simplified ways to perform specific operations.
SQL extensions
SQL Statement and Case
Use of Whitespace
Logical Operators

42. Specify one or more columns on which to order the display.
DESC
ORDER BY
SQL Statement and Case
SQL extensions

43. Number value with a maximum number of digits of "size" total - with a maximum number of "d" digits to the right of the decimal.
SQL Statement and Case
AVG()
number(size -d)
Column

44. Prevents duplicate values witihin a table or group of rows from being used in the evaluation of the function's result
SQL Statement and Case
Aggregate Functions
SELECT Statement
DISTINCT

45. A structured list of data of a specific type
Terminating Statements
Table
Always define Primary Keys
application

46. Fixed-length character string. Size is specified in parenthesis. Max 255 bytes.
AVG()
Terminating Statements
char(size)
Keyword

47. Multiple SQL statements must be separated by semicolons.
MIN()
Terminating Statements
Table
Aggregate Functions

48. Combines rows from a SELECT statement's results table into groups in which specified columns have the same value.
Keyword
IN
GROUP BY
AVG()

49. _______ column name FROM table name
SELECT
SQL Statement and Case
DELETE
AVG()

50. Provides a numerical tally of how many rows meet a specific set of criteria.
char(size)
COUNT()
FROM
DELETE