QUESTION 11

"This is in contrast to database architectures such as Microsoft SQL Server and IBM DB2, for which the word instance indicates a collection of databases that share common memory resources" The result of the statement above is that:

a. With DB2, many instances access one and only one database. In Oracle, an instance can access several databases.

b. In Oracle, many instances access one and only one database. With DB2, an instance can access several databases.

c. A database is the same as a schema.

d. Memory resources are shared among several instances in both Oracle and DB2.

QUESTION 13

The EXCEL financial function FV (rate, nper, pmt, [pv], [type]) can be used to calculate extent size when adapted to the partial SQL code below:

DEFAULT STORAGE (INITIAL 500K NEXT 200K MAXEXTENTS 20 PCTINCREASE 15)

Note that the last two arguments are optional

a. none of these choices

b. = FV (20, 0.15, 204800)

c. = FV (0.15, 19, 204800, 512000)

d. = FV (0.15, 19, 204800) - 512000