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*’;
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.
![](https://static.ppkao.com/ppmg/img/appqrcode.png)
最新试题
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?()
One of the tablespaces is readonly in your database. The loss of all control files forced you to recreate the control file. Which operation do you need to perform after recreating the control file and opening the database?()
In which case would you use the Flashback Database feature to perform a recovery?()
You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and usermanaged 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?()
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? ()
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?()
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 performed an incomplete recovery on your Oracle Database 10g database using the following command: SQL> RECOVER DATABASE 2 UNTIL TIME ’20040805:12:10:03’ 3 USING BACKUP CONTROLFILE; In which situation would the above recovery be required?()
Consider the recovery steps in each of the cases given below: Case 1: Shut down the database and perform a backup. Restore all the data files. Mount the database. Recover the database. Without applying all the redo log files, open the database using the RESETLOGS option. Back up the database. Case 2: Shut down the database and perform a backup. Restore only the data files of the tablespace where user error damaged the data. Mount the database. Recover the database. Open the database with the RESETLOGS option. Back up the database. Case 3:Shut down the database Restore the data files Open the database Perform recovery to the current point in time. Which case has the correct steps for an incomplete recovery?()