网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)

You are managing the APPPROD database as a DBA. You plan to duplicate this database in the same system with the name DUPDB.You issued the following RMAN commands to create a duplicate database:Which three are the prerequisites for the successful execution of the above command?()

A. The source database should be open

B. The target database should be in ARCHIVELOG mode if it is open

C. RMAN should be connected to both the instances as SYSDBA

D. The target database backups should be copied to the source database backup directories

E. The password file must exist for the source database and have the same SYS user password as the target


参考答案

更多 “ You are managing the APPPROD database as a DBA. You plan to duplicate this database in the same system with the name DUPDB.You issued the following RMAN commands to create a duplicate database:Which three are the prerequisites for the successful execution of the above command?()A. The source database should be openB. The target database should be in ARCHIVELOG mode if it is openC. RMAN should be connected to both the instances as SYSDBAD. The target database backups should be copied to the source database backup directoriesE. The password file must exist for the source database and have the same SYS user password as the target ” 相关考题
考题 下列连接字符实现与SQL Server数据库的连接,( )是不正确的。A.Driver={SQL Server}; Server=localhost; Database=stuDB; Uid=; Pwd=;B.Provider=SQLOLEDB; Data Source=localhost; Database=stuDB; Uid=abc; Pwd=12;C.Data Source=.\\SQLEXPRESS; Database=SchoolDB; Uid=abc; Pwd=;D.Driver={SQL Server 2000}; Server=localhost; Database=stuDB; Uid=abc; Pwd=123;

考题 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.

考题 YouareplanningtoimportcustomerdatafromtheCustomertableandtheCountrytableinyourSQLServer2000databaseintoaSQLServer2005database.Youwanttoensurethatduringtheimportprocess,eachvalueintheCountryCodecolumnoftheCustomertablehasacorrespondingrecordintheCountryCodecolumnintheCountrytableoftheSQLServer2005database.Youdefineaforeignkeybetweenthesetwotables.Thus,referentialintegritywillguaranteethattheimportroutinefailsifthereareanyrecordswhereaCountryCodevaluedoesnotexistintheCountrytablebutdoesexistintheCustomertable.YouneedtoensurethattheimportprocessdoesnotfailifrecordsareencounteredthatdonotexistintheCountrytable.Whatshouldyoudo?()

考题 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.

考题 ThesearethedetailsaboutV$FLASHBACK_DATABASE_STAT:SQLDESCV$FLASHBACK_DATABASE_STATNameNull?Type-----------------------------------BEGIN_TIMEDATEEND_TIMEDATEFLASHBACK_DATANUMBERDB_DATANUMBERREDO_DATANUMBERESTIMATED_FLASHBACK_SIZENUMBERWhichtwostatementsregardingtheV$FLASHBACK_DATABASE_STATviewaretrue?()A.BEGIN_TIMEisthetimeatwhichFlashbackloggingisenabled.B.END_TIMEisthetimeatwhichthequeryisexecutedontheview.C.REDO_DATAisthenumberofbytesofredodatawrittenduringtheinterval.D.Thisviewcontainsinformationaboutflashbackdatapertainingtothelast24hours.E.FLASHBACK_DATAistheamountofflashbackdatageneratedsincethedatabasewasopened.

考题 YouareworkingasaDBAatNetFxCorporation.YoudiscoverthattheSCOTTschemaisdeletedbymistake.Youdecidetoflashthedatabasebacktothetimewhentheschemaexisted.Whichviewwillyouquerytodeterminetheestimatedsizeoftheflashbackdatathatyourequireforyourcurrenttargetretention?()A.V$FLASHBACK_DATABASE_LOGB.V$FLASHBACK_DATABASE_STATC.V$DATABASED.V$UNDOSTAT

考题 You enabled an audit policy by issuing the following statements:SQL AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT;SQL AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM;For which database users and for which executions is the audit policy now active? ()A. SYS, SYSTEMB. SCOTTC. Only for successful executionsD. Only for failed executionsE. Both successful and failed executions

考题 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 SYSB. All users except SCOTTC. All users except sys and SCOTTD. All users except sys, system, and SCOTT

考题 Marrywantstocreateanewapplicationonhislaptopthatdoesnothaveanydesignelementsinit.Whichoneofthefollowingshouldhedotobeginhisprocess?() A.selectfile-Database-newandgiveitafilenameof“blank.nsf”B.selectfile-Database-new,chooselocalastheserver,andchosetheblanktemplateC.selectfile-Database-new,chooselocalastheserver,andchosethedefault.ntftemplateD.selectfile-Database-new,giveitafilenameof“blank.nsf”,andchosetheblanktemplate

考题 Anadministratorisplanningaclusterrunningapplicationsin3separateresourcegroups.RGA-Database1RGB-WebServerRGC-Database2Database1andDatabase2mustbeonlinebeforetheWebServer.AllresourcegroupshaveaStartupPolicyofOnlineonHomeNodeOnly.Whichofthefollowingwillensurethattheresourcegroupsareprocessedinthecorrectorder?()A.SettheSerialAcquisitionOrderB.SettheParallelAcquisitionOrderC.ConfigureOnlineontheSameNodeDependencyD.ConfigureOnlineonDifferentNodesDependency