![](https://lstatic.shangxueba.com/sxbzda/h5/images/m_q_title.png)
Inwhichscenarioswouldyourebuildanindex?()
A.whenyouneedtodisabletheindexusage
B.whenyouneedtochangestorageoptions
C.whenyouneedtoenableindexmonitoring
D.whenyouneedtomovetheindextoanothertablespace
![](https://lstatic.shangxueba.com/sxbzda/h5/images/tips_org.png)
A.whenyouneedtodisabletheindexusage
B.whenyouneedtochangestorageoptions
C.whenyouneedtoenableindexmonitoring
D.whenyouneedtomovetheindextoanothertablespace
第1题
A.Displaysonlythelistofdefaultvalues
B.Displaysonlythelistofallbasicparameters
C.Displaysthecurrentlyineffectparametervalues
D.Displaysonlythelistofalladvancedparameters
E.Displaysthelistofalltheparameterfilesofadatabase
F.Displaysthecurrentcontentsoftheserverparameterfile.
第2题
ently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache.What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance?()
A. Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the SQL Tuning Advisor (STA) on the workload captured in the STS.
B. Run the Automatic Workload Repository Monitor (ADDM).
C. Create an STS that contains the queries cached in the library cache and run the SQL Performance Analyzer (SPA) on the workload captured in the STS.
D. Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS.
第3题
A.os
B.local
C.-8:00
D.dbtimezoneLi
E.Australia
第4题
A_TARGET=10GBSGA_MAX_SIZE=14GBSTREAMS_POOL_SIZE=1GBSHARED_POOL_SIZE=3GBWhichtwostatementsarecorrectinthisscenario?()
A.Amaximumof3GBcanbeallocatedtosharedpool
B.ThevalueforSGA_TARGETcanbeincreaseduptoamaximumof15GB
C.Atotalof14GBmemorywillbeallocatedtotheautomaticallytunedmemorycomponents.
D.IncreasingthevalueforSGA_TARGETwillautomaticallyincreasethememoryallocatedforSTREAMS_POOL_SIZE
E.IncreasingthevalueforSGA_TARGETto12GBwillautomaticallyincreasethememoryallocatedtoautotunedparameters
F.ReducingthevalueforSGA_TARGETto9GBwillautomaticallydecreasethememoryallocatedtosharedpoolfrom3GBto2GB
第5题
hedevelopersareresponsibleformodifyingthetablestructureaccordingtotheapplicationrequirements.However,youwanttokeeptrackoftheALTERTABLEcommandsbeingexecutedbydevelopers,soyouenableauditingtoachievethisobjective.Whichtwoviewswouldyourefertofindouttheauditinformation?()
A.DBA_AUDIT_TRAIL
B.DBA_AUDIT_SESSION
C.DBA_FGA_AUDIT_TRAIL
D.DBA_COMMON_AUDIT_TRAIL
第6题
L_PLAN_BASELINES=FALSEOPTIMIZER_USE_SQL_PLAN_BASELINES=TRUEYou want to manage the SQL plan evolution task manually. Examine the following steps:1. Set the evolve task parameters.2. Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK function.3. Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASKfunction.4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.5. Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function.Identify the correct sequence of steps:()
A.2,4,5
B.2,1,4,3,5
C.1,2,3,4,5
D.1,2,4,5
第7题
A.Itkeepstrackofchangesinthebackgroundprocesses.
B.Itrecordsthesystemchangenumber(SCN)inthecontrolfile.
C.Itwritesauditrecordsforuserchangestothechangetrackingfile.
D.Itrecordsanychangestothelistenedconfigurationinthelistener.orafile.
E.Itrecordsanychangestothedatabaseparametersinthechangetrackingfile.
F.Itrecordsthephysicallocationofallthechangesthataremadetothedatabaseinthechangetrackingfile.
第8题
A.Thisclauseisnotvalidforatemporaryorundotablespace.
B.IfthetablespaceisintheNOLOGGINGmode,nooperationonthetablespacewillgenerateredo.
C.ThetablespacewillbeIntheNOLOGGINGmodebydefault,ifnotspecifiedwhilecreatingatablespace.
D.Thetablespace-levelloggingattributecanbeoverriddenbyloggingspecificationatthetable,index,materializedview,materializedviewlog,andpartitionlevels.
第9题
A.A
B.B
C.C
D.D
第10题
tedaqueryonalargetableinthepeaktransactionalhourthatperformsbulkinserts.Thequeryrunsformorethan15minutesandthenSCOTTreceivesthefollowingerror:ORA-01555:snapshottoooldWhatcouldbethereasonforthiserror()
A.Thequeryisunabletogetaread-consistentimage.
B.ThereisnotenoughspaceinFlashRecoveryArea.
C.Thereisnotenoughfreespaceintheflashbackarchive.
D.Thequeryisunabletoplacedatablocksinundotablespace
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!