Database Programming section 1

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

WHICH
EVERY
WHERE(*)
ANYWHERE

2. 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) Point
True
False (*)

3. You cannot use computers unless you completely understand exactly how they work. True or False?
Mark for Review (1) Point
True
False (*)

4. The DESCRIBE command returns all rows from a table. True or False?
Mark for Review (1) Point
True
False (*)

5. What command will return data from the database to you?
Mark for Review (1) Point
RETURN
SELECT(*)
GET
FETCH

6. If you want to see just a subset of the columns in a table, you use what symbol?
Mark for Review (1) Point
&
%
*
None of the above; instead of using a symbol, you name the columns for which you want to see data. (*)

7. In which clause of a SELECT statement would you specify the name of the table or tables being queried?
Mark for Review (1) Point
The FROM clause (*)

The SELECT clause
The WHERE clause
Any of the above options; you can list tables wherever you want in a SELECT statement.

8. Which statement best describes how arithmetic expressions are handled?
Mark for Review (1) Point
Multiplication and subtraction operations are handled before any other operations.
Addition operations are handled before any other operations.
Division and multiplication operations are handled before subtraction and addition operations. (*)

Multiplication and addition operations are handled before subtraction and division operations.

9. Which SQL keyword specifies that an alias will be substituted for a column name in the output of a SQL query?
Mark for Review (1) Point
AS (*)
AND
SUBSTITUTE
OR

10. In a SQL statement, which clause specifies one or more columns to be returned by the query?
Mark for Review (1) Point

SELECT (*)
FROM
WHERE
Any of the above options; you can list columns wherever you want to in a SELECT statement.

11. Every row in a relational database table is unique.
Mark for Review (1) Point
True(*)
False

12. A Relational Database generally contains two or more tables. True or False?
Mark for Review (1) Point
True(*)
False

13. Every time you shop online, it is likely you will be accessing a database. True or False?
Mark for Review (1) Point
True(*)
False

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

15. The basic storage structure in a Relational Database is a _________:
Mark for Review (1) Point
ROW
KEY
TABLE(*)
FIELD