C2090-614 DB2 10.1 Advanced DBA for Linux UNIX and Windows Exam (Exam 2)

C2090-614 DB2 10.1 Advanced DBA for Linux UNIX and Windows Exam (Exam 2)

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • Which statement about Range Clustered Tables (RCT) is correct?

  • For a multi-partitioned database, what is the default behavior of the BACKUP DATAB...

  • Which index(es) are created when a multidimensional clustering (MDC) table is defi...

  • Which configuration parameter setting(s) are needed to force authentication to hap...

  • What type of file system is used to store data and logs in a DB2 pureScale environ...

  • To configure instance-level auditing with db2audit, which authority is required?

  • What are two services that the cluster caching facility (CF) provides in a DB2 pur...

  • An auditor has requested that all activities performed by those with SYSADM or DBA...

  • A database administrator needs to create a federated database and configure access...

  • Which statement about Q Replication is correct?

  • Which command will be executed successfully on every database partition if db2_all...

  • When will the existing data for a new partition be visible to applications queryin...

  • Given the following CREATE TABLE statement:Which statement is correct?

  • Which is a poor choice for a clustering dimension of a multidimensional clustering...

  • Which statement about Range-Clustered Tables (RCTs) is correct?

  • A table named MYTAB was created as follows:How many rows will be inserted into the...

  • Which statement about Insert-Time-Clustered (ITC) is correct?

  • What must be done to convert a populated base table to a multidimensional clusteri...

  • Which command(s) should be used to drop database partition 10 from a database name...

  • If a large amount of sequential prefetching is occurring, what can be done to impr...

Be the first to review
Login and Review
  • info
    Quiz Info
  • date_range
    Feb. 8, 2016, 3:45 a.m.
    help_outline
    20 questions
    dvr
    0 completed
    remove_red_eye
    1 views
    people
    0 takers
    folder
    IBM

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

Ratings

star_borderstar_borderstar_borderstar_borderstar_border
ratings