单项选择题
You need to rename a data file of a tablespace. How would you perform this?()
A.A
B.B
C.C
D.D
点击查看答案
相关考题
-
单项选择题
You have a listener process, L1, currently listening for the connections to the PROD and ADMIN databases. You create a new database, PAY, using CREATE DATABASE.. command. You have not enabled dynamic instance registration. You modified the LISTENER.ORA file manually to include PAY database for L1 listener process. Which command of Listener control utility (LSNRCTL) would you use to enable L1 process to start listening for the connections to the PAY database without disrupting any existing database communications?()
A.START
B.RELOAD
C.RESTART
D.REFRESH
E.START L1
F.RELOAD L1
G.RESTART L1
H.REFRESH L1 -
单项选择题
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
