Every Sunday， consistent&#...

单项选择题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 recover up to the point in time when the RESETLOGS operation was performed on Tuesday
C. 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
D. 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

点击查看答案

您可能感兴趣的试卷

你可能感兴趣的试题

1.单项选择题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.

点击查看答案

2.单项选择题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， and then perform an incomplete recovery
B. restore the tablespace from the backup， and then apply all the redo information
C. restore all the data files in the database， and then perform an incomplete recovery
D. restore the tablespace from the backup

点击查看答案

3.多项选择题Which two statements regarding compressed backups in Recovery Manager （RMAN） are true？（）

A. Backup compression is disabled by default.
B. Backup compression can be used with both backup sets and image copies.
C. Backup compression cannot be enabled using the CONFIGURE command.
D. Backup compression works only if the COMPATIBILITY parameter is set to 9.0.0.0 or higher.
E. Backup compression applies to only backup sets.
F. Backup compression applies to only image copies.

点击查看答案

4.多项选择题 Exhibit： 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？（）

A. the materialized views based on the TRANS table
B. the materialized views log of the TRANS table
C. the TRANS table
D. the B*Tree indexes on the TRANS table
E. the large object （LOB） segments of the TRANS table

点击查看答案

5.多项选择题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？（）

A. open the database with the RESTRICTED option
B. open the database with the RESETLOGS option
C. recover to the required SCN only that data file in which the error occurred
D. recover all the data files to the same system change number （SCN）

点击查看答案

6.单项选择题 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 distribute the contents of the specified disk group among all other disk groups and then drop the specified disk group.
C. The command would result in the contents being moved to the parent disk group and dropping of the disk group.
D. The command would result in the disk group being marked as INVALID because it cannot be dropped.
E. The command would drop the disk group， ignoring the EXCLUDING CONTENTS option.

点击查看答案

7.单项选择题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. recycle buffer cache
B. large pool
C. streams pool
D. keep buffer cache
E. redo log buffer

点击查看答案

8.单项选择题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 TIMED_STATISTICS parameter to TRUE in the parameter file
D. set the CPU levels for the users’ group using Resource Manager

点击查看答案

9.多项选择题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？（）

A. SQL scripts
B. Recovery Manager （RMAN） script
C. Data Pump
D. SQL*Loader
E. Flashback database

点击查看答案

10.单项选择题 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. LARGE_POOL_SIZE
B. DB_CREATE_FILE_DEST
C. LOG_ARCHIVE_DEST
D. CONTROL_FILES
E. LOG_ARCHIVE_FORMAT
F. DB_BLOCK_SIZE

点击查看答案