Free Oracle 1z0-062 Exam Dumps Questions & Answers

Which three statements are true about space usage alerts? (Choose three.)

• A.  Alerts are issued only when the critical threshold for space available in a tablespace is breached.
• B.  Database alerts can provide warnings about low space availability at both tablespace and segment levels.
• C.  Alerts are not issued for locally managed tablespaces that are offline or in read-only mode.
• D.  A newly created locally managed tablespace is automatically assigned the default threshold values defined for a database.
• E.  The sum of active extents and allocated user quotas is considered to compute space usage for an undo tablespace.

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

Which statement is true?

• A.  Memory is dynamically re-allocated between the SGA and PGA as needed.
• B.  The value of the MEMORY_TARGET parameter cannot be changed dynamically.
• C.  The size of the PGA cannot grow automatically beyond 500 MB.
• D.  Only SGA components are sized automatically.

Which two can be recommendations given by SQL Access Advisor? (Choose two.)

• A.  creation of SQL plan baselines
• B.  creation of materialized views
• C.  creation of SQL profiles
• D.  creation of indexes
• E.  rewriting of SQL statements

One of your databases runs in ARCHIVELOG mode.
Examine this command:

Now examine these steps executed from RMAN:
1) SHUTDOWN IMMEDIATE
2) STARTUP MOUNT
3) BACKUP DATABASE;
4) BACKUP ARCHIVELOG ALL;
5) ALTER DATABASE OPEN;
6) STARTUP
Identify the minimum required steps in the correct order needed to perform a whole consistent database backup.

• A.  3, 4
• B.  1, 2, 3, 5
• C.  1, 6, 3, 4
• D.  1, 2, 3, 4, 5
• E.  1, 6, 3

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.)

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