首页计算机考试Oracle认证
(多选题)

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

正确答案

来源:www.examk.com

答案解析

相似试题

  • (单选题)

    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? ()

    答案解析

快考试在线搜题