Online Access Free 1Z0-035 Practice Test

The Dynamic SGA feature allows the SGA to grow and shrink dynamically according to an ALTER SYSTEM command.
This avoids the previous need of shutting down the instance in order to modify the components of the SGA, namely the buffer cache and shared pool components.
Which three statements are true for the Dynamic SGA feature? (Choose three.)

• A.The size of the SGA components is limited by the setting of SGA_MAX_SIZE parameter.
• B.The minimum SGA configuration is three granules.
• C.The size of the SGA components is set by the SGA_MAX_SIZE parameter.
• D.SGA memory is based on granules by SGA components.
• E.The maximum granule size is 4 MB.

Which two statements are true? (Choose two.)

• A.Composite partitioning supports composite- partitioned global indexes.
• B.Composite partitioning supports local indexes.
• C.Composite partitioning supports range- partitioned global indexes.
• D.Composite partitioning supports hash- partitioned global indexes.

What should you look at first to compute the number of undo blocks written per second to disk?

• A.V$UNDOSTAT
• B.V$ROLLSTAT
• C.DBA_ROLLBACK_SEGS
• D.V$TRANSACTION
• E.DBA_UNDO_EXTENTS

Which three features are provided by Recovery Manager and NOT provided by user-managed backup and recovery? (Choose three.)

• A.online backups
• B.incremental block-level backup
• C.partial database backups
• D.skipping unused blocks
• E.detection of corrupted blocks during backup

Temporary tables retain data until the _____.

• A.instance is shut down
• B.statement needing sort space commits
• C.database is backed up
• D.transaction or session completes
• E.database is exported