YouareenablingtheAutomaticSharedMemoryManagementfeatureintheOracleDatabase10gtoensurethatt

A. The underlying tables must have data.

B. You need SELECT privileges on the view.

C. The underlying tables must be in the same schema.

D. You need SELECT privileges only on the underlying tables.

of file handles allowed to it by the operating system.Which method will reduce the number of file handles in use?（）

A.Activating the MySQL Enterprise thread pool plugin

B.Relocating your data and log files to separate storage devices

C.Disconnecting idle localhost client sessions

D.Implementing storage engine data compression options

nt wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results? （）

A. SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE >5;

B. SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE >5;

C. SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 >5;

D. SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 >5;

A. The clients must be created manually on the test machines to perform more realistic testing.

B. Restart the database in RESTRICTED mode before beginning workload replay to enable a clean state for workload replay.

C. Restart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.

D. The application state of the capture system must be identical to the application state of the replay system when the workload replay begins.

A.Binary backups are usually faster than text backups

B.Binary backups are usually slower than text backups

C.Text backups are human-readable while binary backups are not

D.Binary backups are not portable across different operating systems

Yourecentlyaddedathird-partyapplicationtoyourdatabaseanddonothaveaccesstotheSQLcodeofthisapplication.Databaseusersarecomplainingofperformance-relatedissues，suchasincreasedtimerequiredtocompleteaquery.Whileinvestigating，youdiscoverfromtheSTATSPACKutilitythatsomeofthememorystructureshavelowhitratios.YouplantoresizesomeofthememorystructuresbyusingtheMemoryAdvisor.ForwhichmemorystructurewillyoufailtoobtainoptimalsettingsbyusingtheMemoryAdvisor？（）

A. The two statements produce identical results.

B. The second statement returns a syntax error.

C. There is no need to specify DESC because the results are sorted in descending order by default.

D. The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.

LE’；INDEX_NAMESTATUS-----------------------------------------EINDUNUSABLEWhichtwostatementsabouttheaboveindexaretrue（）

A.Itisignoredbythequeryoptimizer.

B.Itisnotusedwhiletheindexisbeingrebuilt.

C.Theindexcannotberebuilt，andhastobere-created.

D.Theindexisautomaticallyrebuiltwhenusedthenexttime

YourecentlycreatedadatabaseandconfiguredtheSPFILEwiththefollowingparametersettingstoensurethatOracleautomaticallyadjuststhememoryfortheProgramGlobalArea（PGA）：

SORT_AREA_SIZE=150M

HASH_AREA_SIZE=150M

BITMAP_MERGE_AREA_SIZE=150M

CREATE_BITMAP_AREA_SIZE=150M

WORKAREA_SIZE_POLICY=AUTO

YouhavenotincludedthePGA_AGGREGATE_TARGETinitializationparameterintheSPFILEandtheSystemGlobalArea（SGA）iscurrentlysizedat4G.

WhatisthetotalPGAmemoryallocatedacrossalldatabaseserverprocesses？（）

A.Thedatabaseisinmountstate.

B.Oneofthetablespacesisoffline.

C.Oneofthetablespacesisreadonly.

D.ThedatabaseoperatesinARCHIEVELOGmode.

E.ThedatabaseoperatesinNOARCHIEVELOGmode.