多项选择题
User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not committed the transaction. What are the two types of locks that this scenario would lead to？（）
A.null lock on the row being updated
B.null lock on the table containing the row
C.ROW SHARE lock for the row being updated
D.ROW EXCLUSIVE lock for the row being updated
E.shared row-exclusive lock for the row being updated
F.a shareable table lock for the table containing the row
G.exclusive table-level lock for the table containing the row
点击查看答案
相关考题
-
多项选择题
When you try to start the Database Control by using the emctl start dbconsole command the following error is displayed： TZ set to America/New_york OC4J Configuration issue. /u01/app/oracle/product/10.1.0/db_1/oc4j/j2ee/OC4J_DBConsole_orcl.us.oracle.com not found. Which two environment variables do you need to set appropriately to avoid such errors，and start the Database Control successfully？（）
A.NLS_LANG
B.ORACLE_SID
C.ORACLE_HOME
D.ORACLE_BASE
E.LD_LIBRARY_PATH -
单项选择题
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
