Oracle9i Database Fundamentals Set 4

Question - 15 Maximum mark : - 25

Home
All Exams
Oracle9i Database Fundamentals Online Mock Tests
Oracle9i Database Fundamentals Set 4

You observe that your senior database administrator is executing the following command using Recovery
Manager (RMAN) in order to perform an incomplete recovery of the database:

RMAN> RUN {
ALLOCATE CHANNEL c1 TYPE DISK;
SET UNTEL SEQUENCE 134 THREAD 1;
RESTORE DATABASE;
RECOVER DATABASE;
}

The current sequence number is 189 and your database is running in ARCHIVELOG mode.
What could be the objective of specifying the SET UNTIL SEQUENCE option in the RUN block of RMAN?

to restore and recover the database from the sequence number specified until the current sequence

number ✘ to reset the current sequence number for the database, and then to start restore and recovery processes ofthe database ✘ to restore the database till the sequence number specified, and then recover the database until the currentsequence number ✘ to restore the database completely from the last available backup taken prior to the sequence 134, and thenrecover it until the sequence number specified ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

On March 15, due to an application enhancement you made many structural changes in the database. The
recovery catalog is used with RMAN and backups are performed on the last day of every month. The
CONTROL_FILE_RECORD_KEEP_TIME parameter is set to 7 days. What do you do to ensure that metadata
in the recovery catalog is updated?

reset the database by using the RESET DATABASE command ✘ update the recovery catalog by using the CROSSCHECK command ✘ initiate resynchronization by using the RESYNC CATALOG command ✘ register the database again by using the REGISTER DATABASE command ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You are working in a dedicated server environment. You require the PMON process to register with a local
listener, lsnr1, which does not use TCP/IP, port 1521. The protocol address of lsnr1 is available in the
listener.ora file. What would you do?

configure the LOCAL_LISTENER parameter in the initialization parameter file ✘ configure the SID_LIST_LSNR1 parameter in the listener.ora file ✘ execute the lsnrctl set command with the appropriate parameter to set the correct instance names ✘ no explicit action required because the protocol address of the listener is available in the listener.ora file ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You are using Recovery Manager (RMAN) to back up your database at regular intervals. The database is
running in ARCHIVELOG mode. On Monday morning, you find that the media that contains the users.dbf data
file, which belongs to the USERS tablespace, is corrupted and users are unable to access the USERS
tablespace. After investigating further, you decide to restore the data file to a new location. Which option would
you use to relocate the data file before restoring the data file to the new location?

use the RMAN SET NEWNAME command ✘ use the RMAN RESTORE TABLESPACE command ✘ use the Transportable Tablespace option of Oracle Export and Import utility ✘ use the ALTER DATABASE RENAME FILE command for the data file users.dbf ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

There are three databases in your company: PDDB, QTDB, and SLDB. A single RMAN recovery catalog is
used for all the three databases. In the recovery catalog you have a stored script, Level0Backup, created for
performing a level 0 backup. For which database will the backup be performed when you execute this script?

all the three databases ✘ depends on the channel allocation ✘ the target database to which RMAN is connected ✘ the database configured using the CONFIGURE command at the command line before calling the script ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which statement correctly describes the checkpoint position?

This is the position of the checkpoint queue in the control file. ✘ This is the position in the data file where dirty blocks are written. ✘ This is the position in the redo log file from where archiving starts. ✘ This is the position in the redo log file from where the recovery process starts. ✔ This is the position in the data file header where the Redo Byte Address (RBA) is recorded. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

In your database server, you discovered that a data file that belongs to one of the users tablespaces is corrupted and, therefore, requires a recovery. To perform the recovery, which are the files that you may need to restore from the recent backup? (Choose all that apply.)

control file parameter file archivelog files non-corrupted version of the data file all the archivelog files since the database was created

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You executed the following RMAN script to perform a backup:

RUN
ALLOCATE CHANNEL c1 DEVICE TYPE sbt;
ALLOCATE CHANNEL c2 DEVICE TYPE sbt;
ALLOCATE CHANNEL c3 DEVICE TYPE sbt;
BACKUP DATAFILE5,6,7;
{

Which statement regarding channel allocation is true?

Only one channel is active at any one time to perform a backup. ✘ This type of channel allocation works only if the disk is used as a backup device. ✘ This channel allocation works only if there are no automatic channels configured. ✘ The three chennels are concurrently active ;each chennal performs a backup of one.data file. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You have joined an organization as a DB

While examining one of the databases you notice the following settings:

LOG_ARCHIVE_START = FALSE

LOG_ARCHIVE_MAX_PROCESS = 4

What do you understand from this settings?

✘ Manual archiving is enabled and no archiver processes are started. ✘ Archiving is not enabled, so the database is in NOARCHIVELOG mode. ✘ Automatic archiving is enabled and four archiver processes will be started on demand. ✔ Manual archiving is enabled and four archiver processes will be started for manual archiving. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

10.

Your database operates in NOARCHIVELOG mode. You performed the following steps to change the database
to ARCHIVELOG mode:

Shut down the database. ✘ Start the database in MOUNT state. ✘ Set the database in ARCHIVELOG mode by using the ALTER DATABASE command. ✘ Open the database.What should you do after the database is open? ✔ take a full backup of the database ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Prev Next

Congratulations

you have successfully completed the test

Back to Question View Result

Detail Form

We will send your result on your email id and phone no. please fill detail

Name

Email ID Note: Report will be send to the above Email ID

Phone No

Oracle9i Database Fundamentals Set 4

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner