题目内容（请给出正确答案）

[主观题]

WhichstatementistrueregardingtheeffectofthiscommandonthetransactioninScott’ssession（）

Whichstatementistrueregardingtheeffectofthiscomman

A.Thecommandfailsasatransactionisstillpending.

B.ThetransactioninScott’ssessionisrolledbackandthetablespacebecomesread-only.

C.ThecommandwaitsandtheuserSCOTTcanexecutedatamanipulationlanguage（DML）statementsonlyaspartofthecurrenttransaction.

D.Thecommandhangsuntilalltransactionsontheobjectsinthetablespacecommitorrollback，andthenthetablespaceisplacedinread-onlymode.

查看答案

如搜索结果不匹配，请联系老师获取答案

您可能会需要：

重置密码查看订单联系客服

安装上学吧APP，拍照搜题省时又省心！

更多“Whichstatementistrueregardingt…”相关的问题

第1题

Exhibit:Examine the data in the EMPLOYEES table.Examine the subquery:SELECT last_nameFROM employeesWHERE salary IN (SELECT MAX(salary)FROM employeesGROUP BY department_id);Which statement is true?（）

A. The SELECT statement is syntactically accurate.

B. The SELECT statement does not work because there is no HAVING clause.

C. The SELECT statement does not work because the column specified in the GROUP BY clause is not in the SELECT list.

D. The SELECT statement does not work because the GROUP BY clause should be in the main query and not in the subquery.

点击查看答案

第2题

Animportanttablespaceofyourdatabaseisdropped&ens

Animportanttablespaceofyourdatabaseisdroppedbymistake.YouusetheFlashbackDatabasefeaturetoretrievethetablespace.Youperformthefollowingstepstoretrievethetablespace：

1.YoulogontoEnterpriseManagerasSYSDBA.

2.Youselectthemaintenancescreen.

3.YouchoosePerformRecoveryoptiononthemaintenancescreen.

4.YouchooseWholeDatabaseintheObjectTypedrop-downlistPerformRecovery：Typescreen.5.YouchooseRecovertoCurrentTimefromtheOperationTypeonthePerformRecovery：Typescreen.

6.YouprovidetheHostCredentialsforadatabaseuser.onthePerformRecovery：Typescreen.

7.Youclickthecontinuebutton.

Aninformationscreenappearssayingthatthedatabaseisunavailable.Whatisthisinformationscreen？（）

点击查看答案

第3题

Youexecuteacommandtoresizeadatafile，sales.dbf，ofsize200MBinyourdatabase：ALTERDATABASEDATAFILE’/remorse/sales.dbf’RESIZE150M；Whichstatementistrueaboutthiscommand（）

A.ThecommandmustbeissuedinMOUNTstate.

B.Thecommandsucceedsonlyifthedatafileisoffline.

C.Thecommandmustbeissuedwhenthedatabaseisinthearchivelogmode.

D.Thecommandsucceedsifnoextentinthetablespaceiscurrentlyallocatedabovethe150MBboundaryofthefile.

点击查看答案

第4题

WhichthreepiecesofinformationaretobemandatorilyprovidedwhilecreatinganewlistenerusingEnterpriseManagerDatabaseControl？（）

A.theportusedbythelistener

B.theprotocolusedbythelistener

C.theservernamewherethelistenerruns

D.thelogfileandtracefiledestinationforthelistener

E.thedatabaseservicestoberegisteredwiththelistener

点击查看答案

第5题

InwhichscenariodoyouusetheFlashbackDatabasefeature？（）

A.whenatableisdroppedandyourestoreitfromtheRecycleBin

B.whenauser’sschemaisdroppedandyourecovertheuser’sschema

C.whensomeincorrectdataisinsertedinthetableandyouretrievethetabletoastatethatwasatacertaintimestamp

D.whenarowofatableisupdatedfrequentlyandcommitted，andyouviewalltheversionsoftherowwithinaspecificduration

点击查看答案

第6题

Given:Which two, independently, will allow Sub to compile?（）

点击查看答案

第7题

Examine the statement:GRANT select, insert, updateON student_gradesTO managerWITH GRANT OPTION;Which two are true?（）

A. MANAGER must be a role.

B. It allows the MANAGER to pass the specified privileges on to other users.

C. It allows the MANAGER to create tables that refer to the STUDENT_GRADES table.

D. It allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.

E. It allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table.

F. It allows the MANAGER the ability to select from, delete from, and update the STUDENT_GRADES table.

点击查看答案

第8题

YouexecutethefollowingcommandtochangethestatusoftheSALEStablespace：SQL>ALTERTABLESPACEsalesOFFLINE；Whichstatementsdescribetheeffectofthecommand（）

A.Thetablespacewouldrequirerecoverytogobackonline.

B.AcheckpointistakenonalldatafilesthatareassociatedwiththeSALEStablespace.

C.ThesessionsthatsubsequentlytrytoaccesstheobjectsintheSALEStablespacereceiveanerror.

D.ThenewstatusoftheSALEStablespaceisrecordedinthecontrolfilewhenthedatabaseinstanceisclosed.

点击查看答案

第9题

Which two statements are true about encrypting RMAN backup?（） (Choose two.)

A. The transparent encryption of backups uses the encryption wallet

B. The database uses the same encryption key for every encrypted backup

C. The password encryption of backups only uses the password while creating and restoring backup

D. If transparent encryption is configured, you cannot use the SET ENCRYPTION BY PASSWORD command to make password-protected backups.

点击查看答案

第10题

Inyourdatabase，theLogWriter（LGWR）processisunabletowritetoamemberofacurrentredologgroupduetoread/writefailure.Whichtwoeffectswouldyouseeinyourdatabase？（）

A.Thedatabaseinstanceaborts.

B.Thedatabaseoperationtemporarilyhaltstillthememberbecomesavailable.

C.Writingproceedsasnormal.LGWRwritestotheavailablemembersofagroupandignorestheunavailablemembers.

D.ThememberwouldbemarkedasSTALEandanerrormessagewouldbewrittentothealertlogfileandLGWRtracefile.

E.ThestatusofthegroupchangestoINACTIVEandanerrormessagewouldbewrittentothealertlogfileandLGWRtracefile.

点击查看答案