Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home IBM C2090-616

IBM C2090-616 Exam Practice Questions (P. 1)

  • Full Access (63 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #1
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. A
    DB2 Express-C
  2. B
    DB2 Enterprise Server Edition
  3. C
    DB2 Workgroup Server Edition
  4. D
    DB2 Advanced Enterprise Server Edition D

Correct Answer:
Explanation
Reference: https://www.ibm.com/developerworks/data/library/techarticle/dm-1304whatsnewdb2105/index.html

Question #2
Which of the following editions of DB2 include support for Federation with Oracle database?
  1. A
    DB2 Express-C
  2. B
    DB2 Developer Edition
  3. C
    DB2 Enterprise Server Edition
  4. D
    DB2 Workgroup Server Edition

Correct Answer:
C
Reference: https://www.ibm.com/developerworks/data/library/techarticle/dm-1311db2compare/index.html

Question #3
Which three facilities are used to control authorization in DB2?
  1. A
    privileges, db2ssh, LBAC credentials
  2. B
    privileges, authority levels, certificates
  3. C
    db2ssh, trusted contexts, authority levels
  4. D
    privileges, authority levels, LBAC credentials

Correct Answer:
D
Reference: https://www.ibm.com/support/knowledgecenter/zh/SSEPGG_9.5.0/com.ibm.db2.luw.admin.sec.doc/doc/c0006307.html

Question #4
Which database object can be locked explicitly?
  1. A
    Row
  2. B
    View
  3. C
    Index
  4. D
    Table

Correct Answer:
D
Reference: https://www.ibm.com/support/knowledgecenter/hr/SSEPGG_9.7.0/com.ibm.db2.luw.admin.perf.doc/doc/c0005270.html

Question #5
What happens when you run the following statement if MYUSER holds no privileges on table MYTABLE?
REVOKE SELECT ON TABLE mytable FROM USER myuser
  1. A
    An error is returned
  2. B
    An entry is mane in SYSCAT.TABAUTH
  3. C
    The REVOKE statement succeeds with no effect
  4. D
    All privileges are granted to user MYUSER on MYTABLE C

Correct Answer:
Explanation

Next Questions

All Pages