oracle11g OCP 认证 1Z0-053考试笔记7

602.On Friday at 11:30 am you decided to flash back the database because of a user error that occurred
at 8:30 am.
Which option must you use to check whether a flashback operation can recover the database to the
specified time?
B. Query the V$FLASHBACK_DATABASE_LOG view


和Flashback Database 相关的2个视图： 
1. V$database 
 这个视图可以查看是否启用了Flashback database功能 
SQL> select flashback_on from v$database; 
FLASHBACK_ON 
------------------ 
YES 
 
2. V$flashback_database_log 
 Flashback Database 所能回退到的最早时间，取决与保留的Flashback Database Log 的多少， 该视图就可以查看许多有用的信息。 
Oldest_flashback_scn / Oldest_flashback_time : 这两列用来记录可以恢复到最早的时点 
Flashback_size: 记录了当前使用的Flash Recovery Area 空间的大小 
Retention_target: 系统定义的策略 
Estimated_flashback_size: 根据策略对需要的空间大小的估计值 


603.While performing a regular check on your recovery catalog you realized that the catalog database is
running out of space and you do not have options to increase the space. However, you have another
database where more space is available and you want to move your existing recovery catalog to this
database.
迁移catalog库
The options that can be considered while moving the recovery catalog are as follows:
1. Using one of the Oracle expdp utilities to export the catalog data
2. Creating a recovery catalog user and granting the necessary privileges in the other database
3. Creating the recovery catalog using the CREATE CATALOG command
4. Using the corresponding impdp utility to import the catalog data into the other database
5. Registering the target database in the new catalog database using the REGISTER DATABASE
command Identify the option with the correct sequence for moving the recovery catalog.


B. 1, 2, 4
使用expdp工具导出目录数据---创建恢复目录用户和授权必要的权限----使用impdp导入数据


604.You realize that the control file is damaged in your production database. After restoring the control file
from autobackup, what is the next step that you must do to proceed with the database recovery?


A. Mount the database


控制文件损坏，恢复之后，挂载数据库


605.What two are the prerequisites for enabling Flashback Database? (Choose two)
闪回数据库的先决条件
A. The database must be in ARCHIVELOG mode  归档模式
B. The database must be in MOUNT EXCLUSIVE mode 独占模式
参考：闪回数据库：http://blog.csdn.net/rlhua/article/details/12421005
按以下步骤配置闪回数据库：
1.配置快速恢复区。
2.使用DB_FLASHBACK_RETENTION_TARGET初始化参数设置保留目标。可指定一个上限（以分钟为单位），指示数据库能够闪回到多长时间以前。 ALTER SYSTEM SETDB_FLASHBACK_RETENTION_TARGET=2880 SCOPE=BOTH 使用了2,880 分钟，相当于两天。此参数只是一个目标，并不提供任何保证。闪回时间间隔取决于快速恢复区中保存的闪回数据量。
3.使用以下命令启用闪回数据库：
ALTER DATABASE FLASHBACK ON;
必须先针对归档配置数据库，之后才能发出命令来启用闪回数据库。
可以使用以下查询来确定是否已启用闪回数据库：
SELECT flashback_on FROM v$database;
可使用ALTER DATABASE FLASHBACK OFF命令来禁用闪回数据库。这样，会自动删除所有现有的闪回数据库日志。
注：只有在独占模式下装载数据库后才能启用闪回数据库，在打开状态下则不可以。








606.Identify the channel settings that can be performed using the CONFIGURE CHANNEL or ALLOCATE
CHANNEL commands in RMAN (choose all that apply)
配置和分配通道的作用
A. Limiting the input/output (I/O) bandwidth consumption   限制I/O占用
C. Specifying vendor-specific information for a media manager  制定备份介质的类型




607.Examine the following scenario:
-Database is running in ARCHIVELOG mode.
-Complete consistent backup is taken every Sunday.
-On Tuesday the instance terminates abnormally because the disk on which control files are located gets
corrupted
The disk having active online redo log files is also corrupted.
The hardware is repaired and the paths for online redo log files and control files are still valid. Which
option would you use to perform the recovery of database till the point of failure?


归档模式，每周日一致性备份， 周二实例由于控制文件损坏而崩溃   磁盘联机日志也已经损坏   恢复方式
D. Restore the latest backup control file, perform incomplete recovery using backup control file, and open
the database with the RESETLOG option.
使用备份的控制文件恢复，执行不完全恢复， restlog数据库


Answer: D


608.You are managing a 24*7 database. The backup strategy for the database is to perform
user-managed backups.
Identify two prerequisites to perform the backups. (Choose two.)
24*7的数据库， 备份策略是执行用户管理的备份，先决条件
B. The database must be configured to run in ARCHIVELOG mode.  归档
C. The tablespaces are required to be in backup mode before taking the backup.  表空间改为备份模式






609.Examine the following commands and their output:
SQL> SELECT ename, sal FROM emp WHERE ename='JAMES';
ENAME SAL JAMES 1050
SQL> UPDATE emp SET sal=sal+sal*1.2 WHERE ename='JAMES';
1 row updated.
SQL> SELECT ename, sal FROM emp WHERE ename='JAMES';
ENAME SAL JAMES 2310
View the exhibit and examine the Flashback Version Query that was executed after the preceding
commands.
What could be the possible cause for the query not displaying any row?


闪回版本没有 


B. The changes made to the table are not committed.
改变没提交


610.Which of the following advisors is run in every maintenance window by the auto-task system?


B.The SQL Tuning Advisor


自动 SQL 优化将在系统维护窗口期间作为自动维护任务运行, 搜索改进高负载 SQL 语句的执行计划的方法。


611.To accomplish user-managed backup for the USERS tablespace, you issued the following command
to put the database in backup mode:
SQL> ALTER TABLESPACE users BEGIN BACKUP;
While copying the file to the backup destination a power outage caused the instance to te minate
abnormally.
Which statement is true about the next database startup and the USERS tablespace?


复制文件的时候，电源故障终止
下次启动数据库
C. The database will be mounted, and data files in the USERS tablespace must be taken out of the
backup mode.
数据库将加载，用户表空间脱离备份模式


612.Examine the following command used to perform incremental level 0 backup:
RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE;
To enable the block change tracking, after the incremental level 0 backup you issued the following
command:
SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '/mydir/
rman_change_track.f';
To perform incremental level 1 cumulative backup, you issued the following command:
RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;
Which two statements are true in the above situation? (Choose two.)
0级备份后 打开块跟踪 执行1级累积增量备份   说法正确是


A. The block change tracking data will be used only from the next incremental 0 backup.
块跟踪在下次0级备份后使用
C. The incremental backup will not use change tracking data for accomplishing the backup.
增量备份备份完成不会使用跟踪数据，




613.You want to use the automatic management of backup and recovery operations features for your
database.
Which configuration must you set?


A. Enable the flash recovery area and specify it as the archived redo log destination.
启用闪回区  指定归档日志目录


