Subject: Oracle DBA

1.

Your database has a single undo tablespace, and you decide to add another. How

can you ensure that the new one will be used?

A. Change the UNDO_TABLESPACE parameter to point to the new tablespace; there is no need to restart the database.

B. Change the UNDO_TABLESPACE parameter to point to the new tablespace, and restart the database.

C. Assign the new undo tablespace to one or more users; the UNDO_TABLESPACE parameter will be automatically adjusted.

D. Bring the new tablespace online; the UNDO_TABLESPACE parameter will be automatically adjusted.

2.

When one is using shared servers, what may happen if more concurrent requests are received than there are shared server processes?

A. Sessions may receive errors.

B. Statements may be queued.

C. No more shared servers may be started automatically.

D. The shared servers may execute several requests in parallel.

3.

Which of these is type of segment?

A. View

B. Table

C. Sequence

D. Rownum

E. All of the above

4.

What attributes of a user account can you specify with the CREATE USER command?

A. Default role(s)

B. Tablespace for storing all the users temporary data

C. Privilege

D. All of the above

5.

If a tablespace is made read-only, what can still be done to objects within it?

A. Insertions into a table will work, as long as there is free space within the segment and so no new extents need to be allocated.

B. Operations that are transparent to applications and users (such as creating indexes) can be done in the tablespace, but no DML commands can be executed against tables within it.

C. Objects in the tablespace can be dropped but not created.

D. No SQL commands can be executed against any objects in a read-only tablespace except SELECT statements.