Oracle 1Z0-045 Actual Tests : Oracle database 10g:new features for Oracle8i ocps

Oracle 1Z0-045 Exam Syllabus Topics:

Oracle database 10g:new features for Oracle8i ocps Sample Questions:

1. What should you look at first to compute the number of undo blocks that are consumed and estimate the size of the undo tablespace needed to handle the workload on your system?

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

2. You need to ensure that the database users should be able to use the various flashback query features in order to go back in time by four hours. What would you do to achieve this? (Choose two.)

A) issue ALTER DATABASE FLASHBACK ON; command
B) set SQL_TRACE=True
C) set LOG_CHECKPOINT_INTERVAL=240
D) set FAST_START_MTTR_TARGET=240
E) set the RETENTION GUARANTEE clause for the undotablespace
F) set DB_FLASHBACK_RETENTION_TARGET=14400
G) set UNDO_RETENTION=14400

3. What are three benefits provided by the enhanced Unicode support? (Choose three.)

A) support for fixed-width character encoding
B) support for the AL24UTFFSS character set
C) richer support for more character sets, languages, and territories
D) Unicode support in the database character set

4. You enabled Flashback Database with the following command:
ALTER DATABASE FLASHBACK ON;
Which view would you query to determine whether the Flashback Database has been enabled?

A) V$INSTANCE
B) V$SGA
C) V$FLASHBACK_DATABASE_LOGFILE
D) V$DATABASE
E) V$FLASHBACK_DATABASE_LOG
F) V$FLASHBACK_DATABASE_STAT

5. You set SGA parameters in your database as:
DB_CACHE_SIZE=24 MB JAVA_POOL_SIZE=48 MB SHARED_POOL_SIZE=96 MB
You plan to upgrade to Oracle Database 10g. You need to provide an additional 20 MB memory space to accommodate internal overhead allocations for metadata. Which SGA parameter(s) would you modify?

A) change JAVA_POOL_SIZE to 68 MB
B) change JAVA_POOL_SIZE to 58 MB and DB_CACHE_SIZE to 34 MB
C) change SHARED_POOL_SIZE to 116 MB
D) change DB_CACHE_SIZE to 44 MB
E) change SHARED_POOL_SIZE to 106 MB and DB_CACHE_SIZE to 34 MB

Solutions: