Oracle9i Database Fundamentals Set 1

Question - 15 Maximum mark : - 29

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

What criterion does Oracle9i use to determine whether a database file is an Oracle Managed File?

The filename format. ✘ Information stored inside a data dictionary table. ✘ Information stored in the ALERT.LOG file for the corresponding instance. ✘ Information stored inside the corresponding initialization parameter file for the instance. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Oracle9i extends the cursor sharing functionality with the new value of SIMILAR for the CURSOR_SHARING
parameter. With CURSOR_SHARING = SIMILAR, cursors are shared for safe literals only. What is meant by
'safe literals only'?

No literal value is substituted for a shared cursor. ✘ Different execution plans are generated for substituted literal values. ✘ The substitution of a literal value will produce different execution plans. ✘ The substitution of any literal value will produce exactly the same execution plan. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

There is more than one way to set the server to detect and affect long running operations automatically. What
is the best choice of you want to reduce the impact of long running operations on other users without aborting
the long running operations?

Define user profiles and set the CPU_PER_CALL limit.

✘

Define a SWITCH_TIME for a plan in the Resource Manager.

✘

Create a batch job that checks V$SESSION_LONGOPS; the batch job alters the session priority of the longrunning operations.

✘

Create a user defined event in the Oracle Enterprise Manager, which monitors V$SESSION_LONGOPS.

✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which statement correctly describes the function of Oracle9i Cache Fusion feature?

It provides each session with its own view of the database at a different point in the past. ✘ It enables you to execute scalable applications on a clustered database without having to partition the usersor the database tables. ✘ It lets you dynamically reassign memory in your database buffer cache to different block buffer sizes. ✘ It allows you to add new sites to multimaster replication environment without quiescing the master definitionsite. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

What is true if you want to switch undo tablespaces from the current one, called UNDO1, to a new one called
UNDO2?

It is NOT possible to switch unless no active transaction exist in UNDO1. ✘ It is possible to switch to UNDO2; but current active transactions will abort. ✘ It is possible to switch to UNDO2; current active transactions will be automatically migrated to UNDO2. ✘ It is possible to switch to UNDO2; only current active transactions will continue to execute inside UNDO1. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Consider the following statement:
SQL> EXECUTE DBMS_STATS.GATHER_SHEMA_STATS (-
2> ownname => 'OE', -
3> estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE, -
4> method opt => 'for all columns size AUTO');
What is the effect of 'for all columns size AUTO' of the METHOD_OPT option?

The Oracle server creates a new histogram based on existing histogram definitions for all table, column,
and index statistics for the OE schema. ✘ The Oracle server creates a histogram based on data distribution regardless of how the application uses thecolumn/s for all table, column, and index statistics for the OE schema. ✘ The Oracle server creates a histogram based on data and application usage of the column/s for all table,column, and index statistics for the OE schema. ✘ The Oracle server creates a histogram based on application usage, regardless of data distribution, for alltable, column, and index statistics for the OE schema. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

When does Oracle9i flag an index as being used in the V$OBJECT_USAGE view?

During a query's parse time only. ✘ During a query's execution time only. ✘ During any kind of DML statement execution. ✘ During the execution of an INSERT statement only. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Using a bitmap structure to manage database object space has several benefits over using freelist structures. Which three are benefits of managing space using automaticsegment- space managed objects? (Choose three)

It readily responds to dynamic changes for concurrent access. It improves performance and space utilization in a multiple-instance environment. It requires fewer space related options then freelist managed structures. It improves performance for SYSTEM tablespaces where a high degree of concurrency is required.

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

The EMPLOYEES table has six indexes and DML operations are slow. Which command begins monitoring the
EMPLOYEE_IDX_FK index to determine whether it has been used by an execution plan?

ALTER TABLE employees monitor index employee_idx_fk;

✘

ALTER INDEX employee_idx_fk monitoring on;

✘

ALTER TABLE employees monitor all indexes;

✘

ALTER INDEX employee_idx_fk monitoring usage;

✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

10.

You can control instance recover performance by setting parameters to define targets for ______.

The size of the redo buffer in SGA. ✘ The instance that will perform recovery in Real Application Cluster database. ✘ The number of blocks to be read during instance recovery, or the time needed to complete instancerecovery. ✘ The number of passes through the redo logs made by the recovery process to identify blocks needingrecovery. ✔

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 1

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