单项选择题
In which situation would you use the Oracle Shared Server configuration?()
A.when performing export and import using Oracle Data Pump
B.when performing backup and recovery operations using Oracle Recovery Manager
C.when performing batch processing and bulk loading operation in a data warehouse environment
D.in an online transaction processing (OLTP) system where large number of client sessions are idle most of the time
相关考题
-
单项选择题
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. -
单项选择题
You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA. While observing the server settings, you find that the following parameter has been set in the parameter file of the database: REMOTE_OS_AUTHENT = TRUE What could have been the reason to set this parameter as TRUE?()
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 -
多项选择题
Youplantousestaticdatabaseregistrationforanewlistenerwhenyoucreateit.Whatcouldbethetworeasonsforthis?()
A.More than one database is to be registered with the listener.
B.The users will connect the database by using the host naming method.
C.The Oracle Enterprise Manager is to be used to monitor an Oracle9i database.
D.The database that is to be registered with the listener is configured in shared server mode.
E.The listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.
