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: 22)

Page 17 of 87
PDF with 419 Questions

Which two statements are true about variable extent size support for large ASM files? (Choose two.)

  1. The metadata used to track extents in SGA is reduced.
  2. Rebalance operations are completed faster than with a fixed extent size
  3. An ASM Instance automatically allocates an appropriate extent size.
  4. Resync operations are completed faster when a disk comes online after being taken offline.
  5. Performance improves in a stretch cluster configuration by reading from a local copy of an extent.

Answer(s): A,C

Explanation:

A: Variable size extents enable support for larger ASM datafiles, reduce SGA memory requirements for very large databases (A), and improve performance for file create and open operations.
C: You don't have to worry about the sizes; the ASM instance automatically allocates the appropriate extent size.
Note:
* The contents of ASM files are stored in a disk group as a set, or collection, of data extents that are stored on individual disks within disk groups. Each extent resides on an individual disk. Extents consist of one or more allocation units (AU). To accommodate increasingly larger files, ASM uses variable size extents.
* The size of the extent map that defines a file can be smaller by a factor of 8 and 64 depending on the file size. The initial extent size is equal to the allocation unit size and it
increases by a factor of 8 and 64 at predefined thresholds. This feature is automatic for newly created and resized datafiles when the disk group compatibility attributes are set to Oracle Release 11 or higher.



You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces are created by default in HR_PDB? (Choose three.)

  1. SYSTEM
  2. SYSAUX
  3. EXAMPLE
  4. UNDO
  5. TEMP
  6. USERS

Answer(s): A,B,E

Explanation:

* A PDB would have its SYSTEM, SYSAUX, TEMP tablespaces.It can also contains other user created tablespaces in it.
* Oracle Database creates both the SYSTEM and SYSAUX tablespaces as part of every database.
* tablespace_datafile_clauses
Use these clauses to specify attributes for all data files comprising the SYSTEM and SYSAUX tablespaces in the seed PDB.
Incorrect:
Not D: a PDB can not have an undo tablespace. Instead, it uses the undo tablespace belonging to the CDB.
Note:
* Example:
CONN pdb_admin@pdb1
SELECT tablespace_name FROM dba_tablespaces;
TABLESPACE_NAME
------------------------------
SYSTEM
SYSAUX
TEMP
USERS
SQL>



Examine the resources consumed by a database instance whose current Resource Manager plan is displayed.

Which two statements are true? (Choose two.)

  1. An attempt to start a new session by a user belonging to DSS_QUERIES fails with an error.
  2. An attempt to start a new session by a user belonging to OTHER_GROUPS fails with an error.
  3. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management.
  4. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to I/O waits and latch or enqueue contention.
  5. A user belonging to the DSS__QUERIES resource consumer group can create a new session but the session will be queued.

Answer(s): C,E



Which two statements are true concerning dropping a pluggable database (PDB)? (Choose two.)

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

Answer(s): B,C


Reference:

http://docs.oracle.com/database/121/ADMIN/cdb_plug.htm#ADMIN13658



Viewing page 22 of 87



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

1Z0-062 Exam Discussions & Posts