CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. IBM
  5. C2090-616

Free C2090-616 Exam Braindumps (page: 2)

Page 1 of 16
PDF with 63 Questions

You are asked to provide a recommendation for the appropriate DB2 edition for a new application. The application is characterized by long, complex queries that select a subset of columns and often perform grouping and aggregation. The initial database size is estimated at 5 TB, with growth of about 100 GB per year. Keep data size on disk to a minimum is a priority? Which of the following editions would be best meet the described needs?

  1. DB2 Express-C
  2. DB2 Enterprise Server Edition
  3. DB2 Workgroup Server Edition
  4. DB2 Advanced Enterprise Server Edition

Answer(s): D



Which of the following editions of DB2 include support for Federation with Oracle database?

  1. DB2 Express-C
  2. DB2 Developer Edition
  3. DB2 Enterprise Server Edition
  4. DB2 Workgroup Server Edition

Answer(s): C



Which three facilities are used to control authorization in DB2?

  1. privileges, db2ssh, LBAC credentials
  2. privileges, authority levels, certificates
  3. db2ssh, trusted contexts, authority levels
  4. privileges, authority levels, LBAC credentials

Answer(s): D



Which database object can be locked explicitly?

  1. Row
  2. View
  3. Index
  4. Table

Answer(s): D






Post your Comments and Discuss IBM C2090-616 exam with other Community members:

C2090-616 Discussions & Posts