1z0-060 Free Practice Test

You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.
You have set the DB_SMART_FLASH_FILE parameter:
DB_FLASH_CACHE_FILE= ‘/dev/flash_device_1 ‘,’ /dev/flash_device_2’
How should the DB_FLASH_CACHE_SIZE be configured to use both devices?

1. A. Set DB_FLASH_CACHE_ZISE = 64G.
2. B. Set DB_FLASH_CACHE_ZISE = 64G, 64G
3. C. Set DB_FLASH_CACHE_ZISE = 128G.
4. D. DB_FLASH_CACHE_SIZE is automatically configured by the instance at startup.

Correct Answer: B

Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR) report:
<>

1. A. The size of the shared pool is too small.
2. B. Cursors are not being share
3. C. A large number COMMITS are being performe
4. D. There are frequent logons and logoffs.
5. E. The buffers are being read into the buffer cache, but some other session is changing the buffers.

Correct Answer: ABE

Which two statement is true concerning dropping a pluggable database (PDB)?

1. A. The PDB must be open in read-only mode.
2. B. The PDB must be in mount state.
3. C. The PDB must be unplugge
4. D. The PDB data files are always removed from disk.
5. E. A dropped PDB can never be plugged back into a multitenant container database (CDB).

Correct Answer: CD

You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.
Which method or feature should you use?

1. A. Compare Period ADDM report
2. B. AWR Compare Period report
3. C. Active Session History (ASH) report
4. D. Taking a new snapshot and comparing it with a preserved snapshot

Correct Answer: B

Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart.
Examine the following command and its output:
$ crsctl config has
CRS-4622: Oracle High Availability Services auto start is enabled.
What does this imply?

1. A. When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically starte
2. B. When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still starte
3. C. When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.
4. D. When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.

Correct Answer: B