Appendix L. Sample Questions

SYSADM privileges are:

Given the following users:

User appusr1 belongs to group usr1grp and user appusr2 belongs to group db2grp.

User appusr1 is the owner of the instance db2inst1 and has updated the database manger configuration set the SYSADM_GROUP to usr1grp.

If user appusr2 wants to drop db2inst1 instance and create a new instance db2inst2, user appusr2 needs:

If you set TRUST_ALLCLNTS=YES and TRUST_CLNTAUTH=SERVER, then authentication for Trusted non-DRDA Client Authentication with password is at:

Kerberos authentication is supported only for clients and servers running Windows 2000, Windows XP, and Windows 2003 operating systems. In addition, both the client and server machines must:

With an authentication type of KRB_SERVER_ENCRYPT at the server, if the clients do not support the Kerberos security system, then the effective system authentication type is equivalent to:

During database creation, SELECT privilege on the system catalog views is granted to the PUBLIC group. To prevent non-privileged viewers from viewing the catalog, you must:

A caching mechanism exists so that the client searches the LDAP directory only once in its local directory catalogs. Once the information is retrieved, it is cached on the local machine. Subsequent access to the same information is based on the value of the DIR_CACHE Database Manager Configuration parameter and the DB2LDAPCACHE registry variable. Which one of the following statements is correct?

When running on Windows operating systems, DB2 supports using either IBM LDAP client or the Microsoft LDAP client to access the IBM SecureWay Directory Server. If you want to select the IBM LDAP client explicitly, you must use:

To enable LDAP explicitly, execute the following command:

To avoid LDAP information being cached in the database, node, and DCS directories, which one of the following is correct?

Before accessing information in the LDAP directory, an application or user is authenticated by:

In a multi-partition database, with four database partitions created for each server, there are four identical DB2 servers with a cluster. How many entries will be required in the /etc/services file?

In a partitioned database environment, if there are four DB2 servers and two database partitions for each DB2 server, then how many db2nodes.cfg files will be required?

Which of the following statements is true about Federated Database support in DB2?

What is the processing of a query fragment at a data source instead of at the federated server known as?

In a federated system, the query optimizer generates local and remote access plans for processing a query fragment, based on resource cost. Which of the following statements is true?

Select the correct answer based on following statement:

alter server MYSERV options (ADD CPU_RATIO '0.2');

Select the correct answer based on following statement:

alter server MYSERV options (SET CPU_RATIO '2.0');

Select the correct answer based on following statement:

alter server MYSERV options (SET IO_RATIO '2.0');

Select the correct answer based on following statement:

alter server MYSERV options (ADD COMM_RATE '2');

How many blocks will be required to receive a result set from the data source MYSERV of 10,000 records with a row length of 100 if the RQRIOBLK is set to 65,535?

Given the following statement:

create table mqt_account as
          (select a.c1, a.c2, b.c1
            from taba a, tabb b
          where a.c1=b.c2)
data initially DEFERRED refresh <REFRESH OPTION>;

Which of the refresh options below should be used to allow the user to perform INSERT, UPDATE, and DELETE operations against the materialized query table?

Which of the following sets of configuration parameters allow the database to use infinite active log space?

At the database level, mirroring log files helps protect the database SAMPLE from accidental deletion of an active log. In order to achieve this, which of the following is required?

Which of the following statements is incorrect when referring to the Declared Global Temporary tables?

A transaction that receives a log disk full error (SQL0968C) will fail and be rolled back. In addition, DB2 will stop processing. To prevent disk full errors from causing DB2 to stop processing when it cannot create a new log file in the active log path, you should:

Which of the following commands will collect a complete set of log files up to a known point in time?

For some reason, the user exit did not work properly for the SAMPLE database, and the DIAGLEVEL is set 2. You need to determine the cause of the problem. Which of the information (files) will you need to analyze to help you to identify the problem and determine the solution to resolve it?

Which of the following statements best describe incremental delta backup image?

Which of the following options is required to enable online and incremental backups?

The database SAMPLE is defined on all four partitions numbered 0 through 3. Database partition 0 is the catalog partition. What is the correct way to perform an offline backup of this database?

1.  db2 terminate
2.  db2 force application all
3.  db2stop
4.  db2start
5.  db2_all '<<+0< db2 backup database SAMPLE to /dbbackup/SAMPLE'
6.  db2_all '<<?0< db2 backup database SAMPLE to /dbbackup/SAMPLE'

The database SAMPLE is defined on all four partitions numbered 0 through 3. Database partition 0 is the catalog partition. What is the correct way to restore this database from the recent full offline backup images below?

SAMPLE.0.v8inst.NODE0000.CATN0000.20020829013314.001
SAMPLE.0.v8inst.NODE0001.CATN0000.20020829013401.001
SAMPLE.0.v8inst.NODE0002.CATN0000.20020829013012.001
SAMPLE.0.v8inst.NODE0003.CATN0000.20020829013028.001

Which of the following statements will roll forward a table space backup to the end of logs on database partition number 2?

Which of the following statements is true about db2inidb utility?

Given the following sequences:

Which of the following availability methods is being used in this scenario?

In a partitioned database environment, you do not have to suspend I/O writes on all partitions simultaneously. Which of the following statements is true?

In this example, database partition number 0 is running on server1 configured for automatic failover. After the server1 failed over to the server2, database partition number 0 and database partition number 1 are both running on server2. Which of the following db2nodes.cfg files would exist on server2?

There are two logical database partitions (0 and 1) defined on server1 and two logical database partitions (2 and 3) defined on server2, and the servers are configured for automatic failover. After the failover, database partition 2 and 3 also are running on server1. Which of the following db2nodes.cfg files would exist on server2?

When loading data into a table, which statement is true for the target table in share lock mode? Which of the following LOAD options will allow existing data in the table to be selected?

Which of the following LOAD options will prevent existing data in the table to be selected?

In a partition databases environment, when you issue the db2start command, you will get the following output:

[View full width]
11-20-2002 15:14:05 1 0 SQL6048N A communication error occurred during START or STOP
 DATABASE MANAGER processing.
11-20-2002 15:14:05 2 0 SQL6048N A communication error occurred during START or STOP
 DATABASE MANAGER processing.
11-20-2002 15:14:05 3 0 SQL6048N A communication error occurred during START or STOP
 DATABASE MANAGER processing.
11-20-2002 15:14:05 4 0 SQL6048N A communication error occurred during START or STOP
 DATABASE MANAGER processing.

To resolve this communication error, you must:

In a partition database environment, when you issue the db2start command, you will get the following output:

SQL6031N Error in the db2nodes.cfg file at the line number "2".
Reason code "9".

The content of the db2nodes.cfg is:

0 server1 1
1 server1 1
2 server2 0
3 server3 0

Based on the db2nodes.cfg file above, which of the following db2nodes.cfg files will fix this problem?

If you issue a db2start restart command, you will get the following error:

[View full width]
db2start dbpartitionnum 3 restart hostname server3 port 3 netname netserv3

11-20-2002 15:14:05 3 0 SQL6031N Error in the db2nodes.cfg file at line "5".  Reason code
 "12".

The content of the /etc/services file is:

DB2_db2inst1       50501/tcp
DB2_db2inst1_END   50502/tcp

The content of the db2nodes.cfg file is:

0 server1 0 netserv1
1 server2 0 netserv2
2 server3 0 netserv3

Based on the db2nodes.cfg and /etc/services files above, how many entries will be required in the /etc/services file?

How many buffer pools are created when a database is created?

How many table spaces are created when a database is created?

How many database partition groups are created when a database is created?

For a database with the following table spaces defined:

Tablespace1 with a page size of 4 KB

Tablespace2 with a page size of 4 KB

Tablespace3 with a page size of 4 KB

What is the minimum number of buffer pools required?

For a database with the following table spaces defined:

Tablespace1 with a page size of 4 KB

