Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

IBM C2090-616 Exam Questions

Status: RETIRED
Exam Name: DB2 11.1 Fundamentals for LUW
Exam Code: C2090-616
Related Certification(s):
  • IBM Certified Database Administrator Certifications
  • IBM DB2 10 for z/OS Certifications
Certification Provider: IBM
Actual Exam Duration: 90 Minutes
Number of C2090-616 practice questions in our database: 63 (updated: 26-10-2022)
Expected C2090-616 Exam Topics, as suggested by IBM :
  • Topic 1: Identify and describe the authorities and privileges available/ Identify factors that influence locking
  • Topic 2: Identify characteristics of DB2 locks/ Identify and describe the DB2 products available
  • Topic 3: Given a situation, identify the isolation level that should be used/ Identify and decribe the DB2 Cloud offerings available
  • Topic 4: Demonstrate the ability to create and use triggers/ Describe the characteristics of OLTP and Data Warehouse workloads
  • Topic 5: Demonstrate the ability to create and use temporary tables/ Demonstrate the ability to use DB2 BLU Acceleration
  • Topic 6: Identify the OLAP function used to meet a specific business requirement/ Identify and describe Oracle and Netezza Compatibility Features
  • Topic 7: Identify and describe the DB2 data types available/ Identify and describe the DCL statements available
  • Topic 8: Demonstrate the ability to create and call an SQL stored procedure or a user defined function/ Describe the benefits of DB2 pureScale
  • Topic 9: Identify and describe SQL compatibility enhancements/ Create and connect to DB2 servers and databases
  • Topic 10: Demonstrate the ability to manage transactions/ Describe methods used to restrict data access
Disscuss IBM C2090-616 Topics, Questions or Ask Anything Related

Currently there are no comments in this discussion, be the first to comment!

Free IBM C2090-616 Exam Actual Questions

Note: Premium Questions for C2090-616 were last updated On 26-10-2022 (see below)

Question #1

Which of the following DB2 objects in an efficient way of representing data without the need to maintain it and requires no permanent storage?

Reveal Solution Hide Solution
Correct Answer: A

Question #2

What is the maximum length allowed for a VARCHAR2 data type when the VARCHAR2_COMPAT database configuration parameter is set to ON?

Reveal Solution Hide Solution
Correct Answer: A

Question #3

With HADR, which of the following configuration and topology choices provides the highest level of protection from potential loss of data in a pureScale environment?

Reveal Solution Hide Solution
Correct Answer: A

Standby databases are synchronized with the primary database through log data that is generated on the primary and shipped to the standbys. The standbys constantly roll forward through the logs. You can choose from four different synchronization modes. In order of most to least protection, these are SYNC, NEARSYNC, ASYNC, and SUPERASYNC.


Question #4

Application 1 executes the following statements:

INSERT INTO TAB1 (NAME,AMOUNT) VALUES ('John,100);

COMMIT;

UPDATE TAB1 SET AMOUNT=90 WHERE NAME='John';

After a few seconds, application 2 executes the following query:

SELECT AMOUNT FROM TAB1 WHERE NAME='John'

Assuming the Currently Committed (CUR_COMMIT) configuration parameter is enabled, which of the following is TRUE?

Reveal Solution Hide Solution
Correct Answer: B

Question #5

Below are the SQL statements a DBA is planning to execute on a database:

CREATE TABLE t1 (name VARCHAR (1));

INSERT INTO t1 VALUES ('A'), ('B'), ('C'), ('D');

ALTER TABLE t1 ALTER COLUMN name SET DATA TYPE INT;

What will be the outcome of the last statement?

Reveal Solution Hide Solution
Correct Answer: B


Unlock Premium C2090-616 Exam Questions with Advanced Practice Test Features:
  • Select Question Types you want
  • Set your Desired Pass Percentage
  • Allocate Time (Hours : Minutes)
  • Create Multiple Practice tests with Limited Questions
  • Customer Support
Get Full Access Now

Save Cancel