Oracle9i Database Fundamentals Set 3

Question - 15 Maximum mark : - 27

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

Online index rebuild functionality has been extended to include which four index structures? (Choose four)

Bitmap indexes. Reverse key indexes. Function-based indexes. Key-compressed indexes on regular tables. Key-compressed indexes on IOT (including secondary indexes)

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Consider this syntax:

MERGE INTO t1
USING t2 ON (join predicate).....

What does the MERGE syntax do?

It performs a merge join of the row from T2 only if it doesn't exist in the T1 table. ✘ It creates a natural join of tables T1 and T2 for all columns that have the same name. ✘ It creates a Cartesian product of table T1 and table T2 for all columns that have the same name. ✘ For each row from T2, it updates the row if it exists within table T1, otherwise it inserts the row into T1. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Examine the statement:

DROP TABLESPACE IND2
INCLUDING CONTENTS
AND DATAFILES;

What is the result of the statement?

The contents and data files belonging to the IND2 tablespace are dropped. ✘ The statement will only succeed if the IND2 tablespace was built using Oracle- Managed Files (OMF) datafiles. ✘ The statement will only succeed if the data files belonging to the IND2 tablespace are Oracle-Managed Files(OMF) or of the database was created using OMF. ✘ The contents of the tablespace are dropped along with all its data files except those identical with theOracle-Managed Files (OMF) naming convention. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

A bitmap join index is defined as __________.

An index used to join two bitmap indexes on a table. ✘ A bitmap index created for the join of two or more tables. ✘ A bitmap index created on the join of two or more indexes. ✘ A bitmap index created on the join of two or more indexed-organized tables. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Oracle9i offers the ability to monitor the dynamic use of the SGA through the DB_CACHE_ADVICE parameter.
When this parameter is set to READY, what is its effect?

The Advisory is on and will capture both CPU and memory overhead. ✘ The Advisory is on but the memory for the Advisory is not allocated. ✘ The Advisory is off and the memory for the Advisory is not allocated. ✘ The Advisory is off but the memory for the Advisory remains allocated. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Examine the following parameter settings from an initialization (init.ora) file:

DB_CREATE_FILE_DEST ='/u01/oradata/'
DB_CREATE_ONLINE_LOG_DEST_1 ='/u02/oradata/'
DB_CREATE_ONLINE_LOG_DEST_2 ='/u03/oradata/'

If you create an Oracle Managed Files (OMF) database using these settings, what is the result?

The data files, temp files, and control file will be on device /u01; one online redo log group will be on device /
u02; another redo log group will be on device /u03.

✘

The data files and temp files will be on device /u01; one copy of the control file and one online redo loggroup will be on device /u02; another copy of the control file and a second redo log group will be on device /
u03.

✘

The data files, temp files, online redo log files, and control file will be on device /u01; multiplexed copies ofthe archive log files will be created; one set on device /u02, and another set on device /u03.

✘

The data files and temp files will be on device /u01; one copy of the control file and the first member in eachonline redo log group will be on device /u02; another copy of the control file and a second member of each
redo log group will be on device /u03.

✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which four are true regarding the Workspace Manager in Oracle9i? (Choose four)

Automatically versions all tables. Automatically installed with Oracle9i. Merges changes with parent rows or discard changes. Provides mechanism to identify and resolve conflicts. Allows for version enabling tables by use of a packages procedure.

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

To increase the availability of an Advanced Replication environment, you can add a new master to a replication
group without quiescing the group. This is achieved ___________.

Only when the new master site already has existing replication groups. ✘ By issuing a single command to create, populate, and activate the new master. ✘ When the master definition site is not the same for all of the master groups. ✘ Without impacting end users who are executing data manipulation language (DML) commands on thereplicated tables. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

In user-managed backup and recover procedures, how are data files backed up?

Using SQL commands. ✘ Using SQL*Plus commands. ✘ Using operating system commands. ✘ Using Recover Manager commands. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

10.

Which statement is true regarding checkpoints and recovery?

A checkpoint defines the highest system change number (SCN). ✘ All redo entries higher or at the SCN are known to be written to the data files. ✘ Only the redo records containing SCNs higher then the checkpoint need to be applied during recovery. ✘

The LOG_CHECKPOINT_INTERVAL initialization parameter specifies the amount of time betweenincremental checkpoints.

✔

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 3

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