614.Which three types of files can be automatically placed in the flash recovery area (fast recovery area
in 11g Release 2)?(Choose three.)


B. Archived redo log files
C. Control file autobackups
E. Recovery Manager (RMAN) backup piece
Answer: BCE


615.Before a Flashback Table operation, you execute the following command:
ALTER TABLE employees ENABLE ROW MOVEMENT;
Why would you need this to be executed?


A. Because row IDs may change during the flashback operation
闪回操作的时候 行id会发生变化
先看Flashback Table。这一功能能帮助我们及时回滚一些误操作，防止数据意外丢失。在使用该功能之前，必须先打开ROW MOVEMENT，否则就会抛ORA-08189错误。我们看以下例子，可以说明在使用Flashback Table功能时，ROW MOVEMENT产生了什么作用：
当开启ROW MOVEMENT后，表被顺利的flashback了，数据被找回。此时，再比较flashback前后记录的ROWID，大多数记录的物理位置都变化。这个过程的内部操作， 可以通过对Flashback Table做SQL Trace来进一步观察。通过Trace，我们不难发现，Flashback Table实际是通过Flashback 


616.The EMP table has some discrepancy in data entry with a particular employee ID. You execute the
query as shown in the Exhibit to retrieve all versions of the row that exist between two SCNs.View the
Exhibit.
Which two statements about the results of the query shown in the Exhibit are correct? (Choose two.)
Exhibit:


A. The LAST_SCN value in the first row is NULL, which means that the versions of the row still exist at
SCN 6636300.
B. The LAST_SCN value in the second row in NULL, which means that the version of the row still exists at
SCN 6636300.
C. The LAST_SCN value in the third row is 6636280, which means that the version of row exists above
SCN 6636280.
D. The LAST_SCN value in the second row is NULL, which means that the version of the row no longer
exists because it was deleted.
Answer: AD


闪回版本查询用来找到在两个时间点（SCN）之前表到底发生了什么事情。
empno=7126做了什么
A，因为第一行的first_scn是做insert操作，而last_scn是空的，意味着该行还存在
D，从图上看出第三行first_scn=6636252的时候insert了一行，ename等于”Jones”，但是其存在的生命周期在 last_scn=6636280 就结束了，
    为什么结束了，看第二行scn 6636280做了一个delete操作

617.A database instance is using an Automatic Storage Management (ASM) instance, which has a disk
group, DGROUP1, created as follows:
SQL> CREATE DISKGROUP dgroup1 NORMAL REDUNDANCY
FAILGROUP controller1 DISK '/devices/diska1', '/devices/diska2' FAILGROUP controller2 DISK
'/devices/diskb1', '/devices/diskb2' ;
What happens when the whole CONTROLLER1 Failure group is damaged?
ASM普通冗余，两个故障组 1 和2  
C. The data in the CONTROLLER1 failure group is shifted to the CONTROLLER2 failure group and
implicit rebalancing is triggered
1损坏迁移到2， 后台重平衡会触发


618.You want to set the following initialization parameters for your database instance:
LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch' LOG_ARCHIVE_DEST_2 =
'LOCATION=/disk2/arch' LOG_ARCHIVE_DEST_3 = 'LOACTION=/disk3/arch'
LOG_ARCHIVE_DEST_4 = 'LOCATION=/disk4/arch
MANDATORY'
Identify the statement that correctly describes this setting.


D. The online redo log file is not allowed to be overwritten if the archived log cannot be created in the
fourth destination.
Answer: D
在第四个位置归档日志不能创建，联机日志不能重写


619.View the Exhibit and note the contents of V$DIAG_INFO.
Which statement is true about the ADR?


A. The text alert log file will be available in Diag Trace
ADR (AutomaticDiagnostic Repository) ，ADR 是一个基于文件的资料档案库，用于存放数据库诊断数据（如跟踪、意外事件转储和程序包、预警日志、健康状况监视器报告、核心转储等）。它对存储在任何数据库外的多个实例和多种产品使用一个统一的目录结构
V$DIAG_INFO 视图列出了所有重要的ADR 位置：


(1) ADR Base：ADR 基目录的路径


(2) ADR Home：当前数据库实例的ADR 主目录的路径


(3) Diag Trace：文本预警日志和后台/前台进程跟踪文件的位置


(4) Diag Alert：XML 版本的预警日志的位置






620.You are using the control file to maintain information about the database backups that are being
performed by Recovery Manager (RMAN).
Identify two scenarios is which you must have a recovery catalog. (Choose two.)
A. To store the backup information of multiple database  集中存储
D. To list the data files that were in a target database at a given time by using the AT option of REPORT
SCHEMA command.
列出目标数据库给定时间的数据文件


621.You have enabled backup optimization for the RMAN environment. Identify two criteria标准 on which
RMAN will skip the file, if it has already been backed up. (Choose two.)
C. The backup was taken after the data files was taken offline-normal or is in the read only mode
D. The data file backup complies with the back retention policy and the backup duplexing fe ture
Answer: CD
rman跳过文件的标准
备份后数据文件正常离线或者为只读模式
数据文件备份遵照备份保留策略，备份副本已有


622.You need to maintain a record of all transactions on some tables for at least three years.
Automatic undo management is enabled for the database.
What must you do accomplish this task?


D. Create Flashback Data Archive and enable Flashback Data Archive for specific tables
Answer: D


保存所有的事务至少三年，自动undo已经开启


创建闪回数据归档，指定表启用闪回数据归档


623.You issued the following commands to configure setting in RMAN;


RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 1;
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt;
RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE sbt TO 2;
RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 2;
RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
Then you issued the following command to take the backup:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which statement is true about the execution of the above command?


D. It backs up the data files and archived log files to tape, making two copies of each data file and
archived log file
Answer: D
每个数据文件备份两次，备份到磁带上


624.You work with a newly created database. Presently, there is no application load on the database
instance. You want to create a baseline for tuning the application, so you decide to collect
recommendations that can be implemented to improve application performance.
What action must you take to achieve this?
新创建库，建立性能基线，提高应用程序性能


D. Run the SQL Access Advisor with a hypothetical假设的 workload
Answer: D
运行SQL访问顾问 在假设的负载下


625.Your database is running in ARCHIVELOG mode. One of the data files, USERDATA01.dbf, in the
USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for
the datafile is available.
Which three files would be used in the user-managed recovery process performed by the database
administrator (DBA)? (Choose Three)
A. Redo logs
C. The latest backup of only the damaged data file
F. Archive Logs since the latest backup to point of failure
Answer: ACF
用户管理的恢复过程， 归档模式 ，需要文件 闪回日志，备份的文件，故障点到到最后一次备份的归档日志




626.Which options must you configure while performing an automated Tablespace Point-in-Time
Recovery (TSPITR) by using Recovery Manager (RMAN)?
执行自动基于时间点的表空间恢复


D. Auxiliary destinations for an auxiliary set of data files
Answer: D
为辅助数据文件集建立辅助目的地


