000-610 DB2 10.1 Fundamentals (Exam 2)

000-610 DB2 10.1 Fundamentals (Exam 2)

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • What is the act of exchanging one lock an application holds on a resource for a mo...

  • What isolation level prevents dirty reads, nonrepeatable reads, and phantoms?

  • Which operation normally does NOT require an exclusive lock?

  • When a COMMIT statement is executed, what happens?

  • Which command is used to back out a subset of database changes that have been made...

  • An SQL function designed to convert temperatures from Fahrenheit to Celsius was cr...

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

  • Given an EMPLOYEES table and a SALES table, a user wants to produce a list of all ...

  • Which two operations are allowed in the body of an SQL scalar user-defined functio...

  • Which command will delete all rows from a table without generating log records?

  • Which function can be used to obtain values from XML documents that are to be inse...

  • User USER1 wants to retrieve records from a table named EMPLOYEE that satisfy at l...

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

  • If the following result set is desired:Which SQL statement must be executed?

  • Which statement about INSERT operations is true?

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

  • Which SQL statement should be used to select the minimum and maximum salaries (SAL...

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

  • If a user has been granted SYSCTRL authority, which activities can they perform?

  • What is the purpose of a role?

Be the first to review
Login and Review
  • info
    Quiz Info
  • date_range
    Feb. 8, 2016, 3:49 a.m.
    20 questions
    0 completed
    0 takers

  • 000-610 DB2 10.1 Fundamentals (Exam 2) QR code