A. BACKUP AS BACKUPSET
B. BACKUP AS COPY
C. BACKUP AS COMPRESSED BACKUPSET
D. BACKUP INCREMENTAL LEVEL n CUMULATIVE
您可能感兴趣的试卷
你可能感兴趣的试题
You have configured the ASM instance for the PROD database of iPod Corporation. You have specified the following parameter values in the initialization parameter file:
DB_CREATE_FILE_DEST=’devices/grp1/P’
DB_CREATE_ONLINE_LOG_DEST_1=’devices/d_grp2/Q’
DB_CREATE_ONLINE_LOG_DEST_2=’devices/d_grp3/R’
BACKGROUND_DUMP_DEST=’devices/d_grp1/S’
You have added a new redo log group that contains two redo log members. Where are the redo log members stored?()
A. Both the members will be stored in the ’devices/grp1/P’ directory.
B. Both the members will be stored in the ’devices/d_grp2/Q’ directory.
C. Both the members will be stored in the ’devices/d_grp3/R’ directory.
D. One member will be stored in the ’devices/d_grp2/Q’ directory and the other in the ’devices/d_grp3/R’ directory.
A. incomplete names
B. incomplete names with templates
C. alias with template names
D. numeric names
You included the following Automatic Storage Management (ASM) initialization parameter settings in the ASM initialization parameter file:
INSTANCE_TYPE = ASM ASM_POWER_LIMIT = 11 LARGE_POOL_SIZE = 4M
ASM_DISKGROUPS = DG1, DG2 DB_UNIQUE_NAME = +ASM
You are unable to start the ASM instance. Which initialization parameter file setting(s) is not allowing the ASM instance to start?()
A. only the INSTANCE_TYPE initialization parameter is set to an invalid value
B. only the ASM_POWER_LIMIT initialization parameter is set to an invalid value
C. only the LARGE_POOL_SIZE initialization parameter is set to an invalid value
D. both the LARGE_POOL_SIZE and INSTANCE_TYPE initialization parameters are set to invalid values
You are performing backup and recovery operations by using RMAN. You are using a recovery catalog for the RMAN repository. You are planning to migrate to ASM disk storage to enable new disks to be added to the database without shutting down the database.
Which information is NOT required during the migration process?()
A. Database Identifier (DBID)
B. names and location of datafiles
C. names and location of control files
D. names and location of online redo log files
A. ASMB
B. ARBn
C. RBAL in the ASM instance
D. RBAL in the database instance
Consider the following configuration:
/devices/diskP1 is a member of disk group grp1.
/devices/diskP2 is a member of disk group grp1.
/devices/diskP3 is a member of disk group grp1.
/devices/diskP4 is a candidate disk.
/devices/diskQ1 is a member of disk group grp2.
/devices/diskQ2 is a member of disk group grp2.
/devices/diskQ3 is a member of disk group grp2.
/devices/diskQ4 is a candidate disk.
Which command will add the disk /devices/diskP4 to the disk group, grp1?()
A. ALTER DISKGROUP grp1 ADD DISK ’/devices/diskP1’, ADD DISK ’/devices/diskP4’;
B. ALTER DISKGROUP grp1 ADD DISK ’/devices/disk*4’;
C. ALTER DISKGROUP grp1 ADD DISK ’/devices/diskP*’;
D. ALTER DISKGROUP grp1 ADD DISK ’/devices/diskQ*’, ADD DISK ’/devices/diskP*’;
A. ASM_POWER_LIMIT
B. ASM_DISKSTRING
C. ASM_DISKGROUPS
D. LARGE_POOL_SIZE
A. CREATE TABLESPACE DATA1 DATAFILE ’+grp1/abc(datafile)’;
B. CREATE TABLESPACE DATA1 DATAFILE ’+grp1’;
C. CREATE TABLESPACE DATA1 DATAFILE ’+data1(tempfile)’;
D. CREATE TABLESPACE DATA1 DATAFILE ’+grp1.256.34359’;
A. The database will not start.
B. The database will start but will not retain the undo data in the undo segment.
C. The database will start, and the undo segment will contain the undo data for at least one hour.
D. The database will start, and the undo segment will retain the undo data for at least 15 minutes.
A. The database must be in the ARCHIVELOG mode.
B. The automatic memory tuning must be enabled.
C. The change tracking feature must be enabled.
D. The automatic memory tuning must be disabled.
最新试题
Your database operates in ARCHIVELOG mode and usermanaged 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?()
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?()
View the Exhibit and examine the Flashback Database architecture. Identify the missing component (shown with a "?") in the Flashback Database architecture.()
For an incomplete recovery, which four backup types can be used by Recovery Manager (RMAN) to restore data files? ()
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? ()
In which case would you use the Flashback Database feature to perform a recovery?()
You lost the index tablespace in your database. You are not able to use tablespace pointintime recovery on the index tablespace. What could be the reason for this?()
You disabled the Flashback Database feature by using the following command: SQL> ALTER DATABASE FLASHBACK OFF; What would be the effect of this command on the existing flashback logs?()
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?()
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?()