YouaremaintainingtheSALESdatabaseforeSoftCorporation.YouhavenotconfiguredASMMonthedatabase
A.SQLTuningAdvisor
B.UndoAdvisor
C.ADDM
D.MemoryAdvisor
A.SQLTuningAdvisor
B.UndoAdvisor
C.ADDM
D.MemoryAdvisor
第1题
A.DROPUSERSMITH;
B.DROPTABLEEMPLOYEES;
C.DROPTABLESPACEUSERS;
D.ALTERTABLESALES_REPDROPPARTITIONP1;
E.ALTERTABLEEMPLOYEESDROPCOLUMNDESIG_ID;
第2题
eUSER_DATAtablespace.Thepocketsofemptyspacesaretoosmalltobereusedindividually.Thisisleadingtowastageofspace.Youdecidetoperformtheshrinkoperationtoreclaimthewastedspace.WhichadvisorwillyouusetodeterminetheobjectsintheUSER_DATAtablespacethataregoodcandidatesfortheshrinkoperation?()
A.SQLTuningAdvisor
B.SQLAccessAdvisor
C.UndoAdvisor
D.SegmentAdvisor
第3题
A. Column definitions cannot be altered to add DEFAULT values.
B. A change to the DEFAULT value affects only subsequent insertions to the table.
C. Column definitions cannot be altered at add DEFAULT values for columns with a NUMBER data type.
D. All the rows that have a NULL value for the SALARY column will be updated with the value 5000.
第4题
thetable.YoudecidetoinvoketheSQLAccessAdvisortodeterminetheappropriateindextobecreated.WhichpackagewillyouusetoinvoketheSQLAccessAdvisor?()
A.DBMS_SERVER_ALERT
B.DBMS_ADVISOR
C.DBMS_RESOURCE_MANAGER
D.DBMS_REPAIR
第5题
n. You executed the following command to startup the Automatic Storage Management (ASM) instance.SQL> STARTUP;Which two activities are performed during a successful start up operation? ()(Choose two.)
A. The databases configured to use the ASM instance are mounted
B. The disk groups are mounted as per the ASM_DISKGROUPS initialization parameter
C. ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not started
D. ASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters
第6题
A.ADDM
B.AWR
C.CursorCache
D.SQLTuningSets
E.FlashRecoveryArea
第7题
A.SELECTcust_last_name,cust_credit_limitFROMcustomersORDERBYcust_credit_limitDESC
B.SELECTcust_last_name,cust_credit_limitFROMcustomersORDERBYcust_credit_limit
C.SELECTcust_last_name,cust_credit_limitFROMcustomersORDERBYcust_credit_limitNULLSLAST
D.SELECTcust_last_name,cust_credit_limitFROMcustomersORDERBYcust_last_name,cust_credit_limitNULLSLAST
第8题
A.MemoryAdvisor
B.SegmentAdvisor
C.UndoAdvisor
D.SQLTuningAdvisor
第9题
A.ThedatabasemustbeintheARCHIVELOGmode.
B.Theautomaticmemorytuningmustbeenabled.
C.Thechangetrackingfeaturemustbeenabled.
D.Theautomaticmemorytuningmustbedisabled.
第10题
A.Thedatabasewouldopennormally.
B.Thedatabasewouldnotopen,anditwouldstopatmountstage.
C.Thedatabasewouldopenafterautomaticallyperforminginstancerecovery.
D.Thedatabasewouldnotopen,andyouhavetoperformdatabaserecoverytoopenit.
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!