Is this exam completely free?

ExamCademy offers a free preview for every exam, covering around 20% of the total questions. Full access to all questions is available for free by signing up for an account. Optional supporters unlock AstroTutor (AI tutor) and advanced study modes.

Can I practice IT certification exams from Microsoft, AWS, or CompTIA?

Yes! ExamCademy supports a wide range of IT certification exams including Microsoft Azure, AWS Cloud Practitioner, and CompTIA A+ and Security+.

How accurate are the mock exams?

Our practice questions are community-created and moderator-reviewed to align with realistic exam objectives, style, and difficulty.

C2090-616 by Ibm - Page 1 | ExamCademy

Mode Selection

Question 1

Question 2

Question 3

Shadow tables are a special kind of Materialized Query Table, but what makes them different? (Choose two.)

A Shadow tables cannot be queried directly
B Shadow tables do not store their data on disk
C Shadow tables must be organized by column
D Shadow tables must be maintained by replication
E You cannot join shadow tables to other kinds of tables CD

Question 4

Which isolation level will allow application A to immediately read the committed value of a row that is exclusively locked by application B?

A Read Stability
B Cursor Stability
C Repeatable Read
D Cursor Stability with WAIT FOR OUTCOME clause A

Question 5

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 D

Question 6

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

Question 7

Which database object can be locked explicitly?

A Row
B View
C Index
D Table

Question 8

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 C

That's the end of the Preview

Create a free account to unlock all questions for this exam.

Log In / Sign Up

Page 1 of 2 • Questions 1-25 of 38

1 2

→

Know a question that should be here? Contribute to this exam

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?

A The statement will fail due to variable length character error
B The statement will fail due to an incompatible data type error
C The statement will execute successfully and it deletes the character data
D The statement will execute successfully and it internally converts the character data into ASCII numbers

The DDL statement is used to create table T1:
CREATE TABLEt1 (
c1 INTEGER,
c2 INTEGER NOT NULL,
c1 DECIMAL(11,2),
c4 TIMESTAMP WITH DEFAULT CURRENT TIMESTAMP
)
Which of the following INSERT statements will execute successfully?

A INSERT INTO t1 VALUES (100)
B INSERT INTO t1 (c1, c2) VALUES (100)
C INSERT INTO t1 (c1, c3) VALUES ("˜100', "˜100.00')
D INSERT INTO t1 (c2, c3) VALUES (100, 100.00), (101, 101)