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

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

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • User USER1 is the owner of TABLE1. Assuming user USER1 only holds privileges for T...

  • User USER1 has the privileges needed to invoke a stored procedure named GEN_RESUME...

  • A view named V.VIEW1 is based on a table named T.TABLE1. A user with DBADM authori...

  • What does the following statement do?GRANT ALTER ON SEQUENCE gen_empid TO user1 WI...

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

  • Which of the following statements is used to prevent user TOM from adding and dele...

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

  • Which of the following statements is used to revoke all DML privileges on table EM...

  • What is the lowest privilege and/or authority required to execute the following SQ...

  • Which of the following statements allows BOB to revoke access to the SAMPLE databa...

  • While attempting to connect to a database stored on an iSeries server from a Windo...

  • A database named TEST_DB resides on a z/OS system and listens on port 446. The TCP...

  • Which of the following statements will catalog the database MYDB on the node MYNOD...

  • Which of the following are NOT stored in the system catalog tables?

  • Which of the following tools can NOT be used to catalog a database?

  • In which of the following scenarios would a stored procedure be beneficial?

  • If the following SQL statements are executed in the order shown:CREATE TABLE order...

  • An alias can be an alternate name for which two of the following DB2 objects?

  • Which of the following events will NOT cause a trigger to be activated?

  • If a view named V1 is created in such a way that it references every column in a t...

Nov. 29, 2016
review by shiny s (@jyothi)
Login and Review
  • info
    Quiz Info
  • date_range
    Feb. 8, 2016, 3:45 a.m.
    20 questions
    1 completed
    1 takers

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