Subject: Oracle DBA

1. A table is created with this statement: Create table emp_copy tablespace users as select * from employees; Which of the following changes would make it impossible to drop the table? A. alter tablespace users read only; B. alter tablespace users offline; C. alter table emp_copy read only; D. Any of A, B, and C would make it impossible to drop the table E. None of the A, B, or C would make it impossible to drop the table

2. You create a tablespace with this command: Create tablespace g1_tabs datafile u01/oradata/g1_tabs_01.dbf Size 1000m autoextend on next 100m maxsize 2000m; If the critical alert for tablespace usage is set to 90 percent, when will the alert be raised? A. When the space used by segments that have not been dropped reaches 900MB B. When the space used by segments that have not been dropped and segments in the recycle bin reaches 900MB C. When the space used by segments that have not been dropped reaches 1,800MB D. When the space used by segments that have not been dropped and segments in the recycle bin reaches 1,800MB

3. Which is the effect of running the following command? alter database add logfile (/u01/oradata/redo04.log, /u02/oradata/redo05.log) size 500m; A. One new group will have two members. B. Two new groups will have one new member. C. Two members will be added to the current log file group. D. The command will fail if the existing log file groups do not consist of members that are 500MB in size.

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

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.

6. What is the effect on established sessions of shutting down the database listener? A. No impact on any session. B. Dedicated server sessions will be terminated. C. Shared server sessions connected through a dispatcher will survive; dedicated server sessions will hang until the listener is restarted. D. All sessions will be terminated.