C2090-610 DB2 10.1 Fundamentals (Exam 1)

C2090-610 DB2 10.1 Fundamentals (Exam 1)

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • If the following command is executed: CREATE DATABASE test What is the page size (...

  • Given the following DDL statement: CREATE TABLE sales (item CHAR(20)); If a DBA wi...

  • When is it appropriate to use a sequence?

  • Which clause should be included in a ALTER TABLE statement to update a table defin...

  • Which object is a stored procedure defined into?

  • You have a business need to query DB2 10 and DB2 9 databases and you want to write...

  • Which type of temporal table can be used to store only time-sensitive data?

  • What type of mechanism is a simple token value that is used to refer to a much big...

  • What type of large object (LOB) is used to store LOB data together with the format...

  • What factor influences lock escalation?

  • Which type of lock allows the lock owner and all concurrent applications to read, ...

  • Application APP_A is performing updates to table TAB1 using the cursor stability (...

  • When is an INTENT EXCLUSIVE (IX) lock required?

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

  • When a COMMIT statement is executed, what happens?

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

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

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

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

  • Which statement about INSERT operations 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
    1 completed
    1 takers

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