题目内容
（请给出正确答案）
A.VERSIONS_STARTSCN
B.VERSIONS_STARTTIME
C.VERSIONS_XID
D.VERSIONS_OPERATION
如搜索结果不匹配，请 联系老师 获取答案
更多“YouaremaintainingyourOLTPdatab…”相关的问题
第1题
vilegetotheSKDuserwithADMINOPTION.2：TheSKDusercreatesatable.3：TheSKDusergrantstheCREATETABLEsystemprivilegetotheHRuser.4：TheHRusercreatesatable.5：TheDBArevokestheCREATETABLEsystemprivilegefromSKD.Whichstatementistrueafterstep5isperformed（）
A.ThetablecreatedbySKDisnotaccessibleandSKDcannotcreatenewtables.
B.ThetablescreatedbySKDandHRremain，butbothcannotcreatenewtables.
C.ThetablecreatedbyHRremainsandHRstillhastheCREATETABLEsystemprivilege.
D.ThetablecreatedbyHRremainsandHRcangranttheCREATETABLEsystemprivilegetootherusers.
第2题
A.V$BACKUP_CORRUPTION
B.V$COPY_CORRUPTION
C.V$DATABASE_BLOCK_CORRUPTION
D.RC_BACKUP_CORRUPTION
第3题
A.OnlydatablocksoftheSYSTEMtablespacewillbechecked.
B.OnlydatablocksoftheSYSAUXtablespacewillbechecked.
C.Achecksumwilloccuronlyonthecheckpoint.
D.Achecksumwilloccureverytimeablockismodified.
第4题
oot‘@localhost‘ SQL SECURITY DEFINER VIEW ‘phone_list‘ AS SELECTe . id as id ‘e . first_name AS ‘first_name‘ ‘e . last_name AS ‘last_name‘ ‘coalesce ( ph1.phone_no, ‘ – ‘) AS ‘office_no‘ ‘coalesce (ph2 .phone_no, ‘ – ‘) AS ‘cell_no‘ FROM employees e LEFT JOIN employee_phone ph1 ON ph1.emp_id = e.id AND ph1.type = ‘office‘ LEFT JOIN employee_phone ph2 ON ph2 .emp_id = e.id AND ph2 .type = ‘mobile‘The tables employees and employee_phone are InnoDB tables;all columns are used in this view. The contents of the phone_list view are as follows: Mysql> select * from phone_list; 1 row in set (0.00 sec)Which method can you use to change the cell_no value to ‘555-8888‘ for John Doe?（）
A.INSERT INTO employee_phone (emp_id, phone_no, type) VALUES (1, ‘555-8888‘,‘mobile‘)
B.UPDATE phone_list SET cell_name ‘555-8888‘ WHERE first_name= ‘John‘ and last_name= ‘Doe‘
C.DELETE FROM phone_list WHERE first_name= ‘John‘ and last_name= ‘Doe‘; INSERT INTO phone_list (first_name, last_name, office_no, cell_no) VALUES (‘John‘ , ‘Doe‘ , ‘x1234‘ , ‘555-8888)
D.UPDATE employee_phone SET phone_no= ‘555-8888‘ where emp_id=1
第5题
A.Itisnotpossibletodisabletheprimarykeyconstraint.
B.Itispossibletohavemorethanoneprimarykeyconstraintinasingletable.
C.Theprimarykeyconstraintcanbereferredbyonlyoneforeignkeyconstraint.
D.Theprimarykeyconstraintcanbeimposedbycombiningmorethanonecolumn.
E.Thenon-deferrableprimarykeyconstraintcreatesanuniqueindexontheprimarykeycolumnifitisnotalreadyindexed.
第6题
A.synchcatalog
B.resynccatalog
C.replicatecatalog
D.updatecatalog
E.restorecatalog
第7题
A.Theblockchangetrackingfeaturemustbeenabled.
B.OMFmustbeconfiguredonyourdatabase.
C.ThedatabasemustbeinARCHIVELOGmode.
D.AUSERIDmustbesupplied.
第8题
urdatabaseyousettheFAST_START_MTTR_TARGETinitializationparametertoaverylowvalue.Whateffectitwillhaveonthedatabase？（）
A.Thedatabaseperformancewouldbeenhanced.
B.Theredologfileswouldbegetfilledmorefrequently.
C.Theoveralldatabaseperformancewouldbedegraded.
D.Themeantimetorecover（MTTR）wouldbeincreased.
第9题
A.TEMP
B.UNDO
C.INDEX
D.SYSAUX
E.SYSTEM
第10题
followingerror：01578：ORACLEdatablockcorrupted（file6，block54）ORA-01110：datafile6：’u01/oracle/oradata/data1.dbf’Howwillyouresolvethisproblemofdatablockcorruptionbyreducingthemeantimetorecover（MTTR）？（）
A.byusingtheDBMS_REPAIRpackage
B.byusingtheDBVERIFYutility
C.byusingBlockMediaRecovery
D.byissuingtheANALYZETABLEHR.EMPLOYEESVALIDATESTRUCTUREcommand
为了保护您的账号安全，请在“上学吧”公众号进行验证，点击“官网服务”-“账号验证”后输入验证码“”完成验证，验证成功后方可继续查看答案！
微信搜一搜
上学吧
微信搜一搜
上学吧
