单项选择题n your production database you want to use an Automatic Storage Management (ASM) instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance?()

A. Oracle Migration Assistant
B. Recovery Manager (RMAN)
C. Oracle Data Pump Export and Import
D. conventional Oracle Export and Import
E. operating system utilities to copy the files to the ASM instance


您可能感兴趣的试卷

你可能感兴趣的试题

1.单项选择题The DB_BLOCK_CHECKINGinitialization parameter is set to TRUE. What would be the result of this setting on the data blocks being written to the datafiles, every time the DBWn writes?()

A. The Oracle database will check all data blocks by going through the data on each block, making sure the data is self-consistent.
B. The DBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.
C. The Oracle database will check data blocks belonging to the SYSTEM tablespace only, by going through the data on each block, making sure the data is self-consistent.
D. The Oracle database will check data blocks belonging to the SYSAUX tablespace only, by going through the data on each block, making sure the data is self-consistent.
E. The Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only, by going through the data on each block, making sure the data is self-consistent.

2.单项选择题You work as a database administrator at Certkiller .com. Your production database uses an Automatic Storage Management (ASM) instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users?()

A. mount the new disk group in the ASM instance
B. restart the ASM instance and the production database instance
C. register the new disk groups in the production database instance
D. restart the ASM instance without restarting the production database instance
E. include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

3.单项选择题

Exhibit, One of the important tables in the USERStablespace 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?()

A. You must recover all data files to the required system change number (SCN).
B. You must recover all data files, except those that are offline, to the required SCN.
C. You must recover all data files belonging to the USERS tablespace to the required SCN.
D. You cannot recover all data files because segment space management is performed manually for the undo tablespace.

4.单项选择题While designing your database, you have created the EMPLOYEEStable as an index-organized (IOT). You want to create a bitmap index on the JOD_IDcolumn to make queries faster. Which task must have been completed so that you are able to create the bitmap index?()

A. A primary key must have been created.
B. A mapping table must have been created.
C. An overflow tablespace must have been specified.
D. The PCTTHRESHOLD option must have been specified.

5.多项选择题

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?()

A. shut down and restart the instance
B. add new tempfiles to the temporary tablespaces after recovery
C. perform a media recovery and open the database with the RESETLOGS option
D. perform a media recovery and bring the database to NOARCHIVELOG mode

7.单项选择题You executed the following command in Recovery Manager (RMAN) against your Oracle 10g database:RMAN> REPORT NEED BACKUP days 3;What would be the output of this command?()

A. a list of files that require a backup within three days
B. a list of files that have not been backed up for three days
C. a list of files that RMAN recommends be backed up only once in every three days, based on low volatility
D. a list of files for which a backup has already been performed and may need a backup after three days

8.单项选择题You have specified the warning and critical threshold values of an application tablespace to be 60% and 70% respectively. From the tablespace space usage metrics, you find that the actual space usage has reached the specified warning threshold value, but no alerts have been generated. What could be the reason for this?()

A. The EVENT parameter was not set
B. The SQL_TRACE parameter is set to FALSE
C. The Enterprise Manager Grid Control is not used
D. The STATISTICS_LEVEL parameter is set to BASIC
E. The TIMED_STATISTICS parameter is set to FALSE

9.多项选择题You work as a database administrator at Certkiller .com. In your production database, you observe that users’ transactions are consuming a lot of resource and you plan to impose resource restrictions by using Resource Manager. For which three resources can you enable usage restrictions by using Resource Manager? ()

A. CPU usage
B. degree of parallelism
C. number of open cursors
D. number of sorts performed
E. idle time for blocking sessions
F. number of disk I/O operations performed
G. number of memory I/O operations performed

10.单项选择题Which statement correctly describes the change tracking writer (CTWR) background process?()

A. It keeps track of changes in the background processes.
B. It records the system change number (SCN) in the control file.
C. It writes audit records for user changes to the change tracking file.
D. It records any changes to the listened configuration in the listener.ora file.
E. It records any changes to the database parameters in the change tracking file.
F. It records the physical location of all the changes that are made to the database in the change tracking file.

最新试题

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 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?()

题型:单项选择题

You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area? ()

题型:多项选择题

In which case would you use the Flashback Database feature to perform a recovery?()

题型:单项选择题

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? ()

题型:多项选择题

You performed an incomplete recovery on your Oracle Database 10g database using the following command: SQL> RECOVER DATABASE 2 UNTIL TIME ’2004­08­05:12:10:03’ 3 USING BACKUP CONTROLFILE; In which situation would the above recovery be required?()

题型:单项选择题

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?()

题型:单项选择题

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?()

题型:单项选择题

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?()

题型:单项选择题

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?()

题型:多项选择题