itgle.com

Which three statements must be true before transporting a tablespace from a database on one platform to a database on another platform?()A. Both source and target database must be the same character setB. Both source and target database must have the same

题目
Which three statements must be true before transporting a tablespace from a database on one platform to a database on another platform?()

A. Both source and target database must be the same character set

B. Both source and target database must have the same endian format

C. The COMPATIBLE parameter must be the same in the source and target databases.

D. The minimum compatibility level for both the source and target database must be 10.0.0.

E. All read-only and offline data files that belong to the tablespace to be transported must be platform aware.

相似考题

1.You are a database administrator in the Los Angeles branch office of a specialty foods supplier. A mainframe. database at the headquarters contains all company data. Each branch office contains a SQL Server 2000 computer that imports regional data from the mainframe. database.The server in Los Angeles contains a Data Transformation Services (DTS) package that uses OLE DB to connect to the company's mainframe. database. The DTS package extracts and transforms data about buyers and products for that region. The DTS package then writes the data to the SQL Server database in Los Angeles.You need to configure a SQL Server computer for the new branch office in Sydney. You want to copy the Los Angeles package and modify it so that it writes data to the SQL Server database in Sydney.You use the DTS Designer to modify the DTS package so that it imports regional data from the mainframe. database to the server in Sydney. The modified DTS package runs successfully on the server in Los Angeles. You save this DTS package to the server in Sydney, but the server in Sydney cannot connect to the mainframe. database.You want to enable the server in Sydney to connect to the mainframe. database. What should you do?A．Change the connection properties in the DTS package so that the package uses new login credentials to connect to the mainframe. database.B．Modify the workflow in the DTS package so that the server in Sydney is included.C．On the server in Sydney, install an OLE DB provider for the mainframe. database.D．On the server in Sydney, delete and then re-create the DTS package.

2.Youhavecreatedascriptintherecoverycatalogcalledbackup_database.Whichofthefollowingcommandswouldsuccessfullyexecutethatscript?()A.run{openscriptbackup_database；runscriptbackup_database}B.run{engagescriptbackup_database；}C.run{runscriptbackup_database；}D.Run{executescriptbackup_database；}E.Thenamebackup_databaseisaninvalidnameforanRMANscript.TryingtorunitfromRMAN wouldresultinanerror.

3.Thefollowingquerywillprovidewhatinformationabouttransportabletablespacesforthecurrentdatabase？（）selectd.platform_name"Source"，t.platform_name"CompatibleTargets"，endian_formatfromv$transportable_platformt，v$databasedwheret.endian_format=（selectendian_formatfromv$transportable_platformt，v$databasedwhered.platform_name=platform_name）；A.ThelistoftargetplatformshavingthesameendianformatasthesourcedatabaseB.ThelistoftargetplatformsrequiringendianconversionC.ThelistoftargetplatformsthatwillnotrequireendianconversionD.ThelistofalltargetplatformsthatcanreceivetransportabletablespacesfromthesourcedatabaseE.Noneoftheabove

4.YouareplanningtoimportcustomerdatafromtheCustomertableandtheCountrytableinyourSQLServer2000databaseintoaSQLServer2005database.Youwanttoensurethatduringtheimportprocess，eachvalueintheCountryCodecolumnoftheCustomertablehasacorrespondingrecordintheCountryCodecolumnintheCountrytableoftheSQLServer2005database.Youdefineaforeignkeybetweenthesetwotables.Thus，referentialintegritywillguaranteethattheimportroutinefailsifthereareanyrecordswhereaCountryCodevaluedoesnotexistintheCountrytablebutdoesexistintheCustomertable.YouneedtoensurethattheimportprocessdoesnotfailifrecordsareencounteredthatdonotexistintheCountrytable.Whatshouldyoudo？（）

更多“Which three statements must be true before transporting a tablespace from a database on one platform to a database on another platform?() ”相关问题

  • 第1题：

    You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.You issue the following statements:SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;For which database users is the audit policy now active?（）

    A. All users except SYS

    B. All users except SCOTT

    C. All users except sys and SCOTT

    D. All users except sys, system, and SCOTT


    参考答案：B

  • 第2题：

    Marrywantstocreateanewapplicationonhislaptopthatdoesnothaveanydesignelementsinit.Whichoneofthefollowingshouldhedotobeginhisprocess?()

    A.selectfile->Database->newandgiveitafilenameof“blank.nsf”

    B.selectfile->Database->new,chooselocalastheserver,andchosetheblanktemplate

    C.selectfile->Database->new,chooselocalastheserver,andchosethedefault.ntftemplate

    D.selectfile->Database->new,giveitafilenameof“blank.nsf”,andchosetheblanktemplate


    参考答案：B

  • 第3题：

    WhichfourstatementsaboutEthernetvirtualcircuit(EVC)infrastructurearetrue?()

    A.EVCinfrastructureisaLayer3platform-independentroutingarchitecturethatsupportsIPoverEthernetservices

    B.Ethernetflowpoint（EFP）isconfiguredonthemaininterface

    C.FeaturecommandslikeMQC-basedQoSpoliciescanbespecified

    D.EVCinfrastructureisaLayer2platform-independentbridgingarchitecturethatsupports Ethernetservices

    E.EachEthernetflowpoint（EFP）matchesapredefinedVLANtag-basedcriteria

    F.Ethernetflowpoint（EFP）isconfiguredontheVLANinterface


    参考答案：B, D, E, F

  • 第4题：

    以下对枚举类型名的定义中正确的是______。

    A．enum a={one,two,three}；

    B．enum a{one=9，two=-1,three}；

    C．enum a={"one"，"two"，"three"};

    D．enum a{"one"，"two"，"three"}；


    正确答案：B
    解析：声明枚举类型用enum开头。例如：enum weekday(sun,mon,tue,wed,thu,fri,sat)； 说明：1、在C编译中，对枚举元素按常量处理，同时可以改变他们的值。2、枚举值可以用来做判断比较。3、一个整数不能直接赋给一个枚举变量。

  • 第5题：

    Anadministratorisplanningaclusterrunningapplicationsin3separateresourcegroups.RGA-Database1RGB-WebServerRGC-Database2Database1andDatabase2mustbeonlinebeforetheWebServer.AllresourcegroupshaveaStartupPolicyofOnlineonHomeNodeOnly.Whichofthefollowingwillensurethattheresourcegroupsareprocessedinthecorrectorder？（）

    A.SettheSerialAcquisitionOrder

    B.SettheParallelAcquisitionOrder

    C.ConfigureOnlineontheSameNodeDependency

    D.ConfigureOnlineonDifferentNodesDependency


    参考答案：A

  • 第6题：

    Her speciality is heart surgery.

    A:region
    B:site
    C:field
    D:platform

    答案：C
    解析：

相关内容