A.DROP USER SMITH; B.DROP TABLE EMPLOYEES; C.DROP TABLESPACE USERS; D.ALTER TABLE SALES_REP DROP PARTITION P1; E.ALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID;
单项选择题Yourdatabaseishavingtwocontrolfiles,threeredologfilegroupswithtwomembersineachgroup.Failureofwhichfilewouldcauseaninstancetoshutdown?()
A.any control file B.any archive log file C.one of the redo log members D.loss of the initialization parameter file E.any data file belonging to the default permanent tablespac
单项选择题Youhavebeenrecentlyhiredasadatabaseadministrator.YourseniormanagerasksyoutostudytheproductiondatabaseserverandsubmitareportonthesettingsdonebythepreviousDBA.Whileobservingtheserversettings,youfindthatthefollowingparameterhasbeensetintheparameterfileofthedatabase:REMOTE_OS_AUTHENT=TRUEWhatcouldhavebeenthereasontosetthisparameterasTRUE?()
A.to enable operating system authentication for a remote client B.to restrict the scope of administration to identical operating systems C.to allow the start up and shut down of the database from a remote client D.to enable the administration of the operating system from a remote client E.to disable the administration of the operating system from a remote client
单项选择题Your database is open and users are connected using the LISTENER listener. The new DBA of the system stops the listener by using the following command: LSNRCTL> STOP What would happen to the sessions that are presently connected to the database instance?()
A.The sessions are able to perform only queries. B.The sessions are not affected and continue to function normally. C.The active transactions are rolled back and the sessions get terminated. D.The sessions are not allowed to perform any operations till the listener is started.
单项选择题Youcreatedaresponsefileandwanttocheckitbeforestartinginstallationsinsilentmode.YoustartedinstallationofOraclesoftwareininteractivemodebyprovidingtheresponsefile.Inthemiddleoftheinstallation,yourealizethatthebehavioroftheOracleUniversalInstaller(OUI)isnotconsistentwiththeresponsefile.Whatactionwouldyoutaketodetectthecauseofthisbehavior?()
A.Compare the contents of the install.log file with the response file. B.Refer to the contents of the oraInst.loc file to verify the steps performed by OUI. C.Compare the contents of the installActions.log file with that of the response file. D.Refer to the alert log file for information regarding the actions performed by OUI during installation.
单项选择题Youbackedupthecontrolfiletotrace.Whichstatementistrueaboutthetracefilegenerated?()
A.The trace file is in binary format. B.The trace file has a SQL script to re-create the control file. C.The trace file is a backup set created during the backup of the control file. D.The trace file contains the instructions to manually re-create the control file. E.The trace file is an image copy of the control file created during the backup of the control file.