C2090-611 DB2 10.1 DBA for Linux, UNIX, and Windows (Exam 2)

C2090-611 DB2 10.1 DBA for Linux, UNIX, and Windows (Exam 2)

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • If a single node database is actively being used by applications when a power fail...

  • The values of the automatic maintenance database configuration parameters for a da...

  • If the current value for self-tuning memory is: Self Tuning Memory (SELF_TUNING_ME...

  • What are two types of security label components that can be used with Label-Based ...

  • Where are column mask definitions stored?

  • Which authority is required to revoke SECADM authority?

  • What authorization is needed to execute the CREATE MASK statement?

  • Which statement is correct for a user who holds SECADM authority?

  • What does the FLUSH PACKAGE CACHE statement do?

  • The following commands are executed against a database named MY_DB, which has been...

  • What can be used to provide input to the Design Advisor?

  • If the following statement is executed:What indexes will be created for table TAB1?

  • Which statement about range-clustered tables is true?

  • Which tool can be used to mimic statistics for tables by gathering statistics from...

  • Which statement about Binary XML is FALSE?

  • Which XML format provides a faster way to transmit and receive XML data between Ja...

  • What are two purposes of the SET INTEGRITY statement? (Choose two.)

  • What is an informational constraint?

  • Which two server authentication methods are supported by transparent Lightweight D...

  • Which command is used to export connectivity configuration information from a file...

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

  • C2090-611 DB2 10.1 DBA for Linux, UNIX, and Windows (Exam 2) QR code