单选题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’ 

题目
单选题
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.

相似考题

1.You issued the following commands to configure setting in RMAN;Then you issued the following command to take the backup:RMAN> BACKUP DATABASE PLUS ARCHIVELOG;Which statement is true about the execution of the above command?（）A. The backup will terminate because the FORMAT clause was not configured for the channelB. It backs up two copies of data files to tape and disk, and two copies of archived log file on tapeC. It backs up the data files and archived log files to disk, making two copies of each data file and archived log fileD. It backs up the data files and archived log files to tape, making two copies of each data file and archived log file

2.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;

3.You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database.You executed the following RMAN commands:What are the implications of this command?（）A. It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.B. It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.C. It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.D. It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.

4.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

更多“单选题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’  ”相关问题

  • 第1题：

    Considerthefollowingscenario：Youhaveadirectory，data，underthediskgrouptdgroupA.Youwanttocreateanaliasforoneofthedatafilesandyouexecutethefollowingcommand：ALTERDISKGROUPtdgroupAADDALIAS’+tdgroupA/data/datafile.dbf’FOR’+tdgroupA.231.45678’；Whichtaskwouldbeaccomplishedbythecommand？（）

    A.Thecommanddropsthefile+tdgroupA·231.45678.

    B.Thecommandphysicallyrelocatesthefileto+tdgroupA/dataandrenamesthefiletodatafile.dbf.

    C.Thecommandcreatesacopyofthe+tdgroupA·231.45678fileandplacesitin+tdgroupA/dataafterrenamingthefiletodatafile.dbf.

    D.Thecommandcreatesanalias，datafile.dbf，andplacesitin+tdgroupA/dataanddoesnotremovethe+tdgroupA·231.45678file.

    E.Thecommandcreatesafile，datafile.dbf，in+tdgroupA/dataandremovesthereferencesfor+tdgroupA·231.45678fromthedatadictionaryviews.


    参考答案：D

  • 第2题：

    You are the administrator of a SQL Server 2000 computer. You are creating a data transformation services package. As the first step in this process, you need to load data from text files into a database table. These text files contain data on new stores that join your franchise. The text files list the data columns in the following format StoreID, StoreName, Address, City, State, PostalCode, ManagerID, StoreTypeID, FacilityID.

    The destination table is configured as shown in the exhibit.

    You want to load the data into the table as quickly as possible. What should you do?

    A．Use a Bulk Insert Task to read the data into a temporary table. Use an Execute SQL task to import the appropriate data into the destination table.

    B．Create and edit a format file to select the columns you want to import. Use a Bulk Insert Task, and then specify the format file to import the appropriate data into the destination table.

    C．Use a transform. data task to import the data. Use Microsoft ActiveX transformation scripts to write the appropriate data to the appropriate columns in the destination table.

    D．Create and edit a format file to select the columns you want to import. Use a transform. data task, and then specify the format file to import the appropriate data into the destination table.


    正确答案：B
    解析：Explanation:TheBulkInsertTaskisthefastestmechanismforcopyinglargeamountsofdataintoaSQLServer2000tableorview.However,transformationscannotbeperformedonthedatawhileitismovedfromthesourcefiletothetableorview,asthiswouldslowdownthedatacopyprocess.ThusthetextfilemustbeformattedbeforetheBulkInsertTaskisused.TheformatfileprovidesthedefaultinformationusedeithertobulkcopythedatainthedatafileintoaninstanceofSQLServer2000ortobulkcopydataoutfromthetable.TheformatfilealsoprovidesawaytobulkcopydataselectivelyfromadatafiletoaninstanceofSQLServer.Thisallowsforthetransferofdatatoatablewhenthereisamismatchbetweenfieldsinthedatafileandcolumnsinthetable.Byusingaformatfile,itispossibletobulkcopydataintoaninstanceofSQLServerwithouthavingtoaddordeleteunnecessarydata,orreorderexistingdata,inthedatafile.IncorrectAnswers:A:TheBulkInsertTaskisthefastestmechanismforcopyinglargeamountsofdataintoaSQLServer2000tableorview.Itcanmakeuseofaformatfilethatallowsforthetransferofdatatoatablewhenthereisamismatchbetweenfieldsinthedatafileandcolumnsinthetable.Byusingaformatfile,itispossibletobulkcopydataintoaninstanceofSQLServerwithouthavingtoaddordeleteunnecessarydata,orreorderexistingdata,inthedatafile.Itthusmakestheneedtofirstimportthedataintoatemporarytableobsolete.C:TheTransform.Datataskisusedtocopydatabetweenasourceanddestinationandtooptionallyapplycolumn-leveltransformationstothedata.TheTransform.DatataskisthemostbasicimplementationofthedatapumpengineinDataTransformationServices(DTS)andisoptimizedforinsert-basedcopyingandtransformingofcolumn-leveldatabetweencommercialdatabases,spreadsheets,andtextfiles.However,theBulkInserttaskprovidesthebestperformanceforbulkinsertingtextfilesintoSQLServer2000,althoughitcannotbeusedtotransform.data.D:TheBulkInsertTaskisthefastestmechanismforcopyinglargeamountsofdataintoaSQLServer2000tableorview.Itcanmakeuseofaformatfilethatallowsforthetransferofdatatoatablewhenthereisamismatchbetweenfieldsinthedatafileandcolumnsinthetable.Byusingaformatfile,itispossibletobulkcopydataintoaninstanceofSQLServerwithouthavingtoaddordeleteunnecessarydata,orreorderexistingdata,inthedatafile.

  • 第3题：

    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.

    正确答案:C

  • 第4题：

    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.

    正确答案:D

  • 第5题：

    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.

    正确答案:C

  • 第6题：

    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 offline
    • B、 when one or more ASM files are dropped
    • C、 when some disks in a disk group are offline
    • D、 when some disks in a failure group for a disk group are rebalancing

    正确答案:C

  • 第7题：

    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.

    正确答案:D

  • 第8题：

    单选题
    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 offline

    B

    when one or more ASM files are dropped

    C

    when some disks in a disk group are offline

    D

    when some disks in a failure group for a disk group are rebalancing


    正确答案： C
    解析： 暂无解析

  • 第9题：

    单选题
    You issued the following commands to configure setting in RMAN; Then you issued the following command to take the backup: RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Which statement is true about the execution of the above command?（）
    A

    The backup will terminate because the FORMAT clause was not configured for the channel

    B

    It backs up two copies of data files to tape and disk, and two copies of archived log file on tape

    C

    It backs up the data files and archived log files to disk, making two copies of each data file and archived log file

    D

    It backs up the data files and archived log files to tape, making two copies of each data file and archived log file


    正确答案： D
    解析： 暂无解析

  • 第10题：

    单选题
    You are managing an ASM instance. You previously issued the following statements：   ALTER DISKGROUP dg1 DROP DISK disk2；  ALTER DISKGROUP dg1 DROP DISK disk3；  ALTER DISKGROUP dg1 DROP DISK disk5；   You want to cancel the disk drops that are pending for the DG1 disk group.  Which statement should you issue？（）
    A

     ALTER DISKGROUP dg1 UNDROP disk2，disk3，disk5

    B

     ALTER DISKGROUP dg1 UNDROP

    C

     ALTER DISKGROUP dg1 UNDROP DISKS

    D

     You cannot cancel the pending disk drops


    正确答案： B
    解析： 暂无解析

  • 第11题：

    单选题
    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 CHECK

    B

     ALTER DISKGROUP data CHECK DISK

    C

     ALTER DISKGROUP data CHECK FILE

    D

     ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1


    正确答案： B
    解析： 暂无解析

  • 第12题：

    单选题
    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.


    正确答案： D
    解析： 暂无解析

  • 第13题：

    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 container

    B. 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$SEED

    D. Data files that belong to the root container and all the PDBs excluding PDB$SEED


    参考答案：B

  • 第14题：

    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.

    正确答案:C

  • 第15题：

    Consider the following command to add a new disk group called "tdgroupA" with two failover groups： CREATE DISKGROUP tdgroupA NORMAL REDUNDANCY FAILOVERGROUP control01 DISK ’/devices/A1’，  ’/devices/A2’，  ’/devices/A3’  FAILOVERGROUP control02 DISK ’/devices/B1’，  ’/devices/B2’，  ’/devices/B3’m  The disk "/devices/A1" is currently a member disk of a disk group by the name "tdgroup1".  Which task would be accomplished by the command？（）

    • A、 This command would result in an error because a disk group can have only one failover group.
    • B、 This command would result in an error because the /devices/A1 disk is a member of another disk group tdgroup1.
    • C、 A new disk group called tdgroupA will be added with two failover groups and the /devices/A1 disk will get reattached to the new disk group without being detached from the existing one.
    • D、 A new disk group called tdgroupA will be added with two failover groups and the /devices/A1 disk will be ignored for the new disk group because it is a member of an existing disk group tdgroup1.
    • E、 A new disk group called tdgroupA will be added with two failover groups and the /devices/A1 disk gets detached from the existing disk group tdgroup1 and attached to the new disk group tdgroupA

    正确答案:B

  • 第16题：

    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 opened
    • B、All redo files are opened
    • C、The password file is opened
    • D、The parameter file is opened
    • E、All online data files are opened

    正确答案:B,E

  • 第17题：

    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 container
    • B、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$SEED
    • D、Data files that belong to the root container and all the PDBs excluding PDB$SEED

    正确答案:B

  • 第18题：

    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 CHECK
    • B、 ALTER DISKGROUP data CHECK DISK
    • C、 ALTER DISKGROUP data CHECK FILE
    • D、 ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1

    正确答案:A

  • 第19题：

    单选题
    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 offline

    B

     when one or more ASM files are dropped

    C

     when some disks in a disk group are offline

    D

     when some disks in a failure group for a disk group are rebalancing


    正确答案： B
    解析： 暂无解析

  • 第20题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第21题：

    单选题
    Consider the following command to add a new disk group called "tdgroupA" with two failover groups： CREATE DISKGROUP tdgroupA NORMAL REDUNDANCY FAILOVERGROUP control01 DISK ’/devices/A1’，  ’/devices/A2’，  ’/devices/A3’  FAILOVERGROUP control02 DISK ’/devices/B1’，  ’/devices/B2’，  ’/devices/B3’m  The disk "/devices/A1" is currently a member disk of a disk group by the name "tdgroup1".  Which task would be accomplished by the command？（）
    A

     This command would result in an error because a disk group can have only one failover group.

    B

     This command would result in an error because the /devices/A1 disk is a member of another disk group tdgroup1.

    C

     A new disk group called tdgroupA will be added with two failover groups and the /devices/A1 disk will get reattached to the new disk group without being detached from the existing one.

    D

     A new disk group called tdgroupA will be added with two failover groups and the /devices/A1 disk will be ignored for the new disk group because it is a member of an existing disk group tdgroup1.

    E

     A new disk group called tdgroupA will be added with two failover groups and the /devices/A1 disk gets detached from the existing disk group tdgroup1 and attached to the new disk group tdgroupA


    正确答案： A
    解析： 暂无解析

  • 第22题：

    单选题
    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 （usder_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.


    正确答案： C
    解析： 暂无解析

  • 第23题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

  • 第24题：

    单选题
    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.


    正确答案： D
    解析： 暂无解析

相关内容