2008中國首屆Oracle資料庫精英工程師評選電子試題（選擇題部分）

1．Which six files are maintained in the Flash Recovery Area? (Choose six.)

A. control file

B. RMAN files

C. password file

D. parameter file

E. flashback logs

F. data file copies

G. core dump files

H. archived log files

I. RMAN recovery scripts

J. control file autobackpus

  

2．You are unable to move the Unified Job Scheduler occupant from the SYSAUX

tablespace to the USERS tablespace. What could be the reason?

A. None of the SYSAUX occupants can be relocated.

B. The USERS tablespace is a bigfile tablespace (BFT).

C. The united Job Scheduler occupant cannot be relocated.

D. The SYSAUX occupants can be relocated to the SYSTEM tablespace only.

  

3．You want to enforce a company's business policy on several objects by using a single

policy function.

Which two types of policies can be assigned to the policy_type argument in the

dbms_rls.add_policy procedure to achieve the above objective? (Choose two.)

A. DBMS_RLS.STATIC

B. DBMS_RLS.DYNAMIC

C. DBMS_RLS.SHARED_STATIC

D. DBMS_RLS.CONTEXT_SENSITIVE

E. DBMS_RLS.SHARED_CONTEXT_SENSITIVE

 

4．You need to ensure that the database users should be able to use the various

flashback query features in order to go back in time by four hours. What should

you do? (Choose two.)

A. set SQL_TRACE=true

B. set UNDO_RETENTION=14400

C. set FAST_START_MTTR_TARGET=240

D. set LOG_CHECKPOINT_INTERVAL=240

E. set DB_FLASHBACK_RETENTION_TARGET=14400

F. Issue the ALTER DATABASE FLASHBACK ON; command.

G. set the RETENTION GUARANTEE clause for the undo tablespace

  

5．You are using Recovery Manager (RMAN) to perform. backups. In which three

situations would you perform. a compressed backup? (Choose three.)

A. Your database includes a large number of BFILEs.

B. You are making image copies, and you have not enabled tablespace compression.

C. You are backing up to tape and your tape device performs its won compression.

D. You are using disk-based backups and disk space in your Flash Recovery Area, or

other disk-based backup destinations are limited.

E. You are performing your backups to some device over a network where reduced

network bandwidth is more important than CPU usage.

F. You are using some archival backup media, such as CD or DVD, where reducing

backup sizes saves media costs and archival storage.

 

6．Identify four uses of the Oracle Scheduler. (Choose four.)

A. Enables you to set idle time limits for a resource plan.

B. Enables you to schedule job execution based on time.

C. Enables you to execute jobs in a clustered environment.

D. Enables you to assign priorities to the consumer groups.

E. Enables you to map a consumer group to an Oracle user.

F. Enables you to create a job that makes use of saved programs and schedules.

G. Enables you to periodically execute operating system script. files located on the same

server as the database.

  

7．You flashed back the jobs table at 11:00 a.m. to its state at 9:30 a.m.

At 11:15 a.m., you decided to retrieve the jobs table as it was at 10:12 a.m.

What would you do to retrieve the jobs table fast and with minimum impact to

other objects?

A. drop and re-create the table

B. perform. point-in-time recovery

C. use the ROLLBACK command with SCN

D. use the FLASHBACK TABLE command

E. use the FLASHBACK DATABASE command

  

8．You need to transport tablespaces between platforms with different endians. Which

two steps are required in addition to the regular steps needed for transporting

tablespaces? (Choose two.)

A. The DB_FILE_NAME_CONVERT parameter must be set in the init.ora file.

B. The CONVERT command of SQL*Plus must be used to change byte ordering.

C. No other explicit action is required.

D. The CONVERT command of the Recovery Manager utility must be used to change

byte ordering.

E. The COMPATIBLE parameter must be set to 10.0.0 or higher in both the source and

the target databases.

  

9．You modified the optimizer statistics of a table by using the

DBMS_STATS.GATHER_TABLE_STATS procedure.

You realized that the newly generated statistics have created suboptimal execution

plans for that particular table.

What would you do to revert to the previous set of statistics as soon as possible?

A. run Automatic Database Diagnostic Monitor (ADDM) Advisor to recommend a

solution

B. wait for the default automatic optimizer statistics generation

C. execute the DBMS_STATS.RESTORE_TABLE_STATS procedure

D. execute the DBMS_STATS.RESTORE_DATABASE_STATS procedure

E. purge the existing table statistics and execute the DBMS_STATS.GATHER_TABLE

procedure with a different set of parameters

  

10．You have 100 segments in the USERS tablespace. You realize that the USERS

