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
单项选择题Youaremigratingyourproductiondatabasefromnon-ASMtoASMstorage.YouusedtheRMANutilitytomigratethedatabasefromnon-ASMtoASMstorage.Whichtypeofbackupcommandscriptwillyouuseformigratingthedatabasefromnon-ASMtoASMstorage?()
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.
单项选择题Duringtablespacecreation,whichfilenameformatisNOTusedforcreatingdatafilesassociatedwithatablespace?()
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