C2090-730 DB2 9 Family Fundamentals Exam (Exam 4)

C2090-730 DB2 9 Family Fundamentals Exam (Exam 4)

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • Which of the following would NOT provide access to data stored in table TABLE1 usi...

  • Which of the following DB2 objects can be referenced by an INSERT statement to gen...

  • A sequence was created with the DDL statement shown below:CREATE SEQUENCE my_seq S...

  • Given the following statements:CREATE TABLE tab1 (c1 INTEGER, c2 CHAR(5));CREATE V...

  • Given the following statements:CREATE TABLE t1 (c1 INTEGER, c2 CHAR(5));CREATE TAB...

  • Which of the following is NOT an attribute of Declared Global Temporary Tables (DG...

  • Which of the following is an accurate statement about packages?

  • Given the following information:Protocol: TCP/IPPort Number: 5000Host Name: DB_SER...

  • Which object may be used during query optimization to improve the performance for ...

  • A DRDA host database resides on a z/OS or an i5/OS system and listens on port 446....

  • Given the following ALTER SEQUENCE statement:ALTER SEQUENCE myseq RESTART WITH 0 I...

  • Within the application MY_APP the following PREVIOUS VALUE expression references t...

  • A declared temporary table is used for which of the following purposes?

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

  • Which of the following is NOT an accurate statement about views?

  • Which of the following SQL statements can be used to create a DB2 object to store ...

  • Which of the following DB2 objects are publicly referenced names that require no s...

  • Which of the following describes the objects of a DB2 database and their relations...

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

  • Given the following DDL and INSERT statements:CREATE VIEW v1 AS SELECT col1 FROM t...

starstarstarstar_borderstar_border
Nov. 29, 2016
review by shiny s (@jyothi)
Login and Review
  • info
    Quiz Info
  • date_range
    Feb. 8, 2016, 3:45 a.m.
    help_outline
    20 questions
    dvr
    1 completed
    remove_red_eye
    6 views
    people
    1 takers
    folder
    IBM

  • C2090-730 DB2 9 Family Fundamentals Exam (Exam 4) QR code

Ratings

starstarstarstar_borderstar_border
ratings