627.In Recovery Manager (RMAN), you are taking image copies of the data files of your production
database and rolling them forward at regular intervals. You attempt to restart your database. After a
regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is
damaged and you need to recover the data file by using the image copy. Because a media failure caused
the data file to be damaged, you want to place the data file in a different location while resto ing the file.
Which option must you consider for this task?
副本镜像备份，恢复 更换介质
C. using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.
使用设置新的名字，直接切换


628.The database is running in the ARCHIVELOG mode. It has three redo log groups with one member
each. One of the redo log groups has become corrupted. You have issued the following command during
the recovery of a damaged redo log file:
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;
Which action should you perform immediately after using this command?
三个闪回日志组，其中一个组损坏，执行清理日志组   需要先执行什么命令
B. You should make a backup of the database
做一个数据库的备份


629.Which option is best practice for creating a recovery catalog owner in the catalog database?
创建恢复目录的最佳实践 
C. Creating a new tablespace, allocating this as the default, and granting UNLIMITED QUOTA on this
tablespace to the user


 创建一个新的表空间，分配作为默认表空间，授权用户无限配额
 
 630.Which two statements are true about encrypting RMAN backup? (Choose two.)
 A. The transparent encryption of backups uses the encryption wallet   使用密码钱包加密透明的备份加密
 C. The password encryption of backups only uses the password while creating and restoring backup
 密码加密仅用在创建和还原备份
 
 
 631.View the Exhibit and examine the output of the query in different times when the following command
runs in an
RMAN sessions:
RMAN> BACKUP DATABASE FILESPERSET 2;
The database has seven data files. Why is the %_COMPLETE refreshed to 13.59 in the third output after
reaching 88.77?


备份进度显示


B. Because the progress is reported for each backup set  备份进程报告的是每一个备份集


632.Note the following parameter settings: Which setting is NOT allowed?




B. ALTER SYSTEM SET DB_8K_CACHE_SIZE=10M;
 sys@TEST1107> ALTER SYSTEM SET DB_8K_CACHE_SIZE=10M;


ALTER SYSTEM SET DB_8K_CACHE_SIZE=10M


*


ERROR at line 1:


ORA-32017: failure in updating SPFILE


ORA-00380: cannot specify db_8k_cache_size since 8K is the standard block size


sys@TEST1107> ALTER SYSTEM SET DB_CACHE_SIZE=50M;


System altered.


sys@TEST1107> ALTER SYSTEM SET DB_4K_CACHE_SIZE=10M;


System altered.


sys@TEST1107> ALTER SYSTEM SET DB_16K_CACHE_SIZE=10M;


System altered.




633.Which three statements must be true before transporting a tablespace from a database on one
platform to a database on another platform? (Choose three.)
传输表空间从一个库到另外一个平台
A. Both source and target database must be the same character set  相同的字符集
B. Both source and target database must have the same endian format  相同的字节存储格式
D. The minimum compatibility level for both the source and target database must be 10.0.0.  最小兼容级别为10.0.0.
Answer: ABD
634.Your database instance is running. You are not able to access Oracle Enterprise Manager Database
Control because the listener is not started.
Which tool or utility would you use to start the listener?


B. Listener Control utility
在em中使用监听控制器 启动监听


635.While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that
the flash recovery area does not have enough free space to accommodate any more files and you do not
have necessary permissions to add more space to it.
Identify the two events that can occur in the event of a log switch? (Choose two.)
B. The log switch hangs occur for transactions until free space is available in the flash recovery area
C. The Oracle database server deletes a file that is on the obsolete file list to make free space in the flash
recovery area
Answer: BC
 闪回区满  无权限添加 
 日志切换会宕机
 在闪回区中删除一写过时的文件


 
 636.Identify the persistent永久 configuration setting for the target database that can be set for the backup by
using RMAN. (Choose all that apply.)
通过rman可以确定的永久配置
A. Backup retention policy  备份保留策略
B. Default backup device type  默认备份设备类型
C. Default destinations for backups  备份默认地址


637.Which three statements are true about windows? (Choose three.)


A. Only one window can be open at any given time
C. Windows work with job classes to control resource allocation
E. Windows can automatically start job or change resource allocation among jobs for various time
periods.
Answer: ACE
此Windows非彼Windows，通常说的Windows是指盖首富的操作系统，而此处所说的Windows，是指SCHEDULER特性中的一个子项。在SCHEDULER中，WINDOW对应的是一个时间窗口的概念。
我们知道普通的jobs是没有运行时间管理地概念的，就是说一个job启动之后，用户只能被动地等待其执行，一直到其执行地任务完成(或DBA手动kill对应进程)，在此期间，执行的job将与其它活动的进程共同竞争当前系统中的资源。对于大型数据库系统，系统资源那可是相当宝贵的无形资产哪，企能谁说用就用、想什么时候用就什么时候用，没点儿计划没点儿节制这还了得。你还别说，在9i之前，还真就是这么回事儿，谁想用就用，谁也管不了，其中表示最甚的就是job。你是否想起了Job Classes，没错定义Job Classes确实可以控制job能够使用的资源，不过单单使用Job Classes并不能灵活的控制job在合适的时间使用适当的资源。进入10g之后，SCHEDULER中提供了WINDOW，事情终于有了缓解。


WINDOW 可以指定一个时间窗口，在此期间，通过与Job Classes的搭配组合，能够有效控制job执行时支配(使用)的资源。比如说job通常是在凌晨服务器负载较低时执行，那么就可以通过WINDOW设置在此期间，允许jobs使用更多的系统资源，而到了工作时间后，如果job仍未执行完成，为其分配另一个有限的资源，以尽可能降低job执行占用的资源对其它业务的影响


638.Which three statements are true about persistent configuration? (Choose three.)
A. A user cannot set privileges on the persistent lightweight jobs


D. The use of a template is mandatory to create persistent lightweight jobs
E. Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time
Answer: ADE


639.You want to enable automatic PGA memory management in your database. Which setting is required
to achieve this?
 自动PGA管理
D. Set the PGA_AGGREGATE_TARGET parameter to nonzero value
Answer: D
1．PGA_AGGREGATE_TARGET-此参数用来指定所有session总计可以使用最大PGA内存。这个参数可以被动态的更改,取值范围从10M -- （4096G-1 ）bytes。


640.Examine the parameter setting in your database:


D. Automatic memory management is enabled and, as per policy, 60% of the memory for System Global
Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup
Answer: D
因为Memory_target有设置有值，则启用AMM自动内存管理，使用动态内存管理时，SGA_TARGET和PGA_AGGREGATE_TARGET代表它们各自内存区域的最小设置，要让Oracle完全控制内存管理，这两个参数应该设置为0。
故只能选D。


641.Which three functions are performed by the SQL Tuning Advisor? (Choose three.)


A. Building the SQL profile 创建SQL配置
B. Recommending optimization of materialized views
C. Checking query objects for missing and stale statistics  检查丢失和过期的统计查询对象
D. Recommending bitmap, function-based, and B-tree indexes
E. Recommending restructuring SQL queries that are using bad plans   推荐重建sql查询
Answer: ACE


