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. 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 (Structured Query Language)
Terminating Statements
Use of Whitespace
number(size -d)

2. Fixed-length character string. Size is specified in parenthesis. Max 255 bytes.
DESC
application
char(size)
ANY

3. 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.
MAX()
FROM
WHERE
AVG()

4. Data must be broken into multiple columns correctly. For example - city - state - and zip should always separate columns.
Row
HAVING
Column
Breaking up data

5. A record in a table
IN
Row
Self-Join
Terminating Statements

6. A reserved word that is part of the SQL language. Never name a table or column using a keyword.
IN
Commas
Keyword
SQL (Structured Query Language)

7. Allows you to delete selected rows.
Datatype
INSERT INTO
SELECT Statement
DELETE

8. Primary way to do a query in SQL
SELECT Statement
ANY
Table
Comparison Operators

9. The container - usually a file or set of files - to store organized data
Commas
Database
Aggregate Functions
Row

10. SQL is a language NOT an _______
application
ORDER BY
Simple Subquery
DBMS - Database Management System

11. Allows a comparison with multiple values from a list.
Row
IN
ASC
Breaking up data

12. Alias
mysql
AS
Commas
Logical Operators

13. _______ column name FROM table name
ASC
SELECT
Logical Operators
SQL extensions

14. A popular open source database
IN
Datatype
Logical Operators
mysql

15. 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.
MAX()
Terminating Statements
Always define Primary Keys
HAVING

16. Specify one or more columns on which to order the display.
ORDER BY
GROUP BY
SELECT *
char(size)

17. Ascending
AS
MIN()
SELECT Statement
ASC

18. Takes all of the values in that column and adds them together. Only works on columns containing numeric data.
SUM()
SELECT
AVG()
DISTINCT

19. = Equals - < Less Than - > Greater Than - <= Less Than or Equal To - >= Greater Than or Equal To - <> Not Equal - ! Negation of
DESC
Database
Logical Operators
Comparison Operators

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

21. Limits the rows that appear in the result to those matching a specified condition
Table
Database
SELECT Statement
WHERE

22. Denotes that the search condition is TRUE for at least one element that the subquery returns.
Row
mysql
ANY
GROUP BY

23. When selecting multiple columns be sure to specify a _____ BETWEEN each column name but NOT after the last column name.
WHERE
SUM()
MAX()
Commas

24. Lets you change the values in one or more selected rows of a table.
GROUP BY
ORDER BY
UPDATE
DBMS - Database Management System

25. Limits the output of the established groups into the derived result group.
HAVING
WHERE
AS
Comparison Operators

26. Specifies the tables or views from which rows and columns are retrieved
Row
FROM
number(size -d)
Column

27. SQL statements are case- insensitive
Datatype
Use of Whitespace
Logical Operators
SQL Statement and Case

28. A column or set of columns whose values uniquely identify every row in a table.
AS
char(size)
IN
Primary Key

29. Provides a numerical tally of how many rows meet a specific set of criteria.
Aggregate Functions
Table
COUNT()
AS

30. Simplest type of subquery.
LIKE
SQL (Structured Query Language)
Simple Subquery
DBMS - Database Management System

31. NOT - AND - OR
Always define Primary Keys
SELECT Statement
Logical Operators
HAVING

32. A single field in a table. All tables are made up of one or more columns.
SELECT
Column
HAVING
DESC

33. A structured list of data of a specific type
WHERE
MIN()
Commas
Table

34. Variable-length character string. Max size is specified in parenthesis.
Nested Subquery
varchar(size)
AVG()
MAX()

35. A language designed specifically for communicating with databases.
DISTINCT
SQL extensions
SQL (Structured Query Language)
Column

36. A type of allowed data. Every table column has a datatype that restricts specific data in that column.
Datatype
char(size)
HAVING
GROUP BY

37. Takes a single numeric or alphabetic cloumn and finds the HIGHEST constant value within it.
INSERT INTO
ORDER BY
MAX()
SUM()

38. Descending
DESC
DBMS - Database Management System
Row
mysql

39. Used to nest subqueries within another subquery.
Terminating Statements
Table
INSERT INTO
Nested Subquery

40. Prevents duplicate values witihin a table or group of rows from being used in the evaluation of the function's result
IN
DISTINCT
MIN()
SELECT Statement

41. Usually DBMS specific - these can provide extra functionality or simplified ways to perform specific operations.
Row
SQL extensions
Breaking up data
Always define Primary Keys

42. COUNT() - MAX() - MIN() - SUM() and AVG()
Aggregate Functions
SQL extensions
MAX()
ORDER BY

43. Database software (an application)
ASC
Table
MIN()
DBMS - Database Management System

44. Multiple SQL statements must be separated by semicolons.
COUNT()
varchar(size)
Always define Primary Keys
Terminating Statements

45. Used to select all the information in a specified column.
SELECT *
IN
COUNT()
Aggregate Functions

46. Method used to copy multiple records at one time using a SELECT statement
application
ANY
INSERT INTO
LIKE

47. Takes a single numeric or alphabetic cloumn and finds the LOWEST constant value within it.
AVG()
MIN()
Database
number(size -d)

48. Combines rows from a SELECT statement's results table into groups in which specified columns have the same value.
Column
Logical Operators
LIKE
GROUP BY

49. Lets you use a single- or multiple-character wildcards. Also - this command does not function in Microsoft Access.
SQL extensions
LIKE
UPDATE
Row

50. All extra whitespace within a SQL statement is is ignored when that statement is processed.
SELECT Statement
Use of Whitespace
Terminating Statements
DBMS - Database Management System