中国首届Oracle数据库精英工程师评选电子试题和答案

2022-11-18 00:04:19 网络空间安全 ℃

　　一、选择题

　　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

　　回答: A，B，E，F，H，J

　　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.

　　回答: C

　　3．You want to enforce a companys 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

　　回答: C,E

　　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_ST =240

　　D. set LOG_CHECKPOINT_INTERVAL=240

　　E. set DB_FLASHBACK_RETENTION_TARGET=14400

　　F. Issue the AART_MTTR_TARGETLTER DATABASE FLASHBACK ON; command.

　　G. set the RETENTION GUARANTEE clause for the undo tablespace

　　回答: B,G

　　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.

　　回答: D,E,F

　　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.

　　回答: B, C, G, Fwww.gurufl）

　　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

　　回答: D

　　8．You need to transport tablespaces between platforms with different ians. 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.

　　回答: D,E

　　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 recomm 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

　　回答: C

　　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

　　回答: B

　　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.

　　回答: A, B, FGurufl）

　　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.

　　回答: D

　　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.

　　回答: C，E，F

　　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.

　　回答: B，C，D

　　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)

　　回答: C

　　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.

　　回答: A

　　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.

　　回答: C, E, F

　　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.

　　回答: C,D,F

　　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

　　回答: A, F, GGurufl）

　　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

　　回答: A,B,D

　　二、论述题

　　1.背景描述：客户有一个9208的数据库，没有使用归档方式，数据库的数据文件总共800G。

　　A．客户运行应用时，出现ORA-01578 ORACLE data block corrupted错误，数据不能正常查询。应如何处理使数据损失最小？

　　使用DBMS_REPAIR系统包，2.设置10231 events,然后EXPORT备份表，删除表重建并IMP数据

　　B．重建表以后，客户认识到归档的重要性，决定使用归档方式，用RMAN备份数据库到DISK，但当运行RMAN备份时仍然报ORA-19566: exceeded limit of 0 corrupt blocks for file file_name错误，导致RMAN备份失败，出错的数据块还是原来的块，检查发现此数据块上已无表或索引。问题出在哪？

　　RMAN备份时将所有修改过的数据块都要做备份，当坏块没有被从新占用时，还是坏块

　　Corrupted blocks will still be reported by RMAN and DBV until they are reused and reformatted.

　　C．处理完备份问题后，执行RMAN备份成功，备份到硬盘上的备份集大小为20G，费时20分钟。客户最近新购买了带库设备，自带速度50M/S；但向磁带备份时总共费时3小时，通过备份管理软件查询的结果是备份集大小为20G左右。为什么向磁带备份耗时较多？如何解决？

　　回答:向DISK备份时，只扫描修改过的块；向TAPE备份时扫描整个数据文件

　　2．某客户使用ORACLE10.2.0.3两节点RAC，其中每节点有4块网卡，两块作clust_interconnect, 两块作PUBLIC对外服务，两个OCR裸设备，三个VOTING DISK；客户需要做如下测试，请把预期的结果填入下列表中：