Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
 

IBM C2090-610 Exam Actual Questions

The questions for C2090-610 were last updated on Nov. 4, 2024.
  • Viewing page 1 out of 35 pages.
  • Viewing questions 1-4 out of 138 questions
 

Topic 1 - Volume A

Question #1 Topic 1

If the following command is executed: CREATE DATABASE test What is the page size (in kilobytes) of the database?

  • A. 4
  • B. 8
  • C. 16
  • D. 32
Reveal Solution Hide Solution   Discussion  

Correct Answer: A 🗳️

Question #2 Topic 1

Given the following DDL statement: CREATE TABLE sales (item CHAR(20)); If a DBA wishes to increase the size of the ITEM column, which SQL statement needs to be used?

  • A. ALTER TABLE sales ADD COLUMN item CHAR(40);
  • B. ALTER TABLE sales ALTER COLUMN item CHAR(40);
  • C. ALTER TABLE sales MODIFY COLUMN item CHAR(40);
  • D. ALTER TABLE sales ALTER COLUMN item SET DATA TYPE CHAR(40);
Reveal Solution Hide Solution   Discussion  

Correct Answer: D 🗳️

Question #3 Topic 1

Which DB2 object can be used to improve the execution performance of qualified SELECT statements?

  • A. Trigger
  • B. SQL Procedure
  • C. Sequence Object
  • D. Materialized Query Table
Reveal Solution Hide Solution   Discussion  

Correct Answer: D 🗳️

Question #4 Topic 1

When is it appropriate to use a sequence?

  • A. When you want to control the order in which triggers are fired.
  • B. When you want to control the order in which stored procedures can be invoked.
  • C. When you want to automatically generate a numeric value that is not tied to any specific column or table.
  • D. When you want to automatically generate a numeric value for each row that is added to a specific table.
Reveal Solution Hide Solution   Discussion  

Correct Answer: C 🗳️

Next Questions

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel