多选题

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? （）
单选题查看答案

语音搜题

拍照搜题

打赏

Oracle认证