DBMS-IDM DB2 Universal Database Questions and Answers
DBMS – IDM DB2 Universal Database Questions with Answers focus on IBM’s advanced relational database system. Candidates can practice SQL queries, architecture, and performance-related topics to strengthen their database knowledge. These DB2 programming questions and answers are especially useful for technical interviews and placement tests at IBM, Infosys, and TCS. By solving these questions, learners gain practical insights into enterprise-level database management and optimization.
DBMS-IDM DB2 Universal Database
Showing 10 of
43 questions
21. The LAV Extenders provide the ability to use images, audio and video data in user's applications.
- TRUE
- FALSE
22. DB2 Data Joiner is a version of DB2 Version 2 for Common Servers that enables its users to interact with data from multiple heterogeneous sources, providing an image of a single relational database.
- TRUE
- FALSE
23. Which DB2 UDB product cannot accept requests from remote clients ?
- DB2 Enterprise Edition
- DB2 Workgroup
- DB2 Personal Edition
- DB2 Enterprise-Extended Edition
24. From which DB2 compounent could you invoke Visual Explain ?
- Control Centre
- Command Centre
- Client Configuration Assistant
- Both (a) and (c)
25. Which of the following is the main function of the DB2 Connect product ?
- DRDA Application Requester
- RDBMS Engine
- DRDA Application Server
- DB2 Application Run-time Environment.
26. Which product contains a database engine and an application development environment ?
- DB2 Connect
- DB2 Personal Edition
- DB2 Personal Developer's Edition
- DB2 Enterprise Edition
27. Which communication protocol could you use to accessa DB2 UDB database ?
- X.25
- Apple Talk
- TCP/IP
- None of these
28. What product is required to access a DB2 for OS/390 from DB2 CAE workstation ?
- DB2 Universal Developer's Edition
- DB2 Workgroup
- DB2 Connection Enterprise Edition
- DB2 Personal Edition
29. Which communication protocol can be used between DRDA Appliction Requester (such as DB2 Connect) and a DRADA Application Server (such as DB2 for OS/390)?
- TCP/IP
- NetBIOS
- APPC
- Both (a) and (c)
30. Which of the following provides the ability to access a host database with Distributed Relational Database Architecture (DRDA) ?
- DB2 Connect
- DB2 UDB
- DB2 Developer's Edition
- All of these