logo

CuriousTab

CuriousTab

Discussion


Home Certification IBM Certification Comments

  • Question
  • which of the following represents a set of properties that guarantee that database transactions are processed reliably in computer science ?


  • Options
  • A. Buffer Cache
  • B. ACID
  • C. Foreign Key
  • D. None

  • Correct Answer
  • ACID 

    Explanation

    ACID means (Atomicity, Consistency, Isolation, Durability) is a set of properties of database transactions intended to guarantee validity even in the event of errors, power failures, etc.

    In the context of databases, a sequence of database operations that satisfies the ACID properties and, thus, can be perceived as single logical operation on the data, is called a transaction. For example, a transfer of funds from one bank account to another, even involving multiple changes such as debiting one account and crediting another, is a single transaction.

  • Tags: Analyst, IT Trainer

    IBM Certification problems


    Search Results


    • 1. A solution developer needs to configure the HTTP listener of an Integration Server on a Linux Server. Which operating system privileges does the developer need to modify Integration node properties and properties of integration node resources?

    • Options
    • A. root user
    • B. mqm
    • C. mqbrks
    • D. mqm and mqbrks
    • Discuss
    • 2. Which of the following DB2 data types CANNOT be used to contain the date an employee was hired?

    • Options
    • A. CLOB
    • B. TIME
    • C. VARCHAR
    • D. TIMESTAMP
    • Discuss
    • 3. What is one benefit of My Client Center?
    • Discuss
    • 4. Where can an advertiser change the location targeting of an ad?
    • Discuss
    • 5. What is a primary benefit of location targeting?
    • Discuss
    • 6. Proxy servers have two main purposes : 1. Improve Performance (and) 2. is ______ ?

    • Options
    • A. Transmit Request
    • B. Decrease Requests
    • C. Increase Requests
    • D. Filter Requests
    • Discuss
    • 7. Which of the following extenders allows data to be presented in a three dimensional format?

    • Options
    • A. DB2 AVI Extender
    • B. DB2 XML Extender
    • C. DB2 Text Extender
    • D. DB2 Spatial Extender
    • Discuss
    • 8. The DBA can set the registry variable DB2_HASH_JOIN on or off because:

    • Options
    • A. hash joins may require more resources to run.
    • B. hash joins are not used unless outer joins are requested.
    • C. If hash joins are enabled, no other join method can be used.
    • D. Hash joins are only needed when the tables are portioned using hash keys.
    • Discuss
    • 9. With database logging, where are transaction records first placed?

    • Options
    • A. in the logical log buffer
    • B. in the primary chunk
    • C. in the physical buffer
    • D. in a temporary database table
    • Discuss
    • 10. Suppose an installed z/OS customer also has Power6 Servers. They are investigating consolidation of both types of servers to z/OS.Which of the following will establish the capacity for a new z/OS server?

    • Options
    • A. AD Tools
    • B. CP3000
    • C. Estimate the AIX load and add to CP3000 results.
    • D. Run AIX in a z/OS LPAR to establish the loadWArialTimes New RomanZ
    • Discuss


    Comments

    There are no comments.

Enter a new Comment