Tag: databases

Questions Related to databases

Which of the following DB2 products can only be installed on a System i server?
technology databases

  1. DB2 for z/OS

  2. DB2 for i5/OS

  3. DB2 Data Warehouse Edition

  4. DB2 Enterprise Server Edition

Show answer
Correct Option: B

What is the purpose of the Design Advisor?
technology databases

  1. To analyze workloads and make recommendations for indexes and MQTs

  2. To present a graphical representation of a data access plan and recommend design changes that will improve performance

  3. To replicate data between a DB2 database and another relational database

  4. To configure clients so they can access databases stored on remote servers

Show answer
Correct Option: A

Which of the following DB2 tools allows a user to set DB2 registry parameters?
technology databases

  1. Task Center

  2. Visual Explain

  3. Configuration Assistant

  4. Satellite Administration Center

Show answer
Correct Option: C

What is the SQL Performance Monitor used for?
technology databases

  1. To examine the health of a DB2 Database Manager instance

  2. To visually construct complex DML statements and examine the results of their execution

  3. To schedule tasks, run tasks, and send notifications about completed task s to other users

  4. To analyze database operations performed against a DB2 for i5/OS database

Show answer
Correct Option: D

Which of the following tasks can NOT be performed using the Developer Workbench?
technology databases

  1. Develop and debug an SQL stored procedure

  2. Develop and debug a user-defined data type

  3. Develop and debug a user-defined function

  4. Develop and run XML queries

Show answer
Correct Option: B

Which of the following tools can be used to automate table reorganization operations?
technology databases

  1. Control Center

  2. Command Center

  3. Command Line Processor

  4. Task Center

Show answer
Correct Option: D

Which of the following can be viewed with the Journal?
technology databases

  1. Historical information about tasks, database changes, messages, and notifications

  2. Information about licenses associated with each DB2 9 product installed on a particular system

  3. Graphical representations of data access plans chosen for SQL statements

  4. Warning and alarm thresholds for database indicators

Show answer
Correct Option: A

Which of the following is NOT a characteristic of an OLTP database?
technology databases

  1. Granular transactions

  2. Current data

  3. Optimized for queries

  4. Frequent updates

Show answer
Correct Option: C
Explanation:

To solve this question, the user needs to have an understanding of OLTP (Online Transaction Processing) databases and their characteristics.

Now, let's go through each option and explain why it is right or wrong:

A. Granular transactions: This is a characteristic of OLTP databases. OLTP databases are designed to handle small, granular transactions that involve the insertion, deletion, or modification of individual records in real-time.

B. Current data: This is also a characteristic of OLTP databases. OLTP databases are optimized for real-time data processing and are designed to handle the most up-to-date information.

C. Optimized for queries: This is NOT a characteristic of OLTP databases. OLTP databases are optimized for transaction processing, not for complex queries or data analysis.

D. Frequent updates: This is a characteristic of OLTP databases. OLTP databases are designed to handle frequent updates to individual records in real-time.

Therefore, the correct answer is:

The Answer is: C

Which of the following is NOT a characteristic of a data warehouse?
technology databases

  1. Summarized queries that perform aggregations and joins

  2. Heterogeneous data sources

  3. Voluminous historical data

  4. Sub-second response time

Show answer
Correct Option: D

Which of the following products is used to shred extensible markup language documents?
technology databases

  1. DB2 AVI Extender

  2. DB2 Text Extender

  3. DB2 XML Extender

  4. DB2 Spatial Extender

Show answer
Correct Option: C