642.In your production database, users report that they are unable to generate reports on an important
table because it does not contain any data. While investigating the reason, you realize that another user
executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want
to recover the lost data of the table without affecting objects in other schemas.
Which method must you use to recover the lost data?


C. Tablespace Point-in-Time Recovery (TSPITR)


truncate 表之后 基于时间点的表空间恢复


643.View the Exhibit.
You are creating a database by using Database Configuration Assistant (DBCA). You have chosen the




B. The database files would be managed by the operating system's file system


操作系统文件系统管理数据库文件


644.View the Exhibit and examine the disk groups created at the time of migrating the database storage
to Automatic Storage Management (ASM).
Why does the FRA disk group initially have more free space even though both DATA and FRA disk groups
are provided with the same size?


迁移数据库到ASM上
FRA磁盘组有更多的空间 即使DATA和FRA有相同的尺寸
B. Because the FRA disk group is not configured to support mirroring
FRA没有配置支持镜像


645.Which two statements are true about a job chain? (Choose two.)


A. A job chain can contain a nested chain of jobs.
C. A job of the CHAIN type can be run using event-based or time-based schedules.


Defining Chain Steps
After creating a chain object, you define one or more chain steps. Each step can point to one of the following:
A Scheduler program object (program)
Another chain (a nested chain)
An event schedule, inline event, or file watcher


646.View the exhibit and examine the TRANS table's storage information. After a massive delete
operation, you executed the following statement to shrink the TRANS table: SQL> ALTER TABLE trans
SHRINK SPACE CASCADE;
Which statement describes the outcome of the command?


B. The table and all related objects are compacted and the position of the high-water mark (HWM) for the
table is adjusted调整过的


647.You executed the following commands in a database session:




A. There is demand for space from the new table
新表需求空间
drop后的表被放在回收站(user_recyclebin)里，而不是直接删除掉。这样，回收站里的表信息就可以被恢复，或彻底清除。    通过查询回收站user_recyclebin获取被删除的表信息，然后使用语句
    flashback table <user_recyclebin.object_name or user_recyclebin.original_name> to before drop [rename to <new_table_name>];
                   将回收站里的表恢复为原名称或指定新名称，表中数据不会丢失


1.什么是Recycle Bin


实际上，Recycle Bin只是一个保存被drop的对象的一个数据字典表。所以，可以通过如下语句查询回收站中的信息： 
select * from recyclebin


除非拥有sysdba权限，每个用户只能看到属于自己的对象。所以，对于用户来说，好像每个人都拥有自己的回收站。即使用户有删除其他schema对象的权限，也只能在recyclebin中看到属于自己的对象。




648.Note the following statements that use flashback technology:
1. FLASHBACK TABLE <table> TO SCN <scn>;
2. SELECT * FROM <table> AS OF SCN 123456;
3. FLASHBACK TABLE <table> TO BEFORE DROP;
4. FLASHBACK DATABASE TO TIMESTAMP <timestamp>;
5. SELECT * FROM <table> VERSIONS AS OF SCN 123456 AND 123999;
Which of these statements will be dependent on the availability of relevant undo data in the undo
segment?
与undo段相关


A. 1, 2, and 5


649.Examine the CREATE DISKGROUP command used to create a disk group:
SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCY
DISK 'ORCL: FRA3' NAME misc1, 'ORCL: FRA4' NAME misc2;
In which situation would you use this method of disk group creation?


C. When using hardware mirroring or RAID
外部冗余， 使用硬件镜像或者RAID


650.Which three tasks can be performed using a duplicate database? (Choose three.)
使用数据库的副本完成的任务


A. Testing the backup and recovery procedures  测试恢复和恢复过程
B. Testing the upgrade of an Oracle database to a new release  测试升级到新版本
C. Testing the effect of an application changes on database performance  测试应用程序更改对数据库性能的影响


651.The user SYS creates a job by using the following command:




Which two statements are true about the job that was created by the preceding command? (Choose two.)


B. The job is automatically dropped after the end date
C. The job executes with the privileges of the user SYS




By default, jobs are created with auto_drop set to TRUE. f auto_drop is TRUE, the job is dropped.--B正确。
Jobs are created as disabled by default. --A错误
To create a job in your own schema, you need to have the CREATE JOB privilege. A user with the CREATE ANY JOB privilege can create a job in any schema. 


652.Tape streaming is not happening while performing RMAN tape backup. On investigation, you find that
it is not because of the incremental backup or the empty file backup and that RMAN is sending data
blocks to the tape drive fast enough.
What could be a solution to make tape streaming happen during the backup?
磁带性能不足，rman发送数据块太快。 磁带流无响应


C. Configure the channel to increase the capacity with the RATE parameter


Section: Backup, Recovery & Recovery Manager (RMAN)
In the ALLOCATE or CONFIGURE CHANNEL commands, the RATE parameter specifies the bytes/ second
that are read on a channel. You can use this parameter to set an upper limit for bytes read so that RMANdoes
not consume excessive disk bandwidth and degrade online performance. Essentially, RATE serves as a
backup throttle. For example, if you set RATE 1500K, and if each disk drive delivers 3 MB/ second, then the channel leaves some disk bandwidth available to theonline system.


限制磁盘读取速率
利用RATE参数限制RMAN备份的IO速度！


653.View the Exhibits: Exhibit 1 and Exhibit 2
Both processes use an existing job template PROG_1. The time taken by the jobs are recorded in the
TEST_LOG table. It was observed that the job creation process in exhibit 1 takes less time than in exhibit
2.
What is the reason for this?


A.It creates less metadata for jobs


654.You are using Recovery Manager (RMAN) with a recovery catalog to back up your production
database. The backups and the archived redo log files are copied to a tape drive on a daily basis.
Because of media failure, you lost your production database completely along with the recovery catalog
database. You want to recover the target database and make it functional. You consider performing the
following steps to accomplish the task:
1) Restore an autobackup of the server parameter file.
2) Restore the control file
3) Start the target database instance
4) Mount the database
5) Restore the data files
6) Open the database with RESETLOGS option
7) Recover the data files
8) Set DBID for the target database
Which option illustrates the correct sequence that you must use?


恢复目录备份产品数据库的步骤，备份和归档日志每天都备份到磁带上，


8目标库设置DBID----1还原服务器参数文件spfile----3启动目标库实例----2还原控制文件----4挂载数据库----5还原数据文件----7恢复数据文件---6resetlog打开数据库


A. 8, 1, 3, 2, 4, 5, 7, 6


655.Examine the following ALTER command:
SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;
What is the purpose of the command?


A. It cancels all pending disk drops within the disk group.
取消所有挂起来的盘


656.The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which
statement is true while performing a tape backup in an RMAN session?
不适用异步I/O


C. The tape buffer is allocated from the Program Global Area (PGA)


