A transaction is an action,or a series of actions,carried out by a single user or（ ）,that accesses or changes the contents of the database.A transaction should possess the four basic or so-called ACID properties:Atomicity.The“all or nothing”property.A tra

题目
A transaction is an action,or a series of actions,carried out by a single user or（ ）,that accesses or changes the contents of the database.A transaction should possess the four basic or so-called ACID properties:Atomicity.The“all or nothing”property.A transaction is an（ ）unit that is either performed in its entirety or is not performed at all.Consistency.A transaction must transform the database from one consistent state to another consistent state.Isolation.Transactions execute independently of one another.In other words,the partial effects of（ ）transactions should not be visible to other transactions.Durability.The effects of a successfully completed（committed）transaction are permanently recorded in the database and must not be lost because of a subsequent failure.The four properties above,only（请作答此空）property is the responsibility of the concurrency control subsystem to ensure.It is the responsibility of both the（ ）and the application developers to ensure consistency.To guarantee the Atomicity and Durability properties after a failure,a log file is needed.

A.atomicity
B.consistency
C.isolation
D.durability
相似考题

1.开始事务，提交事务，回滚事务的英语单词分别是：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

2.We are pleased to confirm()with you the transaction of 3,000 metric tons soybean.A、having concludedB、to have concludedC、having come to termsD、tohave carried out

3.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

4.(ii) Identify the points that must be confirmed and any action necessary in order for capital treatment toapply to the transaction. (4 marks)

