单项选择题

A.The sessions are able to perform only queries.B.The s……

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.

单项选择题User A executes the following command to update the TRANS table） SQL> UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code=’C005’； Before user A issues a COMMIT or ROLLBACK command， user B executes the following command on the TRANS table： SQl> ALTER TABLE trans MODIFY （tr_type VARCHAR2 （3））； What would happen in this scenario？（）

A.The transaction for user A is rolled back.
B.The ALTER TABLE command modifies the column successfully.
C.The ALTER TABLE command fails due to the resource being busy.
D.The ALTER TABLE command waits until user A ends the transaction.

多项选择题Whichtwostatementsaboutbigfiletablespacesaretrue？（）

A.The bigfile tablespace have only one data file.
B.The segment space management is automatic.
C.The extent management is dictionary managed.
D.The database can have only one bigfile tablespace.
E.The bigfile tablespace can be converted to a smallfile tablespace.

单项选择题Whichstatementistrueaboutthelossofsystem-criticaldatafilesinARCHIVELOGmode？（）

A.The data files can be recovered till the last committed transaction.
B.The data files can be recovered without shutting down the database.
C.The data file is taken offline automatically； the database remains open.
D.The data files can be recovered to the time of the most recent backup.