网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
判断题
SetTransObject（ transaction ）中的transaction必须是SQLCA。
A
对
B
错
参考答案
参考解析
解析：
暂无解析
更多 “判断题SetTransObject（ transaction ）中的transaction必须是SQLCA。A 对B 错” 相关考题
考题
开始事务，提交事务，回滚事务的英语单词分别是：A.begin transaction , rollback transaction , commit transactionB.commit transaction , rollback transaction , begin transactionC.rollback transaction , begin transaction , commit transactionD.begin transaction , commit transaction , rollback transaction
考题
Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?()
A. point-in-time recoveryB. execute the ROLLBACK command with transaction numberC. flashback the database to before the transaction was committedD. determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery
考题
哪个消息是MGC发给MG的心跳消息?()
A、!/1[192.168.6.71]:2944Transaction=20{Context=-{AuditValue=ROOT{Audit{}}}}B、!/1[192.168.6.71]:2944Transaction=5{Context=-{Auditcapability=A0{Audit{Media,packages}}}}C、!/1[191.2.6.213]:2944Transaction=275{Context=-{Notify=ROOT{ObservedEvents=0{19700101T01153516:it/ito}}}}D、!/1[192.168.1.119]:2944Transaction=2050{Context=-{AuditValue=ROOT{Audit{Package s}}}}
考题
WhichtwostatementsregardingtheFLASHBACK_TRANSACTION_QUERYviewarecorrect?()
A.YoucanfindinformationaboutonlyactivetransactionsfromtheviewB.YoucanfindinformationaboutreadonlytransactionsfromtheviewC.YourequiretheSELECTANYTRANSACTIONsystemprivilegetoaccesstheviewD.YoucanfindinformationaboutbothactiveandcommittedtransactionsfromtheviewE.YourequiretheSELECTONFLASHBACK_TRANSACTION_QUERYobjectprivilegetoaccesstheview
考题
用于提交和回滚事务的语句为（ ）。A.END TRANSACTION和ROLLBACK TRANSACTION
B.COMMIT TRANSACTION和ROLLBACK TRANSACTION
C.SAVE TRANSACTION和ROLLUP TRANSACTION
D.COMMIT TRANSACTION和ROLLUP TRANSACTION
考题
在Hibernate中，下列关于Transaction说法正确的有（）A、事务Transaction为应用程序指定以原子操作单元为范围的对象B、在对数据库进行增加、修改和删除操作时一定要加上TransactionC、在对数据库进行查询操作时一定要加上TransactionD、获得Transaction的方法：Transaction tr = session.beginTransaction（）；
考题
V5.x系统中，手工清除Sybase中zxcms数据库日志的SQL语句是（）A、dump transaction zxcms with no_logB、dump transaction zxcms with nologC、dump transaction zxcms with no-logD、drop transaction zxcms with nolog
考题
下面关于Hibernate中Transaction的使用说法正确的是（）A、Transaction是可有可无的B、Transaction在做查询的时候是可有可无的C、Transaction在做修改的时候是可有可无的D、Transaction在做修改的时候是必须的
考题
下面关于Hibernate中Transaction的使用说法正确的是（）。A、Transaction是可有可无的B、Transaction在做查询的时候是可选的C、Transaction在做删除的时候是可选的D、Transaction在做修改的时候是可选的
考题
下面语句中，能够正确的进入数据库事务的是：（）A、@transaction.non_atomic_requestsB、@transaction.atomicC、withtransaction.atomic（）：D、withtransaction.non_atomic_requests（）：
考题
By using the transaction identifier provided by（）for a particular row change， you can use the Flashback Transaction Query to see the operation performed by the transaction. A、 Flashback TableB、 Flashback DatabaseC、 Flashback Version QueryD、 The RMAN REPORT commandE、 The DBA_PENDING_TRANSACTIONS view
考题
Which of the following describes how a distributed resumable transaction behaves？（） A、 The resumable setting on the initiating session determines the resumable conditions for the entire distributed transaction.B、 The resumable setting for the initiating instance determines the resumable conditions for the entire distributed transaction.C、 The resumable setting on the initiating session controls only that part of the transaction that occurs within the local instance； remote resumable settings determine the behavior of the distributed parts of the transaction.D、 None of the above.
考题
Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?（）A、point-in-time recoveryB、execute the ROLLBACK command with transaction numberC、flashback the database to before the transaction was committedD、determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery
考题
A user performs an update on a table. Shortly after committing the transaction， they realize that they had an error in their WHERE clause causing the wrong rows to be updated. Which Flashback option would allow you to undo this transaction and restore the table to its previous state？（）A、 Flashback DropB、 Flashback QueryC、 Flashback Versions QueryD、 Flashback Transaction QueryE、 Flashback Table
考题
At 10：30 A.M.， you ran a batch job by mistake， which executed a transaction in the database. The transaction identifier of the transaction that made to the changes in the database is 0500A00627B000. At 11：10 A.M.， you stopped the batch job. Now， you want to identify the changes made to the database tables by the batch job. Which view will you query？（）A、 DBA_PENDING_TRANSACTIONSB、 DBA_AUDIT_STATEMENTC、 V$FLASHBACK_DATABASE_STATSD、 FLASHBACK_TRANSACTION_QUERY
考题
单选题By using the transaction identifier provided by（）for a particular row change， you can use the Flashback Transaction Query to see the operation performed by the transaction.A
Flashback TableB
Flashback DatabaseC
Flashback Version QueryD
The RMAN REPORT commandE
The DBA_PENDING_TRANSACTIONS view
考题
单选题By using the transaction identifier provided by （） for a particular row change， you can use the Flashback Transaction Query to see the operation performed by the transaction.A
Flashback TableB
Flashback DatabaseC
Flashback Versions QueryD
the RMAN REPORT commandE
the DBA_PENDING_TRANSACTIONS view
考题
单选题Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions？（）A
point-in-time recoveryB
execute the ROLLBACK command with transaction numberC
flashback the database to before the transaction was committedD
determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery
考题
单选题Which of the following describes how a distributed resumable transaction behaves？（）A
The resumable setting on the initiating session determines the resumable conditions for the entire distributed transaction.B
The resumable setting for the initiating instance determines the resumable conditions for the entire distributed transaction.C
The resumable setting on the initiating session controls only that part of the transaction that occurs within the local instance； remote resumable settings determine the behavior of the distributed parts of the transaction.D
None of the above.
考题
单选题A user performs an update on a table. Shortly after committing the transaction， they realize that they had an error in their WHERE clause causing the wrong rows to be updated. Which Flashback option would allow you to undo this transaction and restore the table to its previous state？（）A
Flashback DropB
Flashback QueryC
Flashback Versions QueryD
Flashback Transaction QueryE
Flashback Table
考题
多选题In WebLogic 10.3.6 and 12c, transaction logs can optionally write to a JDBC store instead of a file store on the file system. Identify the three benefits as a result of this capability.（）Asimplified disaster recovery architecture and effortsBbetter performance than writing logs to a file storeCcommon storage of transaction logs with application dataDcommon replication of transaction logs with application dataEhigher transaction throughput
考题
单选题View the following SQL statements： Transaction T1 INSERT INTO hr.regions VALUES （5，’Pole’）；COMMIT； Transaction T2 UPDATE hr.regions SET region_name=’Poles’ WHERE region_id = 5； COMMIT； Transaction T3 UPDATE hr.regions SET region_name=’North and South Poles’ WHERE region_id = 5； You want to back out transaction T2. Which option would you use？（）A
It is possible，but transaction T3 also backs out.B
It is possible with the NOCASCADE_FORCE option.C
It is possible with the NONCONFLICT_ONLY option.D
It is not possible because it has conflicts with transaction T3.
考题
多选题The session of user SCOTT receives the following error after executing an UPDATE command on the EMPtable： ERROR at line 1： ORA-00060： deadlock detected while waiting for resource On investigation， you find that a session opened byuser JIM has a transaction that caused the deadlock. Which two statements are true regarding the session ofSCOTT in this scenario（）AThe session is terminated after receiving the error and JIM can continue with his transaction.BSCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.CThe session is rolled back after receiving the error and JIM can continue with his transaction.DSCOTT has to reexecute the last command in the transaction after he commits the transaction.
考题
多选题You work as a database administrator for Certkiller .com. In the middle of a transaction， a user session was abnormally terminated but the instance is still up and the database is open. Which two statements are true in this scenario？（）AEvent Viewer gives more details on the failure.BThe alert log file gives detailed information about the failure.CPMON rolls back the transaction and releases the locks.DSMON rolls back the transaction and releases the locks.EThe transaction is rolled back by the next session that refers to any of the blocks updates by the failed transaction.FData modified by the transaction up to the last commit before the abnormal termination is retained in the database.
考题
多选题在Hibernate中，下列关于Transaction说法正确的有（）A事务Transaction为应用程序指定以原子操作单元为范围的对象B在对数据库进行增加、修改和删除操作时一定要加上TransactionC在对数据库进行查询操作时一定要加上TransactionD获得Transaction的方法：Transaction tr = session.beginTransaction（）；
热门标签
最新试卷
