You are connecting to an Oracle database server from a client by using the following connect string: SQL> CONNECT hr/hr@pdserver.us.oracle.com:1521/proddb Which naming method is being used in this case?()
A.Local Naming B.Easy Connect C.External Naming D.Directory Naming
单项选择题YouworkasadatabaseadministratorforSupportcenter.cn.Youreceivedthefollowingerrorwhileworkingonyourdatabase:ORA-01555:snapshottooold,Inwhichsituationwouldyoureceivesuchanerror?()
A.You performed rollback after commit. B.If a log switch occurs in your database. C.Thearchiverfails to generate an archived log file. D.Instance recovery fails to find one of the redo log files. E.A long-running query is unable to get read-consistent image. F.If you perform manual undo management operations in auto mode.
单项选择题YouworkasadatabaseadministratorforSupportcenter.cn.Youaddedatablespacetoyourdatabase.Becauseofthechangestothephysicalstructureofyourdatabase,youperformedabackupofthecontrolfiletotrace.Afterthis,youlostonlythecontrolfilesandtheinstanceabortedduetoahardwarefailure.Howwouldyouproceedtorecoverthedatabase?()
A.Start the instance and open the database, instance recovery automatically recoverscontrol files B.Create a file based on the contents of the trace file and save it to the control file locations and start the database C.Re-create the database (The recovery of the control file is not possible because you have lost all the control files.) D.Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file. E.Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
单项选择题YouworkasadatabaseadministratorforSupportcenter.cn.Clientconnectionrequestsarefailingbecausethelistenerisnotresponding.Youwanttoforwardclientconnectrequeststoanotherlistenerifonelistenerisnotresponding.Howdoyouachievethis?()
A.Enable instance failover B.Configure shared server C.Enable database failover D.Enable connect-time failover E.Enable Transparent Application Failover (TAF)
多项选择题YouworkasadatabaseadministratorforSupportcenter.cn.YourdatabaseisintheMOUNTstateandyouexecutethefollowingcommandtoopenitALTERDATABASEOPEN;Whattwoactionsareperformedasaresultofthiscommand?()
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
单项选择题YouworkasadatabaseadministratorforSupportcenter.cn.Yoususpectthatinoneofyourapplicationsthecustomertableisbeingaccessedbysomeunauthorizedusers.Whichoptionwouldyouusetomonitorthequeriesbeingexecutedonthecustomertable?()
A.Monitor thealert.logfile B.Enable server-side SQL tracing for user sessions C.Enable fine-grained auditing for the customer table D.Enable Fine-Grained Access Control (FGAC) for the customer table E.Write a database trigger on the customer table on the SELECT event