更多“A transaction is an action,or a series of actions,carried out by a single user or（ ）,that accesses or changes the contents of the database.A transaction should possess the four basic or so-called ACI”相关问题

  • 第1题：

    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.


    参考答案：B

  • 第2题：

    A transaction is an action,or a series of actions,carried out by a single user or（请作答此空）,that accesses or changes the contents of the database.A transaction should possess the four basic or so-called ACID properties:Atomicity.The“all or nothing”property.A transaction is an（ ）unit that is either performed in its entirety or is not performed at all.Consistency.A transaction must transform the database from one consistent state to another consistent state.Isolation.Transactions execute independently of one another.In other words,the partial effects of（ ）transactions should not be visible to other transactions.Durability.The effects of a successfully completed（committed）transaction are permanently recorded in the database and must not be lost because of a subsequent failure.The four properties above,only（ ）property is the responsibility of the concurrency control subsystem to ensure.It is the responsibility of both the（ ）and the application developers to ensure consistency.To guarantee the Atomicity and Durability properties after a failure,a log file is needed.

    A.application developer
    B.all users
    C.application program
    D.DBMS

    答案：C
    解析：

  • 第3题：

    A customer’s computer crashes consistently when a specific application is launched. Thetechnician has looked at the computer and confirmed the cause of the crash. Which of thefollowing is the NEXT troubleshooting step the technician should take?（）

    • A、Verify full system functionality.
    • B、Document the findings, actions, and outcomes.
    • C、Establish a plan of action to resolve the problem.
    • D、Question the user and identify changes the user has made to the system.

    正确答案:C

  • 第4题：

    You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature？ （）

    • A、 To recover a dropped table.
    • B、 To recover a dropped schema.
    • C、 To recover data from a truncated table.
    • D、 To view changes made by all the transactions during a given period of time.
    • E、 To view changes made by a single transaction during a given period of time.

    正确答案:D,E

  • 第5题：

    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_TRANSACTIONS
    • B、 DBA_AUDIT_STATEMENT
    • C、 V$FLASHBACK_DATABASE_STATS
    • D、 FLASHBACK_TRANSACTION_QUERY

    正确答案:D

  • 第6题：

    单选题
    You are unable to pump out the aft starboard engine room bilge well that is fouled, with one foot of water over the top of the bilge well, what action should be carried out?（）
    A

    Send the wiper into the well with only a scoop and pail

    B

    Remove the bilge manifold valve and attempt to back flush the line

    C

    Simultaneously operate all available bilge pumps

    D

    It is only necessary to transfer half the contents of a drum of degreaser into the bilge well


    正确答案： B
    解析： 暂无解析

  • 第7题：

    单选题
    You have two tables with referential integrity enforced between them. You need to insert data to the child tablefirst because it is going to be a long transaction and data for the parent table will be available in a later stage，which can be inserted as part of the same transaction. View the Exhibit to examine the commands used tocreate tables.  Which action would you take to delay the referential integrity checking until the end of thetransaction（）
    A

    Set the constraint to deferred before starting the transaction.

    B

    Alter the constraint to NOVALIDATE state before starting the transaction.

    C

    Enable the resumable mode for the session before starting the transaction.

    D

    Set the COMMIT_WAIT parameter to FORCE_WAIT for the session before starting the transaction


    正确答案： A
    解析： 暂无解析

  • 第8题：

    单选题
    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 recovery

    B

     execute the ROLLBACK command with transaction number

    C

     flashback the database to before the transaction was committed

    D

     determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery


    正确答案： C
    解析： 暂无解析

  • 第9题：

    单选题
    You are designing a Windows Azure application that will store data in two SQL Azure databases. The application will insert data in both databases as part of a single logical operation.   You need to recommend an approach for maintaining data consistency across the databases.  What should you recommend？（）
    A

     Execute database calls on parallel threads.

    B

     Wrap the database calls in a single transaction scope.

    C

     Use Microsoft Distributed Transaction Coordinator （MSDTC）.

    D

     Handle errors resulting from the database calls by using compensatory logic.


    正确答案： D
    解析： 暂无解析

  • 第10题：

    单选题
    Bridge orders must be （） and a record of any required changes in speed and direction should be kept.
    A

    slowly carried away

    B

    carried out with a period of delay

    C

    promptly carried out

    D

    paid by the captain


    正确答案： D
    解析： 暂无解析

  • 第11题：

    单选题
    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_TRANSACTIONS

    B

     DBA_AUDIT_STATEMENT

    C

     V$FLASHBACK_DATABASE_STATS

    D

     FLASHBACK_TRANSACTION_QUERY


    正确答案： D
    解析： 暂无解析

  • 第12题：

    多选题
    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.


    正确答案： E,A
    解析： 暂无解析

  • 第13题：

    Preventive maintenance______.

    A.should not be carried out during the watches

    B.can only be carried out in port

    C.is a kind of maintenances carried out prior to the occurrence

    D.is a kind of maintenances carried out after the occurrence


    正确答案：C

  • 第14题：

    A single transaction can be scanned in parallel by：（）

    • A、 Sophos and McAfee
    • B、 Webroot and Sophos
    • C、 Webroot，Sophos and McAfee
    • D、 None of the above

    正确答案:B

  • 第15题：

    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 recovery
    • B、execute the ROLLBACK command with transaction number
    • C、flashback the database to before the transaction was committed
    • D、determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery

    正确答案:D

  • 第16题：

    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 Drop
    • B、 Flashback Query
    • C、 Flashback Versions Query
    • D、 Flashback Transaction Query
    • E、 Flashback Table

    正确答案:E

  • 第17题：

    You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing and sustaining the database life cycle. In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization. A SQL Server 2008 instance is managed by you. A new database should be deployed, and the capacity requirements listed below should be satisfied. There should be 275 GB for the database data file, while there should be 50 GB for the transaction log file. There are six 100-GB disk drives which are accessible for the database in the storage array. The six disks are attached to a redundant array of independent disks (RAID) controller, and the controller supports RAID levels 0, 1, 5, and 10. Since you are the technical support, you are required to maximize the write performance of the transaction log. In addition, you should protect the database and transaction log files, when a drive fails. The storage system should be designed.   From the following four storage configuration, which one should you utilize?（）

    • A、A single RAID 5 volume should be utilized. 
    • B、A RAID 1 volume and a RAID 5 volume should be utilized.
    • C、A single RAID 10 volume should be utilized. 
    • D、A RAID 0 volume and a RAID 5 volume should be utilized.

    正确答案:B

  • 第18题：

    多选题
    You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature？ （）
    A

    To recover a dropped table.

    B

    To recover a dropped schema.

    C

    To recover data from a truncated table.

    D

    To view changes made by all the transactions during a given period of time.

    E

    To view changes made by a single transaction during a given period of time.


    正确答案： B,D
    解析： 暂无解析

  • 第19题：

    多选题
    The session of user SCOTT receives the following error after executing an UPDATE command onthe EMP table：  ERROR at line 1：  ORA-00060： deadlock detected while waiting for resource  On investigation， you find that a session opened by user JIM has a transaction that caused the deadlock.  two statements are true regarding the session of SCOTT in this scenario（）
    A

    The session is terminated after receiving the error and JIM can continue with his transaction.

    B

    SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.

    C

    The session is rolled back after receiving the error and JIM can continue with his transaction.

    D

    SCOTT has to reexecute the last command in the transaction after he commits the transaction.


    正确答案： A,B
    解析： 暂无解析

  • 第20题：

    单选题
    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 Drop

    B

     Flashback Query

    C

     Flashback Versions Query

    D

     Flashback Transaction Query

    E

     Flashback Table


    正确答案： D
    解析： 暂无解析

  • 第21题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

  • 第22题：

    多选题
    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（）
    A

    The session is terminated after receiving the error and JIM can continue with his transaction.

    B

    SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.

    C

    The session is rolled back after receiving the error and JIM can continue with his transaction.

    D

    SCOTT has to reexecute the last command in the transaction after he commits the transaction.


    正确答案： C,B
    解析： 暂无解析

  • 第23题：

    单选题
    By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify：  a） a list of changes made along with the transaction identifier of each change  b） the necessary SQL statements to undo the erroneous changes  Which option would you choose？（）
    A

    RMAN only

    B

    Flashback Table only

    C

    Flashback Versions Query only

    D

    Flashback Database and Flashback Transaction Query

    E

    Flashback Versions Query and Flashback Transaction Query


    正确答案： D
    解析： 暂无解析

相关内容