1 , Select the invalid statements from the following regarding undo segment management. (Choose
all that apply.)
A. ALTER SYSTEM SET UNDO_TABLESPACE = ROLLBACK;
B. ALTER DATABASE SET UNDO_TABLESPACE = UNDOTBS;
C. ALTER SYSTEM SET UNDO_MANAGEMENT = AUTO;
D. ALTER SYSTEM SET UNDO_MANAGEMENT = MANUAL;

2, You are administering an Oracle database using Shared Server. The LARGE_POOL_SIZE is
50MB. You issue the command ALTER SYSTEM SET LARGE_POOL_SIZE = 100M SCOPE=MEMORY.
You then shut down and restart the database. What will the LARGE_POOL_SIZE be?
A. 50MB
B. 100MB
C. The default LARGE_POOL_SIZE
D. The LARGE_POOL_SIZE as you have set it in the Oracle SPFILE that you are using

3, Which of the following objects share the same namespace and therefore cannot have the same name?
A. Tables and sequences
B. Tables and indexes
C. Tables and tablespaces
D. Tables and constraints

4, You are in the middle of an emergency drill at your organization. There is little time to notify
database users, and you need to stop the Oracle database processes as quickly as possible. Which
of the following would you perform?
A. SHUTDOWN ABORT
B. SHUTDOWN TRANSACTIONAL
C. SHUTDOWN
D. SHUTDOWN IMMEDIATE
E. None of the above

5, You are a database administrator with databases in New York, Hong Kong, and London. You
want to administer all your databases from a central console using Grid Control. Which of the
following commands do you issue when using Grid Control?
A. emctl start grid
B. emctl start dbconsole
C. emctl start agent
D. isqlplusctl start

6, Which of the following components is not part of an Oracle instance?
A. System Global Area
B. Server Process
C. Database Writer
D. System Monitor

[@more@]

ITPub博客

10G OCA TEST Attention

最新文章