You are administering a database stored in Automatic Storage management (ASM). The files are storedin the DATA disk group. You execute the following command:SQL ALTER DISKGROUP data ADD ALIAS ‘+data/prod/myfile.dbf’ FOR ‘+data.231.45678’;What is the result?（）A、The file ‘+data.231.54769’ is physically relocated to ‘+data/prod’ and renamed as ‘myfile.dbf’.B、The file ‘+data.231.54769’ is renamed as ‘myfile.dbf’, and copied to ‘+data/prod’.C、The file ‘+data.231.54769’ remains in the same location and a synonym 'myfile.dbf' is created.D、The file ‘myfile.dbf’ is created in ‘+data/prod’ and the reference to ‘+data.231.54769’ in the data dictionary removed.
You are administering a database stored in Automatic Storage management (ASM). The files are storedin the DATA disk group. You execute the following command:SQL > ALTER DISKGROUP data ADD ALIAS ‘+data/prod/myfile.dbf’ FOR ‘+data.231.45678’;What is the result?（）
- A、The file ‘+data.231.54769’ is physically relocated to ‘+data/prod’ and renamed as ‘myfile.dbf’.
- B、The file ‘+data.231.54769’ is renamed as ‘myfile.dbf’, and copied to ‘+data/prod’.
- C、The file ‘+data.231.54769’ remains in the same location and a synonym 'myfile.dbf' is created.
- D、The file ‘myfile.dbf’ is created in ‘+data/prod’ and the reference to ‘+data.231.54769’ in the data dictionary removed.
相关考题：
Examine the following command:ALTER DISKGROUP data MOUNT FORCE;In which scenario can you use the above command to mount the disk group? () A. when ASM disk goes offlineB. when one or more ASM files are droppedC. when some disks in a disk group are offlineD. when some disks in a failure group for a disk group are rebalancing
You want to perform the following operations for the DATA ASM disk group:Which command accomplishes these tasks?() A. ALTER DISKGROUP data CHECK;B. ALTER DISKGROUP data CHECK DISK;C. ALTER DISKGROUP data CHECK FILE;D. ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1;
A senior DBA asked you to execute the following command to improve performance:SQL ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle);You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows.What could be a reason for this recommendation?（）A. The keep pool is not configured.B. Automatic Workarea Management is not configured.C. Automatic Shared Memory Management is not enabled.D. The data blocks in the SUBSCRIBE_LOG table are rarely accessed.E. All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view
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 instanceB、 restart the ASM instance and the production database instanceC、 register the new disk groups in the production database instanceD、 restart the ASM instance without restarting the production database instanceE、 include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance
Consider the following command to create a tablespace in your production database （which is using an Automatic Storage Management [ASM] instance to manage the database files）： CREATE TABLESPACE user_tbsp DATAFILE ’+dgroup3（user_temp）/user_files/user_tbsp’ SIZE 200M； What would be the result of this command？（）A、It would result in an error because the template cannot be used along with the disk group.B、It would result in an error because the path cannot be specified while creating a tablespace in a disk group.C、It would create a tablespace with a data file that has an alias， and its attributes are set by the user-defined template.D、It would create a tablespace with a data file that does not have an alias， and its attributes are set by the user-defined template.
What is the net effect of the following command？（） alter diskgroup dgroup1 drop disk abc；A、 The disk ABC will be dropped from the disk group. Since you did not issue a rebalance command，the data on that disk will be lost.B、 The command will raise an error indicating that you need to rebalance the disk group to remove the data from that disk prior to dropping the disk.C、 The disk group will be automatically rebalanced during the drop operation. Once the rebalancing is complete，the disk will be dropped.D、 This command will fail because you cannot drop a specific disk in an ASM disk group.E、 The disk drop command will be suspended for a predetermined amount of time，waiting for you to also issue an alter diskgroup rebalance command. Once you have issued the rebalance command，ASM will proceed to rebalance the disk group and then drop the disk.
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 AssistantB、 Recovery Manager （RMAN）C、 Oracle Data Pump Export and ImportD、 conventional Oracle Export and ImportE、 operating system utilities to copy the files to the ASM instance
You are using an Automatic Storage Management （ASM） instance to manage the database files of your production database. After adding a new disk group to the ASM instance， you execute the following command： ALTER DISKGROUP dg3 REBALANCE POWER 0； What would be the result of this command？（）A、The rebalancing of the disk group would be stopped.B、The rebalancing of the disk group would be completed as fast as possible.C、The command would result in an error because the value of POWER cannot be 0.D、The rebalancing of the disk group would be completed without affecting the disk group DG3.E、The command would result in an error because the disk groups cannot be manually rebalanced.
Consider the following scenario： You have a directory， data， under the disk group tdgroupA. You want to create an alias for one of the data files and you execute the following command： ALTER DISKGROUP tdgroupA ADD ALIAS ’+tdgroupA/data/datafile.dbf’ FOR ’+tdgroupA.231.45678’； Which task would be accomplished by the command？（）A、The command drops the file +tdgroupA·231.45678.B、The command physically relocates the file to +tdgroupA/data and renames the file to datafile.dbf.C、The command creates a copy of the +tdgroupA·231.45678 file and places it in +tdgroupA/data after renaming the file to datafile.dbf.D、The command creates an alias， datafile.dbf， and places it in +tdgroupA/data and does not remove the +tdgroupA·231.45678 file.E、The command creates a file， datafile.dbf， in +tdgroupA/data and removes the references for +tdgroupA·231.45678 from the data dictionary views.
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 instanceB、restart the ASM instance and the production database instanceC、register the new disk groups in the production database instanceD、restart the ASM instance without restarting the production database instanceE、include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance
You want to convert your existing non-ASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task？（） A、 Data Pump Export and ImportB、 conventional export and importC、 the CONVERT command of RMAND、 the BACKUP AS COPY. command of RMAN
You disabled the Flashback Database feature by using the following command： SQL ALTER DATABASE FLASHBACK OFF； What would be the effect of this command on the existing flashback logs？（）A、 Flashback logs are not deleted.B、 Flashback logs are deleted automatically.C、 Flashback logs are deleted only if you are using Recovery Manager （RMAN）D、 Flashback logs are deleted only if you are using Oracle Manager Files （OFM）E、 Flashback logs are deleted only if you are using Automatic Storage Management （ASM）
In 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 AssistantB、Recovery Manager （RMAN）C、Oracle Data Pump Export and ImportD、conventional Oracle Export and ImportE、operating system utilities to copy the files to the ASM instance
You work as a database administrator for Certkiller .com. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN； What two actions are performed as a result of this command？（）A、All control files are openedB、All redo files are openedC、The password file is openedD、The parameter file is openedE、All online data files are opened
A senior DBA asked you to execute the following command to improve performance: SQL ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle); You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows. What could be a reason for this recommendation?（）A、The keep pool is not configured.B、Automatic Workarea Management is not configured.C、Automatic Shared Memory Management is not enabled.D、The data blocks in the SUBSCRIBE_LOG table are rarely accessed.E、All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view
Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN. Examine the following command and its output: You execute the following command: RMAN BACKUP DATABASE PLUS ARCHIVELOG; Which data files will be backed up?（）A、Data files that belong to only the root containerB、Data files that belong to the root container and all the pluggable databases (PDBs)C、Data files that belong to only the root container and PDB$SEEDD、Data files that belong to the root container and all the PDBs excluding PDB$SEED
Examine the following command： ALTER DISKGROUP data MOUNT FORCE； In which scenario can you use the above command to mount the disk group？（） A、 when ASM disk goes offlineB、 when one or more ASM files are droppedC、 when some disks in a disk group are offlineD、 when some disks in a failure group for a disk group are rebalancing
You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure. In which three ways can you re-create the lost disk group and restore the data?（）A、Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data.B、Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.C、Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data.D、Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group name and same set of disks and failure group configuration, and use RMAN to restore the data.E、Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.F、Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data.
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、 ASMBB、 ARBnC、 RBAL in the ASM instanceD、 RBAL in the database instance
You want to perform the following operations for the DATA ASM disk group： -Verify the consistency of the disk. -Cross-check all the file extent maps and allocation tables for consistency. check whether the alias metadata directory and file directory are linked correctly. -Check that ASM metadata directories do not have unreachable allocated blocks. Which command accomplishes these tasks（）？A、 ALTER DISKGROUP data CHECKB、 ALTER DISKGROUP data CHECK DISKC、 ALTER DISKGROUP data CHECK FILED、 ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1
You issued the following command to mount the DATA disk group in restricted mode： ALTER DISKGROUP data MOUNT RESTRICT； What is the implication of this command？（）A、 The client RDBMS instance can access the file as a read-only file.B、 A new disk cannot be added to a disk group.C、 A disk in a disk group can be taken offline.D、 The client RDBMS instance cannot access the files in the disk group.
You need to cleanse and standardize the data on potential survey participants prior to inserting it into the staging database. What should you do?（）A、Import the data into a staging table by using the OPENROWSET BULK statement. Execute a Transact-SQL stored procedure to cleanse the data and to insert the data into the database.B、Import the data into a staging table by using the BULK INSERT statement. Execute a Transact-SQL stored procedure to cleanse the data and to insert the data into the database.C、Create a SQL Server Integration Services （SSIS） package to import， standardize， and cleanse the data.D、Create a CLR stored procedure to import the data into a staging table， to cleanse and standardize the data， and to insert the data into the database.
单选题You want to perform the following operations for the DATA ASM disk group： -Verify the consistency of the disk. -Cross-check all the file extent maps and allocation tables for consistency. check whether the alias metadata directory and file directory are linked correctly. -Check that ASM metadata directories do not have unreachable allocated blocks. Which command accomplishes these tasks（）？A ALTER DISKGROUP data CHECKB ALTER DISKGROUP data CHECK DISKC ALTER DISKGROUP data CHECK FILED ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1
单选题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？（）Amount the new disk group in the ASM instanceBrestart the ASM instance and the production database instanceCregister the new disk groups in the production database instanceDrestart the ASM instance without restarting the production database instanceEinclude the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance
单选题Consider the following scenario： You have a directory， data， under the disk group tdgroupA. You want to create an alias for one of the data files and you execute the following command： ALTER DISKGROUP tdgroupA ADD ALIAS ’+tdgroupA/data/datafile.dbf’ FOR ’+tdgroupA.231.45678’； Which task would be accomplished by the command？（）AThe command drops the file +tdgroupA·231.45678.BThe command physically relocates the file to +tdgroupA/data and renames the file to datafile.dbf.CThe command creates a copy of the +tdgroupA·231.45678 file and places it in +tdgroupA/data after renaming the file to datafile.dbf.DThe command creates an alias， datafile.dbf， and places it in +tdgroupA/data and does not remove the +tdgroupA·231.45678 file.EThe command creates a file， datafile.dbf， in +tdgroupA/data and removes the references for +tdgroupA·231.45678 from the data dictionary views.
单选题You issued the following command to mount the DATA disk group in restricted mode： ALTER DISKGROUP data MOUNT RESTRICT； What is the implication of this command？（）A The client RDBMS instance can access the file as a read-only file.B A new disk cannot be added to a disk group.C A disk in a disk group can be taken offline.D The client RDBMS instance cannot access the files in the disk group.
单选题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 ASMBB ARBnC RBAL in the ASM instanceD RBAL in the database instance