BACKUP_TAPE_IO_SLAVES参数（默认为False）是设置磁带I/O异步的。如果支持磁带备份设备的异步I/O，我们建议将这个参数设置为TRUE，以启动该设置。 建立BACKUP_TAPE_IO_SLAVES参数后，可以使用allocate channel命令或configure channel 命令的parm 参数来定义内存缓冲区的大小。
磁带缓冲区的大小是在配置通道时确定的，它的默认值是由操作系统决定的，不过通常为64kb。 使用allocate channel命令可以将磁带缓冲区的大小设置为不同的值。 为了达到最佳性能，我们建议将磁带缓冲区的大小设置为256KB 或更大。 如：
Allocate channel c1 device type sbt parms="blksize=262144, ENV=(NB_ORA_CLASS=RMAN_orcl)"
 
如果要在磁盘上备份数据，我们必须判断操作系统是否支持异步I/O。 如果支持，Oracle 会自动使用异步I/O的功能；如果不支持，此时将Oracle提供的DBWR_IO_SLAVES参数设置为非零值，通过启动多个DBWR进程，Oracle 会模拟到磁盘的异步I/O.
当配置DBWR_IO_SLAVES或者BACKUP_TAPE_IO_SLAVES时，可能也需要创建一个large池。 这将帮助消除共享池争用和内存分配的错误问题，这些是在启用BACKUP_TAPE_IO_SLAVES时伴随共享池使用一起发生的问题。如果使用Oracle 10g中的Automatic Shared Memory Management(ASMM),Oracle 将管理共享池的内存分配。 如果需要手工设置large 池，则磁盘缓冲区的总大小限制为每个通道16MB。 为备份设置LARGE_POOL_SIZE参数的公式如下：
LARGE_POOL_SIZE=(number of allocated channels)*(16MB+size of tape buffer)
如果没有配置DBWR_IO_SLAVES 和BACKUP_TAPE_IO_SLAVES。Rman就不会使用large池。一般来说，除非系统不支持异步I/O，这时才需要配置这些参数设置以从RMAN中获得良好的性能。


657.The database is currently open and the temp03.dbf tempfile belonging to the default temporary
tablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an
efficient manner?


D. Allow the database to continue running, add a new tempfile to TEMP tablespace with a new name, and
drop the tempfile that has been corrupted.
Answer: D
临时表空间损坏，直接删除重建。数据库能够继续运行


658.Indentify two advantages of using recovery catalog instead of the control file of the database in
Recovery Manager (RMAN). (Choose two.)


A. You can use RMAN stored scripts
C. You can store backup information of all registered databases in one place
Answer: AC


659.Which two commands never trigger an implicit rebalancing within the disk group?. (Choose two.)
不会触发执行再平衡
A. ALTER DISKGROUP misc MOUNT;  挂载
C. ALTER DISKGROUP misc CHECK ALL NOREPAIR 
只有改变磁盘组的大小才会促发重新平衡。故BDE会促发rebalance，AC不会


660.You want to configure the Flashback Database feature and retain flashback logs for three days.
Presently the database is open and configured in ARCHIVELOG mode.
配置闪回数据库 ，保留闪回日志3天  当前数据库打开  配置为归档模式
The following steps must be performed in the correct sequence to do this:
1. Set the retention target:
SQL> ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=4320;
2. Enable Flashback Database:
SQL> ALTER DATABASE FLASHBACK ON;
3. Mount the database:
SQL> STARTUP MOUNT EXCLUSIVE
4. Shutdown the instance:
SQL> SHUTDOWN IMMEDIATE
5. Open the database:
SQL> ALTER DATABASE OPEN;
Choose the correct sequence.


4关闭实例---3 挂载数据库---1设置保留策略---2 开启闪回数据库----5打开数据库


B. 4, 3, 1, 2, 5




661.View the Exhibit and examine the output. You execute the following RMAN command to perform the
backup operation:
RMAN> RUN { ALLOCATE CHANNEL c1 DEVICE TYPE disk MAXOPENFILES 8;
BACKUP DATABASE FILESPERSET 4; }
What is the multiplexing level in the preceding在。。之前 backup process?
多路技术 级别
A. 4


662.To enable faster incremental backups, you enabled block change tracking for the database. Which
two statements are true about the block change tracking file? (Choose two.)


C. RMAN does not support backup and recovery of the change tracking file.
D. The database clears the change tracking file and starts tracking changes again, after whole database
restore and recovery operations.
Answer: CD




Location of the Block Change Tracking File


One block change tracking file is created for the whole database. By default, the change tracking file is created as an Oracle managed file in the destination specified by the DB_CREATE_FILE_DEST initialization parameter. You can also place the change tracking file in any location that you choose, by specifying its name when enabling block change tracking. Oracle recommends against using a raw device (that is, a disk without a file system) as a change tracking file.
Note:
In an Oracle RAC environment, the change tracking file must be located on shared storage accessible from all nodes in the cluster.
RMAN does not support backup and recovery of the change tracking file. The database resets the change tracking file when it determines that the change tracking file is invalid. If you restore and recover the whole database or a subset, then the database resets the block change tracking file and starts tracking changes again. After you make a level 0 incremental backup, the next incremental backup can use change tracking data.


In an Oracle RAC environment, the change tracking file must be located on shared storage accessible from all nodes in the cluster.
RMAN does not support backup and recovery of the change tracking file. The database resets the change tracking file when it determines that the change tracking file is invalid. If you restore and recover the whole database or a subset, then the database resets the block change tracking file and starts tracking changes again. After you make a level 0 incremental backup, the next incremental backup can use change tracking data.


663.Which options would you consider while configuring a flash recovery area (fast recovery area in 11g
Release 2) for your production database that is running in ARCHIVELOG mode? (Choose all that apply.)
配置闪回区
C. Using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area    目的
D. Using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the
recovery files created in the flash recovery area   大小
Answer: CD


664.You want to take a complete database backup using RMAN. The backup should consist only the used
blocks from your database.
Which two statements are true about this backup operation? (Choose two.)
C. All the files must be backed up as backup sets  
D. The backup may be stored either on disk or on media with media manager
Answer: CD


Answer: CD
答案解析：
排除法，AB选项，备份使用过的块，在备份时可以不用压缩，也可以不用设置为两个并行通道。


665.Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)


E. The ADR can be used for problem diagnosis even when the database instance is down
F. The ADR base is shared across multiple instances
Answer: EF






666.You are working in an online transaction processing (OLTP) environment. You use the
FLASHBACKTABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK
TABLE command, the system change number (SCN) was 663571. After flashing back the CUSTOMERS
table, you realize that the table is not in the correct state. Now, you need to reverse the effects of the
FLASHBACK TABLE command. Which is the fastest and the most efficient option to reverse the effects of
the FLASHBACK TABLE command?




D. Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN
663571
Answer: D
可以再次使用闪回表返回之前的状态。
FLASHBACKTABLECUSTOMERS TOSCN 663571;




667.What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?


