多项选择题

A.AB.BC.CD.DThe CURSOR_SHARING parameter is set to SIMI……

The CURSOR_SHARING parameter is set to SIMILAR at the instance level and you issue these SELECT statements in the order shown below：
SELECT * FROM employees WHERE department_id=50；
SELECT * FROM employees WHERE department_id=70；
There is an index on the DEPARTMENT ID column of the 1，000，000 row EMPLOYEES table. Ninety percent of the employees are part of the DEPARTMENT_ID 50. In which two scenarios will Oracle9i share the corresponding cursors for the two statements？（）

A.A
B.B
C.C
D.D

<上一题目录下一题>

热门试题

单项选择题ThedirecthandoffconnectionmethodtoanOracle9iSharedServerinvolvesfewermessagesthaninpreviousreleasesofthemultithreadedarchitecture.Whichtypeofmessagehasbeeneliminated？（）

A.The initial request from the client to the listener.
B.Messages between the dispatcher and the shared server background processes.
C.A redirect message from the listener to the client during client connections.
D.Round-trip messages between the listener and the shared server background processes.

多项选择题WhichthreeresourceplanparametersareusedtoenableAutomaticConsumerGroupSwitchingtoestimatejobexecutiontimesautomatically，andtoperformaswitchtoalowpriorityconsumergroupbeforetheyareinitiated？（）

A.SWITCH_TIME
B.SWITCH_GROUP
C.MAX_SESS_POOL
D.SWITCH_ESTIMATE

单项选择题Thedatabasewasstartedupusingatextparameterfile.WhatwillbethedefaultscopeofchangesmadebyusingtheSETclauseoftheALTERSYSTEMstatement？（）

A.Only MEMORY is updated.
B.Only SPFILE values are updated.
C.Only init.ora parameters are updated.
D.Both init.ora parameters and SPFILE values are updated.

多项选择题Which two are regarding automatic space management segments？（）

A.A
B.B
C.C
D.D

多项选择题Media recovery can sometimes be stopped by the inability to read past a certain point in the redo stream. This is often referred to as “stuck recovery”. Before Oracle9i， the Database Administrator had few options to deal with stuck recovery. If the corrupt redo could not be recovered from some other source， then all transactions that committed after the corrupt point in the redo steam would be lost. Oracle9i changes that with the Trial Recovery feature. Trial Recover is used to test the application of the redo logs to the database. What are three other characteristics of Trial Recovery（）

A.Speeds up subsequent media recover actions.
B.Writes any uncorrupted block to disk during the test recovery.
C.Can be invoked by adding the TEST option to any RECOVER command.
D.Allows the Administrator to determine how many blocks are affected by corruption.
E.Marks blocks as corrupt in memory， allowing the test recover to proceed to completion.