C2090-610 DB2 10.1 Fundamentals (Exam 4)

C2090-610 DB2 10.1 Fundamentals (Exam 4)

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • Which operation normally does NOT require an exclusive lock?

  • Which SQL statement will retrieve the employee number (EMPNO), hire date (HIREDATE...

  • In a trusted context environment, if a switch request is made with an authorizatio...

  • Which statement about triggers is true?

  • Which statement about BEFORE triggers is FALSE?

  • Which SQL statement will take the ability to create tables in a table space named ...

  • What privilege is required to create a view on a table that you are not the owner of?

  • After creating several new indexes and executing RUNSTATS, user USER1 wants to re-...

  • Which SQL statement will create a DB2 object that can be used to store numerical d...

  • Given the SQL statement: CREATE ALIAS total_sales FOR sales Which statement is valid?

  • Which DB2 object limits the user's ability to retrieve data from a table by defini...

  • Which statement about bitemporal tables is valid?

  • Which object can a buffer pool be assigned to?

  • Which DB2 product is a database cluster solution for non-mainframe platforms and i...

  • Which product replaced the Control Center used in versions prior to DB2 v10?

  • A table named SALES contains a record for every sales transaction a company proces...

  • Which SQL statement would be used to retrieve only salaries that are greater than ...

  • If a table named MY_TAB contains 100 rows and the following statement is executed:...

  • An SQL function named DEPT_INFO was created as follows:What is the correct way to ...

  • Which statement about system-period temporal tables is true?

Dec. 11, 2016
review by None R (@jaks)
Login and Review
  • info
    Quiz Info
  • date_range
    Feb. 8, 2016, 3:45 a.m.
    20 questions
    3 completed
    1 takers

  • C2090-610 DB2 10.1 Fundamentals (Exam 4) QR code