题目内容
（请给出正确答案）
A.TheWebSessionAffinityfeatureofActiveGridLinkforRAC
B.WebLogicClustering
C.TheTransactionAffinityfeatureofActiveGridLinkforRAC
D.Coherence*WebSessionReplication
如搜索结果不匹配，请 联系老师 获取答案
更多“Acustomerhasacritical,performa…”相关的问题
第1题
ofqueries，butaccessadifferentsubsetofdatainthetables，dependingonwhichdepartmentgeneratesthereport.Theformatofthereportsisbeingdeveloped；currently，theformatchangesdaily.Howwouldyouconfigurethedatabasetoensurethateachdepartmentgeneratesitsreport（basedonitstargetdata）usingthemostrecentreportformateveryday？（）
A.Byhavingeachuserrunthereportgenerationprocedureatthescheduledtime，supplyingthenecessaryinputvariables.
B.BycreatingaprogramusingDBMS_JOBthatacceptsoneormorevariables，andcreatingajobthatcallsthisprogramusingDBMS_JOB.
C.ByhavingeachuserscheduleajobusingDBMS_JOBthatacceptsoneormoreinputvariablesandcallsaprocedurethatgeneratesthereport.
D.ByhavingeachusercreateajobusingDBMS_SCHEDULERthatincludesalltheinformationandcommandsnecessarytogeneratethereport.
E.BycreatingaprogramusingDBMS_SCHEDULERthatacceptsoneormorevariables，andcreatingajobthatcallsthisprogramusingDBMS_SCHEDULER.
第2题
.YouwanttokeeptrackofallofthetransactionshappeningonthetableusingPL/SQL.WhichtypeofPL/SQLsubprogramorconstructwouldyouusetoaccomplishthistask？（）
A.functions
B.packages
C.procedures
D.databasetriggers
E.anonymousPL/SQLblock
第3题
A.System.load（"prop.custom"）；
B.System.getenv（"prop.custom"）；
C.System.property（"prop.custom"）；
D.System.getProperty（"prop.custom"）；
E.System.getProperties（）.getProperty（"prop.custom"）；
第4题
A.UsetheDataBlockWizardandbasetherelationonaREFpointer.
B.IntheObjectNavigator,selecttheRelationnodeunderthemasterblockandclicktheCreateicon.Buildtherelationmanuallyandcoordinatetheblocksusingtriggers.
C.UsetheDataBlockWizard,andbasetherelationontheprimarykey-foreignkeyrelationshipinthedatabase.
D.Thistaskisnotpossiblebecausemaster-detailrelationscanbeimplementedonlyforblocksbasedonrelationaltables.
第5题
You execute the following commands to audit database activities:SQL >ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE;SQL >AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL;Which statement is true about the audit record that generated when auditing after instance restarts?（）
A. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.
B. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.
C. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.
D. One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.
E. One audit record is created for the whole session if john successfully executes a SELECT, INSERT,or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.
第6题
A.runaproceduretocheckthetablespacespaceusage
B.definethewarningthresholdforthetablespaceat75%inDatabaseControl
C.createatriggertobeexecutedwhentablespacespaceusagereaches75%
D.submitajobbyusingDBMS_JOBpackagetocheckthefreespaceinthetablespaceatregularintervals
E.definethewarningthresholdtobe75%forthetablespacebyALTERTABLESPACE..ADDTHRESHOLDcommand
第7题
hat create the EMPLOYEES and DEPARTMENTS tables:On the EMPLOYEES table, EMPLOYEE_ID is the primary key.MGR_ID is the ID of managers and refers to the EMPLOYEE_ID.DEPT_ID is foreign key to DEPARTMENT_ID column of the DEPARTMENTS table.On the DEPARTMENTS table, DEPARTMENT_ID is the primary key.Examine this DELETE statement:What happens when you execute the DELETE statement?（）
A. Only the row with department ID 40 is deleted in the DEPARTMENTS table.
B. The statement fails because there are child records in the EMPLOYEES table with department ID 40.
C. The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 110 and 106 are deleted from the EMPLOYEES table.
D. The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 106 and 110 and the employees working under employee 110 are deleted from the EMPLOYEES table.
E. The row with department ID 40 is deleted in the DEPARTMENTS table. Also all the rows in the EMPLOYEES table are deleted.
F. The statement fails because there are no columns specifies in the DELETE clause of the DELETE statement.
第8题
D_PLAN：BEGINDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN（SIMPLE_PLAN=>’prod_plan’，CONSUMER_GROUP1=>’fin_group1’，GROUP1_CPU=>80，CONSUMER_GROUP2=>’pay_group1’，GROUP2_CPU=>20）；END；Whichthreestatementsaretrue？（）
A.SYS_GROUPgets100%CPUresourcesatlevel1.
B.FIN_GROUP1gets80%CPUresourcesatlevel1.
C.FIN_GROUP1gets80%CPUresourcesatlevel2.
D.PAY_GROUP1gets20%CPUresourcesatlevel1.
E.PAY_GROUP1gets20%CPUresourcesatlevel2.
F.OTHER_GROUPgets100%CPUresourcesatlevel1.
G.OTHER_GROUPgets100%CPUresourcesatlevel2.
第9题
gevolumeoftransactionsfromnon-DBAusersinthelastonehour.TheundotablespaceUNDOTBS1isfullwithtransactionsandnotransactionwascommittedmorethanonehourago.Thedatabasehastwomoreundotablespaces.WhathappenstothenewDMLoperationsinthisscenario（）
A.TheDMLcommandswillfail.
B.TheundodatageneratedbytheDMLisstoredinoneofthetwootherundotablespaces.
C.TheundodatageneratedbytheDMLwilloverwritetheextentsthatcontaincommittedundodata.
D.TheundodatageneratedbytheDMLisstoredintheSYSTEMundosegmentoftheSYSTEM
第10题
erver.All databases of all versions use Automatic Storage Management (ASM).Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group?（）
A. The ASM compatibility attribute controls the format of the disk group metadata.
B. RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.
C. The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.
D. The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.
E. The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10g database.
为了保护您的账号安全，请在“上学吧”公众号进行验证，点击“官网服务”-“账号验证”后输入验证码“”完成验证，验证成功后方可继续查看答案！
微信搜一搜
上学吧
微信搜一搜
上学吧
