1Z0-062 Oracle Exam Questions and Free Practice Test

Question 7

Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the HR_PDB. You execute the following command:
SQL > CREATE UNDO TABLESPACE undotb01
DATAFILE ‘u01/oracle/rddb1/undotbs01.dbf’ SIZE 60M AUTOEXTEND ON; What is the result?

A. It executes successfully and creates an UNDO tablespace in HR_PDB.

B. It falls and reports an error because there can be only one undo tablespace in a CDB.

C. It fails and reports an error because the CONTAINER=ALL clause is not specified in the command.

D. It fails and reports an error because the CONTAINER=CURRENT clause is not specified in the command.

E. It executes successfully but neither tablespace nor the data file is created.

Correct Answer:E
Interesting behavior in 12.1.0.1 DB of creating an undo tablespace in a PDB. With the new Multitenant architecture the undo tablespace resides at the CDB level and PDBs all share the same UNDO tablespace.
When the current container is a PDB, an attempt to create an undo tablespace fails without returning an error.

Question 8

Which two statements are true about SQL*Loader Express Mode in an Oracle 12c database? (Choose two.)

A. It loads data faster than conventional SQL*Loader

B. No data file needs to be specified

C. It can load data in parallel

D. It loads data more efficiently than conventional SQL*Loader

E. It requires Enterprise Manager Express to be configured

Correct Answer:AC
Reference: https://www.oracle.com/technetwork/database/enterprise-edition/learnmore/sqlldr-express-modewp- 1991038.pdf

Question 9

Which statement is true about the loss of a data file belonging to the default undo tablespace?

A. The database remains open in read-only mode.

B. The database is put in MOUNT state and requires recovery to be opened.

C. The database remains open for querying but no DML statements can be executed except by the users with SYSDBA privilege.

D. All the noncommitted transactions are lost.

E. The database instance abort

Correct Answer:C

Question 10

Which two statements are true about extents? (Choose two.)

A. Blocks belonging to an extent can be spread across multiple data files.

B. Data blocks in an extent are logically contiguous but can be non-contiguous on disk.

C. The blocks of a newly allocated extent, although free, may have been used before.

D. Data blocks in an extent are automatically reclaimed for use by other objects in a tablespace when all the rows in a table are deleted.

Correct Answer:BC

Question 11

Your multitenant container (CDB) containing three pluggable databases (PDBs) is running in ARCHIVELOG mode. You find that the SYSAUX tablespace is corrupted in the root container.
The steps to recover the tablespace are as follows:
1. Mount the CDB.
2. Close all the PDBs.
3. Open the database.
4. Apply the archive redo logs.
5. Restore the data file.
6. Take the SYSAUX tablespace offline.
7. Place the SYSAUX tablespace online.
8. Open all the PDBs with RESETLOGS.
9. Open the database with RESETLOGS.
10. Execute the command SHUTDOWN ABORT.
Which option identifies the correct sequence to recover the SYSAUX tablespace?

A. 6, 5, 4, 7

B. 10, 1, 2, 5, 8

C. 10, 1, 2, 5, 4, 9, 8

D. 10, 1, 5, 8, 10

Correct Answer:A
RMAN> ALTER TABLESPACE sysaux OFFLINE IMMEDIATE; RMAN> RESTORE TABLESPACE sysaux;
RMAN> RECOVER TABLESPACE sysaux; RMAN> ALTER TABLESPACE sysaux ONLINE;
* Example:
While evaluating the 12c beta3 I was not able to do the recover while testing “all pdb files lost”. Cannot close the pdb as the system datafile was missing…
So only option to recover was: Shutdown cdb (10) startup mount; (1)
restore pluggable database recover pluggable database alter database open; alter pluggable database name open;
Oracle support says: You should be able to close the pdb and restore/recover the system tablespace of PDB.
* Inconsistent backups are usually created by taking online database backups. You can also make an inconsistent backup by backing up data files while a database is closed, either:
/ Immediately after the crash of an Oracle instance (or, in an Oracle RAC configuration, all instances)
/ After shutting down the database using SHUTDOWN ABORT
Inconsistent backups are only useful if the database is in ARCHIVELOG mode and all archived redo logs created since the backup are available.
* Open the database with the RESETLOGS option after finishing recovery: SQL> ALTER DATABASE OPEN RESETLOGS;

Question 12

Which three statements are true about Enterprise Manager Database Express? (Choose three.)

A. It can be used to perform database backup operations.

B. It can use the HTTP protocol.

C. The same port number is used for multiple Database Express configurations on the same host.

D. It can use the HTTPS protocol.

E. It is available only when the database is ope

Correct Answer:BDE

START 1Z0-062 EXAM