Oracle - 11G - 题库337 - 图文(4)

D. remap_schema重映射方案

Answer: D

QUESTION NO: 28

You want to track and store all transactional changes to a table over its lifetime. To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years. After some time, the business requirement changed and you were asked to change the retention from 5 years to 3 years. To accomplish this, you issued the following command: 你想跟踪并存储在其生命周期内的所有事务的变化到一个表。要 完成这个任务，你启用了5年保留的闪回数据归档。一段时间后，业务需求变化，你被要求更改保留从5年 到3年。要做到这一点，你发出以下命令：

ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR; 改变闪回归档FLA1修改保留3年;

What is the implication of this command? 这个命令的含义是什么？

A. The command produces an error because the retention time cannot be reduced.

B. All historical data is retained but the subsequent flashback data archives are maintained for only three years.

C. All historical data is purged and the new flashback data archives are maintained for three years. D. All historical data older than three years is purged from the flashback archive FLA1. 所有三年以

上的历史数据从FLA1闪回归档中清除 Answer: D

QUESTION NO: 29

You are managing an Oracle Database 11g database with ASM storage. The ASM disk group has the COMPATIBLE.ASM attribute set to 11.1. Which statements are true regarding extent management and allocation units in the ASM disk group? (Choose all that apply.) 你正使用ASM存储来管理Oracle11g数据 库。 ASM磁盘组将兼容.ASM属性设为11.1。关于ASM磁盘组的区管理和分配单位哪些说法是正确的？ A. The au_size disk group attribute determines the size of allocation units in the disk group. 该AU_SIZE磁盘组属性决定磁盘组分配单元大小。

B. The allocation unit size may vary but the extent size is fixed.

C. The allocation unit size and extent size are fixed for all the disks in a disk group and cannot be changed.

D. Extent management is completely automated. 区管理是完全自动化的。 Answer: A,D

QUESTION NO: 30

Which are the prerequisites for performing flashback transactions on your database? (Choose all that apply.) 哪些是你的数据库上执行闪回事务的先决条件？

A. Undo retention guarantee for the database must be configured.

B. Supplemental log must be enabled for the primary key. 补全日志必须为主键而启用。 C. Supplemental log must be enabled. 补全日志必须启用。

D. Execute permission on the DBMS_FLASHBACK package must be granted to the user. 数据库管理系统闪回包上的执行权限上必须被授予给用户。 Answer: B,C,D

QUESTION NO: 31

Exhibit: View the Exhibit to examine the parameter values. You are planning to set the value for the MEMORY_TARGET parameter of your database instance. What value would you assign? 查看图表检查 参数值。您计划的设置你的数据库实例的内存目标参数的值。你会分配什么样的值？

A. 1440 MB B. 90 MB C. 362 MB D. 272 MB Answer: C

QUESTION NO: 32

You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big file tablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each. Which method

would accomplish the task quickly and efficiently? 您管理Oracle 数据库11g的数据库，你要采取备份 MULT_DATA，在磁带机上的100 TB大小的大文件表空间，但你的磁带驱动器每个只有10 GB，哪种方法 可以快速、高效地完成任务？ A. parallel image copy backup

B. backup with MAXPIECESIZE configured for the channel

C. parallel backup with MAXPIECESIZE configured for the channel D. intrafile parallel backup 内部文件并行备份 Answer:D

QUESTION NO: 33

You performed the RMAN database backup with the KEEP option. Which two statements are true regarding this backup? (Choose two.) 您用保持选项执行RMAN数据库备份。关于备份哪两个描述是真实 的？

A. The backup contains data files, the server parameter file, and the control file even if the control file autobackup is disabled. 备份包含数据文件，服务器参数文件，控制文件，即使控制文件的自动备份被禁 用。

B. The KEEP option overrides the configured retention policy. 保留选项将覆盖已配置的保留策略。 C. The backup contains only data files and archived redo log files. D. The KEEP option is an attribute of an individual backup piece. Answer: A,B

QUESTION NO: 34

You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup, you issued the following RMAN command: 您管理Oracle数据库11g的数据库，您 要对一个900 MB数据文件的用户表空间采取磁带备份。你有300 MB的磁带驱动器。为了完成备份，你发 出以下RMAN命令： RMAN>BACKUP

SECTION SIZE 300M TABLESPACE users;

What configuration should be effected to accomplish faster and optimized backups by using the above command? 通过使用上述命令，应当进行什么样的配置来实现更快和优化的备份？

A. The SBT channel must be configured, with the default parallelism setting for the SBT device set to 1. B. The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0.

C. The SBT channel must be configured, with the parallelism setting for the SBT device set to 3. SBT通道必须被配置， SBT设备的并行设置应设置为3。

D. The SBT channel must be configured, with the MAXPIECESIZE set to 300 MB. Answer: C

QUESTION NO: 35

The ADMIN_EMP table has columns EMPNO, ENAME, DEPTNO, and SAL. It has a materialized view EMP_MV with a materialized log and an ENAME_IDX index on the ENAME column. You need to perform an online table redefinition on the ADMIN_EMP table to move it from the TBS1 tablespace to the TBS2 tablespace in the same schema. What action is required for the dependent objects when you perform online redefinition on the table? 管理员工表有员工号，员工姓名，部门号，薪水的列。它有一个在员工姓 名列带有物 …… 此处隐藏：6300字，全部文档内容请下载后查看。喜欢就下载吧 ……