Whichofthefollowingarenotdisabledbydefault?()
A.Jobs
B.Chains
C.Windows
D.Windowgroups
E.Schedule
A.Jobs
B.Chains
C.Windows
D.Windowgroups
E.Schedule
第1题
A.Thejobpriorityis1andtheresourceconsumergroupCPUemphasisallocationisalowpercentage.
B.Thejobaffinityistoaserviceandonenodeinthatserviceisunavailable.
C.Thejobaffinityistoaninstanceandthatinstanceisunavailable.
D.Thereisnoserviceaffinity.
E.Noneoftheabove.
第2题
se.Youhavetwodiskgroups,DG1andDG2,withonedeviceeach.Intheparameterfileoftheproductiondatabase,thefollowingparametershavebeenspecified:DB_CREATE_ONLINE_LOG_DEST_1=’+dg1’DB_CREATE_ONLINE_LOG_DEST_2=’+dg2’Whatwouldbetheimpactofthissetting?()
A.Whenanewloggroupisadded,itwouldhaveonememberineachdiskgroup.
B.Whenanewloggroupisadded,itwouldhavetwomembersineachdiskgroup.
C.Whenanewtablespaceisadded,itwouldhaveonedatafileineachdiskgroup.
D.Whenanewlogfileisadded,itwouldhaveonememberspreadacrossthediskgroups.
第3题
A.Systemmonitor(SMON)
B.Processmonitor(PMON)
C.Memorymanagerprocess(MMAN)
D.ManageabilityMonitorprocess(MMON)
第4题
A. The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.
B. The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash.
C. The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement.
D. The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR.
第5题
aticStorageManagement[ASM]instancetomanagethedatabasefiles):CREATETABLESPACEuser_tbspDATAFILE’+dgroup3(user_temp)/user_files/user_tbsp’SIZE200MWhatwouldbetheresultofthiscommand?()
A.Itwouldresultinanerrorbecausethetemplatecannotbeusedalongwiththediskgroup.
B.Itwouldresultinanerrorbecausethepathcannotbespecifiedwhilecreatingatablespaceinadiskgroup.
C.Itwouldcreateatablespacewithadatafilethathasanalias,anditsattributesaresetbytheuserdefinedtemplate.
D.Itwouldcreateatablespacewithadatafilethatdoesnothaveanalias,anditsattributesaresetbytheuserdefinedtemplate.
第6题
efinitionlanguage(DDL)command:SQL>SELECTenameFROMempWHEREjob=’CLERK’FORUPDATEOFempno;SCOTThasopenedanothersessiontoworkwiththedatabaseinstance.WhichthreeoperationswouldwaitwhenissuedinSCOTT’ssecondsession()
A.LOCKTABLEempINSHAREMODE;
B.LOCKTABLEempINEXCLUSIVEMODE;
C.UPDATEempSETsal=sal*1.2WHEREjob=ANAGER?UPDATEempSETsal=sal*1.2WHEREjob=?ANAGER?
D.INSERTINTOemp(empno,ename)VALUES(1289,’Harry’);
E.SELECTenameFROMempWHEREjob=’CLERK’FORUPDATEOFempno
第7题
A. setting the STATISTICS_LEVEL parameter to TYPICAL
B. adding filters to the Automatic Database Diagnostic Monitor (ADDM)
C. enabling Automated Maintenance Task using Oracle Enterprise Manager
D. setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
第8题
A.Dateformat
B.Decimalcharacter
C.Groupseparator
D.Firstdayofthemonth
E.Noneoftheabove
F.Alloftheabove
第9题
A. Diagnose and repair a data file corruption offline.
B. Diagnose and repair a data file corruption online.
C. Diagnose and repair failures on a standby database.
D. Recover from failures in the Real Application Cluster (RAC) environment.
第10题
A.Easeofdiskadministrationandmaintenance
B.Loadbalancingacrossphysicaldisks
C.SoftwareRAID-1dataredundancywithdoubleortriplemirrors
D.Automaticrecoveryoffaileddisks
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!