000-546 DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade (Exam 1)

000-546 DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade (Exam 1)

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • (Topic 1)Click on the Exhibit buttonGiven the following DDL statements:If COL2 con...

  • When storing XML data in a DB2 database, which statement is valid?

  • If table TAB_A is created as follows:Assuming the cardinality of the columns is th...

  • Which of following is true when decomposing multiple XML documents?

  • If table TAB_A has just been created as follows:Which command will create a compre...

  • Which is true regarding collecting distribution statistics for XML data?

  • Table TAB_A and index TABA_IDX were created by executing these SQL statements:If t...

  • Index INDEX1 has been created as follows: CREATE INDEX index1 ON table_x (cola) Wh...

  • Given the following DDL statements:What is the end result of the CREATE INDEX stat...

  • Which of the following SQL statements will return monitoring information of tables...

  • A DBA wants to use XQuery on a XML document to determine the number of lock waits ...

  • You have created a Trusted Context by using following command:What is the ENCRYPTI...

  • Which statements about Explain administration authority (EXPLAIN) are true?

  • When a database is created who is granted SECADM by default?

  • What is the minimum privilege required to run the audit stored procedures and tabl...

  • The following trusted context has been defined:Which statement is correct?

  • Which category is used to audit the running of SQL statements?

  • What authority is required to grant SECADM authority to roles and groups?

  • Given the following GRANT commands:Assuming that user BOB belongs to the group STA...

  • Which SQL statement must be executed in order to give a user named USER1 the abili...

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

  • 000-546 DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade (Exam 1) QR code

Ratings

star_borderstar_borderstar_borderstar_borderstar_border
ratings