C. The amount of time for which the flashback data is to be kept in the flash recovery area, provided that
there is enough space  保留时间  提供足够的空间


668.Examine the following RMAN script:
RMAN> run {
debug on;
allocate channel c1 type disk;
backup datafile 5;
}
Which statement describes the purpose of the script?




D. The backup of data file 5 is performed and all SQL statements that are executed during RMAN
compilation and their results are displayed
Answer: D




669.User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA,
which commands must you execute to enable SCOTT to flash back the transactions? (Choose four.)
用户scott 闪回表 需要dba 做什么


A. ALTER DATABASE FLASHBACK ON;
B. GRANT SELECT any transaction TO scott;  查询所有事务
C. GRANT EXECUTE ON dbms_flashback TO scott;   执行dbms_flashback 权限
D. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;    增加补充日志
E. ALTER TABLESPACE undots1 RETENTION GUARANTEE;
F. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;   增加补充日志数据主键
Answer: BCDF


四个先决条件，通过em可以清楚看到


670.After you have restored and recovered a database to a new host by using a previously performed
Recovery Manager (RMAN) backup, which is the best option you would consider for the new database?


B. Opening the database with the RESETLOGS option




671.Examine the following RMAN command:
RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which prerequisite must be met before accomplishing the backup?
B. Set up an Oracle wallet for the encryption
设置oracle 钱包


672.You are in the process of creating a Virtual Private Catalog (VPC) in your Oracle Database 11g
database. The Prod1, Prod2 and Prod3 Oracle Database 10g databases are registered in the recovery
catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executes
the following command to grant privileges to a new user VPC1 using Oracle Database 11g RMAN
executables:
RMAN> GRANT CATALOG FOR DATABASE prod 1 prod 2 TO vpc1;
Then you issue the following commands;
RMAN > CONNECT CATALOG vpc1/oracle@catdb;
RMAN> SQL XEC catowner.dbms_rcvcat.create virtual_catalog;?
What is the outcome of the above commands?




A. They execute and a create a virtual private catalog for pre-Oracle 11g clients
以下是使用rman虚拟专用目录步骤：
1. 创建RMAN 基本目录：
RMAN> CONNECT CATALOG catowner/oracle@catdb
RMAN> CREATE CATALOG;
2. 将RECOVERY_CATALOG_OWNER授予给VPC 所有者：
SQL> CONNECT SYS/oracle@catdb AS SYSDBA
SQL> GRANT RECOVERY_CATALOG_OWNER to vpcowner;
3a.将REGISTER授予给VPC 所有者：
RMAN> CONNECT CATALOG catowner/oracle@catdb
RMAN> GRANT REGISTER DATABASE TO vpcowner;
3b.或将CATALOG FOR DATABASE授予给VPC 所有者：
RMAN>GRANT CATALOG FOR DATABASE db10g TO vpcowner;


4a.为11g客户机创建虚拟目录：
RMAN> CONNECT CATALOGvpcowner/oracle@catdb
RMAN> CREATE VIRTUAL CATALOG;
4b.或者为11g之前的客户机创建虚拟目录：
SQL> CONNECT vpcowner/oracle@catdb
SQL> exec catowner.dbms_rcvcat.create_virtual_catalog;
5. 在目录中注册新数据库：
RMAN> CONNECT TARGET / CATALOG vpcowner/oracle@catdb
RMAN> REGISTER DATABASE;
6. 使用虚拟目录：
RMAN> CONNECT TARGET / CATALOG vpcowner/oracle@catdb;
RMAN> BACKUP DATABASE;




以下是使用rman虚拟专用目录步骤：
1. 创建RMAN 基本目录：
RMAN> CONNECT CATALOG catowner/oracle@catdb
RMAN> CREATE CATALOG;
2. 将RECOVERY_CATALOG_OWNER授予给VPC 所有者：
SQL> CONNECT SYS/oracle@catdb AS SYSDBA
SQL> GRANT RECOVERY_CATALOG_OWNER to vpcowner;
3a.将REGISTER授予给VPC 所有者：
RMAN> CONNECT CATALOG catowner/oracle@catdb
RMAN> GRANT REGISTER DATABASE TO vpcowner;
3b.或将CATALOG FOR DATABASE授予给VPC 所有者：
RMAN>GRANT CATALOG FOR DATABASE db10g TO vpcowner;


4a.为11g客户机创建虚拟目录：
RMAN> CONNECT CATALOGvpcowner/oracle@catdb
RMAN> CREATE VIRTUAL CATALOG;
4b.或者为11g之前的客户机创建虚拟目录：
SQL> CONNECT vpcowner/oracle@catdb
SQL> exec catowner.dbms_rcvcat.create_virtual_catalog;
5. 在目录中注册新数据库：
RMAN> CONNECT TARGET / CATALOG vpcowner/oracle@catdb
RMAN> REGISTER DATABASE;
6. 使用虚拟目录：
RMAN> CONNECT TARGET / CATALOG vpcowner/oracle@catdb;
RMAN> BACKUP DATABASE;




673.In Recovery Manager (RMAN), you are taking image copies of the datafiles of your production
database and rolling them forward as regular intervals. You attempt to restart your database instance after
a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is
damaged and you need to recover the datafile by using the image copy. You could perform the following
steps to accomplish this:
  镜像备份数据库  恢复单个文件 
1) Mount the database  
2) Take the data file offline
3) Bring the data file online
4) Use the RMAN SWITCH TO command to switch the image copy  切换到复制镜像
5) Apply the archived redo logs
6) Open the database
7) Use the RMAN RESTORE TO command to switch to the image copy
Which two options illustrate the correct sequence of steps that you could follow? (Choose two.)
 
B. 1, 2, 4, 5, 3, 6
C. 1, 2, 4, 6, 3
D. 1, 2, 7, 5, 3, 6
Answer: BD




674.View the Exhibit to observe the error.
You receive this error regularly and have to shutdown the database instance to overcome the error.
Automatic Shared Memory Management is configured for the instance. What can you do to reduce the
chance of this error in the future?


ORA-04331   


B. Enable automatic memory management
使用自动内存管理


675.Which two client requests are captured during database replay Capture? (Choose two)


C. Login and logoff activities of sessions  登录和退出活动的会话
E. Data definition language (DDL) and data manipulation language (DML) operations  ddl和dml 操作
Answer: CE




676.Which command creates an image copy?
A. backup as copy




677.What are the prerequisites for performing flashback transactions? (Choose all that apply)


A.Supplemental log must be enabled
B.Supplemental log must be enabled for the primary key


D.”EXECUTE “ permission on the DBMS_FLASHBACK package must be granted to the user
Answer: ABD


678.Which are the two prerequisites before setting up Flashback Data Archive? (Choose two.)


D.Automatic undo management must be enabled.
E.The tablespace in which the Flashback Data Archive is created must have automatic segment space
Management (ASSM).
Answer: DE