Tablespace2 with a page size of 8 KB

Tablespace3 with a page size of 4 KB

What is the minimum number of buffer pools required?

To create a user table space with a page size of 32 KB, which of the following must already exist?

In which of the following table spaces can the table below be created?

Create table T1(c1 int,c2 char (200), c2 varchar(10000))

What is the minimum page size for table space TS1, given the following statement?

Create table T1(c1 int,c2 char (200), c2 varchar(3800)) in TS1 long in TSLONG

What is the minimum size of a DMS table space, given an extent size of 64 4-KB pages?

If a table space contains a single table with a row size of 700 bytes, including overhead, what is the minimum page size for the table space in order for the table to contain 100 million rows?

If the following table is created in a DMS table space:

Create table table1 (c1 int not null primary key,
  c2 char(30),
  c3 char(10),
  c4 int)

How many table space extents will be used for the table?

Which tool can be used to enable an SMS table space to allocate space an extent at a time, rather than a page at a time?

For a database created using a single-byte code page containing the following tables:

TableA
-------------------
C1A Char(250)
C2A Char(250)
C3A Char(250)
C4A Int
C5A VarChar(2000)

TableB
---------------------
C1B VarChar(2000)
C2B Int
C3B Int
C4B Int

Given the following SQL statement:

Select A.C5A, A.C2A, B.C1B, B.C2B, B.C3B, B.C4B
  from TableA A, TableB B
  where A.C4A = B.C4B
  and B.C4B > 100

What is the minimum page size for the table space where the temporary table will be created?

What type of table space can contain both INDEXes and LOBs for a table?

What option will insert the database partition number to each container name in a create table space statement?

Which of the following is not a valid option for the ALTER TABLESPACE command?

What is the page size for the catalog table space?

Table space TS1 was created using the following SQL statement:

CREATE TABLESPACE TS1 MANAGED BY DATABASE
  USING (FILE 'CONT1' 2000, FILE 'CONT2' 2000)

Which of the following SQL statements cannot be used to change the size of all of the containers in TS1 to 5,000 pages each?

To set aside an area of the buffer pool for block-based prefetching, which of the following options must be set?

Which privilege level is the minimum necessary to alter a buffer pool?

If insufficient memory is available to create a new buffer pool, which of the following will occur?

Given a database in a 32-bit instance of DB2 with an existing 250,000 4-KB pages buffer pool, to create a new buffer pool automatically with a size of 50,000 4-KB pages, to which of the following values must the DATABASE_MEMORY configuration parameter be set?

Given the following user-defined table spaces and associated page sizes:

Table Space Name                     Page Size
----------------                     ---------
Userspace1                           16K
Tempspace1                           16K
Tempspace2                           8K
tbspc1                               8K
tbspc2                               16K

What is the minimum number of buffer pools that must exist in this database?

Given the following statements:

CREATE BUFFERPOOL bp1 SIZE 100000;
ALTER TABLESPACE tbspc1 BUFFERPOOL bp1;

Which of the following statements will fail?

Given the following statements:

CREATE BUFFERPOOL bp1 SIZE 100000;
ALTER TABLESPACE tbspc1 BUFFERPOOL bp1;
CREATE BUFFERPOOL bp2 SIZE 200000;
DROP BUFFERPOOL bp1;

When will the memory for buffer pool BP1 be freed back to the operating system?

Given the following instance and database configuration information:

INTRA_PARALLEL = YES
MAX_QUERYDEGREE = 4
DFT_DEGREE = 8

How many total agent/subagent processes will be used to process the select * from table1 statement?

Given the following statement:

CREATE TABLE T1
  ( c1 int, c2 int, c3 char(10), c4 char(10))
    organize by ( (c1,c3), c2)

How many indexes will be automatically created by DB2?

For the table:

create table t1(c1 varch

    

    
    

    
    

IBM Press Series?Information Management
About Prentice Hall Professional Technical Reference
Foreword
Preface
DB2: Any Workload, Any Data, All the Time
Conventions Used Throughout the Book
Acknowledgments
Trademarks
Chapter 1. Data Storage
Some Terminology Used in DB2
The Default Database
Table Spaces
Additional Table Space Options/Parameters
Summary
Chapter 2. Data Manipulation
The Buffer Pools
Parallelism
Types of Database Objects
Summary
Chapter 3. Database Availability
Ability to Manage Logs
Developing a Backup and Recovery Strategy
Backup Overview
Restore Overview
Rollforward Overview
High Availability Clustering
Availability Enhancements
Ability to Use db2dart
Summary
Chapter 4. Database Security
Selecting User Names and Group Names for DB2 Installation
Authentication Methods
Privileges, Authorities, and Authorizations
Firewall Support
What Is LDAP?
Security Implementation and Usage
How DB2 for Windows NT/2000 Works with Windows NT/2000 Security
User Authentication with DB2 for Windows NT
Summary
Chapter 5. Multi-Dimensional Clustering
MDC Terminology
Design Guidelines for MDC Tables
MDC Performance Guidelines
Space Usage with MDC Tables
MDC Indexes
Summary
Chapter 6. The DB2 Optimizer
Joining in DB2 UDB
Materialized Query Tables
Understanding DB2 Query Access Plans
Summary
Chapter 7. Federated Database Access
What Is a Federated System?
Overview of the Tasks to Set Up a Federated System
How Do You Interact with a Federated System?
Setting Up the Federated Server and Database
Working with the Federated Data
Sample Configuration Federated between DB2 on OS/390 and DB2 on Sun Solaris
Configuration of a Federated Database System
Nickname Characteristics Affecting Global Optimization
Summary
Chapter 8. Performance Tuning
Performance Fundamentals
Configuration Parameter Tuning
Database Configuration Parameter Tuning and Monitoring
Registry Variable Tuning
Other Important Configuration Parameters
Summary
Chapter 9. Database Communications
Database Partition Configuration File (db2nodes.cfg)
Default Port Range
Non-Partitioned Database Environment
Installing the DB2 Server
Partitioned Database Environment
Post-Installation Setup
Installing and Configuring DB2 Client to DB2 Server Communications
Installing and Configuring DB2 Client to DB2 Host Communications
Installing DB2 Connect Personal Edition
Configuring DB2 Clients in a Two-Tier Environment
Configuring DB2 Clients in a Three-Tier Environment
FCM Communication Buffers Considerations
Summary
Chapter 10. Performance Tuning Examples
Example 1: Create Index Taking Too Long
Example 2: Unable to Get Desired Throughput
Example 3: Query1 Taking Too Long to Run
Example 4: Query2 Taking Too Long to Run
Example 5: Periodic Noticeable Slowdown of Database Response Time
Appendix A. Useful DB2 Commands
System Commands
CLP Commands
ONLINE Utility
Appendix B. parseSQL.pl
Appendix C. exfmtDIF.pl
Appendix D. Comparing Index Advisor Recommended Indexes with Existing Indexes
Appendix E. Configuration Parameters That Can Be Changed Online
Appendix F. Explain Tools
EXPLAIN Tables
EXPLAIN Commands
EXPLAIN Output
Appendix G. Starting and Stopping a DB2 Instance
Appendix H. LDAP Integration in DB2 UDB Using Microsoft Active Directory
Implementation Guidelines
Appendix I. Tuning DB2 UDB in the IBM LDAP Environment
Appendix J. DB2 Support Information
DB2 Support Resources
Opening a PMR
Collecting Diagnostic Information
Sending Diagnostic Information
Appendix K. DB2 Connect Implementation
Installing DB2 Connect Enterprise Edition
Appendix L. Sample Questions
Appendix M. Answers to Sample Questions
About the CD-ROM
License Agreement
Technical Support
Article



            
        
     
        

            

                
Remember the name: eTutorials.org
                

                    
                
                
Copyright eTutorials.org 2008-2024. All rights reserved.