![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
OCP 053
文章平均质量分 55
EVISWANG
这个作者很懒,什么都没留下…
展开
-
104 User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, whic
104User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, whichcommands must you execute to enable SCOTT to flash back the transactions? (Choose four.)A. ALT原创 2015-11-26 21:47:14 · 702 阅读 · 0 评论 -
55 Which statement about recovering from the loss of a redo log group is true? A. If the lost redo l
55Which statement about recovering from the loss of a redo log group is true?A. If the lost redo log group is ACTIVE, you should first attempt to clear the log file.B. If the lost redo log group原创 2015-11-26 10:53:27 · 1101 阅读 · 0 评论 -
73 Which two are the prerequisites to enable Flashback Data Archive? (Choose two.) A. Database must
73Which two are the prerequisites to enable Flashback Data Archive? (Choose two.)A. Database must be running in archivelog mode.B. Automatic undo management must be enabled.C. Undo retention g原创 2015-11-26 11:52:08 · 1024 阅读 · 0 评论 -
76 What is the effect of increasing the value of the ASM_POWER_LIMIT parameter? A. The number of DBW
76What is the effect of increasing the value of the ASM_POWER_LIMIT parameter?A. The number of DBWR processes increasesB. The number of ASMB processes increasesC. The number of DBWR_TO_SLAVES原创 2015-11-26 12:43:45 · 609 阅读 · 0 评论 -
111 To enable faster incremental backups, you enabled block change tracking for the database. Which
111To 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.)A. Multiple change tr原创 2015-11-26 22:55:57 · 1035 阅读 · 0 评论 -
121 Tape streaming is not happening while performing RMAN tape backup. On investigation, you find th
121Tape streaming is not happening while performing RMAN tape backup. On investigation, you find that it isnot because of the incremental backup or the empty file backup and that RMAN is sending d原创 2015-11-26 23:54:43 · 1482 阅读 · 0 评论 -
133 You want to enable automatic PGA memory management in your database. Which setting is required t
133You want to enable automatic PGA memory management in your database. Which setting is required toachieve this?A. Set MEMORY_TARGET to zeroB. Set the STATISTICS_LEVEL parameter to BASICC.原创 2015-11-28 10:28:55 · 1044 阅读 · 0 评论 -
134 Which three statements are true about persistent configuration? (Choose three.) A. A user cannot
134Which three statements are true about persistent configuration? (Choose three.)A. A user cannot set privileges on the persistent lightweight jobsB. Persistent lightweight jobs generate a larg原创 2015-11-28 10:36:52 · 848 阅读 · 0 评论 -
23 In Recovery Manager (RMAN), you are taking image copies of the data files of your production data
23In Recovery Manager (RMAN), you are taking image copies of the data files of your production databaseand rolling them forward at regular intervals. You attempt to restart your database. After a原创 2015-11-28 16:09:56 · 1433 阅读 · 0 评论 -
54 You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUT par
54You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUTparameter set to a nonzero value.Which three statements about resumable space allocation are true?原创 2015-11-26 10:49:46 · 1491 阅读 · 0 评论 -
51 You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the
QUESTION 51You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan theentiredatafile every time an incremental backup is performed. You decide to enable the原创 2015-11-26 10:43:22 · 481 阅读 · 0 评论 -
39 Which statement about Automatic Memory Management with Oracle 11g is true?
QUESTION 39Which statement about Automatic Memory Management with Oracle 11g is true?A. You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET orPGA_AGGREGATE_TARGET values that a原创 2015-11-25 22:24:40 · 621 阅读 · 0 评论 -
QUESTION 105 Examine the following RMAN script: RMAN> run { debug on; allocate channel c1 type disk;
QUESTION 105Examine the following RMAN script: RMAN>run {debug on;allocate channel c1 type disk;backup datafile 5;}Which statement describes the purpose of the script?A. The data file原创 2015-11-26 21:59:00 · 1369 阅读 · 0 评论 -
108 Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.) A.
108Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)A. The ADR base keeps all diagnostic information in binary formatB. SQL*Plus provides the ADRI scri原创 2015-11-26 22:12:26 · 1568 阅读 · 0 评论 -
109 You want to take a complete database backup using RMAN. The backup should consist only the used
109You want to take a complete database backup using RMAN. The backup should consist only the usedblocks from your database.Which two statements are true about this backup operation? (Choose two原创 2015-11-26 22:24:33 · 935 阅读 · 0 评论 -
110 Which options would you consider while configuring a flash recovery area (fast recovery area in
110Which options would you consider while configuring a flash recovery area (fast recovery area in 11gRelease 2) for your production database that is running in ARCHIVELOG mode? (Choose all that a原创 2015-11-26 22:27:48 · 586 阅读 · 0 评论 -
63 Which three components does the Scheduler use for managing tasks within the Oracle environment? (
63Which three components does the Scheduler use for managing tasks within the Oracle environment?(Choose three.)A. a jobB. a programC. a scheduleD. a PL/SQL procedureCorrect Answer: AB原创 2015-11-26 11:04:13 · 879 阅读 · 0 评论 -
67 You are maintaining the SALES database. You have added a new disk to a disk group. Automatic Stor
67You are maintaining the SALES database. You have added a new disk to a disk group. Automatic StorageManagement performs the rebalancing activity. You want to speed up the rebalancing activity.原创 2015-11-26 11:21:48 · 341 阅读 · 0 评论 -
95 The SQL Tuning Advisor configuration has default settings in your database instance. Which recomm
95The SQL Tuning Advisor configuration has default settings in your database instance. Whichrecommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic原创 2015-11-26 17:16:13 · 505 阅读 · 0 评论 -
40 For which two situations would you use functionality provided by the Resource Manager? (Choose tw
QUESTION 40For which two situations would you use functionality provided by the Resource Manager? (Choose two.)A. setting idle timeout limits on resource plansB. saving storage space by using co原创 2015-11-25 22:41:10 · 469 阅读 · 0 评论 -
24 You have enabled backup optimization for the RMAN environment. Identify two criteria on which RMA
24You have enabled backup optimization for the RMAN environment. Identify two criteria on which RMAN willskip the file, if it has already been backed up. (Choose two.)A. The data file backup is原创 2015-11-28 16:12:12 · 1103 阅读 · 0 评论 -
25 You are using the control file to maintain information about the database backups that are being
25You are using the control file to maintain information about the database backups that are being performedby Recovery Manager (RMAN).Identify two scenarios is which you must have a recovery ca原创 2015-11-28 16:14:04 · 677 阅读 · 0 评论 -
126 You executed the following commands in a database session: SQL> SELECT object_name, original_nam
126You executed the following commands in a database session:SQL> SELECT object_name, original_name FROM user_recyclebin;OBJECT_NAME ORIGINAL_NAME----------- -----BIN$QJwA1dMyB1LgQJYK+xUptw=原创 2015-11-28 10:09:24 · 1083 阅读 · 0 评论 -
128 Which two statements are true about a job chain? (Choose two.) A. A job chain can contain a nest
128Which two statements are true about a job chain? (Choose two.)A. A job chain can contain a nested chain of jobs.B. The jobs in a job chain cannot have more than one dependency.C. A job of t原创 2015-11-28 10:13:22 · 1174 阅读 · 0 评论 -
138 Your database instance is running. You are not able to access Oracle Enterprise Manager Database
138Your database instance is running. You are not able to access Oracle Enterprise Manager DatabaseControl because the listener is not started.Which tool or utility would you use to start the li原创 2015-11-28 10:55:27 · 1152 阅读 · 0 评论 -
139 Which three statements must be true before transporting a tablespace from a database on one plat
139Which three statements must be true before transporting a tablespace from a database on one platform toa database on another platform? (Choose three.)A. Both source and target database must b原创 2015-11-28 10:57:58 · 845 阅读 · 0 评论 -
142 Which two statements are true about encrypting RMAN backup? (Choose two.) A. The transparent enc
142Which two statements are true about encrypting RMAN backup? (Choose two.)A. The transparent encryption of backups uses the encryption walletB. The database uses the same encryption key for ev原创 2015-11-28 11:08:26 · 1289 阅读 · 0 评论 -
159 Which three types of files can be automatically placed in the flash recovery area (fast recovery
159Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11gRelease 2)? (Choose three.)A. Alert log fileB. Archived redo log filesC. Contro原创 2015-11-28 14:16:02 · 977 阅读 · 0 评论 -
74 For which two situations would you use functionality provided by the Resource Manager? (Choose tw
74For which two situations would you use functionality provided by the Resource Manager? (Choose two.)A. setting idle timeout limits on resource plansB. saving storage space by using compressed原创 2015-11-29 17:56:03 · 604 阅读 · 0 评论 -
QUESTION 47 How many copies of the alert log are stored in the directory specified by the initializa
QUESTION 47How many copies of the alert log are stored in the directory specified by the initialization parameterDIAGNOSTIC_DEST?A. One per databaseB. One per instanceC. Two per databaseD.原创 2016-01-03 17:16:24 · 719 阅读 · 0 评论 -
QUESTION 169 A database has three online redo log groups with one member each. A redo log member wit
QUESTION 169A database has three online redo log groups with one member each. A redo log member with the statusACTIVE is damaged while the database is running.What is the first step you should t原创 2016-01-05 15:43:02 · 875 阅读 · 0 评论 -
135 Which three statements are true about windows? (Choose three.) A. Only one window can be open at
135Which three statements are true about windows? (Choose three.)A. Only one window can be open at any given timeB. Consumer groups are associated with windowsC. Windows work with job classes原创 2015-11-28 10:39:09 · 1236 阅读 · 0 评论 -
130 In your production database, users report that they are unable to generate reports on an importa
130In your production database, users report that they are unable to generate reports on an important tablebecause it does not contain any data. While investigating the reason, you realize that an原创 2015-11-28 10:19:49 · 535 阅读 · 0 评论 -
122 The user SYS creates a job by using the following command: BEGIN DBMS_SCHEDULER.CREATE_JOB ( job
122The user SYS creates a job by using the following command:BEGINDBMS_SCHEDULER.CREATE_JOB ( job_name => 'update_sales',job_type => 'STORED-PROCEDURE',job_action => 'OPS.SALES_PKG.UPDATE_SA原创 2015-11-28 10:00:15 · 999 阅读 · 0 评论 -
166 You are managing a 24*7 database. The backup strategy for the database is to perform user-manage
166You are managing a 24*7 database. The backup strategy for the database is to perform user-managedbackups.Identify two prerequisites to perform the backups. (Choose two.)A. The database must原创 2015-11-28 14:32:04 · 668 阅读 · 0 评论 -
131 Which three functions are performed by the SQL Tuning Advisor? (Choose three.) A. Building the S
131Which three functions are performed by the SQL Tuning Advisor? (Choose three.)A. Building the SQL profileB. Recommending optimization of materialized viewsC. Checking query objects for miss原创 2015-11-28 10:21:35 · 1184 阅读 · 0 评论 -
137 While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that t
137While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that theflash recovery area does not have enough free space to accommodate any more files and you do no原创 2015-11-28 10:53:31 · 864 阅读 · 0 评论 -
152 You have enabled backup optimization for the RMAN environment. Identify two criteria on which RM
152You have enabled backup optimization for the RMAN environment. Identify two criteria on which RMAN willskip the file, if it has already been backed up. (Choose two.)A. The data file backup is原创 2015-11-28 12:00:32 · 816 阅读 · 0 评论 -
161 Examine the following command used to perform incremental level 0 backup: RMAN> BACKUP INCREMENT
161Examine the following command used to perform incremental level 0 backup: RMAN>BACKUPINCREMENTAL LEVEL 0 DATABASE;To enable the block change tracking, after the incremental level 0 backup y原创 2015-11-28 14:21:31 · 652 阅读 · 0 评论 -
164 Using the LIST command in Recovery Manager (RMAN), which two pieces of information from the RMAN
164Using the LIST command in Recovery Manager (RMAN), which two pieces of information from the RMANrepository can be listed?(Choose two.)A. Stored scripts in the recovery catalogB. Backups t原创 2015-11-28 14:26:57 · 1233 阅读 · 0 评论