680.Which two operations are NOT performed by the DUPLICATE command in Recovery Manager
(RMAN) while duplicating a running database? (Choose Two)
不执行的步骤
C.Performing complete recovery using all available backups
E.Copying the online redo log files from the target database to the duplicate database
Answer: CE




681. The environmental variable ORACLE-BASE is set. You want to check the diagnostic files created as
part of the Automatic Diagnostic Repository (ADR). View the Exhibit and note the various parameters set
in your database.


What will be the location of the ADR base?
A.It is set to ORACLE-BASE.




682. Identify the scenarios in which the RMAN CROSSCHECR command is useful. (Choose all that
apply.)


B.To update the RMAN repository if you delete archived redo logs with operating system commands.
更新仓库
C.To update outdated information about backups that disappeared from disk or tape or became corrupted
and inaccessible.
更新过期信息
CROSSCHECK命令用户核对备份文件，以确保RMAN资料库与备份文件保持同步。当执行该命令时，如果RMAN资料库记录的状态与实际备份文件不匹配，则会更新资料库里的状态使其与实际备份文件状态一致；若备份文件处于expired状态，那么说明该备份已失效，可以删除之；
683. Your production database it functional on the SHOST1 host. You are backing up the production
database by using Recovery Manager (RMAN) with the recovery catalog. You want to replicate the
production database to anther host , SHOST2, for testing new applications.
After you ensured that the backups of the target database are accessible on the new host, what must you
do to restore and recover the backup for the test environment?


通过rman 虚拟目录  将一台主机上的数据库复制到另外一台主机上


A.Restoring the control file from the backup by using the NOCATALOG option to restore, and recovering
the data files
还原控制文件 通过nocatalog   恢复数据文件






684. Your database is running in ARCHIVELOG mode. You have been taking backups of all the data files
and control files regularly.
数据库归档模式， 定期备份所有的数据文件 
You are informed that some important tables in the BILLING tablespace have been dropped on February
28, 2007 at 10.30 AM and must be recovered.
You decide to perform an incomplete recovery using the following command:
SQL> RECOVER DATABASE UNTIL TIME ‘2007-02-28:10:15:00’;
Identify the files that must be restored to recover the missing tables successfully.


A.Restore the backup of all the data files.


你的数据库运行在归档模式，并且定期备份了所有的数据文件和控制文件。
你被通知一些在BILLING表空间的重要的表在ebruary 28, 2007 at 10.30 AM丢失，并且要求恢复。
你决定使用以下命令执行不完全恢复SQL> RECOVER DATABASE UNTIL TIME ‘2007-02-28:10:15:00’;


从以下实验中看出，如果是recover database，则必须先restore databse  ，则是restore所有备份的数据文件。




685. In your test database:
-You are using Recovery Manager (RMAN) to perform incremental backups of your test database
-The test database is running in NOARCHIVELOG mode
-One of the data files is corrupted
-All online redo log files are lost because of a media failure
Which option must you consider in this scenario?


C.Creating a new test database because the database is not recoverable due to the fact that the database
is configured in NOARCHIVELOG mode




686. You execute the following FLASHBACK TABLE command:
Which two statements are correct?(Choose two.)


 B.The FLASHBACK TABLE statement is executed as a single transaction.
 D.The changes made to the EMP table since the specified time are undone if no constraint is violated
during flashback.


687. Users are connected to a database instance that is using Automatic Storage Management (ASM).
The DBA executes the command as follows to shut down the ASM instance:
SQL> SHUTDOWN IMMEDIATE;
 
 A.It shuts down long with the ASM instance.
B.It is aborted and the ASM instance shuts down normally.
C.It stays open and SHUTDOWN command for the ASM instance fails.  
D.It shuts down only after all pending transactions are completed and the ASM instance waits for this
before shutting down.
Answer: D 
答案解析：
参考：http://docs.oracle.com/cd/E11882_01/server.112/e18951/asminst.htm#OSTMG13640


IMMEDIATE or TRANSACTIONAL Clause
Oracle ASM waits for any in-progress SQL to complete before performing an orderly dismount of all of the disk groups and shutting down the Oracle ASM instance. Oracle ASM does not wait for users currently connected to the instance to disconnect. If any database instances are connected to the Oracle ASM instance, then the SHUTDOWN command returns an error and leaves the Oracle ASM instance running. Because the Oracle ASM instance does not contain any transactions, the TRANSACTIONAL mode behaves the same as IMMEDIATE mode.
个人觉得这道应该选C?


688. Which two statements are true about the compressed backups in RMAN? (Choose two.)
B.The binary compression creates some performance overhead during backup operation
D.The media manager compression for the tape drive should be enabled for taking compressed backups
on the tape.
Answer:BD


689. View the Exhibit and examine the RMAN commands.
Which statement describes the effect of a backup retention policy on the backup of a backup set?
A.Either all the copies of a backup set are obsolete or none of them are as per the retention policy.


690. The database users regularly complain about the difficulty in performing transactions. On
investigation, you find that some users perform long-running transactions that consume huge amounts of
space in the undo tablespace, which caused the problem. You want to control the usage of the undo
tablespace only for these user sessions and you do not want these sessions to perform long-running
operations.
How would you achieve this?
D.Implement a Database Resource Manager plan.




691. You work in a data warehouse environment that involves the execution of complex queries. The
current content of the SQL cache contains the ideal workload for analysis. You want to analyze only a few
most resource-intensive statements.
What must you do to receive recommendations on efficient use of indexes and materialized views to
improve query performance?
索引和物理视图 提高查询性能
A.Run the SQL Access Advisor.
SQL访问指导


692. Your company wants to upgrade the production database to a Real Application Clusters (RAC)
environment. You set up the best RAC database and want to replay a recorded workload captured from
the production database on the test machine.
The following steps may be used to replay the database workload:
1) Preprocess the captured workload  预处理捕获工作量
2) Restart the database in RESTRICTED mode.
3) Set up Replay Clients.  设置重放客户端
4) Restore the test database to the point when the capture started.  恢复测试库到捕获时间点
5) Remap connections. 重新映射连接
Which is the correct sequence of the required steps?


我们公司希望提高生产数据库到一个真正应用集群（RAC） 
环境。你建立最好的RAC数据库和想在生产数据库重放试验机上记录的工作量


升级产品数据库到RAC环境下 数据库负载回放 ，在测试机器上
遵循 以下步骤
捕获工作量--预处理工作量--重放工作量--还原数据库----
连接映射--
设置客户机--
分析
692选择B 1, 4, 5, 3




693. Which two statements are true about an image copy backup? (Choose two.)
A. It may only be taken to disk
C. It will contain all used and unused blocks.




694. As part of archiving the historical data, you want to transfer data from one database to another
database, which is on another server. All tablespaces in the source database are read/write and online.


The source and target databases use the same compatibility level and character sets.
View the Exhibit and examine the features in the source and target database.
Which of the following steps are required to transport a tablespace from the database to the target
database:
1.Make the tablespace read-only at the source database.
2.Export metadata from the source database.
3.Convert data filed by using Recovery Manager (RMAN).
4.Transfer the dump file and data filed to the target machine.
5.Import metadata at the target database.
6.Make the tablespace read/write at the target database.


