ocp 认证 043

liukaida

分卷:A
1: 单选题
Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every
Sunday night. On Monday morning, while querying the user1.employees table, you receive the
following error message:
01578: ORACLE data block corrupted (file # 5, block # 51) ORA-01110: data file 5:
'/u01/app/oracle/oradata/orcl/example01.dbf'
You need to rectify the corruption while ensuring the following:
The data file should remain online.
The mean time to recover (MTTR) should be minimal.
You are not using a backup control file, and all the archived logs are accessible. Which option
would you choose?
选项
A.
flash back the corrupted blocks
B.
use the DBMS_REPAIR package
C.
use the RMAN TSPITR command
D.
use the RMAN BLOCKRECOVER command
E.
use the RESTORE DATABASE and RECOVER DATABASE commands
F.
investigate the time at which the corruption occurred and perform a point-in-time recovery
正确答案: D
2: 单选题
A database is running in ARCHIVELOG mode. It has two online redo log groups and each group
has one member. A LGWR I/O fails due to permanent media failure that has resulted in the loss of
a redo log file and the LGWR terminates causing the instance to crash.
Which method should be used to efficiently recover from this loss of the current group member?
选项
A.
Restart the database; it would automatically re-create the corrupted redo log member.
B.
Restore the corrupted redo log group, perform incomplete recovery, relocate by renaming the
member of the damaged online redo log group to a new location, and then open the database with
RESETLOGS.
C.
Restore the corrupted redo log member, perform incomplete recovery, relocate by renaming the
member of the damaged online redo log group to a new location, and then open the database with
RESETLOGS.
D.
Restore whole database backup, perform incomplete recovery, relocate by renaming the member
of the damaged online redo log group to a new location, and then open the database with the
RESETLOGS option.
正确答案: D
3: 单选题
There was media failure and you need to check the data files for any block corruption. Which
option would you use to create a report on any corruptions found within the database?
选项
A.
the DBNEWID utility
B.
the DBVERIFY utility
C.
the ANALYZE command
D.
the RMAN REPORT command
E.
the RMAN CROSSCHECK command
F.
the CHECK_OBJECT procedure of the DBMS_REPAIR package
正确答案:B
4: 单选题
You are using Oracle Database 10g.Which statement regarding an incomplete recovery is true?
选项
A.
You do not need to restore all the data files.
B.
You do not need to open the database with the RESETLOGS operation.
C.
You do not need to perform a full backup after the RESETLOGS operation.
D.
You do not need to recover all the data files to the same system change number (SCN).
正确答案: C
5: 多选题
You set the value for the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter to 7.
Which two records in the control file of the database are circularly reused for storage because of
using this parameter? (Choose two.)
选项
A.
backup records
B.
data file records
C.
archive log records
D.
tablespace records
E.
redo thread records
正确答案: C E
6: 多选题
You executed the following command at the command prompt:
$ rman TARGET sys/oracle@ad10g CATALOG rmanusr/rmanusr@as10g SCRIPT backup_whole
Which three statements are true regarding this command? (Choose three.)
选项
A.
The backup_whole script is stored in the target database.
B.
The backup_whole is a stored script in the recovery catalog.
C.
The RMAN session terminates automatically after the execution of the command.
D.
The backup_whole script is executed automatically after the successful connection to the recovery
catalog only.
E.
The command produces an error because the RMAN script cannot be executed from the command
line.
F.
The backup_whole script is executed automatically after the successful connection to target and
catalog database.
正确答案: B C F
7: 单选题
You have configured and registered your target database in a recovery catalog. Because the
application needs it, you created a new tablespace in the target database. Then you executed the
following command from an RMAN session after connecting to the target and catalog databases,
both:
RMAN> REPORT SCHEMA;
Which statement describes the operation performed?
选项
A.
The target database instance transfers the updated information to the recovery catalog.
B.
The command shows the information from the control file of the target database and recovery
catalog is synchronized with the target database after the command is executed.
C.
The media manager transfers the schema details from the control file of the target database to the
recovery catalog.
D.
The recovery catalog will be updated by RMAN with the updated information in the control file of
the target database and displays information about the database files.
正确答案: D
8: 多选题
Your database is functioning in ARCHIVELOG mode. In which two situations would you perform
a cancel-based recovery? (Choose two.)
选项
A.
You find that one of the redo log members in each redo log group is lost.
B.
You find that a data file that belongs to the USERS tablespace is damaged.
C.
You find that a data file that belongs to the SYSTEM tablespace is damaged.
D.
You find that the current redo log group is damaged and is not available for recovery.
E.
You realized while performing a recovery that an archived redo log file needed for recovery is
lost.
正确答案: D E
9: 多选题
Users in your production database complain that they are getting the following error message
while trying to insert rows into the ORDERS table:
ERROR at line 1:
ORA-01654: unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES
While investigating, you find that the INDEXES tablespace has run out of space and there is no
more free space on the disk where the data files are available.
Which two actions could you perform to overcome this error without affecting the queries that are
currently being executed? (Choose two.)
选项
A.
drop and re-create the index
B.
coalesce the ORDERS_IND index
C.
coalesce the INDEXES tablespace
D.
drop and re-create the ORDERS table
E.
rebuild the index online and move it to another tablespace
正确答案: B E
10: 单选题
You lost the index tablespace in your database. You are not able to use tablespace point-in-time
recovery on the index tablespace.What could be the reason for this?
选项
A.
The index tablespace contains bitmap indexes.
B.
The index tablespace contains more than one data file.
C.
The index tablespace supports only complete recovery.
D.
The index tablespace is not a dictionary-managed tablespace.
E.
There is a dependency relationship between a table and its indexes.
正确答案: E
11: 多选题
Last night, a media failure caused the loss of a temporary file that belongs to your database. Which
two things may happen this morning when you try to open your database? (Choose two.)
选项
A.
The database opens normally.
B.
The database prompts for a database recovery.
C.
The database writer writes to a trace file, indicating that the temporary file is not found.
D.
The database gets mounted and throws an error indicating that the temporary file requires
recovery.
正确答案: A C
12: 单选题
You executed the following query:
SELECT operation, undo_sql, table_name
FROM flashback_transaction_query;
Which statement is correct regarding the query output?
选项
A.
It would return information regarding only the last committed transaction.
B.
It would return only the active transactions in all the undo segments in the database.
C.
It would return only the committed transactions in all the undo segments in the database.
D.
It would return both active and committed transactions in all the undo segments in the database.
E.
It would return information regarding the transactions that began and were committed in the last
30 minutes.
正确答案: D
13: 单选题
You are working in an online transaction processing (OLTP) environment. You used the
FLASHBACK TABLE 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 and the resultant
changes are not what you had desired. So, you need to reverse the effects of the FLASHBACK
TABLE command while ensuring that:
a) No other user data in the database is affected.
b) The operation takes the minimum possible time.
Which option would you choose?
选项
A.
use the ROLLBACK command with SCN 663571
B.
perform Flashback Transaction Query with SCN 663571
C.
execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at
SCN 663571
D.
execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at
SCN 663571
正确答案: D
14: 单选题
You have created a resource plan, PROD_DB_PLAN, that uses the RATIO policy. The following
consumer groups and their respective plan directives have been assigned to this resource plan:
Consumer group HIGH_CG with CPU_P1 as 10.
Consumer group MEDIUM_CG with CPU_P1 as 5.
Consumer group LOW_CG with CPU_P1 as 2.
Consumer group OTHER_GROUPS with CPU_P1 as 1.
Which statement is correct in this scenario?
选项
A.
The plan PROD_DB_PLAN can have subplans.
B.
The members of the HIGH_CG consumer group would get 10% of the CPU.
C.
The CPU allocation for the consumer groups would be based on the ratio defined for the CPU_P1.
D.
The CPU allocation would be equal between the HIGH_CG and MEDIUM_CG consumer groups
if there are no sessions existing for the LOW_CG and OTHER_GROUPS consumer groups.
正确答案: C
15: 单选题
You want to create a consumer group, GROUP1, and you execute the following command in the
command-line interface:
SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP
(CONSUMER_GROUP =>'group1', COMMENT => 'New Group');
This command errors out displaying the following message:
ERROR at line 1:
ORA-29371: pending area is not active
ORA-06512: at "SYS.DBMS_RMIN", line 115
ORA-06512: at "SYS.DBMS_RESOURCE_MANAGER", line 108
ORA-06512: at line 1
What action would you take to overcome this error?
选项
A.
create the Pending Area before creating the consumer group
B.
activate the Pending Area before creating the consumer group
C.
increase the size of the large pool to accommodate the Pending Area
D.
increase the size of the shared pool to accommodate the Pending Area
E.
increase the size of the database buffer cache to accommodate the Pending Area
正确答案:A
16: 多选题
You are working on an Oracle Database 10g database. You enabled the Flashback Database
feature.Which two statements regarding flashback logs are true? (Choose two.)
选项
A.
Flashback logs are not archived.
B.
Flashback logs are maintained in redo log files.
C.
Flashback logs are maintained in the Flash Recovery Area.
D.
Flashback logs are used to maintain Flashback Databaserelated errors.
E.
Flashback logs need to be cleared manually after you disable Flashback Database.
正确答案: A C
17: 多选题
You are connected to Recovery Manager (RMAN) without a recovery catalog. There is no copy of
the control file available. You want to restore the control file from an autobackup. To retrieve the
autobackup, you need the database ID (DBID). In which two sources would you find the DBID?
(Choose two.)
选项
A.
the trace file
B.
the alert log file
C.
an RMAN session log file
D.
the server parameter file
E.
the formatted name of a control file autobackup
正确答案: C E
18: 单选题
You executed the following command in Recovery Manager (RMAN) against your Oracle 10g
database:
RMAN> REPORT NEED BACKUP days 3;
What would be the output of this command?
选项
A.
a list of files that require a backup within three days
B.
a list of files that have not been backed up for three days
C.
a list of files that RMAN recommends be backed up only once in every three days, based on low
volatility
D.
a list of files for which a backup has already been performed and may need a backup after three
days
正确答案:B
19: 多选题
You have created a job class, CUST_JOB_1, with two jobs, CUST_JOB_1_A and
CUST_JOB_1_B.Which two statements are true? (Choose two.)
选项
A.
Both the jobs would be executed concurrently.
B.
Jobs in the job class must have been assigned the same priority.
C.
The member jobs would get dropped when the job class is dropped.
D.
The member jobs would get disabled when the job class is dropped.
E.
The attributes defined at the class level would be applied to both the jobs.
正确答案: D E
20: 单选题
When you start the database instance, it does not open after reaching the mount state. The
initialization parameter DB_RECOVERY_FILE_DEST_SIZE is set to 2 GB. The archive
destination for the database is set to USE_DB_RECOVERY_FILE_DEST. While opening the
database by using the ALTER DATABASE command, you receive the following error:
ERROR at line 1:
ORA-16038: log 1 sequence# 1535 cannot be archived
ORA-19809: limit exceeded for recovery files
Which is the operation after which you can open the database successfully?
选项
A.
Delete the obsolete files in RMAN after running the CROSSCHECK command.
B.
Delete unnecessary files from the Flash Recovery Area by using an OS command.
C.
Delete unnecessary files from the Flash Recovery Area by using an OS command, and then use
RMAN to delete the expired files after running the CROSSCHECK command.
D.
Delete unnecessary files from the Flash Recovery Area by using an OS command, and then run
the RESYNC command in RMAN.
正确答案: D
21: 多选题
In which two situations would you prefer to use a hash cluster? (Choose two.)
选项
A.
Evenly distributed key values are present in the table.
B.
The applications occasionally use queries joining tables.
C.
The data retrieval has to be in the order in which it was inserted.
D.
The applications frequently modify a cluster key value in a constantly growing table.
E.
The application frequently uses queries with an equality predicate on the cluster key.
正确答案: A E
22: 单选题
The warning and critical threshold values have been set to 85% and 97%, respectively, for one of
the tablespaces. The current tablespace space usage is 54%. You modify the warning threshold to
be 50% and critical threshold to be 53% in Database Control.Which statement is true?
选项
A.
The new setting would be applied but no alerts would be raised immediately.
B.
The new setting would be applied and an alert would be raised immediately.
C.
The new setting would be ignored because the tablespace space usage is more than the specified
threshold value.
D.
The new setting would cause an error because the tablespace space usage is more than the
specified threshold value.
正确答案:A
23: 多选题
You have decided to perform a full database export to check the consistency of a database. Which
two statements are true regarding the limitations of this method in detecting database
corruption?(Choose two.)
选项
A.
It does not detect index block corruptions.
B.
It detects block corruptions in used as well as free extents.
C.
It does not detect all the block corruptions in the SYSTEM tablespace.
D.
It detects logical and physical block corruptions only when Direct path export is used.
正确答案: A C
24: 单选题
You decided to use the Flashback Drop feature to recover a dropped table called EMPLOYEES.
There is no other table with the same name existing in the schema. You query the RECYCLEBIN
and get the query output as displayed below:
SQL> SELECT OBJECT_NAME, ORIGINAL_NAME, DROPTIME FROM RECYCLEBIN;
OBJECT_NAME ORIGINAL_NAME
DROPTIME
--------------------------------------------------- ----------------------- ------------------------------
BIN$/m0DrBV9RFGOAA53dC+FPw==$0 EMPLOYEES
2007-04-09:11:08:55
BIN$2DeIssLeQTqgH/n80Rm2JQ==$0 EMPLOYEES
2007-04-09:11:11:38
BIN$UuqroNodQy6ouDtaA+XOVw==$0 EMPLOYEES
2007-04-09:11:08:18
You then issue the following statement to recover the table:
SQL> FLASHBACK TABLE EMPLOYEES TO BEFORE DROP;
What would be the outcome of the above statement?
选项
A.
It retrieves the latest version of the table from the RECYCLEBIN.
B.
It retrieves the oldest version of the table from the RECYCLEBIN.
C.
It returns an error because the system-generated table name in the OBJECT_NAME column
should have been specified as the table name.
D.
It returns an error because the RENAME option should have been specified to convert the
system-generated name of the retrieved table to the original name.
正确答案: D
25: 单选题
You executed the following command in Recovery Manager (RMAN):
RMAN> RESTORE CONTROLFILE;
Which operation must you perform before this command is executed?
选项
A.
back up the control file to trace
B.
bring database to the MOUNT state
C.
open a connection to the RMAN recovery catalog, which contains the RMAN metadata for the
target database
D.
set the database ID (DBID), but only if the DB_NAME parameter associated with the target
database is unique in the recovery catalog
正确答案: C
26: 单选题
You want an ASM instance to manage the files of your database. To achieve this objective, you
specify the following parameters in the parameter file of the database:
INSTANCE_TYPE = RDBMS
DB_NAME = PROD
LARGE_POOL_SIZE = 8MB
DB_BLOCK_SIZE = 4K
LOG_ARCHIVE_DEST = +dgroupA
LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t"
DB_CREATE_FILE_DEST = +dgroupA
COMPATIBLE = 10.1.0.2.0
CONTROL_FILES = +dgroupA
Which parameter would be ignored while starting up the instance for the database PROD?
选项
A.
DB_BLOCK_SIZE
B.
CONTROL_FILES
C.
LARGE_POOL_SIZE
D.
LOG_ARCHIVE_DEST
E.
LOG_ARCHIVE_FORMAT
F.
DB_CREATE_FILE_DEST
正确答案: E
27: 单选题
View the Exhibit.
You have more than one table in the recycle bin having the same original name, DEPT2. You do
not have any table with the name DEPT2 in your schema. You executed the following command:
PURGE TABLE dept2;
Which statement is correct in this scenario?
选项
A.
All the tables having the same original name as DEPT2 will be purged from the recycle bin.
B.
The table with dropscn = 1928151 (oldest dropscn) will be purged from the recycle bin.
C.
The table with dropscn = 1937123 (most recent dropscn) will be purged from the recycle bin.
D.
None of the tables will be purged because there are multiple entries with the same original name in
the recycle bin.
正确答案:B
28: 单选题
You are working on an Oracle Database 10g database that operates in the ARCHIVELOG mode.
At 06:00 p.m., you discovered that a table in the SYSTEM tablespace that does not belong to the
data dictionary was dropped at 03:00 p.m.What would you do to recover the table?
选项
A.
perform point-in-time recovery to recover the table
B.
recover the table by using the Flashback Table feature
C.
restore the entire database from the most recent backup and open it
D.
use the Flashback Transaction Query feature to identify the relevant SQL statement and use it to
undrop the table
正确答案:A
29: 单选题
A redo log file is corrupted while the database is open; as a consequence, database operations are
stopped because archiving cannot continue.What would you do to solve the problem?
选项
A.
clear the redo log group
B.
perform redo log file import
C.
perform an incomplete recovery
D.
perform a redo log recovery using Recovery Manager (RMAN)
E.
shut down the database and open the database in the NOARCHIVELOG mode
正确答案:A
30: 多选题
You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter in the parameter file
to YYYY-MM-DD. The default format of which two data types would be affected by this setting?
(Choose two.)
选项
A.
DATE
B.
TIMESTAMP
C.
INTERVALYEAR TO MONTH
D.
INTERVAL DAY TO SECOND
E.
TIMESTAMPWITH LOCAL TIME ZONE
正确答案: B E
31: 单选题
Examine the RMAN commands in a backup strategy implemented in your company:
Day 1 - Sunday
RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG
WEEKLY DATABASE;
RMAN> RECOVER COPY OF DATABASEWITH TAG WEEKLY;
Day 2 - Monday
RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG
WEEKLY DATABASE;
RMAN> RECOVER COPY OF DATABASEWITH TAG WEEKLY;
Day 3 - Tuesday
RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG
WEEKLY DATABASE;
RMAN> RECOVER COPY OF DATABASEWITH TAG WEEKLY;
On Tuesday, before the backup is performed, you added a new tablespace. Which statement is true
regarding Tuesday's backup?
选项
A.
It will show an error because there is no Level 0 backup available for new data files.
B.
It will be an image copy backup of new data files and Level 1 incremental backup of all other data
files.
C.
It will be a Level 1 incremental backup of all the data files including the data files that belong to
the new tablespace.
D.
It will be a Level 0 backup of all the data files including the data files that belong to the new
tablespace.
正确答案:B
32: 单选题
View the Exhibit.
A number of big tables were recently dropped from the SALES_DATA tablespace. Because you
are seeing alerts reported for other tablespaces and you have shortage of disk space, you decide to
reduce the size of the data file for the SALES_DATA tablespace so that the data file size for the
tablespace with space-related alerts can be increased. You tried to reduce the data file size by using
the following command:
SQL> ALTER DATABASE DATAFILE '+DF/orcl/datafile/sales_data.326.617879191' RESIZE
2M;
*
ERROR at line 1:
ORA-03297: file contains used data beyond requested RESIZE value
What could be the reason for this error?
选项
A.
The dropped tables appear in the Recycle Bin.
B.
The minimum size for locally managed tablespace is 5 MB.
C.
The size of the data file cannot be reduced for a permanent tablespace.
D.
The size of the data file cannot be reduced for a locally managed tablespace.
正确答案:A
33: 多选题
In the parameter file of your production database, the FAST_START_MTTR_TARGET
parameter is set to 300 to optimize instance recovery. While observing the performance of the
database during instance recovery, you find that the redo log files are not sized properly to support
this activity. Which two sources could you use to determine the optimal size of the redo log files?
(Choose two.)
选项
A.
the V$LOG view
B.
the V$DBFILE view
C.
the V$LOGFILE view
D.
the V$INSTANCE_RECOVERY view
E.
Oracle Enterprise Manager Database Control
正确答案: D E
34: 单选题
You are using an Automatic Storage Management (ASM) instance to manage the files of your
production database. You have two disk groups, DG1 and DG2, with one device each.
In the parameter file of the production database, the following parameters have been specified:
DB_CREATE_ONLINE_LOG_DEST_1 = '+dg1'
DB_CREATE_ONLINE_LOG_DEST_2 = '+dg2'
What would be the impact of this setting?
选项
A.
When a new log group is added, it would have one member in each disk group.
B.
When a new log group is added, it would have two members in each disk group.
C.
When a new tablespace is added, it would have one data file in each disk group.
D.
When a new log file is added, it would have one member spread across the disk groups.
正确答案:A
35: 单选题
View the Exhibit and examine the characteristics of the USERS tablespace.
You observe that a large volume of inserts and deletes are happening on the TRANS table in the
USERS tablespace and you suspect that the TRANS table is fragmented.
Which advisory component would you refer to, in order to find information about table
fragmentation?
选项
A.
MemoryAdvisor
B.
Segment Advisor
C.
SQL TuningAdvisor
D.
SQLAccess Advisor
E.
Automatic Database Diagnostic Monitor (ADDM)
正确答案:B
36: 多选题
View the Exhibit.
You executed the following command to perform a backup of the USERS tablespace:
RMAN> BACKUP TABLESPACE USERS;
Which three types of files are backed up? (Choose three.)
选项
A.
password file
B.
online redo log files
C.
the current control file
D.
archived redo log files
E.
the current server parameter file
F.
all the data files belonging to the USERS tablespace
G.
data files belonging to the USERS tablespace and all the default tablespaces
正确答案: C E F
37: 多选题
You issue the following command in your database:
CREATE RESTORE POINT rec_load
GUARANTEE FLASHBACK DATABASE;
Which two statements are true regarding the REC_LOAD guaranteed restore point? (Choose two.)
选项
A.
It cannot be used in RECOVER DATABASE operations.
B.
It can work only if logging for Flashback Database is enabled.
C.
It creates logs in the flash recovery area that would not be deleted even if there is space pressure.
D.
It can be used to reverse the effects of NOLOGGING operations like in the case of direct load
inserts.
正确答案: C D
38: 多选题
For which two SQL statements can you use the Flashback Table feature to revert a table to its
previous state? (Choose two.)
选项
A.
UPDATE TABLE
B.
CREATE CLUSTER
C.
TRUNCATE TABLE
D.
ALTER TABLE MOVE
E.
INSERT INTO...VALUES
F.
ALTER TABLE...DROP COLUMN
G.
ALTER TABLE...DROP PARTITION
正确答案: A E
39: 单选题
Your database operates in ARCHIVELOG mode and user-managed consistent backups are
performed every Sunday night. On Tuesday, at 9:00 a.m. the current log sequence number was
369. Also, on Tuesday you lost the data file belonging to the SYSTEM tablespace and an
archivelog file (sequence number 356) that contained redo entries between 8:00 a.m. and 8:30 a.m.
With reference to this scenario, what would you do to recover the database?
选项
A.
restore all the data files from last Sunday's backup, and then perform a time-based recovery
B.
restore all the data files from last Sunday's backup, and then perform a cancel-based recovery
C.
restore all the data files from last Sunday's backup, and then perform a change-based recovery
D.
restore only data files that belong to the SYSTEM tablespace from last Sunday's backup, and then
perform a complete recovery
正确答案:B
40: 单选题
The DB_BLOCK_CHECKING initialization parameter is set to FALSE. What level of block
checking would be performed?
选项
A.
The Oracle database will not perform block checking for any of the data blocks.
B.
The Oracle database will perform block checking for the default permanent tablespace only.
C.
The Oracle database will perform block checking for the data blocks in all user tablespaces.
D.
The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace
only.
E.
The Oracle database will perform block checking for the data blocks in the SYSTEM and
SYSAUX tablespaces.
正确答案: D
41: 多选题
Following are the parameters and their values set in your database instance:
SGA_TARGET=8GB
SGA_MAX_SIZE=10GB
DB_KEEP_CACHE_SIZE=1GB
You executed the following command to increase SGA_TARGET:
SQL> ALTER SYSTEM SET SGA_TARGET=9GB;
Which three memory components would grow by the command above? (Choose three.)
选项
A.
large pool
B.
shared pool
C.
multiple block size caches
D.
keep pool of database buffer cache
E.
default pool of database buffer cache
正确答案: A B E
42: 单选题
You have an RMAN backup of the database on a tape device that was performed through the
Media Management Library (MML) software. As part of the media recovery, you want to restore
the data files from the backup set.
Which two steps from the list below does the media manager perform?
1)rquests for the restoration of a particular file
2)identifies the tape containing the file and reads the tape
3)passes the media information back to the Oracle database session
4)writes the file to disk
选项
A.
2, 3
B.
1, 4
C.
2, 4
D.
3, 4
正确答案:A
43: 多选题
These are the details about V$FLASHBACK_DATABASE_STAT:
SQL> DESC V$FLASHBACK_DATABASE_STAT
Name Null? Type
--------------------------------- -------- --------------
BEGIN_TIME DATE
END_TIME DATE
FLASHBACK_DATA NUMBER
DB_DATA NUMBER
REDO_DATA NUMBER
ESTIMATED_FLASHBACK_SIZE NUMBER
Which two statements regarding the V$FLASHBACK_DATABASE_STAT view are true?
(Choose two.)
选项
A.
BEGIN_TIME is the time at which Flashback logging is enabled.
B.
END_TIME is the time at which the query is executed on the view.
C.
REDO_DATA is the number of bytes of redo data written during the interval.
D.
This view contains information about flashback data pertaining to the last 24 hours.
E.
FLASHBACK_DATA is the amount of flashback data generated since the database was opened.
正确答案: C D
44: 单选题
In your production database you want to use an Automatic Storage Management (ASM) instance
to manage the database files. Which option would you use to migrate the database files from a
non-ASM instance to an ASM instance?
选项
A.
Oracle Migration Assistant
B.
Recovery Manager (RMAN)
C.
Oracle Data Pump Export and Import
D.
conventional Oracle Export and Import
E.
operating system utilities to copy the files to the ASM instance
正确答案:B
45: 单选题
In your Automatic Storage Management (ASM) instance, one of the nonempty disk groups,
DGROUP1, is no longer required and you want this disk group to be removed. You execute the
following command to achieve this objective:
DROP DISKGROUP dgroup1 EXCLUDING CONTENTS;
What would be the result of this command?
选项
A.
This command would result in an error because the disk group is not empty.
B.
The command would drop the disk group, ignoring the EXCLUDING CONTENTS option.
C.
The command would result in the disk group being marked as INVALID because it cannot be
dropped.
D.
The command would result in the contents being moved to the parent disk group and dropping of
the disk group.
E.
The command would distribute the contents of the specified disk group among all other disk
groups and then drop the specified disk group.
正确答案:A
46: 单选题
You have specified the warning and critical threshold values of an application tablespace to be
60% and 70%, respectively. From the tablespace space usage metrics, you find that the actual
space usage has reached the specified warning threshold value, but no alerts have been generated.
What could be the reason for this?
选项
A.
The EVENT parameter was not set.
B.
The SQL_TRACE parameter is set to FALSE.
C.
The Enterprise Manager Grid Control is not used.
D.
The STATISTICS_LEVEL parameter is set to BASIC.
E.
The TIMED_STATISTICS parameter is set to FALSE.
正确答案: D
47: 单选题
Consider the following configuration:
/devices/D1 is a member of disk group dgroupA.
/devices/D2 is a member of disk group dgroupA.
/devices/D3 is a member of disk group dgroupA.
You plan to add a new disk, /devices/D4, to the disk group dgroupA.
You execute the following command:
SQL> ALTER DISKGROUP dgroupAADD DISK '/devices/D*';
Which task would be accomplished by the command?
选项
A.
The command adds the new disk, D4, to the disk group.
B.
The command would result in an error because there is no disk by the name "/devices/D*".
C.
The command will be ignored because disks starting with "D" are already members of the disk
group.
D.
The command would result in an error because no wildcard characters can be used in the disk
name.
E.
The command first detaches all the member disks starting with "D," and then reattaches them
including the new disk.
正确答案:A
48: 多选题
In your production database, you observe that users' transactions are consuming a lot of resources
and you plan to impose resource restrictions by using Resource Manager. For which three
resources can you enable usage restrictions by using Resource Manager? (Choose three.)
选项
A.
CPU usage
B.
degree of parallelism
C.
number of open cursors
D.
number of sorts performed
E.
idle time for blocking sessions
F.
number of disk I/O operations performed
G.
number of memory I/O operations performed
正确答案: A B E
49: 单选题
A media failure has occurred. This has resulted in all the members of the next log group being
rendered inaccessible to the log writer process (LGWR) at a log switch. How does this failure
affect the operational database?
选项
A.
The database re-creates the missing redo log files automatically.
B.
The database continues to function normally with the existing files.
C.
The database allows only queries; no other statements are allowed.
D.
The database returns an error and the database instance shuts down.
E.
The user sessions that generate redo logs are terminated automatically.
正确答案: D
50: 单选题
View the Exhibit and examine the Flashback Database architecture.
Identify the missing component (shown with a "?") in the Flashback Database architecture.
选项
A.
DBWn
B.
RVWR
C.
ARCH
D.
RECO
E.
TRWR
正确答案:B
51: 单选题
While designing the database for one of your online transaction processing (OLTP) applications,
you want to achieve the following:
a) high availability of data
b) faster primary key access to the table data
c) compact storage for the table
Which type of tables would you use to achieve these objectives?
选项
A.
heap tables
B.
object tables
C.
partitioned tables
D.
index-organized tables (IOTs)
正确答案: D
52: 单选题
The database has the data block size set to 8 KB. You need to import a tablespace with a 4 KB
block size into the database. Which additional memory parameter(s) should be configured to
perform a transportable tablespace import?
选项
A.
DB_CACHE_SIZE only
B.
DB_8K_CACHE_SIZE only
C.
DB_4K_CACHE_SIZE only
D.
SGA_TARGET and DB_4K_CACHE_SIZE
E.
DB_BLOCK_SIZE and DB_8K_CACHE_SIZE
F.
DB_BLOCK_SIZE and DB_4K_CACHE_SIZE
正确答案: C
53: 多选题
You created a partition table using the following command:
CREATE TABLE professional_history (
prof_history_id NUMBER(10),
person_id NUMBER(10) NOT NULL,
organization_id NUMBER(10) NOT NULL,
record_date DATE NOT NULL,
prof_hist_comments VARCHAR2(2000))
PARTITION BY HASH (prof_history_id)
PARTITIONS 3
STORE IN (part1, part2, part3);
Which statements are true about the partitions created by this command? (Choose all that apply.)
选项
A.
All partitions share the same segment for physical storage.
B.
All partitions share the same column and constraint definition.
C.
Each partition can be backed up and recovered independently.
D.
The distribution of data among the partitions is controlled by the DBA.
E.
Operations can be performed in parallel by different parallel execution servers for different
partitions of the table.
F.
The storage characteristics for the partitions can be changed after the partitions are created.
正确答案: B C E F
54: 单选题
You lost the PRODSTD tablespace, which was read-only. The tablespace was read-only when the
last backup was taken. How would you recover the tablespace?
选项
A.
restore the tablespace from the backup
B.
restore the tablespace from the backup, and then perform an incomplete recovery
C.
restore the tablespace from the backup, and then apply all the redo information
D.
restore all the data files in the database, and then perform an incomplete recovery
正确答案:A
55: 单选题
You are designing an application for a telecom company and you have been asked to design a
database table to facilitate monthly bill generation. The bill would include details of customer
calls, listed in chronological order. Which method would you follow to achieve this objective
without increasing the overhead of sorting the rows?
选项
A.
create a hash cluster to store the data
B.
create an index cluster to store the data
C.
create a partitioned table to store the data
D.
create a sorted hash cluster to store the data
E.
create a heap table with rowid to store the data
正确答案: D
56: 单选题
In your database there exists a set of read-only tablespaces that have not been made read/write at
any time since the last backup. Before performing an incomplete recovery on a database using a
backup control file, what precautions should be taken regarding read-only tablespaces?
选项
A.
All read-only tablespaces should be taken offline.
B.
All read-only tablespaces should be made read/write.
C.
All read-only tablespaces should be dropped and restored separately.
D.
All read-only tablespaces should be renamed to names having the MISSINGnnnn format.
正确答案: C
57: 单选题
You decided to change the location of the flash recovery area. You executed the following
command:
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST='+disk1' SCOPE=BOTH SID='*';
Which statement is true?
选项
A.
The location can be changed only if the flash recovery area is empty.
B.
After executing the command, all new flash recovery area files will be created in the new location.
C.
The command will generate an error because you cannot change the flash recovery area while the
database is open.
D.
All the existing files in the flash recovery area will be moved to the new location, and all new
Flash Recovery Area files will be created in the new location.
正确答案:B
58: 多选题
Which two metadata values are used to perform a consistency check in a block whenever a block
is read or written to in a database? (Choose two.)
选项
A.
SCN
B.
block version
C.
high water mark
D.
data block address
E.
checkpoint position
正确答案: B D
59: 多选题
In which two conditions are resumable statements suspended? (Choose two.)
选项
A.
when a user session is terminated
B.
when a user exceeds the space quota
C.
when a user manually suspends the statement
D.
when the maximum extents of a segment is reached
E.
when a table that is being accessed by the current transaction is not found
正确答案: B D
60: 单选题
Consider the recovery steps in each of the cases given below:
Case 1:
1Shut down the database and perform a backup.
2Restore all the data files.
3Mount the database.
4Recover the database.
5Without applying all the redo log files, open the database using the RESETLOGS option.
6Back up the database.
Case 2:
1Shut down the database and perform a backup.
2Restore only the data files of the tablespace where user error damaged the data.
3Mount the database.
4Recover the database.
5Open the database with the RESETLOGS option.
6Back up the database.
Case 3:
1Shut down the database
2Restore the data files
3Open the database
4Perform recovery to the current point in time.
Which case has the correct steps for an incomplete recovery?
选项
A.
only case 1
B.
only case 2
C.
only case 3
D.
case 1 and 2
E.
case 2 and 3
F.
case 1 and 3
G.
all cases: case 1, case 2 and case 3
正确答案:A
61: 多选题
The ORACLE_SID environment variable is set to +ASM. You executed the following command
to start up the ASM instance:
SQL> STARTUP;
Which two statements describe the activities performed during a successful start up operation?
(Choose two.)
选项
A.
ASM starts the CSS daemon if it is not started.
B.
The databases configured to use the ASM instance are mounted.
C.
The disk groups are mounted as per the ASM_DISKGROUPS initialization parameter.
D.
ASM discovers and examines the contents of all of the files that are in the paths specified in the
ASM_DISKSTRING initialization parameter.
正确答案: C D
62: 单选题
Which statement is true regarding the creation of nested plans using Resource Manager?
选项
A.
Only one nested subplan is allowed.
B.
The plans can be nested up to four levels.
C.
Resource Manager does not support nested plans.
D.
Nested plans control only the degree of parallelism but not the CPU.
E.
Each nested plan gets a proportion of the CPU resources assigned to its parent group.
正确答案: E
63: 单选题
You receive an error while performing an RMAN backup of the whole database. The alert log file
has the following entry in it:
ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 100.00% used, and
has 0 remaining bytes available.
You deleted unnecessary files from the Flash Recovery Area by using an operating system
command. Which statement is true regarding the space freed by the delete operation?
选项
A.
RMAN uses the space for the database backup.
B.
Oracle is not aware of the free space created this way.
C.
RMAN uses the space only after the database is restarted.
D.
The space can be used for storing archive logs, but not RMAN backups.
正确答案:B
64: 多选题
View the Exhibit and examine the properties of the USERS tablespace.
You execute the following statement to shrink the TRANS table existing on the USERS
tablespace:
SQL> ALTER TABLE trans SHRINK SPACE CASCADE;
Which objects would be affected by this command? (Choose all that apply.)
选项
A.
the TRANS table
B.
the B*Tree indexes on the TRANS table
C.
the materialized views log of the TRANS table
D.
the materialized views based on the TRANS table
E.
the large object (LOB) segments of the TRANS table
正确答案: A B
65: 多选题
Identify four uses of the Oracle Scheduler. (Choose four.)
选项
A.
enables you to execute jobs in a clustered environment
B.
enables you to schedule the execution of jobs based on time
C.
enables you to automate the management of the jobs that are created using the DBMS_JOB
package
D.
enables Oracle database to do patches according to a DBA-defined schedule
E.
enables you to create a job that makes use of saved programs and schedules
F.
enables you to periodically execute operating systemscript files located on the same server as the
database
G.
enables Oracle database to schedule which processes execute on which processors in a multiple
CPU environment
正确答案: A B E F
66: 单选题
You defined the Recovery Manager (RMAN) retention policy to recovery window of 7 days by
executing the following command:
RMAN> CONFIGURE RETENTION POLICY TO RECOVERYWINDOWOF 7 DAYS;
When a backup is performed, what would be the status of this backup after seven days?
选项
A.
The backup would be marked as invalid.
B.
The backup would be marked as obsolete.
C.
The backup would be removed from the media.
D.
The backup would be removed from the RMAN repository.
正确答案:B
67: 单选题
The database is running in ARCHIVELOG mode and the FORMAT option is not configured in
RMAN for disk backups. You configured the flash recovery area location and size by using the
DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE initialization
parameters.
Which statement is correct in this scenario?
选项
A.
If no other destination is configured for recovery files, then RMAN places the control file
autobackups in the flash recovery area by default.
B.
If any local destinations for LOG_ARCHIVE_DEST_n are set, then archived redo logs are stored
in these destinations as well as in the flash recovery area.
C.
If the flash recovery area location is configured using the DB_RECOVERY_FILE_DEST
initialization parameter, then the RMAN backup of Oracle managed datafiles (OMF) only will go
to the flash recovery area by default.
D.
If the FORMAT option to the RMA BACKUP command is specified, then RMAN creates backup
pieces and image copies in the flash recovery area with names in the Oracle Managed Files (OMF)
format.
正确答案:A
68: 多选题
Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user
error, you decided to perform an incomplete recovery. Which two tasks would you be required to
perform in the recovery process? (Choose two.)
选项
A.
open the database with the RESETLOGS option
B.
open the database with the RESTRICTED option
C.
recover all the data files to the same system change number (SCN)
D.
recover to the required SCN only that data file in which the error occurred
正确答案: A C
69: 多选题
Your database is running in ARCHIVELOG mode. Using RMAN you have enabled the control
file autobackup feature for the target database but have not used a recovery catalog. Which two
statements are true regarding recovery using the backup control file? (Choose two.)
选项
A.
You can restore the autobackup only to the default location.
B.
You must run the RECOVER command after restoring a backup control file, even if no data files
have been restored.
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 with the RESETLOGS option after performing either complete or
point-in-time recovery with a backup control file.
正确答案: B D
70: 单选题
You have a read-only tablespace on read-only media. You want to perform a media recovery on
the existing data files, but using a backup control file. The backup control file indicates that the
status of the read-only tablespace was read/write when the control file was backed up. What
should you consider?
选项
A.
drop the read-only tablespace and re-create the tablespace after recovery
B.
take data files from the read-only tablespace offline before performing a recovery
C.
perform a recovery; status of the tablespace in control file will be changed automatically
D.
recovery using backup control file is not possible, so restore all the files from the last full database
backup, and then open the database
正确答案:B
71: 单选题
View the Exhibits.
You performed operations on the DEPT4 table as shown in the Exhibit. When you perform the
Flashback Versions Query, you find that the first two updates are not listed.
What could be the reason?
选项
A.
The row movement is not enabled on the table.
B.
The first two updates were not explicitly committed.
C.
The Flashback Versions Query lists only the most recent update.
D.
The Flashback Versions Query stops producing rows after it encounters a time in the past when the
table structure was changed.
正确答案: D
72: 单选题
You have accidentally dropped a table called CUSTOMERS. This table had an index called
CUST_IDX. You then recover the table by using the FLASHBACK TABLE command. How
would you recover the index?
选项
A.
The index has to be re-created after the table is flashed back.
B.
The index has to be restored from a backup and then recovered.
C.
The index is automatically flashed back when the table is flashed back.
D.
The index has to be flashed back separately after the table has been flashed back.
正确答案: C
73: 多选题
Your production database is running in the ARCHIVELOG mode and the ARCn process is
functional. You have two online redo log groups. Which three background processes would be
involved when a log switch happens? (Choose three.)
选项
A.
archival
B.
log writer
C.
database writer
D.
system monitor
E.
process monitor
F.
change tracking writer
正确答案: A B C
74: 单选题
You set the recovery window to seven days and the backup optimization to ON using the
CONFIGURE command of Recovery Manager (RMAN). The most recent backup of the TOOLS
tablespace to disk was taken on January 3. The TOOLS tablespace is read-only. On February 21,
when you execute a command to back up all the tablespaces to disk, you find that RMAN backs
up the TOOLS tablespace also, even though the contents of the tablespace have not changed after
the backup on January 3.
Because there are no changes made to the TOOLS tablespace, you decide that the tablespace
should not be backed up by RMAN. What can you to do skip backing up the TOOLS tablespace
without changing the current backup optimization setting?
选项
A.
configure a default device for RMAN backups
B.
temporarily disable the retention policy for RMAN backups
C.
configure automatic channel allocation for RMAN backups
D.
use the CONFIGURE command to reconfigure the recovery window to 60 days
正确答案:B
75: 多选题
You lost a data file that belongs to an index tablespace in your database, which operates in
ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries.
Which two options would you use to solve this problem? (Choose two.)
选项
A.
restore the lost data file from the backup, and then flash back the database
B.
restore the data file pertaining to index tablespace, and then recover the tablespace
C.
restore all the data files, and then perform an incomplete recovery to get the tablespace back
D.
restore all the data files, and then perform an incomplete recovery using the backup control file
E.
drop and re-create the index tablespace, and then re-create all of the indexes in that tablespace
正确答案: B E
76: 单选题
You are working on Oracle Database 10g, which is in ARCHIVELOG mode. All the archived
log files are intact. In which scenario would performing a recovery require the opening of the
database with the RESETLOGS option?
选项
A.
loss of a tempfile
B.
loss of a system data file
C.
loss of one of the control files
D.
loss of one of the tablespaces
E.
loss of a member from each redo log group
F.
loss of the only member of an unarchived redo log group
正确答案: F
77: 多选题
Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces.
You want to use Recovery Manager (RMAN) to perform backups. Which two backups would you
be able to perform when the database is being accessed by users? (Choose two.)
选项
A.
backup of offline tablespaces
B.
backup of read-only tablespaces
C.
backup of system-critical tablespaces
D.
backup of online, locally managed tablespaces
E.
backup of read/write dictionary-managed tablespaces
正确答案: A B
78: 单选题
If you are executing a point-in-time recovery on a database using RMAN and a data file is
read-only at the point in time to which the database is being recovered, how would RMAN handle
the data file?
选项
A.
RMAN would recover the file and leave it as read only.
B.
RMAN would recover the file and change it to read/write.
C.
RMAN would not recover the file but the rest of the database is recovered successfully.
D.
RMAN would not recover the file but would halt the database recovery when it encounters the
file.
正确答案:A
79: 多选题
You enabled Automatic Shared Memory Management. The initialization parameters are set as
shown below:
SGA_TARGET = 10GB
SGA_MAX_SIZE = 14GB
STREAMS_POOL_SIZE = 1GB
SHARED_POOL_SIZE = 3GB
Which two statements are correct in this scenario? (Choose two.)
选项
A.
A maximum of 3 GB can be allocated to shared pool.
B.
The value for SGA_TARGET can be increased up to a maximum of 14 GB.
C.
A total of 14 GB memory will be allocated to the automatically tuned memory components.
D.
Increasing the value for SGA_TARGET will automatically increase the memory allocated for
STREAMS_POOL_SIZE.
E.
Increasing the value for SGA_TARGET to 12 GB will automatically increase the memory
allocated to autotuned parameters.
F.
Reducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated
to shared pool from 3 GB to 2 GB.
正确答案: B E
80: 多选题
View the Exhibit.
While inserting rows into the INVESTMENT table, the user receives the following error:
ORA-1653: unable to extend table SMITH.INVESTMENT by 128 in tablespace SALES_DATA
The SALES_DATA tablespace has one data file. On investigation, you find that sufficient amount
of disk space is available on the disk.
Which three solutions would allow the user to perform the insert successfully? (Choose three.)
选项
A.
adding a data file to the SALES_DATA tablespace
B.
increasing the size of the data file for the SALES_DATA tablespace
C.
increasing space quota on SALES_DATA tablespace for the user SMITH
D.
setting AUTOEXTEND ON for the data file of the SALES_DATA tablespace
E.
changing the extent allocation type for the SALES_DATA tablespace to AUTOALLOCATE
正确答案: A B D
81: 多选题
You are working in a dedicated server environment. Your database is running in the automatic
Program Global Area (PGA) memory management mode. Which two statements are correct in this
scenario? (Choose two.)
选项
A.
TheWORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.
B.
The Oracle database automatically controls the amount of PGA memory allotted to SQL work
areas.
C.
Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic
PGA memory management.
D.
The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA
memory management mode.
正确答案: B D
82: 多选题
You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL
statements in your development environment. Which three sources can you select for the advisor
to analyze? (Choose three.)
选项
A.
Top SQL
B.
snapshots
C.
SQL Tuning sets
D.
index access path
E.
optimizer statistics
F.
materialized view logs
正确答案: A B C
83: 单选题
On Monday morning, an important table named EMP_DATA was dropped. You are asked to
recover the table using the Flashback Drop feature. On investigation, you find that there is another
table existing with the same name in the same schema.
What would you do to recover the table in this scenario?
选项
A.
Flash back the dropped table into a different schema.
B.
Flash back the dropped table by using a different table name.
C.
Flash back the dropped table using the same table name because it will automatically replace the
existing table.
D.
Flash back the dropped table using the same table name because during recovery the table name
would be automatically changed to a new name.
正确答案:B
84: 单选题
On Tuesday, a junior DBA dropped an important application user account, whose schema has
important tables. You are asked to recover all the objects in the schema. On investigation, you find
that the user account was dropped at 11:00 a.m. and Sunday's backup is the most recent backup.
Which flashback feature would you use?
选项
A.
Flashback Drop
B.
Flashback Table
C.
Flashback Database
D.
Flashback Version Query
E.
Flashback Transaction Query
正确答案: C
85: 多选题
You have issued the following flashback command to recover a table called ORDER_ITEMS:
FLASHBACK TABLE order_items TO BEFORE DROP;
The flashback command executes successfully.
Which two statements are true regarding the dependent objects of ORDER_ITEMS? (Choose
two.)
选项
A.
Any indexes created on the ORDER_ITEMS table are also flashed back except for bitmap join
indexes.
B.
Any views existing on the ORDER_ITEMS table would remain invalid and they have to be
dropped and re-created.
C.
Any synonyms existing on the ORDER_ITEMS table would remain invalid and they have to be
dropped and re-created.
D.
Any triggers and constraints defined on the ORDER_ITEMS table are also flashed back except
referential integrity constraints.
正确答案: B C
86: 单选题
You execute the following RMAN commands in the order shown below:
BACKUP VALIDATE DATABASE;
BLOCKRECOVER CORRUPTION LIST;
What will these commands do?
选项
A.
create a backup of the database and recover all corrupted blocks found in the backup
B.
run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks
in the database
C.
run a backup validation to populate V$COPY_CORRUPTION view, and then list any corrupt
blocks recorded in the view
D.
run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view, and then
repair any corrupt blocks recorded in the view
E.
run a backup validation, repair any corrupt blocks found during the validation process, and then
update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have
been repaired
正确答案: D
87: 单选题
You need to create a schedule that will run a job on the second Friday of each month. What should
the repeat interval of the schedule be set to?
选项
A.
FREQ = MONTHLY; BYDAY = 2FRI;
B.
FREQ = MONTHLY; BYDAY = FRI2;
C.
FREQ = MONTHLY; BYDAY = -2FRI;
D.
FREQ = MONTHLY; BYDAY = FRI(2);
正确答案:A
88: 单选题
What purpose would you achieve by enabling the block change tracking feature?
选项
A.
eliminate the necessity for backups
B.
perform optimized image copy backups
C.
perform optimized incremental backups
D.
enable checkpoint (CKPT) to perform checkpointing at every block change
E.
enable database writer (DBWn) to write changed blocks to data files faster
正确答案: C
89: 单选题
In the parameter file of your production database, the CONTROL_FILE_RECORD_KEEP_TIME
parameter is set to 31. What would be the impact of this setting on the backup that is being
performed by using Recovery Manager (RMAN)?
选项
A.
The backup would be retained on the media for 31 days.
B.
The backup would be maintained in the recovery catalog for 31 days.
C.
The backup metadata would be retained in the control file for 31 days.
D.
The backup metadata would be maintained in the recovery catalog for 31 days.
E.
Automatic backups of the control file will be retained in the flash recovery area for 31 days.
正确答案: C
90: 单选题
View the Exhibit and examine the disks in the FRA disk group.
You use the FRA disk group, which has been created with external redundancy, for the Flash
Recovery Area.What could be the reason for the disks FRA3 and FRA4 being HUNG?
选项
A.
The rebalancing is being performed on the disks by the RBAL process.
B.
The Automatic Storage Management disk state is not known for the disks.
C.
Disk-drop operations were discontinued because there is insufficient space to relocate the data
from the disk being dropped.
D.
Disks have been manually taken offline and space allocation or data access for the disks has been
halted.
正确答案: C
91: 单选题
Examine the following CREATE DISKGROUP command to create a disk group:
SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCY DISK 'ORCL:FRA3' NAME
misc1, 'ORCL:FRA4' NAME misc2;
Which situation would suit this style of disk group creation?
选项
A.
when disk mirroring is required for the ASM disks
B.
when two-way mirroring is required for the allocation units in the disk
C.
when three-way mirroring is required for the allocation units in the disk
D.
when mirroring for disks that are already protected using hardware mirroring or RAID
正确答案: D
分卷: B
1: 单选题
The warning and critical threshold values have been set to 85% and 97%, respectively, for one of
the tablespaces. The current tablespace space usage is 54%. You modify the warning threshold to
be 50% and critical threshold to be 53% in Database Control.Which statement is true?
选项
A.
The new setting would be applied but no alerts would be raised immediately.
B.
The new setting would be applied and an alert would be raised immediately.
C.
The new setting would be ignored because the tablespace space usage is more than the specified
threshold value.
D.
The new setting would cause an error because the tablespace space usage is more than the
specified threshold value.
正确答案:A
2: 多选题
You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL
statements in your development environment. Which three sources can you select for the advisor
to analyze? (Choose three.)
选项
A.
Top SQL
B.
snapshots
C.
SQL Tuning sets
D.
index access path
E.
optimizer statistics
F.
materialized view logs
正确答案: A B C
3: 单选题
You want to create a consumer group, GROUP1, and you execute the following command in the
command-line interface:
SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP
(CONSUMER_GROUP =>'group1', COMMENT => 'New Group');
This command errors out displaying the following message:
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_RMIN", line 115
ORA-06512: at SYS.DBMS_RESOURCE_MANAGER", line 108
ORA-06512: at line 1
What action would you take to overcome this error?
选项
A.
grant SYSDBA to the user
B.
grant SYSOPER to the user
C.
grant the RESOURCE role to the user
D.
use the GRANT command to grant the ADMINISTER_RESOURCE_MANAGER privilege to the
user
E.
grant the ADMINISTER_RESOURCE_MANAGER privilege to the user by using the
DBMS_RESOURCE_MANAGER_PRIVS package
正确答案: E
4: 多选题
Which two statements regarding compressed backups in Recovery Manager (RMAN) are true?
(Choose two.)
选项
A.
Backup compression is disabled by default.
B.
Backup compression applies to only backup sets.
C.
Backup compression applies to only image copies.
D.
Backup compression cannot be enabled using the CONFIGURE command.
E.
Backup compression can be used with both backup sets and image copies.
F.
Backup compression works only if the COMPATIBILITY parameter is set to 9.0.0.0 or higher.
正确答案: A B
5: 单选题
You enabled the flashback logging feature, but you have not specified the location of the flash
recovery area.Which location would be used as the default location for the flash recovery area?
选项
A.
the location used for control files
B.
the location used for redo log files
C.
the location set by using $ORACLE_BASE
D.
the location set by using $ORACLE_HOME
E.
the location set by using CORE_DUMP_DEST
F.
the location set by using BACKGROUND_DUMP_DEST
正确答案: C
6: 单选题
You have an RMAN backup of the database on a tape device that was performed through the
Media Management Library (MML) software. As part of the media recovery, you want to restore
the data files from the backup set.
Which two steps from the list below does the media manager perform?
1)rquests for the restoration of a particular file
2)identifies the tape containing the file and reads the tape
3)passes the media information back to the Oracle database session
4)writes the file to disk
选项
A.
2, 3
B.
1, 4
C.
2, 4
D.
3, 4
正确答案:A
7: 多选题
While creating a scheduler window using the DBMS_SCHEDULER package, a user logged in as
DBMGR gets the error message insufficient privileges. Which two commands would you use to
resolve this error? (Choose two.)
选项
A.
GRANT dba TO dbmgr;
B.
GRANT connect TO dbmgr;
C.
GRANT resource TO dbmgr;
D.
GRANT hs_admin_role TO dbmgr;
E.
GRANT manage scheduler TO dbmgr;
正确答案: A E
8: 单选题
You lost the index tablespace in your database. You are not able to use tablespace point-in-time
recovery on the index tablespace.What could be the reason for this?
选项
A.
The index tablespace contains bitmap indexes.
B.
The index tablespace contains more than one data file.
C.
The index tablespace supports only complete recovery.
D.
The index tablespace is not a dictionary-managed tablespace.
E.
There is a dependency relationship between a table and its indexes.
正确答案: E
9: 单选题
In one of your online transaction processing (OLTP) applications, users are manipulating and
querying a database table simultaneously. From the Segment Advisor, you find that one of the
tables is highly fragmented and you want to shrink the table immediately without affecting the
currently active queries. Which option would you use with the ALTER TABLE command to
achieve this objective?
选项
A.
REBUILD
B.
CASCADE
C.
TRUNCATE
D.
ROW MOVEMENT
E.
SHRINK SPACE COMPACT
F.
SHRINK SPACE CASCADE
正确答案: E
10: 单选题
You receive an error while performing an RMAN backup of the whole database. The alert log file
has the following entry in it:
ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 100.00% used, and
has 0 remaining bytes available.
You deleted unnecessary files from the Flash Recovery Area by using an operating system
command. Which statement is true regarding the space freed by the delete operation?
选项
A.
RMAN uses the space for the database backup.
B.
Oracle is not aware of the free space created this way.
C.
RMAN uses the space only after the database is restarted.
D.
The space can be used for storing archive logs, but not RMAN backups.
正确答案:B
11: 多选题
In Recovery Manager (RMAN), you have set control file autobackup to ON by using the
following command:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
Which two events would cause the control file to be backed up automatically? (Choose two.)
选项
A.
a tablespace is taken offline
B.
the database instance is restarted
C.
a new data file is added to an existing tablespace
D.
a successful backup is recorded in the RMAN repository
E.
the RMAN connection is disconnected from the target database
正确答案: C D
12: 多选题
You are performing a block media recovery on the tools01.dbf data file in the SALES database by
using RMAN.Which two statements are correct in this scenario? (Choose two.)
选项
A.
You must ensure that the SALES database is mounted or open.
B.
You must restore a backup control file to perform a block media recovery.
C.
You must take the tools01.dbf data file offline before you start a block media recovery.
D.
You must put the database in NOARCHIVELOG mode to perform a block media recovery.
E.
You can perform only a complete media recovery of individual blocks; point-in-time recovery of
individual data blocks is not supported.
正确答案: A E
13: 单选题
Consider the following command to create a tablespace in your production database (which is
using an Automatic Storage Management [ASM] instance to manage the database files):
CREATE TABLESPACE user_tbsp
DATAFILE '+dgroup3(user_temp)/user_files/user_tbsp' SIZE 200M;
What would be the result of this command?
选项
A.
It would result in an error because the template cannot be used along with the disk group.
B.
It would result in an error because the path cannot be specified while creating a tablespace in a
disk group.
C.
It would create a tablespace with a data file that has an alias, and its attributes are set by the
user-defined template.
D.
It would create a tablespace with a data file that does not have an alias, and its attributes are set by
the user-defined template.
正确答案: C
14: 单选题
In which case would you use the Flashback Database feature to perform a recovery?
选项
A.
to recover a dropped tablespace
B.
to recover data from a truncated table
C.
to recover a data file that has been shrunk
D.
to recover a database to the state that existed before the RESETLOGS operation
正确答案:B
15: 单选题
One of the tablespaces is read-only in your database. The loss of all control files forced you to
re-create the control file. Which operation do you need to perform after re-creating the control file
and opening the database?
选项
A.
drop and re-create the read-only tablespaces
B.
rename the read-only data files to their correct file names
C.
change the tablespace status from read/write to read-only
D.
re-create the read-only tablespace because it is automatically removed
正确答案:B
16: 单选题
The loss of the control file forced you to re-create the control file. After re-creating it and opening
the database, you find that some of the data files are named as MISSINGnnnnn, where nnnnn is a
five-digit number starting with 0.What could be the possible reason?
选项
A.
These are the data files that are corrupted.
B.
There is no SYSAUX tablespace in your database
C.
There is a read-only tablespace in your database.
D.
These are the data files that cannot be recovered.
正确答案: C
17: 多选题
These are the details about V$FLASHBACK_DATABASE_STAT:
SQL> DESC V$FLASHBACK_DATABASE_STAT
Name Null? Type
---------------------------------------- -------- --------------
BEGIN_TIME DATE
END_TIME DATE
FLASHBACK_DATA NUMBER
DB_DATA NUMBER
REDO_DATA NUMBER
ESTIMATED_FLASHBACK_SIZE NUMBER
Which two statements regarding the V$FLASHBACK_DATABASE_STAT view are true?
(Choose two.)
选项
A.
BEGIN_TIME is the time at which Flashback logging is enabled.
B.
END_TIME is the time at which the query is executed on the view.
C.
REDO_DATA is the number of bytes of redo data written during the interval.
D.
This view contains information about flashback data pertaining to the last 24 hours.
E.
FLASHBACK_DATA is the amount of flashback data generated since the database was opened.
正确答案: C D
18: 单选题
You have configured and registered your target database in a recovery catalog. Because the
application needs it, you created a new tablespace in the target database. Then you executed the
following command from an RMAN session after connecting to the target and catalog databases,
both:
RMAN> REPORT SCHEMA;
Which statement describes the operation performed?
选项
A.
The target database instance transfers the updated information to the recovery catalog.
B.
The command shows the information from the control file of the target database and recovery
catalog is synchronized with the target database after the command is executed.
C.
The media manager transfers the schema details from the control file of the target database to the
recovery catalog.
D.
The recovery catalog will be updated by RMAN with the updated information in the control file of
the target database and displays information about the database files.
正确答案: D
19: 单选题
View the Exhibit.
One of the important tables in the USERS tablespace was dropped and purged from the recycle
bin at 9:00 a.m. You noticed this at 11:00 a.m. and you want to perform an incomplete recovery to
recover the table.
Which statement is true?
选项
A.
You must recover all data files to the required system change number (SCN).
B.
You must recover all data files, except those that are offline, to the required SCN .
C.
You must recover all data files belonging to the USERS tablespace to the required SCN.
D.
You cannot recover all data files because segment space management is performed manually for
the undo tablespace.
正确答案:B
20: 单选题
From the V$SESSION_LONGOPS view, you find that some of the database users have
long-running queries that consume a lot of CPU time. This causes performance problems for other
users in the database, who have much shorter queries.
You would like to make sure that the users with large queries do not use all the CPU time, but you
still do not want to terminate them with an error message.
Which method would you follow to achieve this?
选项
A.
set the CPU time per call in the users profile
B.
set the CPU time per session in the users profiles
C.
set the CPU levels for the users' group using Resource Manager
D.
set the TIMED_STATISTICS parameter to TRUE in the parameter file
正确答案: C
21: 单选题
The backup retention policy is configured as RECOVERY WINDOW 2. You executed the
following command in Recovery Manager (RMAN) against your database:
RMAN> REPORT OBSOLETE;
What would you see in the output?
选项
A.
a list of all the expired backups and copies
B.
a list of all those files that have been deleted in the last two days
C.
a list of all those files that have been recovered within the last two days
D.
a list of backups and copies that are outside the range covered by the current retention policy
正确答案: D
22: 多选题
You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter in the parameter file
to YYYY-MM-DD. The default format of which two data types would be affected by this setting?
(Choose two.)
选项
A.
DATE
B.
TIMESTAMP
C.
INTERVALYEAR TO MONTH
D.
INTERVAL DAY TO SECOND
E.
TIMESTAMPWITH LOCAL TIME ZONE
正确答案: B E
23: 单选题
On Tuesday, a junior DBA dropped an important application user account, whose schema has
important tables. You are asked to recover all the objects in the schema. On investigation, you find
that the user account was dropped at 11:00 a.m. and Sunday's backup is the most recent backup.
Which flashback feature would you use?
选项
A.
Flashback Drop
B.
Flashback Table
C.
Flashback Database
D.
Flashback Version Query
E.
Flashback Transaction Query
正确答案: C
24: 多选题
In which two situations would you prefer to use a hash cluster? (Choose two.)
选项
A.
Evenly distributed key values are present in the table.
B.
The applications occasionally use queries joining tables.
C.
The data retrieval has to be in the order in which it was inserted.
D.
The applications frequently modify a cluster key value in a constantly growing table.
E.
The application frequently uses queries with an equality predicate on the cluster key.
正确答案: A E
25: 单选题
View the Exhibit and examine the characteristics of the USERS tablespace.
You observe that a large volume of inserts and deletes are happening on the TRANS table in the
USERS tablespace and you suspect that the TRANS table is fragmented.
Which advisory component would you refer to, in order to find information about table
fragmentation?
选项
A.
MemoryAdvisor
B.
Segment Advisor
C.
SQL TuningAdvisor
D.
SQLAccess Advisor
E.
Automatic Database Diagnostic Monitor (ADDM)
正确答案:B
26: 多选题
You are using Oracle Database 10g. You performed an incomplete recovery of your database and
opened the database with the RESETLOGS option.
What is the effect of opening the database with the RESETLOGS option? (Choose two.)
选项
A.
This operation resets the SCN for the database.
B.
This operation creates a new incarnation of the database.
C.
This operation moves all the redo log files to a different location.
D.
This operation deletes the old redo log files and creates new redo log files.
E.
This operation updates all current datafiles and online redo logs and all subsequent archived redo
logs with a new RESETLOGS SCN and time stamp.
正确答案: B E
27: 单选题
You executed the following command in Recovery Manager (RMAN):
RMAN> RESTORE CONTROLFILE;
Which operation must you perform before this command is executed?
选项
A.
back up the control file to trace
B.
bring database to the MOUNT state
C.
open a connection to the RMAN recovery catalog, which contains the RMAN metadata for the
target database
D.
set the database ID (DBID), but only if the DB_NAME parameter associated with the target
database is unique in the recovery catalog
正确答案: C
28: 单选题
You executed the following query:
SELECT operation, undo_sql, table_name
FROM flashback_transaction_query;
Which statement is correct regarding the query output?
选项
A.
It would return information regarding only the last committed transaction.
B.
It would return only the active transactions in all the undo segments in the database.
C.
It would return only the committed transactions in all the undo segments in the database.
D.
It would return both active and committed transactions in all the undo segments in the database.
E.
It would return information regarding the transactions that began and were committed in the last
30 minutes.
正确答案: D
29: 单选题
You have specified the warning and critical threshold values of an application tablespace to be
60% and 70%, respectively. From the tablespace space usage metrics, you find that the actual
space usage has reached the specified warning threshold value, but no alerts have been generated.
What could be the reason for this?
选项
A.
The EVENT parameter was not set.
B.
The SQL_TRACE parameter is set to FALSE.
C.
The Enterprise Manager Grid Control is not used.
D.
The STATISTICS_LEVEL parameter is set to BASIC.
E.
The TIMED_STATISTICS parameter is set to FALSE.
正确答案: D
30: 多选题
You have decided to perform a full database export to check the consistency of a database. Which
two statements are true regarding the limitations of this method in detecting database
corruption?(Choose two.)
选项
A.
It does not detect index block corruptions.
B.
It detects block corruptions in used as well as free extents.
C.
It does not detect all the block corruptions in the SYSTEM tablespace.
D.
It detects logical and physical block corruptions only when Direct path export is used.
正确答案: A C
31: 单选题
You have been assigned to manage a set of databases. The previous DBA did not leave you notes
regarding the structure of each of the databases. While analyzing an instance, you notice that the
system identifier (SID) for the instance is set to '+ASM'. What is the purpose of this instance?
选项
A.
This instance is being used to manage the operating system files.
B.
This instance is being used to manage the files of other databases.
C.
This instance is being used to manage the instances of other databases.
D.
This instance is being used to manage the background processes of other instances.
正确答案:B
32: 单选题
The current time is 12:00 noon. You want to recover the USERS tablespace from a failure that
occurred at 11:50 a.m. You discover that the only member of an unarchived redo log group
containing information from 11:40 a.m. onwards is corrupt.
With reference to this scenario, if you are not using Recovery Manager (RMAN), which recovery
method would you use?
选项
A.
time-based recovery
B.
log sequence recovery
C.
cancel-based recovery
D.
change-based recovery
正确答案: C
33: 单选题
You have accidentally dropped a table called CUSTOMERS. This table had an index called
CUST_IDX. You then recover the table by using the FLASHBACK TABLE command.
How would you recover the index?
选项
A.
The index has to be re-created after the table is flashed back.
B.
The index has to be restored from a backup and then recovered.
C.
The index is automatically flashed back when the table is flashed back.
D.
The index has to be flashed back separately after the table has been flashed back.
正确答案: C
34: 单选题
View the Exhibit.
A number of big tables were recently dropped from the SALES_DATA tablespace. Because you
are seeing alerts reported for other tablespaces and you have shortage of disk space, you decide to
reduce the size of the data file for the SALES_DATA tablespace so that the data file size for the
tablespace with space-related alerts can be increased. You tried to reduce the data file size by using
the following command:
SQL> ALTER DATABASE DATAFILE '+DF/orcl/datafile/sales_data.326.617879191' RESIZE
2M;
*
ERROR at line 1:
ORA-03297: file contains used data beyond requested RESIZE value
What could be the reason for this error?
选项
A.
The dropped tables appear in the Recycle Bin.
B.
The minimum size for locally managed tablespace is 5 MB.
C.
The size of the data file cannot be reduced for a permanent tablespace.
D.
The size of the data file cannot be reduced for a locally managed tablespace.
正确答案:A
35: 单选题
Examine the RMAN commands in a backup strategy implemented in your company:
Day 1 - Sunday
RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG
WEEKLY DATABASE;
RMAN> RECOVER COPY OF DATABASEWITH TAG WEEKLY;
Day 2 - Monday
RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG
WEEKLY DATABASE;
RMAN> RECOVER COPY OF DATABASEWITH TAG WEEKLY;
Day 3 - Tuesday
RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG
WEEKLY DATABASE;
RMAN> RECOVER COPY OF DATABASEWITH TAG WEEKLY;
On Tuesday, before the backup is performed, you added a new tablespace.
Which statement is true regarding Tuesday's backup?
选项
A.
It will show an error because there is no Level 0 backup available for new data files.
B.
It will be an image copy backup of new data files and Level 1 incremental backup of all other data
files.
C.
It will be a Level 1 incremental backup of all the data files including the data files that belong to
the new tablespace.
D.
It will be a Level 0 backup of all the data files including the data files that belong to the new
tablespace.
正确答案:B
36: 单选题
The EMPLOYEES table is stored in the USERS tablespace. You need to check if the
EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which
option would you use?
选项
A.
the DBNEWID utility
B.
the ANALYZE command
C.
the RMAN LIST command
D.
the RMAN REPORT command
E.
the RMAN CROSSCHECK command
F.
the RMAN BLOCKRECOVER command
正确答案:B
37: 单选题
You have a disk group, DGROUP1, with three disks and NORMAL redundancy. You execute the
following command to create a template for the disk group:
ALTER DISKGROUP dgroup1
ADD TEMPLATE my_temp
ATTRIBUTES (MIRROR FINE);
Which statement is true?
选项
A.
When a file is created in DGROUP1 with the template, it would have three-way mirroring.
B.
When a file is created in DGROUP1, the MY_TEMP template becomes the default template.
C.
When a file is created in DGROUP1 with the template, it would have two-way mirroring and file
striping.
D.
When a file is created in DGROUP1 with the template, it would have three-way mirroring and file
striping.
E.
When a file is created in DGROUP1 with the template, it would have two-way mirroring but no
file striping.
正确答案: C
38: 单选题
A user executes a query on the EMP table, which contains thousands of rows, to get details about
employees in one of the departments. The user receives the following error:
SQL> SELECT ename FROM empWHERE deptno=10 ORDER BY sal;
SELECT ename FROM empWHERE deptno=10 ORDER BY sal
*
ERROR at line 1: ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/u01/app/oracle/oradata/orcl/temp01.dbf'
What is a possible reason?
选项
A.
The tempfile belonging to the default temporary tablespace is missing.
B.
The database is opened in restricted mode, so queries are not allowed.
C.
The default temporary tablespace required to execute the query is offline.
D.
The default temporary tablespace required to execute the query is dropped.
E.
The default temporary tablespace required to execute the query is read-only.
正确答案:A
39: 单选题
Your production database uses an Automatic Storage Management (ASM) instance to manage its
files. You want to add a new disk group to the ASM instance to manage the increased data load.
What action would you perform to include the new disk group in the ASM instance without
causing any impact on the currently connected users?
选项
A.
mount the new disk group in the ASM instance
B.
restart the ASM instance and the production database instance
C.
register the new disk groups in the production database instance
D.
restart the ASM instance without restarting the production database instance
E.
include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart
the ASM instance
正确答案:A
40: 多选题
You executed the following command in Recovery Manager (RMAN) to perform a backup of the
DETTBS tablespace:
RMAN> BACKUP TABLESPACE DETTBS;
Under which conditions would this command execute successfully? (Choose all that apply.)
选项
A.
The database is in NOMOUNT state.
B.
The database is in ARCHIVELOG mode and the tablespace is online.
C.
The database is in ARCHIVELOG mode and the tablespace is offline.
D.
The database is in NOARCHIVELOG mode and the tablespace is online.
E.
The database is in NOARCHIVELOG mode and the tablespace is offline.
正确答案: B C E
41: 单选题
While designing your database, you have created the EMPLOYEES table as an index-organized
table (IOT). You want to create a bitmap index on the JOB_ID column to make queries faster.
Which task must have been completed so that you are able to create the bitmap index?
选项
A.
A primary key must have been created.
B.
A mapping table must have been created.
C.
An overflow tablespace must have been specified.
D.
The PCTTHRESHOLD option must have been specified.
正确答案:B
42: 多选题
You executed the following command at the command prompt:
$ rman TARGET sys/oracle@ad10g CATALOG rmanusr/rmanusr@as10g SCRIPT backup_whole
Which three statements are true regarding this command? (Choose three.)
选项
A.
The backup_whole script is stored in the target database.
B.
The backup_whole is a stored script in the recovery catalog.
C.
The RMAN session terminates automatically after the execution of the command.
D.
The backup_whole script is executed automatically after the successful connection to the recovery
catalog only.
E.
The command produces an error because the RMAN script cannot be executed from the command
line.
F.
The backup_whole script is executed automatically after the successful connection to target and
catalog database.
正确答案: B C F
43: 多选题
You issue the following command in your database:
CREATE RESTORE POINT rec_load
GUARANTEE FLASHBACK DATABASE;
Which two statements are true regarding the REC_LOAD guaranteed restore point? (Choose two.)
选项
A.
It cannot be used in RECOVER DATABASE operations.
B.
It can work only if logging for Flashback Database is enabled.
C.
It creates logs in the flash recovery area that would not be deleted even if there is space pressure.
D.
It can be used to reverse the effects of NOLOGGING operations like in the case of direct load
inserts.
正确答案: C D
44: 单选题
The DB_BLOCK_CHECKING initialization parameter is set to TRUE. What would be the result
of this setting on the data blocks being written to the datafiles, every time the DBWn writes?
选项
A.
The Oracle database will check all data blocks by going through the data on each block, making
sure the data is self-consistent.
B.
DBWn and the direct loader will calculate a checksum and store it in the cache header of every
data block when writing it to disk.
C.
The Oracle database will check data blocks belonging to the SYSTEM tablespace only, by going
through the data on each block, making sure the data is self-consistent.
D.
The Oracle database will check data blocks belonging to the SYSAUX tablespace only, by going
through the data on each block, making sure the data is self-consistent.
E.
The Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only, by
going through the data on each block, making sure the data is self-consistent.
正确答案:A
45: 多选题
What are the two advantages of RMAN Block Media Recovery (BMR) over file-level recovery?
(Choose two.)
选项
A.
BMR lowers the mean time to recover (MTTR).
B.
BMR supports point-in-time recovery of individual data blocks.
C.
BMR enables you to use incremental backups for block recovery.
D.
BMR enables recovery even when the database is not mounted or open.
E.
BMR enables you to use proxy backups to perform block media recovery.
F.
BMR enables increased availability of data during recovery because the data file that requires a
recovery can remain online.
正确答案: A F
46: 单选题
A data file became corrupted in your database due to bad sectors on the disk. Because of
corruption, you lost all the important tables in that data file. Which method would you use for
recovery?
选项
A.
flash back all the tables in the data file, one by one
B.
restore the data file to a new location and perform a media recovery
C.
flash back the database; there is no need to restore the data file
D.
restore the data file from the most recent backup and flash back the database
正确答案:B
47: 多选题
What are the prerequisites for enabling Flashback Database? (Choose all that apply.)
选项
A.
The database must be in the NOMOUNT state.
B.
The database must have multiplexed control files.
C.
The database must be in ARCHIVELOG mode.
D.
The database must be opened in RESTRICTED mode.
E.
The database must be started in the MOUNT EXCLUSIVE state.
F.
The database must be opened by using a text-based parameter file instead of a server parameter
file (SPFILE).
正确答案: C E
48: 单选题
You observe that the senior database administrator always uses the following command when
connecting to Recovery Manager (RMAN), and then starts executing commands to backup the
database files:
$ rman target /
What would be the effect of this command?
选项
A.
RMAN would use the current operating system location to place the backup.
B.
RMAN would use the control file of the target database to maintain the backup.
C.
RMAN would use the recovery catalog of the target database to maintain the backup.
D.
RMAN would use the control file of the target database to maintain the backup metadata.
E.
RMAN would use the recovery catalog of the target database to maintain the backup metadata.
正确答案: D
49: 多选题
In the parameter file of your production database, the FAST_START_MTTR_TARGET
parameter is set to 300 to optimize instance recovery. While observing the performance of the
database during instance recovery, you find that the redo log files are not sized properly to support
this activity. Which two sources could you use to determine the optimal size of the redo log files?
(Choose two.)
选项
A.
the V$LOG view
B.
the V$DBFILE view
C.
the V$LOGFILE view
D.
the V$INSTANCE_RECOVERY view
E.
Oracle Enterprise Manager Database Control
正确答案: D E
50: 单选题
Every Sunday, consistent backups are performed on your database. Because of a user error, you
performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS
option.
A user error occurs again on Thursday, which necessitates an incomplete recovery. Sunday's
backup is the most recent backup available.
What would you do in this scenario?
选项
A.
recovery cannot be performed because a backup was not performed after the last incomplete
recovery
B.
restore all the files from Sunday's backup, and then perform an incomplete recovery up to the
point in time when the user error occurred on Thursday
C.
restore all the files from Sunday's backup, and then recover up to the point in time when the
RESETLOGS operation was performed on Tuesday
D.
restore all the files from Sunday's backup, and open the database to reset the database to the point
in time when the backup was performed on Sunday
正确答案:B
51: 多选题
You executed the following FLASHBACK TABLE command:
FLASHBACK TABLE emp TO TIMESTAMP ('11:45','hh12:mi');
Which two statements are correct? (Choose two.)
选项
A.
The FLASHBACK TABLE statement will not be written to the alert log file.
B.
The changes made to the EMP table since the specified time will be undone.
C.
The EMP table that was dropped by mistake from the database will be restored.
D.
The FLASHBACK TABLE statement will be executed within a single transaction.
E.
The FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table.
F.
The list of transactions that have modified the EMP table since the specified time will be
displayed.
正确答案: B D
52: 单选题
Your business has departmental reports that are generated every day. Each department must use
the same set of queries, but accesses a different subset of data in the tables, depending on which
department generates the report. The format of the reports is being developed; currently, the
format changes daily.
How would you configure the database to ensure that each department generates its report (based
on its target data) using the most recent report format every day?
选项
A.
by having each user run the report generation procedure at the scheduled time, supplying the
necessary input variables
B.
by creating a program using DBMS_JOB that accepts one or more variables, and creating a job
that calls this program using DBMS_JOB
C.
by having each user schedule a job using DBMS_JOB that accepts one or more input variables
and calls a procedure that generates the report
D.
by having each user create a job using DBMS_SCHEDULER that includes all the information and
commands necessary to generate the report
E.
by creating a program using DBMS_SCHEDULER that accepts one or more variables, and
creating a job that calls this program using DBMS_SCHEDULER
正确答案: E
53: 单选题
In one of your online transaction processing (OLTP) applications, most users frequently modify
the values, including the key values, of the application tables. Some users generate application
reports by using multiple application tables. What is the best table structure that you can use to
gain optimal performance?
选项
A.
heap table
B.
object table
C.
external table
D.
clustered table
E.
global temporary table
F.
index-organized table (IOT)
正确答案:A
54: 多选题
Which two metadata values are used to perform a consistency check in a block whenever a block
is read or written to in a database? (Choose two.)
选项
A.
SCN
B.
block version
C.
high water mark
D.
data block address
E.
checkpoint position
正确答案: B D
55: 单选题
On Monday morning, an important table named EMP_DATA was dropped. You are asked to
recover the table using the Flashback Drop feature. On investigation, you find that there is another
table existing with the same name in the same schema.
What would you do to recover the table in this scenario?
选项
A.
Flash back the dropped table into a different schema.
B.
Flash back the dropped table by using a different table name.
C.
Flash back the dropped table using the same table name because it will automatically replace the
existing table.
D.
Flash back the dropped table using the same table name because during recovery the table name
would be automatically changed to a new name.
正确答案:B
56: 单选题
In your database there exists a set of read-only tablespaces that have not been made read/write at
any time since the last backup. Before performing an incomplete recovery on a database using a
backup control file, what precautions should be taken regarding read-only tablespaces?
选项
A.
All read-only tablespaces should be taken offline.
B.
All read-only tablespaces should be made read/write.
C.
All read-only tablespaces should be dropped and restored separately.
D.
All read-only tablespaces should be renamed to names having the MISSINGnnnn format.
正确答案: C
57: 单选题
A database is running in ARCHIVELOG mode. It has two online redo log groups and each group
has one member. A LGWR I/O fails due to permanent media failure that has resulted in the loss of
a redo log file and the LGWR terminates causing the instance to crash.
Which method should be used to efficiently recover from this loss of the current group member?
选项
A.
Restart the database; it would automatically re-create the corrupted redo log member.
B.
Restore the corrupted redo log group, perform incomplete recovery, relocate by renaming the
member of the damaged online redo log group to a new location, and then open the database with
RESETLOGS.
C.
Restore the corrupted redo log member, perform incomplete recovery, relocate by renaming the
member of the damaged online redo log group to a new location, and then open the database with
RESETLOGS.
D.
Restore whole database backup, perform incomplete recovery, relocate by renaming the member
of the damaged online redo log group to a new location, and then open the database with the
RESETLOGS option.
正确答案: D
58: 单选题
You have created a resource plan, PROD_DB_PLAN, that uses the RATIO policy. The following
consumer groups and their respective plan directives have been assigned to this resource plan:
Consumer group HIGH_CG with CPU_P1 as 10.
Consumer group MEDIUM_CG with CPU_P1 as 5.
Consumer group LOW_CG with CPU_P1 as 2.
Consumer group OTHER_GROUPS with CPU_P1 as 1.
Which statement is correct in this scenario?
选项
A.
The plan PROD_DB_PLAN can have subplans.
B.
The members of the HIGH_CG consumer group would get 10% of the CPU.
C.
The CPU allocation for the consumer groups would be based on the ratio defined for the CPU_P1.
D.
The CPU allocation would be equal between the HIGH_CG and MEDIUM_CG consumer groups
if there are no sessions existing for the LOW_CG and OTHER_GROUPS consumer groups.
正确答案: C
59: 单选题
When you start the database instance, it does not open after reaching the mount state. The
initialization parameter DB_RECOVERY_FILE_DEST_SIZE is set to 2 GB. The archive
destination for the database is set to USE_DB_RECOVERY_FILE_DEST. While opening the
database by using the ALTER DATABASE command, you receive the following error:
ERROR at line 1:
ORA-16038: log 1 sequence# 1535 cannot be archived
ORA-19809: limit exceeded for recovery files
Which is the operation after which you can open the database successfully?
选项
A.
Delete the obsolete files in RMAN after running the CROSSCHECK command.
B.
Delete unnecessary files from the Flash Recovery Area by using an OS command.
C.
Delete unnecessary files from the Flash Recovery Area by using an OS command, and then use
RMAN to delete the expired files after running the CROSSCHECK command.
D.
Delete unnecessary files from the Flash Recovery Area by using an OS command, and then run
the RESYNC command in RMAN.
正确答案: D
60: 单选题
You noticed that large memory allocations for the Oracle backup and restore operations are
causing a performance overhead on the shared pool. Which memory structure would you
configure to avoid this performance overhead?
选项
A.
large pool
B.
streams pool
C.
redo log buffer
D.
keep buffer cache
E.
recycle buffer cache
正确答案:A
61: 多选题
You enabled Automatic Shared Memory Management. The initialization parameters are set as
shown below:
SGA_TARGET = 10GB
SGA_MAX_SIZE = 14GB
STREAMS_POOL_SIZE = 1GB
SHARED_POOL_SIZE = 3GB
Which two statements are correct in this scenario? (Choose two.)
选项
A.
A maximum of 3 GB can be allocated to shared pool.
B.
The value for SGA_TARGET can be increased up to a maximum of 14 GB.
C.
A total of 14 GB memory will be allocated to the automatically tuned memory components.
D.
Increasing the value for SGA_TARGET will automatically increase the memory allocated for
STREAMS_POOL_SIZE.
E.
Increasing the value for SGA_TARGET to 12 GB will automatically increase the memory
allocated to autotuned parameters.
F.
Reducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated
to shared pool from 3 GB to 2 GB.
正确答案: B E
62: 单选题
Using Oracle Scheduler you have scheduled two jobs, JOB_A and JOB_B, to run at 9:00 p.m.
every Friday. You want both the jobs to use a single resource plan, WEEKEND_PLAN. Which
task must have already been performed to enable you to achieve this objective?
选项
A.
A window must have been created with theWEEKEND_PLAN resource plan.
B.
A program must have been created with theWEEKEND_PLAN resource plan.
C.
A job class must have been created with theWEEKEND_PLAN resource plan.
D.
A window group must have been created with theWEEKEND_PLAN resource plan.
正确答案:A
63: 多选题
The ORACLE_SID environment variable is set to +ASM. You executed the following command
to start up the ASM instance:
SQL> STARTUP;
Which two statements describe the activities performed during a successful start up operation?
(Choose two.)
选项
A.
ASM starts the CSS daemon if it is not started.
B.
The databases configured to use the ASM instance are mounted.
C.
The disk groups are mounted as per the ASM_DISKGROUPS initialization parameter.
D.
ASM discovers and examines the contents of all of the files that are in the paths specified in the
ASM_DISKSTRING initialization parameter.
正确答案: C D
64: 单选题
You have only two redo log groups and these groups get overwritten several times in a day. Your
database operates in NOARCHIVELOG mode and user-managed consistent backups are
performed every Sunday night. On Thursday morning, you find that an important table has been
dropped and purged. With reference to this scenario, up to what point in time can the data be
recovered?
选项
A.
until Thursday morning
B.
until last Sunday's backup
C.
until Wednesday evening
D.
until that point in time when the database is opened
E.
until that point in time when the recovery is performed
F.
until that point in time when the table is dropped and purged
正确答案:B
65: 多选题
In which scenarios would you rebuild an index? (Choose all that apply.)
选项
A.
when you need to disable the index usage
B.
when you need to change storage options
C.
when you need to enable index monitoring
D.
when you need to move the index to another tablespace
正确答案: B D
66: 多选题
You set the value for the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter to 7.
Which two records in the control file of the database are circularly reused for storage because of
using this parameter? (Choose two.)
选项
A.
backup records
B.
data file records
C.
archive log records
D.
tablespace records
E.
redo thread records
正确答案: C E
67: 单选题
Which type of PL/SQL construct would you use to automatically correct the error resulting from a
statement that was suspended due to a space-related problem?
选项
A.
function
B.
package
C.
procedure
D.
database trigger
E.
anonymous PL/SQL block
正确答案: D
68: 单选题
You have an Automatic Storage Management (ASM) instance managing the database files of your
production database. The database contains ASM files and non-ASM files. Using Recovery
Manager (RMAN), you migrate the complete production database to use the ASM instance.
Which statement is true?
选项
A.
RMAN would relocate all the database files to an ASM disk group.
B.
RMAN would change the file definitions in the control file to use the ASM but would not relocate
the database files physically.
C.
RMAN would relocate all the data files to an ASM disk group and other files to an operating
system location, defined using Oracle Managed Files (OMF).
D.
RMAN would relocate the ASM files to an ASM disk group and the non-ASM files to an
operating system location, defined using OMF.
正确答案:A
69: 多选题
You created a partition table using the following command:
CREATE TABLE professional_history (
prof_history_id NUMBER(10),
person_id NUMBER(10) NOT NULL,
organization_id NUMBER(10) NOT NULL,
record_date DATE NOT NULL,
prof_hist_comments VARCHAR2(2000))
PARTITION BY HASH (prof_history_id)
PARTITIONS 3
STORE IN (part1, part2, part3);
Which statements are true about the partitions created by this command? (Choose all that apply.)
选项
A.
All partitions share the same segment for physical storage.
B.
All partitions share the same column and constraint definition.
C.
Each partition can be backed up and recovered independently.
D.
The distribution of data among the partitions is controlled by the DBA.
E.
Operations can be performed in parallel by different parallel execution servers for different
partitions of the table.
F.
The storage characteristics for the partitions can be changed after the partitions are created.
正确答案: B C E F
70: 单选题
You are working on a database, where you have three redo log groups. When the database is down
for a backup, an operating system (OS) user deletes all the redo log files in a group. What will
happen when you open your database?
选项
A.
The instance starts and the database opens because two redo log groups still exist.
B.
Before the instance starts, you receive an error about the missing redo log files of a group.
C.
The instance starts and the database opens with an error message written to the alert log file.
D.
The instance starts and the database opens, but every attempt to write to redo log files fails with an
error.
E.
The instance starts, the database is mounted, but efforts to open the database fail, and an error
about the missing redo log group is displayed.
正确答案: E
71: 多选题
You are connected to Recovery Manager (RMAN) without a recovery catalog. There is no copy of
the control file available. You want to restore the control file from an autobackup. To retrieve the
autobackup, you need the database ID (DBID). In which two sources would you find the DBID?
(Choose two.)
选项
A.
the trace file
B.
the alert log file
C.
an RMAN session log file
D.
the server parameter file
E.
the formatted name of a control file autobackup
正确答案: C E
72: 多选题
Your database is running in ARCHIVELOG mode. Using RMAN you have enabled the control
file autobackup feature for the target database but have not used a recovery catalog. Which two
statements are true regarding recovery using the backup control file? (Choose two.)
选项
A.
You can restore the autobackup only to the default location.
B.
You must run the RECOVER command after restoring a backup control file, even if no data files
have been restored.
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 with the RESETLOGS option after performing either complete or
point-in-time recovery with a backup control file.
正确答案: B D
73: 单选题
Your database operates in ARCHIVELOG mode. The redo log files are not multiplexed and one of
the online redo logs is missing. The missing redo log sequence, 230, is not archived, and it
contained information from 10:35 a.m. onwards.
The current time is 11:00 a.m. Because of a disk crash, you executed the following command to
perform an incomplete recovery:
RMAN> RUN {
2> SET UNTIL SEQUENCE 230 THREAD 1;
3> ALTER DATABASE MOUNT;
4> RESTORE DATABASE;
5> RECOVER DATABASE;
6> ALTER DATABASE OPEN RESETLOGS;
7> };
With reference to this scenario, which statement is true?
选项
A.
RMAN recovers up to log sequence 230, but not including 230.
B.
RMAN returns an error because the log sequence number mentioned in the command should be
229.
C.
RMAN returns an error because the log sequence number mentioned in the command may never
be missing.
D.
RMAN recovers up to and including log sequence 229 but then returns an error because log
sequence 230 is missing.
正确答案:A
74: 多选题
You lost the index tablespace in your database. You decided to re-create the index tablespace and
the indexes in the tablespace. What methods can you use to re-create the indexes? (Choose all that
apply.)
选项
A.
Data Pump
B.
SQL scripts
C.
SQL*Loader
D.
Flashback database
E.
Recovery Manager (RMAN) script
正确答案: A B
75: 单选题
You are managing a database for which incremental backups can be very time consuming. In order
to perform optimized incremental backups you enable the block change tracking feature. How
would you instruct RMAN to use the block change tracking feature when performing incremental
backups?
选项
A.
You need to mention it with every BACKUP command.
B.
You need to configure it using the CONFIGURE command.
C.
The block change tracking feature is used automatically by RMAN.
D.
You need to set the necessary initialization parameters to direct RMAN to use the feature.
正确答案: C
76: 单选题
View the Exhibit and examine the disks in the FRA disk group.
You use the FRA disk group, which has been created with external redundancy, for the Flash
Recovery Area.What could be the reason for the disks FRA3 and FRA4 being HUNG?
选项
A.
The rebalancing is being performed on the disks by the RBAL process.
B.
The Automatic Storage Management disk state is not known for the disks.
C.
Disk-drop operations were discontinued because there is insufficient space to relocate the data
from the disk being dropped.
D.
Disks have been manually taken offline and space allocation or data access for the disks has been
halted.
正确答案: C
77: 单选题
If you are executing a point-in-time recovery on a database using RMAN and a data file is
read-only at the point in time to which the database is being recovered, how would RMAN handle
the data file?
选项
A.
RMAN would recover the file and leave it as read only.
B.
RMAN would recover the file and change it to read/write.
C.
RMAN would not recover the file but the rest of the database is recovered successfully.
D.
RMAN would not recover the file but would halt the database recovery when it encounters the
file.
正确答案:A
78: 单选题
A redo log file is corrupted while the database is open; as a consequence, database operations are
stopped because archiving cannot continue.What would you do to solve the problem?
选项
A.
clear the redo log group
B.
perform redo log file import
C.
perform an incomplete recovery
D.
perform a redo log recovery using Recovery Manager (RMAN)
E.
shut down the database and open the database in the NOARCHIVELOG mode
正确答案:A
79: 单选题
Your database is running in the automatic Program Global Area (PGA) memory management and
Shared Memory Management mode. You want to increase the memory available for the SQL work
areas.What would you do?
选项
A.
modify the HASH_AREA_SIZE initialization parameter
B.
modify the PGA_AGGREGATE_TARGET initialization parameter
C.
modify theWORK_AREASIZE_POLICY initialization parameter
D.
increase the value of the SGA_TARGET initialization parameter
E.
increase the value of the SGA_MAX_SIZE initialization parameter
F.
increase the value of the SORT_AREA_SIZE initialization parameter
正确答案:B
80: 单选题
You decided to use the Flashback Drop feature to recover a dropped table called EMPLOYEES.
There is no other table with the same name existing in the schema. You query the RECYCLEBIN
and get the query output as displayed below:
SQL> SELECT OBJECT_NAME, ORIGINAL_NAME, DROPTIME FROM RECYCLEBIN;
OBJECT_NAME ORIGINAL_NAME
DROPTIME
----------------------------------------------------- --------------------- ---------------------------
BIN$/m0DrBV9RFGOAA53dC+FPw==$0 EMPLOYEES
2007-04-09:11:08:55
BIN$2DeIssLeQTqgH/n80Rm2JQ==$0 EMPLOYEES
2007-04-09:11:11:38
BIN$UuqroNodQy6ouDtaA+XOVw==$0 EMPLOYEES
2007-04-09:11:08:18
You then issue the following statement to recover the table:
SQL> FLASHBACK TABLE EMPLOYEES TO BEFORE DROP;
What would be the outcome of the above statement?
选项
A.
It retrieves the latest version of the table from the RECYCLEBIN.
B.
It retrieves the oldest version of the table from the RECYCLEBIN.
C.
It returns an error because the system-generated table name in the OBJECT_NAME column
should have been specified as the table name.
D.
It returns an error because the RENAME option should have been specified to convert the
system-generated name of the retrieved table to the original name.
正确答案: D
81: 单选题
The database is running in ARCHIVELOG mode and the FORMAT option is not configured in
RMAN for disk backups. You configured the flash recovery area location and size by using the
DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE initialization
parameters.
Which statement is correct in this scenario?
选项
A.
If no other destination is configured for recovery files, then RMAN places the control file
autobackups in the flash recovery area by default.
B.
If any local destinations for LOG_ARCHIVE_DEST_n are set, then archived redo logs are stored
in these destinations as well as in the flash recovery area.
C.
If the flash recovery area location is configured using the DB_RECOVERY_FILE_DEST
initialization parameter, then the RMAN backup of Oracle managed datafiles (OMF) only will go
to the flash recovery area by default.
D.
If the FORMAT option to the RMAN BACKUP command is specified, then RMAN creates
backup pieces and image copies in the flash recovery area with names in the Oracle Managed
Files (OMF) format.
正确答案:A
82: 单选题
Examine the following CREATE DISKGROUP command to create a disk group:
SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCY DISK 'ORCL:FRA3' NAME
misc1, 'ORCL:FRA4' NAME misc2;
Which situation would suit this style of disk group creation?
选项
A.
when disk mirroring is required for the ASM disks
B.
when two-way mirroring is required for the allocation units in the disk
C.
when three-way mirroring is required for the allocation units in the disk
D.
when mirroring for disks that are already protected using hardware mirroring or RAID
正确答案: D
83: 多选题
View the Exhibit.
While inserting rows into the INVESTMENT table, the user receives the following error:
ORA-1653: unable to extend table SMITH.INVESTMENT by 128 in tablespace SALES_DATA
The SALES_DATA tablespace has one data file. On investigation, you find that sufficient amount
of disk space is available on the disk.
Which three solutions would allow the user to perform the insert successfully? (Choose three.)
选项
A.
adding a data file to the SALES_DATA tablespace
B.
increasing the size of the data file for the SALES_DATA tablespace
C.
increasing space quota on SALES_DATA tablespace for the user SMITH
D.
setting AUTOEXTEND ON for the data file of the SALES_DATA tablespace
E.
changing the extent allocation type for the SALES_DATA tablespace to AUTOALLOCATE
正确答案: A B D
84: 单选题
You defined the Recovery Manager (RMAN) retention policy to recovery window of 7 days by
executing the following command:
RMAN> CONFIGURE RETENTION POLICY TO RECOVERYWINDOWOF 7 DAYS;
When a backup is performed, what would be the status of this backup after seven days?
选项
A.
The backup would be marked as invalid.
B.
The backup would be marked as obsolete.
C.
The backup would be removed from the media.
D.
The backup would be removed from the RMAN repository.
正确答案:B
85: 多选题
Your production database is running in the ARCHIVELOG mode and the ARCn process is
functional. You have two online redo log groups. Which three background processes would be
involved when a log switch happens? (Choose three.)
选项
A.
archival
B.
log writer
C.
database writer
D.
system monitor
E.
process monitor
F.
change tracking writer
正确答案: A B C
86: 单选题
On Monday, you dropped the DEPT table from your schema and then you re-created the DEPT
table in your schema. On Wednesday, you have a requirement to restore the DEPT table from the
recycle bin.
Which statement is correct?
选项
A.
You can restore the DEPT table by using the Oracle Flashback Drop feature, provided you use the
RENAME TO clause.
B.
You can restore the DEPT table by using the Oracle Flashback Drop feature and a
system-generated name will be assigned to the restored table.
C.
You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table
with the name DEPT already exists in your schema.
D.
You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the
contents of the recycle bin are purged every 12 hours by default.
正确答案:A
87: 多选题
Which two statements are correct regarding the Flashback Versions Query feature? (Choose two.)
选项
A.
You can use this feature to identify the versions of V$ views.
B.
You can use this feature to identify the versions of external and fixed tables.
C.
You can use this feature for a table only if row movement is enabled for the table.
D.
You can use this feature to identify the committed versions of the rows, but not the uncommitted
versions.
E.
You can use this feature to identify the inserts, deletes, and updates performed on a particular row
but not the data definition language (DDL) operations performed on the table.
正确答案: D E
88: 多选题
Following are the parameters and their values set in your database instance:
SGA_TARGET=8GB
SGA_MAX_SIZE=10GB
DB_KEEP_CACHE_SIZE=1GB
You executed the following command to increase SGA_TARGET: SQL> ALTER SYSTEM SET
SGA_TARGET=9GB;
Which three memory components would grow by the command above? (Choose three.)
选项
A.
large pool
B.
shared pool
C.
multiple block size caches
D.
keep pool of database buffer cache
E.
default pool of database buffer cache
正确答案: A B E
89: 单选题
Manually, you set the consumer group of all of the newly created users to MYDB_GRP. You want
the users to be able to change their consumer groups as per the application requirement. What was
the first step that was needed in the process to achieve this objective?
选项
A.
The user must have been granted the DBA role.
B.
The user must have been granted the switch privilege as a part of a role.
C.
The user must have been granted the Resource Manager administrator privilege.
D.
The user must have been granted the switch privilege by using the
DBMS_RESOURCE_MANAGER_PRIVS package.
正确答案: D
90: 多选题
You have issued the following flashback command to recover a table called ORDER_ITEMS:
FLASHBACK TABLE order_items TO BEFORE DROP;
The flashback command executes successfully.
Which two statements are true regarding the dependent objects of ORDER_ITEMS? (Choose
two.)
选项
A.
Any indexes created on the ORDER_ITEMS table are also flashed back except for bitmap join
indexes.
B.
Any views existing on the ORDER_ITEMS table would remain invalid and they have to be
dropped and re-created.
C.
Any synonyms existing on the ORDER_ITEMS table would remain invalid and they have to be
dropped and re-created.
D.
Any triggers and constraints defined on the ORDER_ITEMS table are also flashed back except
referential integrity constraints.
正确答案: B C
91: 多选题
For which two SQL statements can you use the Flashback Table feature to revert a table to its
previous state? (Choose two.)
选项
A.
UPDATE TABLE
B.
CREATE CLUSTER
C.
TRUNCATE TABLE
D.
ALTER TABLE MOVE
E.
INSERT INTO...VALUES
F.
ALTER TABLE...DROP COLUMN
G.
ALTER TABLE...DROP PARTITION
正确答案: A E