单项选择题

A.It terminates all user sessions.B.It prevents users f……

You executed the following command in the lsnrctl utility to stop the listener： lsnrctl> STOP L1
What is the effect of this command if L1 is the only listener configured for your database？（）

A.It terminates all user sessions.
B.It prevents users from logging in to the database remotely.
C.It halts the server until all user transactions are completed.
D.The server hangs， so users will receive an error asking them to login again.
E.Connected users would get an error with the message "End of communication channel".

<上一题目录下一题>

热门试题

单项选择题You have a production instance running on your server. UNDO_RETENTION is not long enough to satisfy read-consistency requirements. How do you change the UNDO_RETENTION value？（）

A.A
B.B
C.C
D.D

多项选择题Inwhichtwocaseswouldyouperformonlyconsistentbackup？（）

A.You are working on a database where downtime is not tolerated.
B.You are working on a database where downtime can be tolerated.
C.You are working on a database that operates in ARCHIVELOG mode.
D.You are working on a database that operates in NOARCHIVELOG mode.
E.You are working on a database where all the tablespaces are locally managed.
F.You are working on a database where control files and redo log files are multiplexed.
G.You are working on a database where control files and redo log files are not multiplexed.

单项选择题DuetomediafailureyoulostoneofthedatafilesbelongingtotheUSERStablespace，andthetablespaceisnotavailabletouse.Whichstatementregardingthestatusofthedatabaseistrue？（）

A.The database remains open.
B.The database gets dismounted.
C.The database becomes read only.
D.The database instance gets aborted.
E.The database gets shut down automatically.
F.The status of the database depends on the status of the USERS tablespace.

多项选择题OnwhichthreecanyouuseRecoveryManager（RMAN）toperformincrementalbackup？（）

A.data files
B.control files
C.tablespaces
D.password file
E.parameter file
F.whole database
G.flashback log file
H.archived log files
I.change tracking file

单项选择题Asadatabaseadministratoryouspendalotoftimeobservingandsettingvariousstorageparametervaluesforyourapplicationtablesinordertogainperformancebenefits.Whichtaskwouldyouperformtoreducethisoverhead？（）

A.Coalesce the application tables at a regular interval.
B.Export and Import the application tables a regular interval.
C.Drop and recreate the application tables at a regular interval.
D.Move the application tables to a tablespace with less space usage.
E.Distribute the application tables across multiple tablespaces depending on usage.
F.Move the application tables to automatic segment space management tablespace.