Online Access Free 1Z0-035 Practice Test

You decide to activate the resumable space allocation feature for all your database users by enabling the feature in a logon trigger. This causes a statement that requires space beyond a user's quota _____.

• A.to wait in a suspended state until the quota is increased or until the timeout value is reached
• B.to fail because quota limits do not activate the resumable space allocation feature
• C.to wait indefinitely for the quota to be increased, regardless of the timeout setting for other space allocation problems.
• D.to invoke the default trigger that resets user quota, if there is free space in the related tablespace

What is true regarding fact tables having bitmap join indexes defined on them?

• A.You cannot have more than one dimension table being part of the join condition of a bitmap join index definition.
• B.You can create a bitmap join index on an index-organized table.
• C.Tables participating in the join condition of the bitmap join index definition cannot be updated concurrently.
• D.You can create a bitmap join index on a temporary table.

Which three resource plan parameters are used to enable Automatic Consumer Group Switching to estimate job execution times automatically, and to perform a switch to a low priority consumer group before they are initiated? (Choose three.)

• A.MAX_SESS_POOL
• B.SWITCH_GROUP
• C.SWITCH_ESTIMATE
• D.SWITCH_TIME

Before adding a nonstandard block size to your database, which preparatory task must you complete?

• A.Rebuild the control file using an instance with an initialization file containing two DB_nK_CACHE_SIZE parameters, one for the standard and one for the new block size.
• B.Define a new buffer pool by setting the DB_nK_CACHE_SIZE parameter where n is the new block size.
• C.Rebuild the control file using an instance with an initialization file containing two DB_BLOCK_SIZE parameters, one for the standard and one for the new block size.
• D.Redefine the buffer pool by setting the DB_mK_CACHE_SIZE and DB_nK_CACHE_SIZE parameters, where m is the standard block size and n is the new block size.

What is the benefit of the Cached Execution Plan feature?

• A.The SQL statement no longer needs to be cached in the library cache.
• B.SQL statement performance is improved.
• C.The execution plan is available for diagnosis after the SQL statement is aged out of the library cache.
• D.Improved diagnosability, as the execution plan of a cached SQL statement in memory is preserved.