Db2 Practice 1

68 Questions | Total Attempts: 262

SettingsSettingsSettings
Db2 Practice 1 - Quiz

.


Questions and Answers
  • 1. 
    If the following command is executed: CREATE DATABASE test What is the page size (inkilobytes) of the database?
    • A. 

      4

    • B. 

      8

    • C. 

      16

    • D. 

      32

  • 2. 
    Which DB2 object can be used to improve the execution performance of qualified SELECTstatements?
    • A. 

      Materialized Query Table

    • B. 

      Sequence Object

    • C. 

      SQL Procedure

    • D. 

      Trigger

  • 3. 
    When is it appropriate to use a sequence?
    • A. 

      When you want to control the order in which triggers are fired.

    • B. 

      When you want to control the order in which stored procedures can be invoked.

    • C. 

      When you want to automatically generate a numeric value that is not tied to any specific column or table.

    • D. 

      When you want to automatically generate a numeric value for each row that is added to a specific table.

  • 4. 
    Which clause should be included in a ALTER TABLE statement to update a table definition with anew column?
    • A. 

      ADD COLUMN

    • B. 

      ALTER COLUMN

    • C. 

      APPEND COLUMN

    • D. 

      RENAME COLUMN

  • 5. 
    Which object is a stored procedure defined into?
    • A. 

      Table

    • B. 

      Schema

    • C. 

      Package

    • D. 

      Database

  • 6. 
    Which action needs to be performed in order to complete the definition of an application-periodtemporal table?
    • A. 

      A transaction-start-id column must be defined for the table.

    • B. 

      A BUSINESS_TIME period must be specified in a CREATE or ALTER of the table.

    • C. 

      A history table must be defined and associated with the base table.

    • D. 

      A unique index must be created that prevents overlapping of the BUSINESS_TIME period of the table.

  • 7. 
    What functionality allows users to perform a UNION operation between a DB2 table and an Oracleview?
    • A. 

      Oracle connect

    • B. 

      Trusted context

    • C. 

      Oracle federation

    • D. 

      Distributed request

  • 8. 
    You have a business need to query DB2 10 and DB2 9 databases and you want to write anapplication that can run on most platforms unchanged. Which interface would you use to achieveyour goal?
    • A. 

      CLI

    • B. 

      JDBC

    • C. 

      XML

    • D. 

      RUBY

  • 9. 
    Which DB2 object is used to provide a logical grouping of other database objects?
    • A. 

      Alias

    • B. 

      Index

    • C. 

      Schema

    • D. 

      Collection

  • 10. 
    What are two valid objects that can be created in DB2?
    • A. 

      Tree

    • B. 

      Node

    • C. 

      Trigger

    • D. 

      Contexts

    • E. 

      Sequence

    • F. 

      Table

  • 11. 
    Which type of temporal table can be used to store only time-sensitive data?
    • A. 

      Bitemporal

    • B. 

      Time-period

    • C. 

      System-period

    • D. 

      Application-period

  • 12. 
    When an index is created for a table, where is the metadata for that index stored?
    • A. 

      In the table definition.

    • B. 

      In the system catalog.

    • C. 

      In the schema that the index resides in.

    • D. 

      In the metadata of the table the index was created for.

  • 13. 
    Which product is used to customize execution environments for the purpose of controlling systemresources so that one department or service class does not overwhelm the system?
    • A. 

      PureScale

    • B. 

      Data partitioning feature

    • C. 

      Workload manager

    • D. 

      Self-tuning memory manager

  • 14. 
    What type of mechanism is a simple token value that is used to refer to a much bigger large object(LOB)?
    • A. 

      Reference

    • B. 

      Address

    • C. 

      Pointer

    • D. 

      Locator

  • 15. 
    What type of large object (LOB) is used to store LOB data together with the formatted rows ondata pages, instead of in a separate LOB storage object?
    • A. 

      Inline

    • B. 

      Binary

    • C. 

      Internal

    • D. 

      Partitioned

  • 16. 
    What is the purpose of the Query Tuner?
    • A. 

      To automatically capture and stop rogue queries.

    • B. 

      To provide recommendations and analysis for tuning a single query.

    • C. 

      To provide recommendations and analysis for tuning up to 100 queries.

    • D. 

      To recommend indexes and to guide DBAs through the process of creating new indexes.

  • 17. 
    Which tool allows users to connect to a DB2 database using a wizard?
    • A. 

      Control Center

    • B. 

      Universal Connection Expert

    • C. 

      DB2 Connection Pool Manager

    • D. 

      IBM Data Studio

  • 18. 
    Which two activities indicate the need for a data warehouse?
    • A. 

      Confirm product inventory.

    • B. 

      Monitor product availability.

    • C. 

      Summarize sales by region.

    • D. 

      Identify patterns for products sold in the last five years.

    • E. 

      Associate one or more products with a purchase order.

  • 19. 
    What is the primary function of an Online Transaction Processing (OLTP) workload?
    • A. 

      To combine data from multiple sources.

    • B. 

      To discover hidden relationships in data.

    • C. 

      To analyze large amounts of data to find patterns.

    • D. 

      To make changes to a small number of records within a single transaction.

  • 20. 
    Which isolation level offers the greatest protection of data but provides the least amount of concurrency?
    • A. 

      Read Stability (RS)

    • B. 

      Cursor Stability (CS)

    • C. 

      Repeatable Read (RR)

    • D. 

      Uncommitted Read (UR)

  • 21. 
    What factor influences lock escalation?
    • A. 

      Table size

    • B. 

      Buffer space

    • C. 

      Number of locks

    • D. 

      Available real storage

  • 22. 
    Which type of lock allows the lock owner and all concurrent applications to read, but not update,the locked data?
    • A. 

      Share (S)

    • B. 

      Update (U)

    • C. 

      Exclusive (X)

    • D. 

      Intent Exclusive (IX)

  • 23. 
    Application APP_A is performing updates to table TAB1 using the cursor stability (CS) isolationlevel. If application APP_B wants to retrieve all rows from table TAB1 without waiting forapplication APP_A to finish making updates, what isolation level must application APP_B use?
    • A. 

      Read Stability (RS)

    • B. 

      Repeatable Read (RR)

    • C. 

      Uncommitted Read (UR)

    • D. 

      Cursor Stability (CS)

  • 24. 
    Which statement will prevent concurrent application processes from performing anything otherthan read-only operations against a table named TAB1?
    • A. 

      LOCK TABLE tab1 IN READ MODE

    • B. 

      LOCK TABLE tab1 IN SHARE MODE

    • C. 

      LOCK TABLE tab1 IN EXCLUSIVE MODE

    • D. 

      LOCK TABLE tab1 IN READ-ONLY MODE

  • 25. 
    When is an INTENT EXCLUSIVE (IX) lock required?
    • A. 

      When a transaction intends to read or change data.

    • B. 

      When a transaction intends to change but not read data.

    • C. 

      When a transaction intends to read but not change data.

    • D. 

      When a transaction intends to change the system catalog.

Related Topics
Back to Top Back to top