1Z0-062 Free Practice Test

Examine this command executed on a client that is remote from the database server. SQL> CONNECT hr/hr@orcl Which two are required for this command to connect the SQLPLUS client to a database instance? (Choose two.)

1. A. An orcl TNS entry must be defined in the client-side and server-side tnsnames.ora files
2. B. An orcl TNS entry must be defined in the client-side tnsnames.ora file
3. C. A service name must be defined to the listener that matches the service name in the orcl TNS entry
4. D. An orcl TNS entry must be defined in the server-side tnsnames.ora file
5. E. The service name orcl must be defined to the listener

Correct Answer: DE

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. A. Configure the KEEP buffer pool and alter the table with the corresponding storage clause.
2. B. Increase the database buffer cache size.
3. C. Configure the RECYCLE buffer pool and alter the table with the corresponding storage clause.
4. D. Configure Automata Shared Memory Management.
5. E. Configure Automatic Memory Management.

Correct Answer: A
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.

You plan to install the Oracle Database 12c software on a new server. The database will use Automatic Storage Management (ASM) and Oracle Restart. Oracle Grid Infrastructure for a standalone server is already installed on the server.
You want to configure job role separation. You create the following operating system users and groups:
- The user oracle as the owner of the Oracle database installation
- The user grid as the owner of Oracle Grid Infrastructure
- The group oinstall as an Oracle Inventory group
- The group dba as the OSDBA group for Oracle database
- The group asmdba as the OSDBA group for Oracle ASM
- The group asmadmin as the administration privileges group for Oracle ASM
- The group asmoper as the group for Oracle ASM
Which two additional tasks should you perform with regard to the OS-level owners and groups? (Choose two.)

1. A. creating a separate central inventory group for the Oracle Database 12c installation
2. B. assigning oinstall as the primary group for the oracle user
3. C. assigning asmadmin and asmoper as primary groups for the oracle user
4. D. creating OS groups associated with the OSBACKUPDBA, OSDGDBA, and OSKMDBA system privileges
5. E. assigning asmdba as the secondary group for the oracle user

Correct Answer: BD

Which action takes place when a file checkpoint occurs?

1. A. The checkpoint position is advanced in the checkpoint queue.
2. B. All buffers for a checkpointed file that were modified before a specific SCN are written to disk by DBWn and the SCN is stored in the control file.
3. C. The Database Writer process (DBWn) writes all dirty buffers in the buffer cache to data files.
4. D. The Log Writer process (LGWR) writes all redo entries in the log buffer to online redo log file

Correct Answer: B

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

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

Correct Answer: AC
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 and 64 depending on the file size. The initial extent size is equal to the allocation unit size and it increases by a factor 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.