Cisco®
Oracle
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
All Vendors
  2. Home
  3. Exams
  4. Oracle
  5. 1Z0-062

Free Oracle 1Z0-062 Exam Questions (page: 4)

Page 4 of 87
PDF with 419 Questions

An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache.
How would you guarantee that the blocks for the table never age out?

  1. Configure the KEEP buffer pool and alter the table with the corresponding storage clause.
  2. Increase the database buffer cache size.
  3. Configure the RECYCLE buffer pool and alter the table with the corresponding storage clause.
  4. Configure Automata Shared Memory Management.
  5. Configure Automatic Memory Management.

Answer(s): A

Explanation:

Schema objects are referenced with varying usage patterns; therefore, their cache behavior may be quite different. Multiple buffer pools enable you to address these differences. You can use a KEEP buffer pool to maintain objects in the buffer cache and a RECYCLE buffer pool to prevent objects from consuming unnecessary space in the cache. When an object is allocated to a cache, all blocks from that object are placed in that cache. Oracle maintains a DEFAULT buffer pool for objects that have not been assigned to one of the buffer pools.



Examine the memory-related parameters set in the SPFILE of an Oracle database:

Which statement is true?

  1. Only SGA components are sized automatically.
  2. Memory is dynamically re-allocated between the SGA and PGA as needed.
  3. The size of the PGA cannot grow automatically beyond 500 MB.
  4. The value of the MEMORY_TARGET parameter cannot be changed dynamically.

Answer(s): B



To enable the Database Smart Flash Cache, you configure the following parameters:
DB_FLASH_CACHE_FILE = `/dev/flash_device_1' , `/dev/flash_device_2'
DB_FLASH_CACHE_SIZE=64G
What is the result when you start up the database instance?

  1. It results in an error because these parameter settings are invalid.
  2. One 64G flash cache file will be used.
  3. Two 64G flash cache files will be used.
  4. Two 32G flash cache files will be used.

Answer(s): A



You must track all transactions that modify certain tables in the sales schema for at least three years.
Automatic undo management is enabled for the database with a retention of one day.
Which two must you do to track the transactions? (Choose two.)

  1. Enable supplemental logging for the database.
  2. Specify undo retention guarantee for the database.
  3. Create a Flashback Data Archive in the tablespace where the tables are stored.
  4. Create a Flashback Data Archive in any suitable tablespace.
  5. Enable Flashback Data Archiving for the tables that require tracking.

Answer(s): D,E

Explanation:

E: By default, flashback archiving is disabled for any table. You can enable flashback archiving for a table if you have the FLASHBACK ARCHIVE object privilege on the Flashback Data Archive that you want to use for that table.
D: Creating a Flashback Data Archive
/ Create a Flashback Data Archive with the CREATE FLASHBACK ARCHIVE statement, specifying the following:
Name of the Flashback Data Archive
Name of the first tablespace of the Flashback Data Archive (Optional) Maximum amount of space that the Flashback Data Archive can use in the first tablespace
/ Create a Flashback Data Archive named fla2 that uses tablespace tbs2, whose data will be retained for two years:
CREATE FLASHBACK ARCHIVE fla2 TABLESPACE tbs2 RETENTION 2 YEAR;



Viewing page 4 of 87



Post your Comments and Discuss Oracle 1Z0-062 exam prep with other Community members:

1Z0-062 Exam Discussions & Posts