IBM DB2 Interview Questions & Answers part 3

0
522
Q: – Which of the following is NOT a characteristic of a data warehouse?

A. Summarized queries that perform aggregations and joins
B. Heterogeneous data sources
C. Voluminous historical data
D. Sub-second response time

The correct answer is C. The DB2 XML Extender can be used to decompose (shred) XML elements from a document and store them in columns and tables; it can also compose (create) new XML documents from existing character and numerical data or previously shredded XML documents. (If the DB2 XML extender is not used, XML documents are stored hierarchically in columns with the XML data type.) The DB2 Audio, Video, and Image (AVI) Extender contains a set of data types and functions that can be used to store and manipulate nontraditional data such as audio clips, movies, and pictures in a DB2 UDB database; the DB2 Text Extender contains a set of data types and functions that can be used to store complex text documents in a DB2 UDBdatabase and to extract key information from such documents; and the DB2 Spatial Extender contains a set of user-defined data types that can be used to describe spatial data (for example, points, lines, and polygons) and a set of user-defined functions that can be used to query spatial objects (for example, to find area, endpoints, and intersects).

Q: – What is the error code -803?

unique index violation

Q: –Define "Table spaces"?

A table space is a logical entity used to define where tables and indexes will be
stored within a database. As all DB2 tables and indexes reside in table spaces, this allows complete control over where the table and index data is physically stored.

Q: – Which of the following is NOT a characteristic of an OLTP database?

A. Granular transactions
B. Current data
C. Optimized for queries
D. Frequent updates

The correct answer is C. OLTP systems are designed to support day-to-day, mission-critical business activities such as order entry, stock trading, inventory management, and banking. This typically involves hundreds to thousands of users issuing millions of transactions per day against databases that vary in size. Response time requirements tend to be sub-second and workloads tend to be a mix of real-time DML operations (inserts, updates, and deletes). Workloads in a data warehouse can consist of bulk load operations, short running queries, long running complex queries, random queries, occasional updates to data, and the execution of online utilities. Thus, data warehouses are optimized for queries.

Q: – Can you define an Index if the table size less than 10 PAGES?

No

Q: – What is sqlcode -811?

SELECT statement has resulted in retrieval of more than one row.

Q: – What are uses of "Triggers"?

– Validation
– Conditioning
– Integrity

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

A. DB2 Express-C
B. DB2 Express
C. DB2 Personal Edition
D. DB2 Enterprise Server Edition

The correct answer is D. DB2 Enterprise Server Edition (ESE) is designed to be used on a server that is running any of the following operating systems: AIX, HP-UX, Solaris, Linux, and Windows. DB2 Express-C is designed to be used on microcomputers that are running a supported version of Linux or Windows; DB2 Express is designed to be used on microcomputers that are running a supported version of Linux, Solaris, or Windows; and DB2 Personal Edition can be deployed on any Personal Computer (PC) that is running Linux or Windows.

Submitted By:-Vikas            Email-ID: – vikas123.singh@yahoo.com

SHARE

LEAVE A REPLY