网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
V5.x系统中，手工清除Sybase中zxcms数据库日志的SQL语句是（）
- A、dump transaction zxcms with no_log
- B、dump transaction zxcms with nolog
- C、dump transaction zxcms with no-log
- D、drop transaction zxcms with nolog
参考答案
更多 “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” 相关考题
考题
开始事务，提交事务，回滚事务的英语单词分别是：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
考题
View the following SQL statements: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.
考题
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数据库空间剩余情况，一般我们都是（）。A、通过Sybase中master数据库下的段来查看B、通过Sybase中master数据库下的存储过程来查看C、通过Sybase中动环网管数据库如：zxcms，下的段来查看D、通过Sybase中动环网管数据库如：zxcms，下的存储过程来查看
考题
下面关于Hibernate中Transaction的使用说法正确的是（）A、Transaction是可有可无的B、Transaction在做查询的时候是可有可无的C、Transaction在做修改的时候是可有可无的D、Transaction在做修改的时候是必须的
考题
下面关于Hibernate中Transaction的使用说法正确的是（）。A、Transaction是可有可无的B、Transaction在做查询的时候是可选的C、Transaction在做删除的时候是可选的D、Transaction在做修改的时候是可选的
考题
You are employed as a DBA in an organization. You are informed that the record of EMP_NO 1000 is missing from the SCOTT.EMP table. You are required to identify the user who deleted the record， the SQL statement that will undo the deletion， and the transaction ID of the transaction that deleted the employee record. Which feature will you use to perform the tasks？（）A、 Only the Flashback TableB、 Both the Flashback Transaction Query and the Flashback Version QueryC、 Only the Flashback DropD、 Only the Flashback Version
考题
下面语句中，能够正确的进入数据库事务的是：（）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.
考题
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.
考题
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
考题
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？（）A、Event Viewer gives more details on the failure.B、The alert log file gives detailed information about the failure.C、PMON rolls back the transaction and releases the locks.D、SMON rolls back the transaction and releases the locks.E、The transaction is rolled back by the next session that refers to any of the blocks updates by the failed transaction.F、Data modified by the transaction up to the last commit before the abnormal termination is retained in the database.
考题
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.（） A、simplified disaster recovery architecture and effortsB、better performance than writing logs to a file storeC、common storage of transaction logs with application dataD、common replication of transaction logs with application dataE、higher transaction throughput
考题
You executed this command to create a temporary table： SQL CREATE GLOBAL TEMPORARY TABLE report_work_area （startdate DATE， enddateDATE， class CHAR（20）） ON COMMIT PRESERVE ROWS； Which statement is true about the rows inserted into the REPORT_WORK_AREA table during a transaction（）A、The rows stay in the table only until session termination.B、The rows stay in the table only until the next transaction starts on the table.C、The rows are visible to all current sessions after the transaction is committed.D、The rows stay available for subsequent sessions after the transaction is committed
考题
You are a database administrator for your company. The company uses a SQL Server 2005 database. A full backup of the database is made each night. Transaction log backups are made each morning and each afternoon. You notice that the database transaction log file grows very large throughout the day. You need to minimize the size of the transaction log file. You also need to minimize data loss in the event of a failure. What should you do？（）A、Decrease the amount of time between transaction log backups.B、Configure the database to use the simple recovery model.C、Configure the RECOVERY INTERVAL option to be a smaller value.D、Run DBCC SHRINKFILE on the transaction log file.
考题
TestKing.com has two SQL Server 2005 computers named SQL1 and SQL2. Transaction log shipping occurs from SQL1 to SQL2 by using default SQL Server Agent schedule settings. You need to reconfigure transaction log shipping to provide minimum latency on SQL2. What should you do？（）A、On SQL1， reschedule the transaction log backup job so that it occurs every minute. On SQL2， maintain default schedule settings for both the log shipping copy and the restore jobs.B、On SQL1，change the schedule type for the transaction log backup to Start automatically when SQL server Agent starts. On SQL2， change the schedule types for both the log shipping copy and the restore jobs to Start automatically when SQL Server gent starts.C、On SQL1， maintain default schedule settings for the transaction log backup job. On SQL2， change the schedule types for both the log shipping copy and the restore jobs to Start automatically when SQL server Agent starts.D、On SQL1， reschedule the transaction log backup job so that it occurs every minute. On SQL2， reschedule both the log shipping copy and the restore jobs so that they occur every minute.
考题
单选题By using the transaction identifier provided by （） for a particular row change， you can use theFlashback 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.
考题
多选题在Hibernate中，下列关于Transaction说法正确的有（）A事务Transaction为应用程序指定以原子操作单元为范围的对象B在对数据库进行增加、修改和删除操作时一定要加上TransactionC在对数据库进行查询操作时一定要加上TransactionD获得Transaction的方法：Transaction tr = session.beginTransaction（）；
热门标签
最新试卷