053新题目解析
最新题库 & 考试交流 & 培训班视频
+微信 cycleyu
1.
You want to convert an existing database backup into an archival backup that will always be exempt from the RMAN
retention policy.
Which two conditions should be met for the backup to be converted successfully?
□ A) The RESTORE POINT clause should be used.
□ B) It should be registered in a recovery catalog.
□ C) It should reside in the fast recovery area.
□ D) It should not reside in the fast recovery area.
□ E) The RESTORE POINT clause should not be used
□ F) It should not be registered in a recovery catalog
如果你想让一个已经存在的备份文件不受retention policy影响，该怎么办
答案BD
B:这个文件需要被注册在恢复目录
D:这个文件不应该属于快速恢复区
快速恢复区有两个参数，包括位置和大小
2.
Which two are true about components of Oracle Resource Manager?
A) A resource manager plan directive can restrict sessions in the same consumer
B) A resource manager plan directive specifies how resources should be allocated amoungst session in the same
consumer group.
C) A resouce manager plan directive can specify resource allocation rules for multiple consumer groups.
D) A resource plan contains directives that specify how resource should be allocated amongst resource consumer
groups.
E) A resource consumer group can be managed differently in different resource manager plans.
CE
oracle资源管理是对资源通过rule和plan进行宏观上的管理 记住两个关键字 rule 和plan
3.
One of your databases has resumable space allocation enabled.
Which two conditions will suspend a session performing DML in that database instance?
□ A) A deadlock is detected.
□ B) A transaction reaches a tablespace space quota.
□ C) The DML affects objects in a tablespace that is going offline.
□ D) A transaction cannot allocate extents in a temporary segment.
□ E) Total undo space for a session exceeds the amount available.
AE
这个答案应该很明显吧，dml就是所谓的增删查改合的操作，有deadlock了或者undo空间不足了肯定没办法进行dml操作的。
4.
Which two are true about a fast incremental backup?
□ A) It can be performed for both cumulative and differential incremental backups.
□ B) It can be enabled only for the whole database,
□ C) It can be performed for both level 0 and level 1 incremental backups.
□ D) It uses a block change tracking file when the incremental level is greater than 0
□ E) It requires the fast recovery area to be configured.
AD
这题考察快速增量备份
b肯定错，
c 增量备份包含0和1级，0其实就是全局备份，只是0可以作为1 的起点。
d:系统怎么知道哪些是增量呢？ 根据block change
e：和快速恢复区不冲突
5.
Which two are true about automatic PGA memory management?
□ A) PGA_AGGREGATE_TARGET cannot be configured if SGA_TARGET is configured.
□ B) The PGA is auto-tuned whether or not PGA_AGGREGATE^TAKGET is explicitly set.
□ C) PGA_AGGREGATE_TARGET cannot be configured if MEMORY_TARGET is configured.
□ D) Memory is allocated separately for FGA_AGGREGATE_TARGET and SGA_TARGET.
□ E) PGA_AGGREGATE_TARGET always defaults to zero.
BD
这题记忆一下吧
下面是关于target的ixie参数
6 .
Examine these RMAN commands:
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;
RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY;
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
Your database uses an SPFILE.
You issued this command:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which three actions will occur?
□ A) backup of the entire SPFILE
□ B) backup only of SPFILE content that has changed since the last backup
□ C) backup of online logs
□ D) backup of all used and unused blocks in all data files
□ E) backup of archived logs
□ H backup of all used blocks only, in all data files
ADE
这题考察rman的知识
下面的rman的所有参数
可以明显的看到因为没有启用catelog，所以这些参数都是放在控制文件里面的
7 .
In which two situations must you open a database with RESETLOGS
□ A) after bringing a recovered user tablespace online
□ B) afterperforming a database point-in-time recovery
□ C) afterrecovering from the loss of a server parameter file
□ D) afterrecovering from the loss of a CURRENT redo loggroup
□ E) afterrecovering from the loss of an ACTIVE redo log group
BD
这题因该很好理解，当两个点不一致的时候就需要resetlogs了
8 .
Which three are true about the recycle bin in Oracle 1 lg?
□ A) A dropped table may always be flashed back from the recycle bin.
□ B) Objects in the recycle bin ate stored In the TEMP tablespace of the schema owner.
□ C) If HR.EMPLOYEES is dropped and moved to the recycle bin, then another table railed HR.EMPLOYEES may
also be dropped and moved to the recycle bin.
□ D) A dropped index may be flashed bark from the recycle bin.
□ E) Objects in the recycle bin are stored In the same tablespace as they wore before they were dropped.
□ F) Spare occupied by objects in the recycle bin count against the quota of the schema owner
A:always，paichu
b:其实并没有删除，还在原tablespace
c：
d:对
e:对
f：对
这题题库答案选择cde但是我觉得应该选择def
9.
One of your database's is In ARCHIVE LOG mode.
You execute these commands:
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE BACKUP OPTIMIZATION ON;
BACKUP DATABASE;
What will the backup contain?
O A) used blocks only from data files and the control file C B) used and compressed blocks only from data files 错
O C) all blocks from data files, the control file, the server parameter file (SPFILE), and archived redo log files 错误
D) all
blocks only from data files, the control file, and the server parameter file (SPFILE)
O E) all blocks only from data files and the control
答案选A
RMAN中的备份优化(Backup Optimization)是指在备份过程中，如果满足特定条件，RMAN将自动跳过某些文件而不将它们包含在备份集中以节省时间和空间。说的直白些就是能不备的它就不备了，不像原来甭管文件有没有备份过统统再备一遍。通常必须满足如下几个条件的情况下，才能够启用备份优化的功能：
(1).CONFIGURE BACKUP OPTIMIZATION参数置为on；
(2).执行的BACKUP DATABASE或BACKUP ARCHIVELOG命令中带有ALL或LIKE参数。
(3).分配的通道仅使用了一种设备类型，也就是没有同时分配使用sbt与disk的多个通道。
打开备份优化设置通过如下命令：
RMAN> CONFIGURE BACKUP OPTIMIZATION ON;
那么在进行备份优化时，RMAN是如何判断要备份的文件是否需要被优化呢，这个算法就相当复杂了，而且可能影响优化算法的因素也非常多，假如某库在上午9点被执行过一次全库备份，等下午3点再次执行全库备份时，备份的文件没有变动而且也已经被备份过时，才会跳过这部分文件。所以理论上备份优化仅对于只读表空间或offline表空间起作用。当然对于已经备份过的archivelog文件，它也会跳过。
10.
You have configured archive log destinations lot one of your databases.
Which two ensure log switching will only occui if arc-hiving Is successful to at least two destinations?
□ A) Set the OPTIONAL attribute for LOG ARCHIVE DFST_n for the four destinations and set
LOG_ARCHIVE_MIN_SUCCEED_DEST to 4
□ B) Set the MANDATORY attribute for LOG ARCHIVE DEST_n for any two destinations and set
LOG_ARCHIVE_MIN_SUCCEED_DEST to 1.
□ C) Configure the flash recovery area and set the LOG_ARCHIVE_MIN_SUCCEED_DEST parameter to 2.
□ D) Set LOG_ARCHIVE_DEST and LOG_AKCHIVE_DUELEX_DEST to two chosen destinations and set LOGAKCHIVE
MIN SUCCEED PEST to IXJ
□ E) Set the OPTIONAL attribute for LOG ARCHIVE DEST n for the four destinations and set LOG ARCHIVE MIN
SUCCEED_DEST to 2.
BE
答案BE
这题排除法吧，不太会做。
11.
The BOOKINGS table contains oline booking information. When a booking is confirmed,the details are transferred
to an archival table BOOKINGS_HIST and deleted from the BOOKINGS table. Is no fixed time interval between each
online booking and its confirmation. Because sufficient space is not always available from the delete operations, the
high-water mark(HWM) is moved up and many rows are insterted below the HWM of the table.
The BOOKINGS table has Automatic segments space management(ASSM) and row movement enabled. The table is
accessible in 24x7 mode.
What is the most efficient method to reclaim the space released by the delete operations in the BOOKINGS table?
A) Move the BOOKINGS table to a different location by using the ALTER table … move command.
B) Shrink the bookings table by using the alter table … shrink space command.
C) Perform export,drop,and import operations on the bookings table sequentially.
D) Deallocate the space in the booking table by using the alter table... deallocate unused command.
B
这题很明显选择b
记住这个命令 alter table shrink space，调整高位水位线
12 .
3QL> SHOW PARAMETER TARGET
NAME TYPE VALUE
------- ------------- --------------------
archive lag target integer o 1
db flashback retention target integer 1440
fast start io_target integer 0
fast start mttr target integer 0
memory_max_target big integer 0
memory_te rget big integer 0
pga aggregate target big integer 90M
sga target big integer 272M
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 recommend?
O A) 362 MB
O B) 1,440 MB
O C) 272 MB
O D) 90 MB
A
这题也很明显
memory_target=pga + sga
13 .
In a database instance, the NLS_DATE_LANGUAGE parameter is set to AMERICAN.
On a client, the NLSLANG environmental variable is set to FRENCH_CANADA.WE8ISO8859P1.
A user starts a session on the client and issues these commands:
SQL> ALTER SESSION SET NLS LANGUAGE = GERMAN;
SQL> SELECT TO_CHAR(hire_date,’DD/MON/YYYY ' ,' nls_date_lanquage = ITALIAN’)
FROM employees;
What is the result?
A) The query displays abbreviated month names in Canadian English.
B) The query displays abbreviated month names in Canadian French.
C) The query displays abbreviated month names in German.
D) The query displays abbreviated month names in Italian.
E) The query displays abbreviated month names in US English,
D
这题没有什么悬念吧。
本地的languages是德语，但是他特别指定了zhetiaosql用意大利语，所以选d
14 .
One of your databases is in ARCHIVELOG mode.
You execute these commands:
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE BACKUP OPTIMISATION ON;
BACKUP DATABASE;
What will the backup contain?
A) all blocks only from data files,the control file, and the server parameter file (SPFILE)
B) used blocks only fiom data files and the control file
C) used and compressed blocks only from data files
D) all blocks from data files, the control file, the server parameter file (SPFILE),and archived redo log files
E) all blocks only from data files and the control file
这题貌似A也不太对，但是用排除法只能选择a，因为控制文件和spfile都会被备份，根据这一点派出其他选项。
15 .
You plan to use the Flashback Drop feature to recover a dropped table SALES_EMP.
NO other table with the same name exists in the schema.
You query RECYCLEBIN and find multiple entries for the SALFS EMP table as follows:
SQL> SELECT object_name, original name, droptime FROM recyclebin;
QBJECTNAME ORIGINAL_NAME DROPTIME
------------ ---------- --------------- -----------
BINS/m0DrBV9RFGOAA53dC+FPw=$0 SALES EMP 2007-12-07:11:08:55
BINS2DeIssLeQTqgH/nSQRm2JO=50 SALES_EMP 2007-12-07:11:11:38
BIN$OuqroHodQy6ouDtaAr-XOVw=$0 SALES EMP 2007-12-07:11: 08 :18
You then issue this statement to recover the table:
SQL> FLASHBACK TABLE sales_emp TO BEFORE DROP;
What would be the outcome of the preceding statement?
O A) It retrieves the latest version of the table from the recycle bin.
O B) It returns an error because the table name is not specified as per the names in the OBJECT_NAME column
O C) It retrieves the version of the table for which undo information is available. 错
O D) It retrieves the oldest version of the table from the recycle bin. 错
A 这题没问题，选择A
16.
You are managing a 24X7 database. The backup strategy for the database is to perform user-managed backups
Identify two prerequisites to perform the backups.
□ A) The database must be opened in restricted mode.
□ B) The tablespaces are reguired to be in read only mode before taking the backup.
□ C) The database must be configured to run In ARCHIVE LOG. mode.
□ D) The tablespaces are required to be In backup mode before taking the backup.
CD
排除法吧，AB明显不对。
17.
A database is running In ARCHIVELOG mode.
You took a binary backup of the control file.
Which two statements are true about recovery using the backup control file?
A) You must always RECOVER the database after restoring a backup control file, even if no data files have been
restored
B) You can only restore the control file to its original location.
C) You can perform only an incomplete recovery with a backup control file even If all the online redo logs and
archived logs are available.
D) You must open the database RESETLOGS after recovery using a backup control file.
E) You can only restore the control file to the default location.
AD
这题应该没什么问题吧，排除法，明显其他选项是错误的。
18 .
How can an Oracle stored procedure be executed automatically every Monday next month using Oracle Scheduler?
A) Configure the stored procedure to be tun in a scheduler schedule with the correct schedule parameters and then
call the schedule In a scheduler program.
B) Configure the stored procedure to be run In a scheduler program and specify the program in a scheduler job
with the correct schedule
parameters.
C) Configure the stored procedure to be run in a scheduler schedule with the correct schedule parameters and
specify the schedule In a scheduler Job.
D) Configure the stated procedure to be run In a scheduler job and configure a scheduler program and job In a
scheduler schedule with the coned scheduler parameters
E) Configure the stared procedure to be run In a scheduler program arrd specify the schedule, program In a
schedule, schedule with the correct schedule parameters.
B
这题没啥好讲的 背一下吧
19 .
Which two are true about configuring the fast recovery area?
A) DB_FLASHBACK_RETENTION_TARGET must be set if defining a retention policy.
B) DB_RECOVERY_FILE_DEST_SIZE must be Set if DB_RECOVERY_FILE_DEST IS set.
C) DB_RECOVERY_FILE_DEST must be set when configuring flashback for the database
D) Archive log destinations must be specified using LOG_ARCHIVE_DEST_n parameters.
E) USE_DB_RECOVERY_FILE_DEST must be explicitly set to LOG_ARCHIVE_DEST_10.
BC
这题主要需要掌握快速恢复区的主要两个参数 ，路径和大小。
DB_FLASHBACK_RETENTION_TARGET 这个参数我搜了一下确实也存在，但是和这题无关。
20.
Examine this recovery manager(RMAN) command:
RUN{
SET UNTIL TIME '2008-01-14:21:59:0’;
RESTORE DATABASE;
RECOVER DATABASE;
}
The time pecified Is earlier than the most recent harkup taken before the recovery, but older backups also exist.
Which two actions will occur?
A) All data files and the control file from the most recent backup prior to the recovery will be restored.
B) All data files from the most recent backup prior to SET TIME will be restored.
C) All data files from the most recent backup will be restored.
D) Only the SYSTEM data file from the most lecent backup will be restored.
E) All redo log data up to the set time will be applied.
F) All (lata flies, redo logs, and control files from the most recent backup prior to the recovery will be restored.
BE
这题BC 两个比较肯定选择b，更准确
d肯定错误
a和f都是认为控制文件也会被恢复，这里错误。
21.
View the Exhibit and examine the results of two queries executed In two user sessions from the same client. What
accounts for the formatting differences?
A) The NLS LANG environment variable was changed on the database host before starting the second session.
B) The second session connected via the listener but the first session used a local connection.
C) The database character set was changed before executing the second query.
D) The NLS_LANG environment variable was changed on the client before starting the second session.
E) The database national character set was changed before executing the second query.
D
这题很明显，很好理解。
格式排版只会和本地的参数设置有关，和服务器没关系
更listener更没关系啦。
23.
This command is excuted to shut down an automatic storage management (ASM) instance:
SQL>SHUTDOWN ABORT;
Which two statements describe the consequences of the above command?
A) the ASM instance requires recovery when it is started.
B) The CSS daemon stops and has to be restarted before the ASM instance is restarted.
C) The database instances that are currently clients of the ASM instance are aborted.
D) The disk groups are orderly dismounted.
AC
如果启用了asm的话，要记住asm实例是依附于数据库实例的，它在数据库实例下面run
所以这里asm实例奔溃了，那数据库实例自然也会奔溃了，因为数据库实例需要asm帮他管理storage
这里软件层面的奔溃不会影响硬件，所以d排除
24.
In which two situations must you open a database with RESETLOGS?
A) after recovering from the loss of an ACTIVE redo log group
B) after recovering from the loss of a CURRENT redo log group
C) after bringing a recovered user tablespace online
D) after performing a database point-in-time recovery
E) after recovering from the loss of a server parameter file
BD
这题我会的。等于是原题目了。
25.
Examine this commands:
SQL> CREATE INDEX french_index ON product_descriptions_sort (NLSSORT(translated_name, ‘NLS_SORT=FRENCH’));
Which two determine if the index might be used for a query sorting on the TRANSLATED_NAME column?
A) the NLS_TERRITORY environment variable on the database host
B) the NLS_TERRITORY environment variable on the client
C) the NLS_COMP session parameter
D) the NLS_SORT function arguments in the ORDER BY clause
E) the NLS_TERRITORY database parameter
F) the NLS_SORT session parameter
CF
这一题还是考格式
终端格式怎么显示，默认是终端的那个参数对不对，但是如果你在你自己的那个session上设置了一次性的参数，那么就由那个一次性的参数决定了
所以这一题选择cf
26 .
What is the effect of increasing the value of the ASM_POWER_LIMIT parameter?
A) the rebalancing operation in an ASM instance completes more quickly but can result in higher I/O overhead.
B) The number of ASMB processes increases.
C) The number of DBWR_IO_SLAVES increases.
D) The number of DBWR processes increases.
A
考察asm_power_limit 这个参数
27.
Which two are true about a fast incremental backup?
A) It requires the fast recovery area to be configured.
B) It uses a block change tracking file when the incremental level is greater than 0.
C) It can be enabled only for the whole database.
D) It can be performed for both cumulative and differential incremental backups.
E) It can be performed for both level 0 and level 1 incremental backups.
BD
第二次看到这道题目了。
28 .
One of your databases has resumable space allocation enabled.
Which two conditions will suspend a session performing DML in that database instance?
A) Total undo space for a session exceeds the amout available.
B) A transaction cannot allocate extents in a temporary segment.
C) A deadlock is detected.
D) A transaction reaches a tablespace space quota.
E) The DML affects objects objects in a tablespace that is going offline.
AD
这题到底是选择ad还是cd呢
优先cd吧。a不确定，难道tablespace还会针对session吗？
29 .
Which two are true about the creation, configuration, and use of an RMAN recovery catalog?
□ A) It cannot be created in any of the target databases.
□ B) RESYNC CATALOG must be executed after registering each target database.
□ C) The recovery catalog owner must have the CREATE SESSION privilege and the RECOVERY CATALOG OWNER
role.
□ D) REGISTER DATABASE must be executed separately for each target database.这个是正确的，一次只可以注册一个database。
□ E) The recovery catalog database must be in ARCHIVELOG mode.
□ F) The recovery catalog schema must be stored in a tablespace containing no other schemas.
CD
这题EF肯定错误的。
30 .
Note these parameter settings in your database:
SGA_MAX_SIZE=1024M
SGA_TARGET=700M
DB_8K_CACHE_SIZE=12M
LOG_BUFFER=200M
You issued this command to increase the value of DB_8K_CACHE_SIZE:
SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;
What will happen?
A) It will be successful only if the memory is available from the autotuned components of the SGA.
B) It will fail because an increase in DB_8K_cache_size cannot be accommodated within SGA_TARGET.
C) It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE.
D) It will fail because the DB_8K_CACHE_SIZE parameter cannot be changed dynamically.
A
这一题背诵一下吧，不太会。
31 .
Which three statements are true about Automatic Storage Management (ASM) in Grid Infrastructure 11g R2?
A) ASM mirrors at the allocation unit (AU) level for Disk Groups with High Redundancy.
B) ASM load balancing is optional when External Redundancy is set for a Disk Group.
C) ASM mirrors at the allocation unit (AU) level for Disk Groups with Normal Redundancy.
D) ASM load balances Disk Group content across all ASM disks In that Disk Group.
E) ASM load balances Disk Group content across a maximum of eight ASM disks in that Disk Group.
F) An ASM file is always mirrored based on the redundancy attribute of the Disk Group containing that file.
BDF
这题真心不会。背答案吧，两个balance，一个mirror always。
32 .
You executed this query:
SELECT oldest_Flashback_scn, oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG;
Consideiing that all the redo logs are available, what information can you derive from the output of the preceding
query?
A) the system change number (SCN) and the time when the Flashback Database was enabled in the database
Instance
B) the time when the last flashback operation In your database was performed
C) the approximate time and the lowest system change number (SCN) to which you can flash back your database
D) the time when the first flashback operation in your database was performed
这题认真理解一下应该就会做了。答案选择C。
33.Which would require the use of NCHAR, NVARCHAR2, and NCLOB data types to display characproperly?A) when the client applications use different character sets than the database character set
B) The database does not have to support multilingual data.C) when the database uses a national character set and a database character set
D) when the database does not use Unicode for the database character setE) The database uses a fixed-width, multi byte character set for the database character set
答案B
这题背诵一下吧
34.
Which two are true about database point-in-time recovery for a database in ARCHIVELOG mode?
A) It can use incremental backups, redo logs, and archived logs.
B) It can only be performed if the database uses an incremental backup strategy.
C) It can be used to recover from a failed database upgrade.
D) It can be performed while the database is in open or mount state.
open状态下肯定是不可以的。
E) It can be used to restore data in a subset of database tables.
只恢复某个table的子集？ 不可以
AC
34.
Which two are true about database point-in-time recovery for a database in ARCHIVELOG mode?
A) It can use incremental backups, redo logs, and archived logs.
B) It can only be performed if the database uses an incremental backup strategy.
C) It can be used to recover from a failed database upgrade.
D) It can be performed while the database is in open or mount state.
E) It can be used to restore data in a subset of database tables.
AC
34.
Which two are true about database point-in-time recovery for a database in ARCHIVELOG mode?
A) It can use incremental backups, redo logs, and archived logs.
B) It can only be performed if the database uses an incremental backup strategy.
C) It can be used to recover from a failed database upgrade.
D) It can be performed while the database is in open or mount state.
E) It can be used to restore data in a subset of database tables.
AC
这题背诵一下吧，by using a window to
--------------
36.
A database is configured in ARCHIVELOG mode.
You issued this RMAN command to take backup to media:
BACKUP DATABASE
PLUS ARCHIVELOG
TAG TESTDB
KEEP UNTIL ’SYSDATE+1'
RESTORE POINT TESTDB06;
Which two statements are true?
□ A) Online logs are backed up.
□ B) Archived logs are backed up if they have not yet been backed up.
□ C) The backup is always automatically deleted after one day.
□ D) The backup is categorized as OBSOLETE after one day.
□ E) The backup is categorized as EXPIRED after one day
答案BD
online logs 不会被backup，archive logs可以被backup
