Passquestion will be the first time to provide you with exam information and IBM C2090-616 Practice Test Questions to let you be fully prepared to ensure 100% to pass C2090-616 DB2 11.1 Fundamentals for LUW exam. Passquestion can not only allow you for the first time to participate in the IBM C2090-616 exam to pass it successfully, but also help you save a lot of valuable time.

C2090-616 Exam Information - DB2 11.1 Fundamentals for LUW

This Database Associate certification is an entry level exam for a user of any of the DB2 family of products. This individual is knowledgeable about the fundamental concepts of DB2 11.1 through either hands on experience or formal and informal education. The database associate should have an in-depth knowledge of the basic to intermediate tasks required in day-to-day administration, basic SQL (Structured Query Language), understand which additional products are available with DB2 11.1, understand how to create databases and database objects, and have a basic knowledge of database security and transaction isolation. 

There are 63 questions in the real C2090-616 test,you should answer 43 questions correctly to pass your exam, and you need to finish your IBM C2090-616 exam in 90 minutes. If you want to get your IBM Certified Database Associate Certification, you should know the exam objectives and studying PassQuestion IBM C2090-616 Practice Test Questions.

IBM C2090-616 Exam Objectives:

Section 1 - Planning       21%
Section 2 - Security       17%
Section 3 - Working with Databases and Database Objects     16%
Section 4 - Working with DB2 Data using SQL   19%
Section 5 - Working with DB2 Tables, Views, and Indexes      13%
Section 6 - Data Concurrency       14%

Share Free IBM C2090-616 Exam Questions To Check:

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?
A. DB2 Express-C
B. DB2 Enterprise Server Edition
C. DB2 Workgroup Server Edition
D. DB2 Advanced Enterprise Server Edition
Answer: D

2.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

3.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

4.Which database object can be locked explicitly?
A. Row
B. View
C. Index
D. Table
Answer: D

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
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
Answer: C

6.A user executes the following statements:
СREATE TABLE t1 (c1 INT, c2 INT);
CREATE ALIAS a1 FOR t1;
What will be the result if the user executes the following statement?
DROP ALIAS a1;
A. The alias A1 will be dropped
B. The table T1 will be dropped
C. Both T1 and A1 will be dropped
D. Nothing, the statement will result in an error
Answer: A