• databases Online Quiz - 80
Back
0

databases Online Quiz - 80

Description: databases Online Quiz - 80
Number of Questions: 20
Created by:
Tags: databases
Start the Quiz
Attempted 0/20 Correct 0 Score 0
‹
›

Which of the following products must be installed on an AIX server in order to build an application for AIX that will access a DB2 for z/OS database?

technology databases

  1. DB2Enterprise Server Edition

  2. DB2 Personal Developer's Edition

  3. DB2 Universal Developer's Edition

  4. DB2 Universal Database Enterprise Edition and DB2 Connect Enterprise Edition

Show answer
Correct Option: C

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. DB2Enterprise 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 tools can be used to catalog a database?
technology databases

  1. Visual Explain

  2. Alert Center

  3. Journal

  4. Configuration Assistant

Show answer
Correct Option: A

Which of the following is used to create and debug user-defined functions?

technology databases

  1. SQL Assist

  2. Control Center

  3. Command Editor

  4. Developer Workbench

Show answer
Correct Option: D

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

Which of the following is the lowest cost DB2 product that can be legally installed on a Windows server that has 2 CPUs?

technology databases

  1. DB2 Everyplace

  2. DB2 Express Edition

  3. DB2 Workgroup Server Edition

  4. DB2 Enterprise Server Edition

Show answer
Correct Option: B

Which of the following is the lowest cost DB2 product that can be legally installed on an HP-UX server?

technology databases

  1. DB2 Express-C

  2. DB2 Express

  3. DB2 Personal Edition

  4. DB2 Enterprise Server Edition

Show answer
Correct Option: D

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

AI Explanation

To answer this question, you need to understand the purpose of each DB2 tool mentioned. Let's go through each option to understand why it is correct or incorrect:

Option A) Task Center - Task Center is a tool that allows users to schedule and manage tasks in DB2. It does not provide the functionality to set DB2 registry parameters. Therefore, this option is incorrect.

Option B) Visual Explain - Visual Explain is a tool that helps users understand and optimize the performance of DB2 queries. It does not provide the functionality to set DB2 registry parameters. Therefore, this option is incorrect.

Option C) Configuration Assistant - Configuration Assistant is a DB2 tool that allows users to configure and manage various aspects of a DB2 database, including setting DB2 registry parameters. This option is correct.

Option D) Satellite Administration Center - Satellite Administration Center is a tool that helps users manage and monitor DB2 database replication. It does not provide the functionality to set DB2 registry parameters. Therefore, this option is incorrect.

The correct answer is C) Configuration Assistant. This option is correct because Configuration Assistant allows a user to set DB2 registry parameters.

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

AI Explanation

To answer this question, you need to understand the capabilities of the Developer Workbench. Let's go through each option to understand why it is correct or incorrect:

Option A) Develop and debug an SQL stored procedure - This option is correct because the Developer Workbench allows you to develop and debug SQL stored procedures. You can write, test, and debug your SQL code within the Developer Workbench.

Option B) Develop and debug a user-defined data type - This option is correct because the Developer Workbench does not provide the capability to develop and debug user-defined data types. User-defined data types are typically created and managed through other tools or interfaces.

Option C) Develop and debug a user-defined function - This option is correct because the Developer Workbench allows you to develop and debug user-defined functions. You can write, test, and debug your function code within the Developer Workbench.

Option D) Develop and run XML queries - This option is correct because the Developer Workbench allows you to develop and run XML queries. You can write and execute XML queries within the Developer Workbench.

The correct answer is B) Develop and debug a user-defined data type. This option is correct because the Developer Workbench does not provide the capability to develop and debug user-defined data types.

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

AI Explanation

To answer this question, you need to understand the characteristics of a data warehouse. Let's go through each option to understand why it is correct or incorrect:

Option A) Summarized queries that perform aggregations and joins - This option is a characteristic of a data warehouse. Data warehouses are designed to support complex queries that involve aggregations and joins to provide summarized information.

Option B) Heterogeneous data sources - This option is a characteristic of a data warehouse. Data warehouses are built by integrating data from different sources, which may have different formats and structures. This allows for a comprehensive view of the data.

Option C) Voluminous historical data - This option is a characteristic of a data warehouse. Data warehouses store large amounts of historical data to support trend analysis, forecasting, and decision-making based on historical patterns.

Option D) Sub-second response time - This option is NOT a characteristic of a data warehouse. Data warehouses are optimized for analytical processing rather than real-time transactional processing. While they can provide fast query performance, sub-second response time is typically not a requirement for a data warehouse.

The correct answer is D) Sub-second response time. This option is not a characteristic of a data warehouse because data warehouses are not typically designed to provide sub-second response times.

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

Which of the following best describes the difference between the DB2 Spatial Extender and the DB2 Geodetic Extender?

technology databases

  1. The DB2 Spatial Extender uses a latitude-longitude coordinate system; the DB2 Geodetic Extender uses a planar, x- and y-coordinate system

  2. The DB2 Geodetic Extender is used to describe points, lines, and polygons; the DB2 Spatial Extender is used to find area, endpoints, and intersects

  3. The DB2 Spatial Extender treats the world as a flat map; the DB2 Geodetic Extender treats the world as a round globe

  4. The DB2 Geodetic Extender can be used to manage information like the locations of office buildings or the size of a flood zone; the DB2 Spatial Extender can be used for calculations and visualizations in disciplines like military command/control and asset

Show answer
Correct Option: C

Which of the following is true about XML columns?

technology databases

  1. XML columns are used to store XML documents as a hierarchical set of entities

  2. Only XQuery can be used to retrieve an XML document from an XML column

  3. XML columns must be altered to accommodate additional parent/child relationships if they are used in referential constraints

  4. In order to access any portion of an XML document stored in an XML column, the entire document must be retrieved

Show answer
Correct Option: A
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
963 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
598 Quizzes
13441 Questions
 biology
1160 Quizzes
12174 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
518 Quizzes
9324 Questions
 softskills
0 Quizzes
7131 Questions