1z0-062 by Oracle Actual Free Exam Questions And Answers

Question 1

Your database is configured for ARCHIVELOG mode, and a daily full database backup is taken. RMAN is configured to perform control file autobackup.
In which three scenarios do you need media recovery? (Choose three.)

A. loss of a data file that belongs to the active undo tablespace

B. loss of all the inactive online redo log group members

C. abnormal termination of the database instance

D. logical corruption of data that is caused by a wrong transaction

E. loss of all the copies of the control file

F. loss of data files that belong to the SYSTEM tablespace

Discussion 0

Correct Answer: A,E,F Vote an answer

Question 2

The HR user receives the following error while inserting data into the sales table:

On investigation, you find that the users tablespace uses Automatic Segment Space Management (ASSM). It is the default tablespace for the HR user with an unlimited quota on it.
Which two methods would you use to resolve this error? (Choose two.)

A. Altering the data file associated with the USERS tablespace to extend automatically

B. Creating a new tablespace with autoextend enabled and changing the default tablespace of the HR user to the new tablespace

C. Enabling resumable space allocation by setting the RESUMABLE_TIMEOUT parameter to a nonzero value

D. Adding a data file to the USERS tablespace

E. Changing segment space management for the USERS tablespace to manual

Discussion 0

Correct Answer: A,D Vote an answer

Question 3

What is the benefit of running the catctl.pl script during an upgrade of a pre-12c database to an Oracle 12c database?

A. It recompiles all invalid PL/SQL and Java code.

B. It provides a summary of the upgrade results.

C. It provides parallel upgrade options to finish the upgrade process with a reduced down time.

D. It generates fix-up scripts to be run on the source database before upgrade.

E. It generates a log file containing the fixes that can be made to the source database.

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 4

You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server.
All databases of all versions use Automatic Storage Management (ASM).
Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group? (Choose three.)

A. The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.

B. RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.

C. The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10 g database.

D. The ASM compatibility attribute controls the format of the disk group metadata.

E. The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.

Discussion 0

Correct Answer: A,B,D Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 5

You created a new database using the "create database" statement without specifying the "ENABLE PLUGGABLE" clause.
What are two effects of not using the "ENABLE PLUGGABLE database" clause?

A. The database is created as a non-CDB but can be plugged into an existing CDB.

B. The database is created as a non-CDB but will become a CDB whenever the first PDB is plugged in.

C. The database is created as a non-CDB and can never be plugged into a CDB.

D. The database is created as a non-CDB and can never contain a PDB.

E. The database is treated as a PDB and must be plugged into an existing multitenant container database (CDB).

Discussion 0

Correct Answer: A,D Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 6

You created an encrypted tablespace:

You then closed the encryption wallet because you were advised that this is secure.
Later in the day, you attempt to create the EMPLOYEES table in the SECURESPACE tablespace with the SALT option on the EMPLOYEE column.
Which is true about the result?

A. It creates the table successfully, and encrypts any inserted data in the EMPNAME column because the wallet needs to be open only for tablespace creation.

B. It generates error when creating the table, because the salt option cannot be used with encrypted tablespaces.

C. It generates an error when creating the table because the wallet is closed.

D. It creates the table successfully but does not encrypt any inserted data in the EMPNAME column because the wallet must be opened to encrypt columns with SALT.

Discussion 0

Correct Answer: C Vote an answer

Question 7

Unified auditing is enabled in your database. The HR_ADMIN and OE_ADMIN roles exist and are granted system privileges.
You execute the command:
SQL>CREATE AUDIT POLICY tab1e_aud PRIVILEGES CREATE ANY TABLE, DROP ANY TABLE ROLES hr_admin, oe_admin; Which statement is true?

A. It fails because system privileges cannot be granted with roles in the same audit policy.

B. It succeeds and needs to be enabled to capture all SQL statements that require either the specified privileges or any privilege granted to the HR_ADMIN and OE_ADMIN role.

C. It fails because the command does not specify when the unified audit policy should be enforced.

D. It succeeds and starts capturing only successful SQL statements for all users who have either the specified privileges or roles granted to them.

Discussion 0

Correct Answer: D Vote an answer

Question 8

You are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table's indexes, to another tablespace.
The table does not have a primary key and is used by an OLTP application.
Which technique will move the table and indexes while maintaining the highest level of availability to the application?

A. Edition-Based Table Redefinition.

B. An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.

C. Oracle Data Pump.

D. An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.

E. Online Table Redefinition.

Discussion 0

Correct Answer: E Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 9

Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components?

Discussion 0

Correct Answer: D Vote an answer

Question 10

Which three activities are supported by the Data Recovery Advisor? (Choose three.)

A. Advising on inaccessible block change tracking files

B. Advising on inaccessible control files

C. Advising on empty password files

D. Advising on block checksum failures

E. Advising on invalid block header field values

Discussion 0

Correct Answer: B,D,E Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Oracle Database 12c: Installation and Administration - 1z0-062 Exam Practice Test

Contact Us

Useful Links

Latest Updated