Question No. 1

You issue commands in SQL*Plus as the Oracle owner, to enable multithreading for your UNIX-based Oracle 12c database:

CONNECT /AS SYSDBA

ALTER SYSTEM SET THREADED_EXECUTION=TRUE SCOPE=SPFILE;

SHUTDOWN IMMEDIATE

You then restart the instance and get an error:

STARTUP

ORA-01031: insufficient privileges

Why does the startup command return the error shown?

Abecause the threaded architecture requires exiting from sql*plus and reconnecting with sql*Plus / as sysdba before issuing a startup command

Bbecause the threaded architecture requires issuing a new connect / as sysdba from within sql*plus before issuing a startup command

Cbecause the threaded architecture requires authentication using a password file before issuing a startup command

Dbecause the threaded architecture requires connecting to the instance via a listener before issuing a startup command

Ebecause the threaded architecture requires restarting the listener before issuing a startup command

Show Answer

Correct Answer: C

Question No. 2

Which three statements are true about the database instance startup after an instance failure? (Choose three.)

AThe RECO process recovers the uncommitted transactions at the next instance startup.

BOnline redo log files and archived redo log files are required to complete the rollback stage of instance recovery.

CUncommitted changes are rolled back to ensure transactional consistency.

DThe SMON process coordinates the database recovery.

EMedia recovery is required to complete the database recovery.

FChanges committed before the failure, which were not written to the data files, are re-applied.

Show Answer

Correct Answer: A, C, D

A: Occasionally a database closes abnormally with one or more distributed transactions in doubt (neither committed nor rolled back). When you reopen the database and recovery is complete, the RECO background process automatically, immediately, and consistently resolves any in-doubt distributed transactions.

C: Crash and instance recovery involve two distinct operations: rolling forward the current, online datafiles by applying both committed and uncommitted transactions contained in online redo records, and then rolling back changes made in uncommitted transactions to their original state.

D: The SMON background process performs instance recovery, applying online redo automatically. No user intervention is required.

References:

https://docs.oracle.com/cd/B28359_01/server.111/b28318/startup.htm

https://docs.oracle.com/database/121/CNCPT/startup.htm

Question No. 3

Examine the RMAN command:

RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;

RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

Which prerequisite must be met before accomplishing the backup?

AThe password for the encryption must be set up.

BOracle wallet for the encryption must be set up.

CAll the tablespaces in the database must be encrypted.

DOracle Database Vault must be enabled.

Show Answer

Correct Answer: B

Question No. 4

You created a tablespace with this statement:

CREATE BIGFILE TABLESPACE adtbs

DATAFILE '/proddb/data/adtbs.dbf' SIZE 10G;

The tablespace is nearly full and you need to avoid any out of space errors for the load of a 5 gig table.

Which two alter statements will achieve this? (Choose two.)

AALTER TABLESPACE adtbs RESI2E 20G;

BALTER TABLESPACE adtbs ADD DATAFILE;

CALTER TABLESPACE adtbs AUTOEXTEND ON;

DALTER TABLESPACE adtbs ADD DATAFILE '/proddb/data/adtbsl.dbf' SIZE 1QG;

EALTER TABLESPACE adtbs MODIFY DATAFILE '/proddb/data/adtbs.dbf AUTOEXTEND ON;

Show Answer

Correct Answer: A, C

http://www.techonthenet.com/oracle/tablespaces/alter_tablespace.php

Question No. 5

Consider the following scenario for your database:

Backup optimization is enabled in RMAN.

The recovery window is set to seven days in RMAN.

The most recent backup to disk for the tools tablespace was taken on March 1, 2013.

The tools tablespace is read-only since March 2, 2013.

On March 15, 2013, you issue the RMAN command to back up the database to disk.

Which statement is true about the backup of the tools tablespace?

AThe RMAN backup fails because the tools tablespace is read-only.

BRMAN skips the backup of the tools tablespace because backup optimization is enabled.

CRMAN creates a backup of the tools tablespace because backup optimization is applicable only for the backups written to media.

DRMAN creates a backup of the tools tablespace because no backup of the tablespace exists within the seven-day recovery window.

Show Answer

Correct Answer: D

Free Oracle 1Z0-063 Exam Actual Questions

The questions for 1Z0-063 were last updated On Nov 21, 2024