Free Preparation Discussions
MENU
IBM C2090-616 Exam
- 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
Free IBM C2090-616 Exam Actual Questions
The questions for C2090-616 were last updated On 26-10-2022
Which of the following DB2 objects in an efficient way of representing data without the need to maintain it and requires no permanent storage?
What is the maximum length allowed for a VARCHAR2 data type when the VARCHAR2_COMPAT database configuration parameter is set to ON?
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?
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.
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?
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?
- Select Question Types you want
- Set your Desired Pass Percentage
- Allocate Time (Hours : Minutes)
- Create Multiple Practice tests with Limited Questions
- Customer Support
Currently there are no comments in this discussion, be the first to comment!