Category «1Z0-043»

Exam 1z0-043: Database 10g: Administration II (October 26th, 2014)

Which advisory component would you refer to, in order to determine that required size of the database buffer c

You observe that a database performance has degraded over a period of time. Whileinvestigating the reason, you find that the size of the database buffer cache is not largeenough to cache all the needed data blocks. Which advisory component would you refer to,in order to determine that required size of the database buffer cache? A.Memory …

you need to perform after re-creating the control file and opening the database?

One of the tablespaces is read-only in your database. The loss of all control files forced youto re-create the control file. Which operation do you need to perform after re-creating thecontrol file and opening the database? A.drop and re-create the read-only tablespaces B.rename the read-only data files to their correct file names C.change the tablespace …

Which two statements are correct?

You have set some of the initialization parameters as:DB_BLOCK_SIZE = 8KBSGA_MAX_SIZE = 2GBSGA_TARGET = 0SHARED_POOL_SIZE = 120MBDB_CACHE_SIZE = 896MBSTREAM_POOL_SIZE = 0LARGE_POOL_SIZE = 110 MBWhich two statements are correct? (Choose two.) A.You cannot set a value for the DB_8K_CACHE_SIZE parameter. B.If you increase the size of the large pool to 120 MB, then the memory allocated …

Which two statements are correct?

You have set some of the initialization parameters as:DB_BLOCK_SIZE = 8KBSGA_MAX_SIZE = 2GBSGA_TARGET = 0SHARED_POOL_SIZE = 120MBDB_CACHE_SIZE = 896MBSTREAM_POOL_SIZE = 0LARGE_POOL_SIZE = 110 MBWhich two statements are correct? (Choose two.) A.You cannot set a value for the DB_8K_CACHE_SIZE parameter. B.If you increase the size of the large pool to 120 MB, then the memory allocated …