Which two are valid locking levels that are used by transactions in an Oracle database？（）A、row levelB、block levelC、object levelD、schema levelE、database level

题目

Which two are valid locking levels that are used by transactions in an Oracle database？（）

  • A、row level
  • B、block level
  • C、object level
  • D、schema level
  • E、database level
相似考题

1.The DB_BLOCK_CHECKING initialization parameter is set to OFF.Which block checking would be performed?()A. The Oracle database will perform block checking for the index blocks onlyB. The Oracle database will not perform block checking for any of the data blocksC. The Oracle database will perform block checking for the default permanent tablespace onlyD. The Oracle database will perform block checking for the data blocks in all user tablespacesE. The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only

2.Scalability is provided in the server farm module by which of the following design strategies?()A. up to 10Gbps of bandwidth at the access levelB. redundant servers at the access levelC. modular block design at the access levelD. high port densities at the access level

3.The most commonly used locking level in implementing concurrency control is at which of the following levels?A．databaseB．tableC．recordD．field

4.Examine the following scenario:The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows:Which statement is true about the duplicate database in this scenario?（）A. It contains data till the last backupB. It contains all data from target database until the current timeC. It contains all data from only the committed transactions in the target databaseD. It contains all data except that which is used by the transactions in the current online redo file of target database

