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
相关考题：
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
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
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
The most commonly used locking level in implementing concurrency control is at which of the following levels?A．databaseB．tableC．recordD．field
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 levelB.syntactic levelC.discourse levelD.morphological level
When teaching students how to give appropriate responses to a congratulation or an apology,the teacher is probably teaching at _________.A.lexical levelB.sentence levelC.grammatical levelD.discourse level
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 levelB.syntactic levelC.discourse levelD.morphological level
With which level in IBM Maximo Asset Management V6.2 are Purchase Contracts associated？ （）A、 Set LevelB、 System LevelC、 Database LevelD、 Organization Level
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 levelB、 redundant servers at the access levelC、 modular block design at the access levelD、 high port densities at the access level
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
At which level do Commodity Codes exist within IBM Maximo Asset Management V6.2？ （）A、 Set levelB、 Site levelC、 System levelD、 Organization level
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.
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
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
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
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.
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
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.
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.
单选题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 levelB redundant servers at the access levelC modular block design at the access levelD high port densities at the access level
多选题Which two statements are true regarding transactions in an Oracle database（）AMultiple transactions can use the same undo segment.BA transaction is assigned an undo segment when it is started.CMore than one transaction cannot share the same extent in the undo tablespace.DThe transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.
单选题The DB_BLOCK_CHECKING initialization parameter is set to OFF. 数据库块检测初始化参数被设定为关 Which block checking would be performed?（）AThe Oracle database will perform block checking for the index blocks only BThe Oracle database will not perform block checking for any of the data blocks CThe Oracle database will perform block checking for the default permanent tablespace only DThe Oracle database will perform block checking for the data blocks in all user tablespaces EThe Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only Oracle
单选题With which level in IBM Maximo Asset Management V6.2 are Purchase Contracts associated？ （）A Set LevelB System LevelC Database LevelD Organization Level
单选题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.
多选题Which two are valid locking levels that are used by transactions in an Oracle database？（）Arow levelBblock levelCobject levelDschema levelEdatabase level
单选题At which level do Commodity Codes exist within IBM Maximo Asset Management V6.2？ （）A Set levelB Site levelC System levelD Organization level
单选题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