Database Programming with SQL-Section 1 Quiz

Section 1 Quiz
(Answer all questions in this section)

1. Most of the well know Internet search engines use databases to store data. True or False? Mark for Review
(1) Points

True (*)
False

Incorrect Incorrect. Refer to Section 1 Lesson 2.
2. Databases are used in most countries and by most governments. Life, as we know it, would change drastically if we no longer had access to databases. True or False? Mark for Review
(1) Points

True (*)
False

Correct Correct
3. What language is used to query data in a Relational Database? Mark for Review
(1) Points

BASIC
SQL (*)
C++
Java

Correct Correct

4. A Relational Database generally contains two or more tables. True or False? Mark for Review
(1) Points

True (*)
False

Correct Correct
5. Columns in a database table contain data with the same _________: Mark for Review
(1) Points

Type (*)
Row
Field
Key

Incorrect Incorrect. Refer to Sec
—————————\
Section 1 Quiz
(Answer all questions in this section)

6. Which statement best describes how arithmetic expressions are handled? Mark for Review
(1) Points

Multiplication and addition operations are handled before subtraction and division operations.
Multiplication and subtraction operations are handled before any other operations.
Division and multiplication operations are handled before subtraction and addition operations. (*)
Addition operations are handled before any other operations.

Correct Correct.
7. You query the database with this SQL statement:
SELECT *
FROM transaction
WHERE product_id = 4569;

Which SQL SELECT statement capabilities are achieved when this statement is executed?

Mark for Review
(1) Points

Projection, selection and joining
Projection only
Selection only
Selection and projection only (*)

Incorrect Incorrect. See Section 1 Lesson 3.
8. SELECT * FROM departments; is a: Mark for Review
(1) Points

Strategy
Statement (*)
Keyword
Declaration

Correct Correct
9. The order of operator precedence is Mark for Review
(1) Points

/ + – *
* – + /
* / + – (*)
None of the above

Correct Correct
10. The SQL SELECT statement is capable of: Mark for Review
(1) Points

Selection and protection
Selection and projection (*)
Projection and updating
None of the above

Correct Correct
—————-
Section 1 Quiz
(Answer all questions in this section)

11. The _______ clause can be added to a SELECT statement to return a subset of the data. Mark for Review
(1) Points

EVERY
ANYWHERE
WHERE (*)
WHICH

Correct Correct.
12. All computers in the world speak the same languages, so you only need to learn one programming language – Oracle SQL. True or False? Mark for Review
(1) Points

True
False (*)

Correct Correct.
13. What command do you use to add rows to a table Mark for Review
(1) Points

NEW_ROW
INSERT (*)
ADD_ROW
ADD

Correct Correct
14. Examine the follolowing SELECT statement.
SELECT *
FROM employees;

This statement will retrieve all the rows in the employees table. True or False?

Mark for Review
(1) Points

True (*)
False

Correct Correct
15. The DESCRIBE command returns all rows from a table. True or False? Mark for Review
(1) Points

True
False (*)

Correct Correct.