单项选择题Your database is configured on non-ASM disk storage. You need to migrate your database to ASM disk storage.  Which statement is true about migrating from non-ASM disk storage to ASM disk storage？（） 

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.

点击查看答案

您可能感兴趣的试卷

你可能感兴趣的试题

1.单项选择题

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

点击查看答案
2.单项选择题You are migrating your production database from non-ASM to ASM storage. You used the RMAN utility to migrate the database from non-ASM to ASM storage. Which type of backup command script will you use for migrating the database from non-ASM to ASM storage？（）

A. BACKUP AS BACKUPSET
B. BACKUP AS COPY
C. BACKUP AS COMPRESSED BACKUPSET
D. BACKUP INCREMENTAL LEVEL n CUMULATIVE

点击查看答案
3.单项选择题

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.

点击查看答案
4.单项选择题During tablespace creation， which filename format is NOT used for creating datafiles associated with a tablespace？（）

A. incomplete names
B. incomplete names with templates
C. alias with template names
D. numeric names

点击查看答案
5.单项选择题

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

点击查看答案
6.单项选择题

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

点击查看答案
7.单项选择题You are the Database Administrator for WonderWeb， which has recently acquired a media company TXGlobal. You have been assigned the task to migrate all the database applications of TXGlobal to the database server of WonderWeb. To accommodate more database applications， you need to add disks to the existing disk group. Whenever you add or remove disks from the disk group， Automatic Storage Management （ASM） rebalancing distributes the data evenly across all the disks of the disk group. Which background process performs this actual rebalancing activity， resulting in the movement of data extents in the disk groups？（）  

A. ASMB
B. ARBn
C. RBAL in the ASM instance
D. RBAL in the database instance

点击查看答案
8.单项选择题

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*’；

点击查看答案
9.单项选择题You are maintaining the SALES database on Oracle 10g. You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity. Which parameter will you specify to control the speed of the rebalancing activity？ （） 

A. ASM_POWER_LIMIT
B. ASM_DISKSTRING
C. ASM_DISKGROUPS
D. LARGE_POOL_SIZE

点击查看答案
10.单项选择题Which statement will NOT create a tablespace？（）

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’；

点击查看答案

最新试题

Your database operates in ARCHIVELOG mode and user­managed 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？（）

题型：单项选择题

You have a read­only tablespace on read­only 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 read­only tablespace was read/write when the control file was backed up. What should you consider？（）

题型：单项选择题

One of the tablespaces is read­only in your database. The loss of all control files forced you to re­create the control file. Which operation do you need to perform after re­creating the control file and opening the database？（）

题型：单项选择题

You are connected to Recovery Manager （RMAN） without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup，you need the database ID （DBID）. In which two sources would you find the DBID？ （）

题型：多项选择题

You lost the PRODSTD tablespace， which was read/write. The tablespace was read­only when the last backup was performed. How would you recover the tablespace？（）

题型：单项选择题

You executed the following query in your database： FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output？（）

题型：单项选择题

You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user­managed 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？（）

题型：单项选择题

You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re­create the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re­create the indexes？（）

题型：多项选择题

You enabled the flashback logging feature， but you have not specified the location of the flash recovery area. Which location would be used as the default location for the flash recovery area？（）

题型：单项选择题

Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel­based recovery？（）

题型：多项选择题