000-730 DB2 9 Fundamentals (Exam 3)

000-730 DB2 9 Fundamentals (Exam 3)

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • Which of the following is a typical data warehouse query?

  • Which of the following will begin a new unit of work?

  • Which of the following tools is used to view historical information about tasks, d...

  • Which tool must be used to analyze all of the database operations performed by an ...

  • Which of the following database objects is considered executable using SQL?

  • If a unique constraint is defined on column COL1 of table TAB1, what are the chara...

  • A user invoking a user-defined function requires which DB2 privilege?

  • Which of the following is a characteristics of a schema ?

  • Which of the following commands is used retrieve database names from the local cat...

  • How should be following UDF be invoked to convert US currency values stored in the...

  • Which of the following privileges permits a user to update the comment on a sequence?

  • Which of the following statements is used to grant user TOM and Application team A...

  • Given the following stored procedure:How can this stored procedure be called form ...

  • Which of the following best describes the age of the data in an OLTP system?

  • A programmer wants to generate values for a numeric ID Column in their EXPENSE tab...

  • Which of the following best describes how locks are used in DB2?

  • On which of the following database objects may the SELECT privilege be controlled?

  • What type of constraint can be used to ensure that, in any given row in a table, t...

  • How many names will be returned for this XQuery? CREATE TABLE customer (cid BIGINT...

  • Which of the following is a feature of a unit work?

Be the first to review
Login and Review
  • info
    Quiz Info
  • date_range
    Feb. 8, 2016, 3:49 a.m.
    help_outline
    20 questions
    dvr
    0 completed
    remove_red_eye
    4 views
    people
    0 takers
    folder
    IBM

  • 000-730 DB2 9 Fundamentals (Exam 3) QR code

Ratings

star_borderstar_borderstar_borderstar_borderstar_border
ratings