跨平台迁移数据库   表空间迁移




D.1, 2, 4, 5 and 6


695. Identify two options that Oracle recommends while configuring the backup and recovery environment
for your recovery catalog. (Choose two.)


A. configuring control file autobackup to be ON   配置自动备份
D. setting the retention policy to a REDUNDANCY value greater than   设置冗余策略大于1




696. Examine the following command for RMAN backup:


Which statement Is true regarding the approach in the command?


C.It is a case of parallelization of the backup set. 并行备份集合




697. Which statement is true about a Scheduler-generated event?




D. it requires jobs to be defined with an event condition and a queue specification. 
在Oracle计划任务中，programe是定义具体的做事内容，需要写执行代码；
而schedule是定义了什么时候开始做，下一次间隔多长时间，什么时候结束；
而job就是做，job中把programe和schedule联系起来开始干活，所以触发计划任何产生的事件就是job中的定义
调度程序生成的事件：调度程序可以提高一个事件来表示发生的状态变化 
在调度程序本身。


例如，当一个作业开始时，调度程序可以提供一个事件 
当工作超过其分配的运行时间时，就完成。




698. In your production database, you:
-Are using Recovery Manager (RMAN) with a recovery catalog to perform the backup operation at regular
intervals
-Set the control file autobackup to “on”
-Are maintaining image copies of the database files
You have lost the server parameter file (SPFILE) and the control file. Which option must you consider
before restoring the SPFILE and the control file by using the control file autobackup?


698选D
当catalog中存在多个数据库时恢复顺序: 
1.nomont
2.set DBID
3.restore spfile
但只有一个DB时步骤2可以省略




699. Your database is using a default temporary tablespace that contains the temp01.tmp temporary file.
All the users on the database use the default temporary tablspace. A user issues a query on the ORDERS
table and receives the following error:
ORA-01565  临时文件出错
What would be the most efficient way to rectify this error?
A.Add a new tempfile to the user’s temporary tablespace and drop the tempfile that produced the error.
创建一个新的临时文件 删除产生错误的临时表文件


700. Which two statements are true about a duplicate database that is created by using the DUPLICATE
command in RMAN? (Choose two.)
A.It is a copy or a subset of the target database.
 
C.It is created by using backups and archived redo log files from the target database.
 
Answer:AC




701. A user receives the following error while performing a large volume of inserts into a table:


ORA-01536  空间超出配额
The issue is resolved by increasing the space quota on the USERS tablespace for the user. But the user
may perform such transaction in the future. You want to ensure that the command waits rather than
produce an error when such an event occurs the next time.
What can you do to achieve this before running the command in the future?
A.Set RESUMABLE_TIMEOUT for the instance.
701 选择A
alter system set resumable_timeout=10;
10秒后超时报错.
也可以session级别设置
参考Database Administrator's Guide中 •Managing Resumable Space Allocation


702. View the Exhibit and examine the parameter settings in your server-side parameter file (SPFILE).
When you tried to start the database instance, you received the following error:
 ORA-00824
 Why did the instance fail to start?
 
 D.Because both the SGA_TARGET and MEMORY_TARGET parameters are set.
Answer:D


703. Given below are RMAN commands to enable backup optimization and set the retention policy:


The USERS tablespace has never been backed up. You take the USERS tablespace offline on Monday.
View the Exhibit to examine the operations performed by using RMAN. Which two statements are true
about the backup of the USERS tablespace? (Choose two.)




选项BD


优化设置后,
RMAN会保留离线文件的备份数量=冗余数+1 后不再备份,直到过期被删除后的再次备份.
也就是星期2,3,4,下一个星期1都会备份.
B.It will be backed up as a part of database backup on Tuesday.
D.The command on Sunday deletes the backup of the USERS tablespace taken on Tuesday.
 
 
 704. View the Exhibit and examine the data manipulation language (DML) operations that you performed
on the NEWEMP table. Note that the first two updated are not listed by the Flashback Versions Query.


D.Flashback Versions Query stops producing versions of rows that existed before a change in the table
structure.


闪回查询停止产生版本， 先前改变了表的结构




705. View Exhibit1 to examine the DATA disk group when all the disks are online.




D.Because the other three disks have 60% free space, the disk rebalancing is delayed
途中对比，发现第二文件的path没有了，题中问为什么没有重新平衡。
因为设置了DISK_REPAIR_TIME 参数，to repair the disk and bring it back online，推迟了重新平衡。
故选B。B.Because the disk repair time attribute is set to a nonzero value
Configuring Disk Repair Time
Specify a time period that is long enough for you to repair a disk in the disk group.
For information about disk group repair time, see "Oracle ASM Fast Mirror Resync".




706. You execute the following command to set the redundancy retention policy in Recovery Manager
(RMAN):
RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 3;
Identify the statement that correctly describes the implications of this command.


B. When there are already three backups, for the fourth backup RMAN marks the oldest backup as
obsolete.
标记为过期




707. Because of a logical corruption in the EMPLOYES tables, you want to perform Tablespace
Point-in-Time Recovery (TSPITR) to recover the table. Before you started the TSPITR process, you
queried the TS_PITR_CHECK view and you realized that the table has a referential constraint with
DEPARTMENTS that exists in another tablespace, MASTERTBS.
Which two actions will permit the TSPITR to work? (Choose two.)


B.Dropping the relationship between the tables
C.Adding the MASTERTBS tablespace to the recovery set
707选B,C.
实际只有recover set能让TSPITR正确执行.
但要求两个答案,只能附加B选项.实测B选项在此种情况下不行.
 
 
 708. You executed the following query:
 SELECT OLDEST_FILASHBACK_SCN,OLDEST_FLASHBACK_TIME FROM V$FLASHBACK_DATABASE_LOG;
 Considering that all the redo logs are available, what information can you derive from the output of the
preceding query?
考虑到所有的在线日志都可用，从之前的查询可以得到什么结论
C.The approximate近似的 time and the lowest system change number (SCN) to which you can flash back your
database
近似的时间和最小scn可以闪回数据库


709. A database has three online redo log groups with one member each. A redo log member with the
status ACTICE is damages while the database is running.
What is the first step you should take to solve this problem?
组中的一个active日志文件损坏   
C.Drop the redo log number and create it in a different location.
删除重建


710. You executed the following commands in a database session:


Which statement is true about the contents of the recycle bin in this situation?


E.The objects in the recycle bin that are in the default tablespace for the session user are cleaned up.
回收站清空了


Answer:E


711. The following command is executed to shut down an Automatic Storage Management (ASM)
instance:
SQL>SHUTDOWN ABORT;
Which two statements describe the consequences of the above command? (Choose two.)


B.The ASM instance requires recovery when it is started.
C.The database instance that are currently clients of the ASM instance are aborted