← Back to exam page

1z0-062 – Oracle Database 12c: Installation and Administration

Loading demo links...

Showing 10–12 of 20 questions

Question 10

Identify three situations in which messages are written to the alert log file. (Choose three.)

Select all that apply, then click Submit answer.

  • ○

    Rebuilding an index using ALTER INDEX ... REBUILD fails with an error "ORA-01578: ORACLE data block corrupted (file # 14, block # 50)"
  • ○

    Creating a table returns "ORA-00955: name is already in used by an existing object"
  • ○

    Inserting a value into a table returns "ORA-01722: invalid number"
  • ○

    Updating a record in a table returns "ORA-00060: deadlock detected while waiting for resource"
  • ○

    Inserting a value into a table returns "ORA-00001: unique constraint (SYS.PK_XXXX) violated"
  • ○

    Running a query on a table returns "ORA-01578: ORACLE data block corrupted (file # 4, block # 131)"
Question 11

The user SCOTT owns the CUST table that is placed in the SALES tablespace. The user SCOTT opens a session and executes commands as follows:

SQL> INSERT INTO cust VALUES(101, 'JACK');

1 row created.

SQL> INSERT INTO cust VALUES(102, 'SMITH'); 1 row created.

As a DBA, you execute the following command from another session: ALTER TABLESPACE sales READ ONLY;

Which statement is true regarding the effect of this command on the transaction in Scott's session?

Select an option, then click Submit answer.

  • ○

    The command fails as a transaction is still pending.
  • ○

    The transaction in Scott's session is rolled back and the tablespace becomes readonly.
  • ○

    The command waits and the user SCOTT can execute data manipulation language (DML) statements only as part of the current transaction.
  • ○

    The command hangs until all transactions on the objects in the tablespace commit or rollback, and then the tablespace is placed in readonly mode.
Question 12

You want to create a test database as a replica of your production database with minimum intervention from a DBA.

Which method would you use?

Select an option, then click Submit answer.

  • ○

    Use DBCA to create a template from the existing database to contain the database structure and then manually copy the data by using Oracle Data Pump.
  • ○

    Use Database Configuration Assistant (DBCA) to create a template from the existing database to contain the database structure.
  • ○

    Create the database by using the CREATE DATABASE... command and manually import data by using Data Pump.
  • ○

    Use DBCA to create a template from the existing database to contain the database structure with data files and then use the same template to create the database in the new location.