更多“Which two are valid locking levels that are used by transactions in an Oracle database？（）A、row levelB、block levelC、object levelD、schema levelE、database level”相关问题

  • 第1题：

    Ifa teacher asks students to fill in the blanks in a passage with "that", "which" or "whom",he/she is least likely focusing on grammar at_________．


    A.lexical level

    B.syntactic level

    C.discourse level

    D.morphological level

    答案：D
    解析：
    考查语法教学内容。题干意思是：如果教师让学生用that／which／whom进行填空，那么他／她最不可能关注语法的哪个层面lexical level“词汇层面”，syntactic level“句法层面”，discourse level“语篇层面”．morphological level“形态学层面”。语法教学的内容不仅包括语言形式／结构，还包括语意和语用。语言形式／结构包括词法、句法等；语意包括语法形式与结构的意义；语用指语言在一定的语境、语篇中的表意功能。该教师让学生选择关系代词填空，目的是让学生掌握定语从句这项语法的形式、意义和运用。形态学是研究词的内部结构和构词规则的科学。故选D。

  • 第2题：

    If a teacher asks students to fill in the blanks in a passage with "that", "which" or "whom",he/she is least likely focusing on grammar at __________.


    A.lexical level

    B.syntactic level

    C.discourse level

    D.morphological level

    答案：D
    解析：
    考查语法教学内容。题于意思是：如果教师让学生用that／which／whom进行填空，那么他／她最不可能关注语法的哪个层面lexical level“词汇层面”，syntactic level“句法层面”，discourse level“语篇层面”．morphological level“形态学层面”。语法教学的内容不仅包括语言形式／结构，还包括语意和语用。语言形式／结构包括词法、句法等；语意包括语法形式与结构的意义；语用指语言在一定的语境、语篇中的表意功能。该教师让学生选择关系代词填空．目的是让学生掌握定语从句这项语法的形式、意义和运用。形态学是研究词的内部结构和构词规则的科学。故选D。

  • 第3题：

    Scalability is provided in the server farm module by which of the following design strategies？（）

    • A、 up to 10 Gbps of bandwidth at the access level
    • B、 redundant servers at the access level
    • C、 modular block design at the access level
    • D、 high port densities at the access level

    正确答案:C

  • 第4题：

    At which level do Commodity Codes exist within IBM Maximo Asset Management V6.2？ （）

    • A、 Set level
    • B、 Site level
    • C、 System level
    • D、 Organization level

    正确答案:A

  • 第5题：

    The DB_BLOCK_CHECKING initialization parameter is set to OFF. 数据库块检测初始化参数被设定为关  Which block checking would be performed?（）

    • A、The Oracle database will perform block checking for the index blocks only 
    • B、The Oracle database will not perform block checking for any of the data blocks 
    • C、The Oracle database will perform block checking for the default permanent tablespace only 
    • D、The Oracle database will perform block checking for the data blocks in all user tablespaces 
    • E、The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only Oracle

    正确答案:E

  • 第6题：

    The DB_BLOCK_CHECKING initialization parameter is set to OFF. Which block checking would be performed？（）  

    • A、 The Oracle database will perform block checking for the index blocks only
    • B、 The Oracle database will not perform block checking for any of the data blocks
    • C、 The Oracle database will perform block checking for the default permanent tablespace only
    • D、 The Oracle database will perform block checking for the data blocks in all user tablespaces
    • E、 The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only

    正确答案:E

  • 第7题：

    You receive complaints from users regarding the high waiting time for their transactions. Oninvestigation， you find that some users are not committing their transactions though they are  notperforming any activity for a long time. As a result， SQL statements need to wait for row-level locks.  Which two actions could you take to prevent this locking problem in the future（）

    • A、Decrease the IDLE_TIME resource limit in the profile assigned to the blocking users.
    • B、Use Database Resource Manager to automatically log out sessions that block others and are idle.
    • C、Set the limit in the profile of blocking users to control the number of blocks to be accessed in a session.
    • D、Decrease the maximum number of interested transaction list （ITL） slots for the segments on which the blocking user performs the transaction

    正确答案:A,B

  • 第8题：

    Which two statements describe good practices for an application developer to reduce lockingconflicts in Oracle database（）

    • A、Avoid coding unnecessary long-running transactions.
    • B、Allow the database to handle locks in default locking mode.
    • C、Always explicitly code the locks as per the requirement of the application.
    • D、Allow escalation of row locks to block locks if too many row locks cause problem.

    正确答案:A,B

  • 第9题：

    多选题
    Which two statements are true regarding transactions in an Oracle database（）
    A

    Multiple transactions can use the same undo segment.

    B

    A transaction is assigned an undo segment when it is started.

    C

    More than one transaction cannot share the same extent in the undo tablespace.

    D

    The transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.


    正确答案： B,D
    解析： 暂无解析

  • 第10题：

    单选题
    With which level in IBM Maximo Asset Management V6.2 are Purchase Contracts associated？ （）
    A

     Set Level

    B

     System Level

    C

     Database Level

    D

     Organization Level


    正确答案： A
    解析： 暂无解析

  • 第11题：

    多选题
    Which two are valid locking levels that are used by transactions in an Oracle database？（）
    A

    row level

    B

    block level

    C

    object level

    D

    schema level

    E

    database level


    正确答案： D,E
    解析： 暂无解析

  • 第12题：

    单选题
    The DB_BLOCK_CHECKING initialization parameter is set to OFF. Which block checking would be performed？（）
    A

     The Oracle database will perform block checking for the index blocks only

    B

     The Oracle database will not perform block checking for any of the data blocks

    C

     The Oracle database will perform block checking for the default permanent tablespace only

    D

     The Oracle database will perform block checking for the data blocks in all user tablespaces

    E

     The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only


    正确答案： B
    解析： 暂无解析

  • 第13题：

    When teaching students how to give appropriate responses to a congratulation or an apology,the teacher is probably teaching at _________.


    A.lexical level

    B.sentence level

    C.grammatical level

    D.discourse level

    答案：D
    解析：
    考查语篇教学。题干的意思是当教给学生如何对祝贺和道歉进行合适的回应时，老师可以以下哪个层次进行教学。A项是词汇层次，B项是句式层次，C项是语法层次，D项是话语(语篇)层次。祝贺和道歉属于交流，是语言功能的运用，通过话语层次教学，可以有利于学生经历真实语境，提高语言运用的准确性。故选D。

  • 第14题：

    With which level in IBM Maximo Asset Management V6.2 are Purchase Contracts associated？ （）

    • A、 Set Level
    • B、 System Level
    • C、 Database Level
    • D、 Organization Level

    正确答案:D

  • 第15题：

    Scalability is provided in the server farm module by which of the following design strategies?（）

    • A、up to 10Gbps of bandwidth at the access level
    • B、redundant servers at the access level
    • C、modular block design at the access level
    • D、high port densities at the access level

    正确答案:C

  • 第16题：

    The DB_BLOCK_CHECKING initialization parameter is set to FALSE. What level of block checking would be performed？（）

    • A、 The Oracle database will not perform block checking for any of the data blocks.
    • B、 The Oracle database will perform block checking for the default permanent tablespace only. 
    • C、 The Oracle database will perform block checking for the data blocks in all user tablespaces.
    • D、 The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only.
    • E、 The Oracle database will perform block checking for the data blocks in the SYSTEM and SYSAUX tablespaces.

    正确答案:D

  • 第17题：

    You are creating a form that will access an Oracle8 database. On which three sources can you base a data block?（）

    • A、BFILE 
    • B、REF column 
    • C、Object table 
    • D、Column object 
    • E、INSTEAD-OF trigger

    正确答案:B,C,D

  • 第18题：

    Examine the following command used to perform incremental level 0 backup：   RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE；   To enable the block change tracking， after the incremental level 0 backup you issued the following command：   SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ’/mydir/ rman_change_track.f’；To perform incremental level 1 cumulative backup， you issued the following command：   RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE；   Which two statements are true in the above situation？（）

    • A、 The block change tracking data will be used only from the next incremental 0 backup.
    • B、 The incremental backup will use change tracking data for accomplishing the backup.
    • C、 The incremental backup will not use change tracking data for accomplishing the backup.
    • D、 The block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.

    正确答案:A,C

  • 第19题：

    Which two statements are true regarding transactions in an Oracle database（）

    • A、Multiple transactions can use the same undo segment.
    • B、A transaction is assigned an undo segment when it is started.
    • C、More than one transaction cannot share the same extent in the undo tablespace.
    • D、The transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.

    正确答案:A,B

  • 第20题：

    单选题
    Scalability is provided in the server farm module by which of the following design strategies？（）
    A

     up to 10 Gbps of bandwidth at the access level

    B

     redundant servers at the access level

    C

     modular block design at the access level

    D

     high port densities at the access level


    正确答案： B
    解析： 暂无解析

  • 第21题：

    单选题
    The DB_BLOCK_CHECKING initialization parameter is set to OFF. 数据库块检测初始化参数被设定为关  Which block checking would be performed?（）
    A

    The Oracle database will perform block checking for the index blocks only 

    B

    The Oracle database will not perform block checking for any of the data blocks 

    C

    The Oracle database will perform block checking for the default permanent tablespace only 

    D

    The Oracle database will perform block checking for the data blocks in all user tablespaces 

    E

    The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only Oracle


    正确答案： D
    解析： 暂无解析

  • 第22题：

    单选题
    The DB_BLOCK_CHECKING initialization parameter is set to FALSE. What level of block checking would be performed？（）
    A

     The Oracle database will not perform block checking for any of the data blocks.

    B

     The Oracle database will perform block checking for the default permanent tablespace only. 

    C

     The Oracle database will perform block checking for the data blocks in all user tablespaces.

    D

     The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only.

    E

     The Oracle database will perform block checking for the data blocks in the SYSTEM and SYSAUX tablespaces.


    正确答案： E
    解析： 暂无解析

  • 第23题：

    单选题
    At which level do Commodity Codes exist within IBM Maximo Asset Management V6.2？ （）
    A

     Set level

    B

     Site level

    C

     System level

    D

     Organization level


    正确答案： A
    解析： 暂无解析

相关内容