What is the new&#819...

单项选择题What is the new Oracle Shared Server?（）

A.An improved version of multithreaded server configuration.
B.A connection pooling configuration where several clients are connected to the same server process.
C.Two more database servers, which share data by means of database links; the client software is unaware to which server it is connected.
D.A configuration of Real Application Cluster where the client connection is routed to the least busy instance.

点击查看答案

您可能感兴趣的试卷

你可能感兴趣的试题

1.多项选择题Which three statements are true about the privileged connection options available in Oracle9i？（）

A.The CONNECT INTERNAL is disallowed.
B.The Server Manager tool is no longer supplied.
C.The listener must be running to make a connection.
D.The use of remote password login file (orapw<sid>) is unchanged.

点击查看答案

2.单项选择题You can control instance recover performance by setting parameters to define targets for（）

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

点击查看答案

3.单项选择题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？（）

A.ALTER TABLE employees monitor index employee_idx_fk;
B.ALTER INDEX employee_idx_fk monitoring on;
C.ALTER TABLE employees monitor all indexes;
D.ALTER INDEX employee_idx_fk monitoring usage;

点击查看答案

4.多项选择题Using a bitmap structure to manage database object space has several benefits over using freelist structures. Which three are benefits of managing space using automatic-segment-space managed objects？（）

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

点击查看答案

5.单项选择题When does Oracle9i flag an index as being used in the V$OBJECT_USAGE view？（）

A.During a query’s parse time only.
B.During a query’s execution time only.
C.During any kind of DML statement execution.
D.During the execution of an INSERT statement only.

点击查看答案

6.多项选择题Which two are true regarding external tables？（）

A.External tables can be updated.
B.External tables are read-only tables.
C.Indexes can be created on external tables.
D.Indexes cannot be created on external tables.

点击查看答案

7.单项选择题 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？（）

A.The Oracle server creates a new histogram based on existing histogram definitions for all table, column, and index statistics for the OE schema.
B.The Oracle server creates a histogram based on data distribution regardless of how the application uses the column/s for all table, column, and index statistics for the OE schema.
C.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.
D.The Oracle server creates a histogram based on application usage, regardless of data distribution, for all table, column, and index statistics for the OE schema.

点击查看答案

8.多项选择题 Examine the list of variables and their data types：
AME DATA Type
TS， TS1 TIMESTAMP
TSZ TIMESTAMP WITH TIME ZONE
TLZ TIMESTAMP WITH LOCAL TIME ZONE
IYM INTERVAL YEAR TO MONTH
IDS， IDSI INTERVAL YEAR To SECOND
Which three expressions using the new data and time data types are valid？（）

A.IDS* 2
B.TS + IYM
C.TS –TSI
D.IDS – TS
E.IDS + IYM

点击查看答案

9.单项选择题What is true if you want to switch undo tablespaces from the current one， called UNDO1， to a new one called UNDO2？（）

A.It is NOT possible to switch unless no active transaction exist in UNDO1.
B.It is possible to switch to UNDO2； but current active transactions will abort.
C.It is possible to switch to UNDO2； current active transactions will be automatically migrated to UNDO2.
D.It is possible to switch to UNDO2； only current active transactions will continue to execute inside UNDO1.

点击查看答案

10.单项选择题Which statement correctly describes the function of Oracle9i Cache Fusion feature？（）

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

点击查看答案