A. If the SHUTDOWN IMMEDIATE command is issued to the ASM instance, the ASM instance immediately shuts down.
B. If the SHUTDOWN ABORT command is issued to the ASM instance, the ASM instance will shut down all the database instances and then shut down immediately.
C. If the SHUTDOWN NORMAL command is issued to the ASM instance, before shutting down, the ASM instance waits for the dependent database instances to shut down.
D. If the SHUTDOWN TRANSACTIONAL command is issued to the ASM instance, the ASM instance passes the same SHUTDOWN command to the dependent database instances, but does not wait for any active transactions to complete before it shuts down.
您可能感兴趣的试卷
你可能感兴趣的试题
A. INSTANCE_TYPE
B. DB_UNIQUE_NAME
C. ASM_DISKSTRING
D. ASM_POWER_LIMIT
A. You can use the operating system utility to migrate from non-ASM disk storage to ASM disk storage.
B. You cannot perform a database backup from non-ASM disk storage to tape and then move it to ASM disk storage.
C. You can use the SWITCH DATABASE TO COPY Recovery Manager (RMAN) command to switch back to non-ASM disk storage if you have not deleted your original datafiles.
D. You cannot use Recovery Manager (RMAN) to migrate from non-ASM disk storage to ASM disk storage if you are not using RMAN for your backup and recovery strategies.
You execute the following command to start an Automatic Storage Management (ASM) instance: SQL>STARTUP;
In which of the following modes will the ASM instance start?()
A. OPEN
B. MOUNT
C. NORMAL
D. NOMOUNT
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*’;
最新试题
You have a readonly tablespace on readonly 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 readonly tablespace was read/write when the control file was backed up. What should you consider?()
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?()
The loss of the control file forced you to recreate the control file. After recreating it and opening the database, you find that some of the data files are named as MISSINGnnnnn, where nnnnn is a fivedigit number starting with 0. What could be the possible reason?()
You are working on an Oracle Database 10g database. Because of data loss, you decided to perform a Flashback Database operation using the following command: SQL> FLASHBACK DATABASE TO TIMESTAMP(SYSDATE 5/24); Which two statements are true? ()
In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog. The following commands are used in the process of recovering the database by using the backup control file: In what sequence would you use this process to perform the recovery?()
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? ()
Your database operates in ARCHIVELOG mode. Usermanaged consistent backups are performed every Sunday night. On Tuesday, client A drops a table at 8:00 a.m. as follows: SQL> DROP TABLE cust_ord PURGE; Table dropped. Client B executes a query at 9:00 a.m. on the same table as follows: SQL> SELECT * FROM cust_ord;SELECT * FROM cust_ord* ERROR at line 1: ORA00942: table or view does not exist Client B needs the dropped table and reports the problem to you. With reference to this scenario, which action should you take?()
In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog and restored the control file by using the following command: RMAN> RESTORE CONTROLFILE; Which two operations do you need to perform after restoring the control file from backup?()
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?()