SUBJECTS
|
BROWSE
|
CAREER CENTER
|
POPULAR
|
JOIN
|
LOGIN
Business Skills
|
Soft Skills
|
Basic Literacy
|
Certifications
About
|
Help
|
Privacy
|
Terms
|
Email
Search
Test your basic knowledge |
SQL: Structured Query Language
Start Test
Study First
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 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.
Aggregate Functions
AVG()
AS
SELECT Statement
2. Primary way to do a query in SQL
COUNT()
WHERE
Row
SELECT Statement
3. Ascending
char(size)
Breaking up data
Nested Subquery
ASC
4. Fixed-length character string. Size is specified in parenthesis. Max 255 bytes.
WHERE
Always define Primary Keys
MIN()
char(size)
5. COUNT() - MAX() - MIN() - SUM() and AVG()
Breaking up data
Self-Join
char(size)
Aggregate Functions
6. Limits the output of the established groups into the derived result group.
Datatype
HAVING
Database
UPDATE
7. A record in a table
Terminating Statements
Row
FROM
SQL extensions
8. When selecting multiple columns be sure to specify a _____ BETWEEN each column name but NOT after the last column name.
Row
AS
Commas
Self-Join
9. Allows you to delete selected rows.
DELETE
SQL (Structured Query Language)
Database
Logical Operators
10. Simplest type of subquery.
ORDER BY
Simple Subquery
UPDATE
Self-Join
11. A reserved word that is part of the SQL language. Never name a table or column using a keyword.
Keyword
DESC
ASC
Nested Subquery
12. A single field in a table. All tables are made up of one or more columns.
AS
COUNT()
UPDATE
Column
13. Allows you to correlate information between different rows of the same table and combine this information in rows of a result table.
SELECT
COUNT()
Self-Join
ANY
14. Used to select all the information in a specified column.
SQL Statement and Case
MIN()
Use of Whitespace
SELECT *
15. SQL is a language NOT an _______
Breaking up data
application
MIN()
INSERT INTO
16. Descending
DESC
HAVING
MAX()
ASC
17. Lets you change the values in one or more selected rows of a table.
UPDATE
varchar(size)
char(size)
MAX()
18. Provides a numerical tally of how many rows meet a specific set of criteria.
AS
Column
SUM()
COUNT()
19. NOT - AND - OR
Logical Operators
application
SQL Statement and Case
Column
20. Alias
LIKE
mysql
Aggregate Functions
AS
21. Usually DBMS specific - these can provide extra functionality or simplified ways to perform specific operations.
Comparison Operators
Simple Subquery
SQL extensions
ORDER BY
22. Database software (an application)
Row
DBMS - Database Management System
Always define Primary Keys
Database
23. Combines rows from a SELECT statement's results table into groups in which specified columns have the same value.
Nested Subquery
GROUP BY
Comparison Operators
INSERT INTO
24. The container - usually a file or set of files - to store organized data
Database
COUNT()
application
SQL extensions
25. SQL statements are case- insensitive
Nested Subquery
INSERT INTO
AS
SQL Statement and Case
26. Data must be broken into multiple columns correctly. For example - city - state - and zip should always separate columns.
Breaking up data
UPDATE
Datatype
HAVING
27. A popular open source database
AVG()
DISTINCT
DELETE
mysql
28. A language designed specifically for communicating with databases.
SQL (Structured Query Language)
Row
GROUP BY
Database
29. Variable-length character string. Max size is specified in parenthesis.
varchar(size)
Datatype
Logical Operators
AVG()
30. A column or set of columns whose values uniquely identify every row in a table.
Aggregate Functions
ASC
Primary Key
ORDER BY
31. Method used to copy multiple records at one time using a SELECT statement
Primary Key
Terminating Statements
INSERT INTO
FROM
32. Number value with a maximum number of digits of "size" total - with a maximum number of "d" digits to the right of the decimal.
application
mysql
Database
number(size -d)
33. 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.
DISTINCT
AS
Always define Primary Keys
ASC
34. Denotes that the search condition is TRUE for at least one element that the subquery returns.
AS
COUNT()
ANY
char(size)
35. A type of allowed data. Every table column has a datatype that restricts specific data in that column.
SQL (Structured Query Language)
Nested Subquery
number(size -d)
Datatype
36. Specify one or more columns on which to order the display.
INSERT INTO
ORDER BY
Commas
SUM()
37. Allows a comparison with multiple values from a list.
IN
FROM
char(size)
Breaking up data
38. Takes a single numeric or alphabetic cloumn and finds the LOWEST constant value within it.
IN
ORDER BY
application
MIN()
39. Prevents duplicate values witihin a table or group of rows from being used in the evaluation of the function's result
DISTINCT
Self-Join
COUNT()
DESC
40. Limits the rows that appear in the result to those matching a specified condition
WHERE
char(size)
Comparison Operators
SQL Statement and Case
41. Multiple SQL statements must be separated by semicolons.
Datatype
Terminating Statements
DISTINCT
Database
42. Specifies the tables or views from which rows and columns are retrieved
AVG()
Primary Key
FROM
COUNT()
43. = Equals - < Less Than - > Greater Than - <= Less Than or Equal To - >= Greater Than or Equal To - <> Not Equal - ! Negation of
ORDER BY
SQL (Structured Query Language)
Comparison Operators
mysql
44. Takes all of the values in that column and adds them together. Only works on columns containing numeric data.
ANY
SUM()
Table
HAVING
45. _______ column name FROM table name
SELECT *
MAX()
SELECT Statement
SELECT
46. All extra whitespace within a SQL statement is is ignored when that statement is processed.
Use of Whitespace
SQL (Structured Query Language)
AVG()
DBMS - Database Management System
47. A structured list of data of a specific type
Keyword
Table
IN
Comparison Operators
48. Used to nest subqueries within another subquery.
Nested Subquery
AVG()
HAVING
Aggregate Functions
49. Takes a single numeric or alphabetic cloumn and finds the HIGHEST constant value within it.
UPDATE
FROM
SUM()
MAX()
50. Lets you use a single- or multiple-character wildcards. Also - this command does not function in Microsoft Access.
Breaking up data
WHERE
LIKE
application