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

Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information lifecycle Management (ILM)? (Choose three.)

  1. Tracking the most recent read time for a table segment in a user tablespace
  2. Tracking the most recent write time for a table segment in a user tablespace
  3. Tracking insert time by row for table rows
  4. Tracking the most recent write time for a table block
  5. Tracking the most recent read time for a table segment in the SYSAUX tablespace
  6. Tracking the most recent write time for a table segment in the SYSAUX tablespace

Answer(s): A,B,D

Explanation:

Incorrect:
Not E, Not F When Heat Map is enabled, all accesses are tracked by the in-memory
activity tracking module. Objects in the SYSTEM and SYSAUX tablespaces are not tracked.
* To implement your ILM strategy, you can use Heat Map in Oracle Database to track data access and modification.
Heat Map provides data access tracking at the segment-level and data modification tracking at the segment and row level.
* To implement your ILM strategy, you can use Heat Map in Oracle Database to track data access and modification. You can also use Automatic Data Optimization (ADO) to automate the compression and movement of data between different tiers of storage within the database.



Which three statements are true about using flashback database in a multitenant container database (CDB)? (Choose three.)

  1. The root container can be flashed back without flashing back the pluggable databases (PDBs).
  2. To enable flashback database, the CDB must be mounted.
  3. Individual PDBs can be flashed back without flashing back the entire CDB.
  4. The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CDB.
  5. A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.

Answer(s): A,B,D



Which two statements are true about the logical storage structure of an Oracle database? (Choose two.)

  1. An extent contains data blocks that are always physically contiguous on disk.
  2. An extent can span multiple segments.
  3. Each data block always corresponds to one operating system block.
  4. It is possible to have tablespaces of different block sizes.
  5. A data block is the smallest unit of I/O in data files.

Answer(s): D,E



In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer.
Which statement is true?

  1. The CDB must be open.
  2. The CDB must be in the mount stage.
  3. The CDB must be in the nomount stage.
  4. Alt existing PDBs must be closed.

Answer(s): A

Explanation:

* Creating a PDB
Rather than constructing the data dictionary tables that define an empty PDB from scratch, and then populating its Obj$ and Dependency$ tables, the empty PDB is created when the CDB is created. (Here, we use empty to mean containing no customer-created artifacts.) It is referred to as the seed PDB and has the name PDB$Seed. Every CDB non-negotiably contains a seed PDB; it is non-negotiably always open in read-only mode. This has no conceptual significance; rather, it is just an optimization device. The create PDB operation is implemented as a special case of the clone PDB operation. The size of the seed PDB is only about 1 gigabyte and it takes only a few seconds on a typical machine to copy it.



Viewing page 10 of 87



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

1Z0-062 Exam Discussions & Posts