1z0-043

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

第2题：

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

第3题：

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

第4题：

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

第5题：

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.

第6题：

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.


参考答案：B

第7题：

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

第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题：

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

第10题：

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

更多相关问题
相关内容