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. 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)