Ensurepass

QUESTION 1

Which action takes place when a file checkpoint occurs?

 

A.

The checkpoint position is advanced in the checkpoint queue.

B.

All buffers for a checkpointed file that were modified before a specific SCN are written to disk by DBWn and the SCN is stored in the control file.

C.

The Database Writer process (DBWn) writes all dirty buffers in the buffer cache to data files.

D.

The Log Writer process (LGWR) writes all redo entries in the log buffer to online redo log files.

 

Correct Answer: C

 

 

QUESTION 2

You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege.The CDB has several pluggable databases (PDBs) open in the read/write mode.There are ongoing transactions in both the CDB and PDBs.What happens alter issuing the SHUTDOWN TRANSACTIONAL statement?

 

A.

The shutdown proceeds immediately.The shutdown proceeds as soon as all transactions in the PDBs are either committed or rolled hack.

B.

The shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back.

C.

The shutdown proceeds as soon as all transactions in both the CDB and PDBs are either committed or rolled back.

D.

The statement results in an error because there are open PDBs.

 

Correct Answer: B

Explanation:

* SHUTDOWN [ABORT | IMMEDIATE | NORMAL | TRANSACTIONAL [LOCAL]]

Shuts down a currently running Oracle Database instance, optionally closing and dismounting a database. If the current database is a pluggable database, only the pluggable database is closed. The consolidated instance continues to run.Shutdown commands that wait for current calls to complete or users to disconnect
such as SHUTDOWN NORMAL and SHUTDOWN TRANSACTIONAL have a time limit that the SHUTDOWN command will wait. If all events blocking the shutdown have not occurred within the time limit, the shutdown command cancels with the following message:

ORA-01013: user requested cancel of current operation

* If logged into a CDB, shutdown closes the CDB instance.

To shutdown a CDB or non CDB, you must be connected to the CDB or non CDB instance that you want to close, and then enter

SHUTDOWN

Database closed.

Database dismounted.

Oracle instance shut down.

To shutdown a PDB, you must log into the PDB to issue the SHUTDOWN command.

SHUTDOWN

Pluggable Database closed.

Note:

* Prerequisites for PDB Shutdown

When the current container is a pluggable database (PDB), the SHUTDOWN command can only be used if:

The current user has SYSDBA, SYSOPER, SYSBACKUP, or SYSDG system privilege.

The privilege is either commonly granted or locally granted in the PDB.

The current user exercises the privilege using AS SYSDBA, AS SYSOPER, AS SYSBACKUP, or AS SYSDG at connect time.

To close a PDB, the PDB must be open.

 

 

QUESTION 3

You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure. In which three ways can you re-create the lost disk group and restore the data?

 

A.

Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data.

B.

Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.

C.

Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data.

D.

Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group name and same set of disks and failure group configuration, and use RMAN to restore the data.

E.

Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.

F.

Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use R
MAN to restore the data.

 

Correct Answer: ACF

Explanation:

AC (not E):The md_restore command allows you to restore a disk group from the metadata created by the md_backup command.md_restore can’t restore data, only metadata.

 

 

QUESTION 4

You performed an incremental level 0 backup of a database:

 

RMAN > BACKUP INCREMENTAL LEVEL 0 DATABASE;

 

To enable block change tracking after the incremental level 0 backup, you issued this command:

 

SQL > ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE

 