tablespace is running low on space. You can use Segment Advisor to _______.

A. add data files to the tablespace

B. identify the segments that you should shrink

C. modify the storage parameters for the tablespace

D. automatically shrink the segments with unused space

E. check the alerts generated for the table space that is running low on space

  

11．Which three statements regarding collection of database usage metrics are correct?

(Choose three.)

A. The metrics survive database reboots and crashes.

B. The MMON process tracks and records the database usage metrics.

C. The MMAN process tracks and records the database usage statistics.

D. The Oracle Enterprise Manager (OEM) repository is used to store metrics.

E. The SMON process tracks and records the database usage metrics once a month.

F. The SYSAUX tablespace contains table, where the database usage metrics are

physically stored.

G. The SYSTEM tablespace by default contains tables where the database usage metrics

and physically stored.

 

12．An online tablespace, TEST_TBS, is full and you realize that no server-managed

tablespace threshold alerts were generated for the TEST_TBS tablespace. What

could be the reason, if the TEST_TBS tablespace does not include autoextensible

data files?

A. TEST_TBS is a small file tablespace.

B. TEST_TBS is a bigfile tablespace (BFT).

C. TEST_TBS is the default temporary tablespace.

D. TEST_TBS is the dictionary-managed tablespace.

E. Threshold values for the TEST_TBS tablespace are not explicitly specified.

 

13．Which three statements regarding compressed backups are correct? (Choose three)

A. The compression applies to only image copies.

B. The compressed backup is applicable to only data files.

C. The COMPATIBLE parameter must be set to 10.0.0 or higher.

D. The compressed backup is applicable to only the entire database backup.

E. Restoration from a compressed backup does not require any special action.

F. The compression provided by media manager and the RMAN backup compression

should not be used together.

 

14．Which three statements regarding the bigfile tablespace (BFT) are correct? (Choose

three)

A. BFT can be dictionary managed.

B. A BFT always contains a single file.

C. BFT is supported for locally managed tablespaces.

D. In BFT, the maximum file size ranges from 8 TB to 128 TB.

E. BFT, when uses with Oracle Managed Files (OMF), provides complete data file

transparency.

 

15．Which process performs the rebalance data extent movements across ASM disk

groups in ASM?

A. Checkpoint (CKPT)

B. System Monitor (SMON)

C. ASM Rebalance (ARBn)

D. Process Monitor (PMON)

E. ASM Background (ASMB)

F. ASM Rebalance Master (RBAL)

 

16．Consider the following configuration:

/devices/D1 is a member of disk group dgroupA.

/devices/D2 is a member of disk group dgroupA.

/devices/D3 is a member of disk group dgroupA.

You plan to add a new disk, /devices/D4, to the disk group dgroupA

and execute the following command:

SQL> ALTER DISKGROUP dgroupA ADD DISK '/devices/D4';

Which task would be accomplished by the command?

A. The command adds the new disk, D4 to the disk group.

B. The command would result in an error because there is no disk by the name

"/devices/D*".

C. The command would result in an error because no wildcard characters can be used in

the disk name.

D. The command will be ignored because disks starting with "D" are already members of

the disk group.

E. The command first detaches all the member disks starting with "D" and then

reattached all of them including the new disk.

  

17．To which three elements is the size of the block change tracking file proportional?

(Choose three)

A. Number of redo log groups.

B. Number of DBWR process.

C. Size of the database in bytes.

D. Number of archiving destinations.

E. Number of old backups maintained by the block change tracking file.

F. Number of enabled threads in Real Application Cluster (RAC) environment.

 

18．Which three statements regarding resumable statements are correct? (Choose

three)

A. Resumable statements cannot contain a distributed transaction.

B. Resumable statements can only be enabled at the system level.

C. Resumable statements can be enabled at the system level as well as the session level.

D. RESUMABLE_TIMEOUT=0 disabled resumable space allocation

for all sessions.

E. The ALTER SESSION ENABLE RESUMABLE command is obsolete in Oracle

Database 10g.

F. Only the local instance is affected when changing the resumable timeout parameter in

a distribution transaction.

 

19．Which three files can be managed using an ASM Instance? (Choose three.)

A. Data files

B. Audit files

C. Trace files

D. Export files

E. Alert log files

F. Archived log files

G. Change tracking files

 

20．Which three statements are true about the privileged connection options available

in Oracle 10g? (Choose three.)

A. The CONNECT INTERNAL is disallowed

B. The Server Manager tool is no longer supplied

C. The listener must be running to make a connection

D. The use of a remote password login file (orapwd) is unchanged

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/498744/viewspace-269241/，如需轉載，請註明出處，否則將追究法律責任。