IBM C2090-616 - DB2 11.1 Fundamentals for LUW Exam
Page: 1 / 13
Total 63 questions
Question #1 (Topic: Topic 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?
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?
A. DB2 Express-C
B. DB2 Enterprise Server Edition
C. DB2 Workgroup Server Edition
D. DB2 Advanced Enterprise Server Edition D
Answer: Explanation
Question #2 (Topic: Topic 1)
Which of the following editions of DB2 include support for Federation with Oracle database?
A. DB2 Express-C
B. DB2 Developer Edition
C. DB2 Enterprise Server Edition
D. DB2 Workgroup Server Edition
Answer: C
Question #3 (Topic: Topic 1)
Which three facilities are used to control authorization in DB2?
A. privileges, db2ssh, LBAC credentials
B. privileges, authority levels, certificates
C. db2ssh, trusted contexts, authority levels
D. privileges, authority levels, LBAC credentials
Answer: D
Question #4 (Topic: Topic 1)
Which database object can be locked explicitly?
A. Row
B. View
C. Index
D. Table
Answer: D
Question #5 (Topic: Topic 1)
What happens when you run the following statement if MYUSER holds no privileges on table MYTABLE?
REVOKE SELECT ON TABLE mytable FROM USER myuser
REVOKE SELECT ON TABLE mytable FROM USER myuser
A. An error is returned
B. An entry is mane in SYSCAT.TABAUTH
C. The REVOKE statement succeeds with no effect
D. All privileges are granted to user MYUSER on MYTABLE C
Answer: Explanation