` /mydir/rman_change_track.f’;

 

To perform an incremental level 1 cumulative backup, you issued this command:

 

RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;

 

Which three statements are true?

 

A.

Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.

B.

The change tracking file must always be backed up when you perform a full database backup.

C.

Block change tracking will always reduce I/O performed during cumulative incremental backups.

D.

More than one database block may be read by an incremental backup for a change made to a single block.

E.

The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.

 

Correct Answer: ADE

Explanation:

A: In a cumulative level 1 backup, RMA
N backs up all the blocks used since the most recent level 0 incremental backup.

E: Oracle Block Change Tracking

Once enabled; this new 10g feature records the modified since last backup and stores the log of it in a block change tracking file using the CTW (Change Tracking Writer) process. During backups RMAN uses the log file to identify the specific blocks that must be backed up. This improves RMAN’s performance as it does not have to scan whole datafiles to detect changed blocks. Logging of changed blocks is performed by the CTRW process which is also responsible for writing data to the block change tracking file.

Note:

An incremental level 0 backup backs up all blocks that have ever been in use in this database.

 

 

QUESTION 5

Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR) report:

 

clip_image001

 

What are three possible causes for the latch-related wait events?

 

A.

The size of the shared pool is too small.

B.

Cursors are not being shared.

C.

A large number COMMITS are being performed.

D.

There are frequent logons and logoffs.

E.

The buffers are being read into the buffer cache, but some other session is changing the buffers.

 

Correct Answer: ABE

 

 

QUESTION 6

Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs.

 

You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands:

 

SQL > SHUTDOWN IMMEDIATE

SQL > STARTUP MOUNT

SQL > FLASHBACK DATABASE to TIME “TO_DATE (`08/20/12′ , `MM/DD/YY’)”;

< font style="font-size: 10pt" color="#000000"> 

Examine following commands:

 

1. ALTER PLUGGABLE DATABASE ALL OPEN;

2. ALTER DATABASE OPEN;

3. ALTER DATABASE OPEN RESETLOGS;

 

Which command or commands should you execute next to allow updates to the flashback back schema?

 

A.

Only 1

B.

Only 2

C.

Only 3

D.

3 and 1

E.

1 and 2

 

Correct Answer: C

Explanation:

Example (see step23):

Step 1:

Run the RMAN FLASHBACK DATABASE command.

You can specify the target time by using a form of the command shown in the following examples:

FLASHBACK DATABASE TO SCN 46963;

FLASHBACK DATABASE

TO RESTORE POINT BEFORE_CHANGES;

FLASHBACK DATABASE TO TIME

“TO_DATE(’09/20/05′,’MM/DD/YY’)”;

When the FLASHBACK DATABASE command completes, the database is left mounted and recovered to the specified target time.

Step 2:

Make the database available for updates by opening the database with the RESETLOGS option. If the database is currently open read-only, then execute the following commands in SQL*Plus:

SHUTDOWN IMMEDIATE

STARTUP MOUNT

ALTER DATABASE OPEN RESETLOGS;

 

 

QUESTION 7

You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index.Which two are possible if table updates are performed which affect the invisible index columns?

 

A.

The index remains invisible.

B.

The index is not updated by the DML statements on the indexed table.

C.

The index automatically becomes visible in order to have it updated by DML on the table.

D.

The index becomes unusable but the table is updated by the DML.

E.

The index is updated by the DML on the table.

 

Correct Answer: AE

< font face="Arial">Explanation:

Unlike unusable indexes, an invisible index is maintained during DML statements.

Note:

Oracle 11g allows indexes to be marked as invisible. Invisible indexes are maintained like any other index, but they are ignored by the optimizer unless the OPTIMIZER_USE_INVISIBLE_INDEXES parameter is set to TRUE at the instance or session level. Indexes can be created as invisible by using the INVISIBLE keyword, and their visibility can be toggled using the ALTER INDEX command.

 

 

QUESTION 8

You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs).

 

Examine the query and its output:

 

clip_image003

 

Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file?

 

A.

Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.

B.

Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.

C.

Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.

D.

Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.

E.

Re-create the password file in the Oracle Database 12c format.

 

Correct Answer: BD

Explanation:

* orapwd

/ You can create a database password file using the password file creation utility, ORAPWD.

The syntax of the ORAPWD command is as follows:

orapwd FILE=filename [ENTRIES=numusers] [FORCE={y|n}] [ASM={y|n}] [DBUNIQUENAME=dbname] [FORMAT={12|legacy}] [SYSBACKUP={y|n}] [SYSDG={y|n}] [SYSKM={y|n}] [DELETE={y|n}] [INPUT_FILE=input-fname]

force – whether to overwrite existing file (optional),

* v$PWFILE_users

/ 12c: V$PWFILE_USERS lists all users in the password file, and indicates whether the user has been granted the SYSDBA, SYSOPER, SYSASM, SYSBACKUP, SYSDG, and SYSKM privileges.

/ 10c: sts users who have been granted SYSDBA and SYSOPER privileges as der
ived from the password file.

ColumnDatatypeDescription

USERNAMEVARCHAR2(30)The name of the user that is contained in the password file SYSDBAVARCHAR2(5)If TRUE, the user can connect with SYSDBA privileges SYSOPERVARCHAR2(5)If TRUE, the user can connect with SYSOPER privileges

Incorrect:

not E: The format of the v$PWFILE_users file is already in 12c format.

 

 

QUESTION 9

You plan to implement the distributed database system in your company. You invoke Database Configuration Assistant (DBCA) to create a database on the server. During the installation, DBCA prompts you to specify the Global Database Name.What must this name be made up of?

 

A.

It must be made up of a database name and a domain name.

B.

It must be made up of the value in ORACLE_SID and HOSTNAME.

C.

It must be made up of the value that you plan to assign for INSTANCE_NAME and HOSTNAME.

D.

It must be made up of the value that you plan to assign for ORACLE_SID and SERVICE_NAMES.

 

Correct Answer: A

Explanation:

Using the DBCA to Create a Database (continued)

3.Database Identification: Enter the Global Database Name in The form database_name.domain_name, and the system identifier (SID). The SID defaults lo the database name and uniquely identifies the instance associated with the database.

4.Management Options: Use this page to set up your database so that it can be managed with Oracle Enterprise Manager. Select the default: “Configure the Database with Enterprise Manager.” Optionally, this page allows you to configure alert notifications and daily disk backup area settings.

Note: Yon must configure the listener before you can configure Enterprise Manager (as shown earlier).

 

 

QUESTION 10

Identify three valid options for adding a pluggable database (PDB) to an existing multitenant container database (CDB).

 

A.

Use the CREATE PLUGGABLE DATABASE statement to create a PDB using the files from the SEED.

B.

Use the CREATE DATABASE . . . ENABLE PLUGGABLE DATABASE statement to provision a PDB by copying file from the SEED.

C.

Use the DBMS_PDB package to clone an existing PDB.

D.

Use the DBMS_PDB package to plug an Oracle 12c non-CDB database into an existing CDB.

E.

Use the DBMS_PDB package to plug an Oracle 11 g Release 2 (11.2.0.3.0) non-CDB database into an existing CDB.

 

Correct Answer: ACD

Explanation:

Use the CREATE PLUGGABLE DATABASE statement to create a pluggable database (PDB).

This statement enables you to perform the following tasks:

* (A) Create a PDB by using the seed as a template

Use the create_pdb_from_seed clause to create a PDB by using the seed in the multitenant container database (CDB) as a template. The files associated with the seed are copied to a new location and the copied files are then associated with the new PDB.

* (C) Create a PDB by cloning an existing PDB

Use the create_pdb_clone clause to create a PDB by copying an existing PDB (the source PDB) and then plugging the copy into the CDB. The files associated with the source PDB are copied to a new location and the copied files are associated with the new PDB. This operation is called cloning a PDB.

The source PDB can be plugged in or unplugged. If plugged in, then the source PDB can be in the same CDB or in a remote CDB. If the source PDB is in a remote CDB, then a database link is used to connect to the remote CDB and copy the files.

* Create a PDB by plugging an unplugged PDB or a non-CDB into a CDB

Use the create_pdb_from_xml clause to plug an unplugged PDB or a non-CDB into a CDB, using an XML metadata file.

 

Free VCE & PDF File for Oracle 1Z0-062 Real Exam

Instant Access to Free VCE Files: CompTIA | VMware | SAP …
Instant Access to Free PDF Files: CompTIA | VMware | SAP …

Comments are closed.