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?()
Anull lock on the row being updated
Bnull lock on the table containing the row
CROW SHARE lock for the row being updated
DROW EXCLUSIVE lock for the row being updated
Eshared row-exclusive lock for the row being updated
Fa shareable table lock for the table containing the row
Gexclusive table-level lock for the table containing the row
正确答案
答案解析
相似试题
(单选题)
What will be the result of using the SQL> DROP USER SCOTT CASCADE; command?()
(多选题)
User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?()
(单选题)
Which of the following roles must be granted to a user to perform a full database import?()
(单选题)
The DBA issues this SQL command:CREATE USER scott IDENTIFIED by tiger;What privileges does the user Scott have at this point?()
(单选题)
The DBA issues this SQL command: CREATE USER scott IDENTIFIES by tiger; What privileges does the user Scott have at this point? ()
(单选题)
The DBA issues this SQL command: CREATE USER scott IDENTIFIED by tiger; What privileges does the user Scott have at this point?()
(单选题)
The DBA issues this SQL command: CREATE USER scott IDENTIFIES by tiger; What privileges does the user Scott have at this point?()
(单选题)
You are specifying French case-insensitive sorts by using the NSL_SORT parameter for the user session of the user, Scott. Which value will you set for the NLS_SORT parameter?()
(单选题)
In order to find out how many database objects a user has created, which view would the DBA query in the Oracle data dictionary? ()