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

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

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • Assuming USER1 has no authorities or privileges, which of the following will allow...

  • Which of the following will allow user USER1 to change the comment associated with...

  • A table called DEPARTMENT has the following columns:DEPT_IDDEPT_NAMEMANAGERWhich o...

  • An index named EMPID_X exists for a table named EMPLOYEE. Which of the following w...

  • On which two of the following database objects may the SELECT privilege be control...

  • User USER1 wants to utilize an alias to remove rows from a table. Assuming USER1 h...

  • A user utilizing an alias to update a subset of columns in a table must have UPDAT...

  • Assuming PUBLIC has been granted all privileges on table T1, which of the followin...

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

  • A "trusted" client needs to communicate with a server that has been configured to ...

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

  • A user needs to create a trigger that will update table T2 whenever a row is added...

  • User USER1 holds CONTROL privilege on table TABLE1. Which two of the following sta...

  • A user wishing to invoke an SQL stored procedure that queries a table must have wh...

  • After the following SQL statement is executed:GRANT ALL PRIVILEGES ON TABLE employ...

  • Which two of the following privileges is required in order to use a package?

  • Which of the following statements allows USER1 to take away read access on the tab...

  • Which of the following statements allows user USER1 to take the ability to create ...

  • Which of the following will provide user USER1 and all members of the group GROUP1...

  • What does the following statement do?GRANT REFERENCES (col1, col2) ON TABLE table1...

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
    2 views
    people
    1 takers
    folder
    IBM

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

Ratings

starstarstarstar_borderstar_border
ratings