IBMDatabaseMagazine.com Blogs

Here are two more sample questions to help you prepare for the DB2 9 DBA certification exam. Give these a try, then try past questions here. All questions are from the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC Press and are reprinted with permission. Check back each week for more.

QUESTION 37

A database administrator successfully changes the value of the SORTHEAP database configuration parameter while a running application is accessing the database. When will the application see the effects?

A. When a new SQL statement is executed.
B. When a new transaction is started.
C. When a new database connection is established.
D. When the application terminates and is restarted.

QUESTION 38

Given the following CREATE TABLESPACE statement:

CREATE REGULAR TABLESPACE payroll_ts
MANAGED BY AUTOMATIC STORAGE
EXTENTSIZE 32
PREFETCHSIZE 128

Which of the following statements is NOT true?

A. When created, the PAYROLL_TS table space will be a DMS table space with file containers.
B. The database the PAYROLL_TS table space is to be created for must be enabled for automatic storage.
C. Then created, the PAYROLL_TS table space will be an SMS table space with directory containers.
D. The MANAGED BY AUTOMATIC STORAGE clause is unnecessary and could have been left out of the CREATE TABLESPACE command.

Continue reading "DB2 9 DBA Certification: Changing the SORTHEAP during access; creating storage tablespaces..."

Comment on this blog entry


DB2 Certification: Restoring a database and understanding database privileges

Brush up for certification by glancing through these sample questions. All questions are from the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC Press, and are reprinted with permission. Check back each week for more; browse past questions here.

QUESTION 35
Which of the following commands will restore a database using information found in the recovery history log file?

A. RESTART DATABASE
B. RESTORE DATABASE
C. RECOVER DATABASE
D. REBUILD DATABASE

QUESTION 36
Which of the following database privileges are NOT automatically granted to the group PUBLIC when a database is created?

A. CONNECT
B. BINDADD
C. IMPLICIT_SCHEMA
D. CREATE_EXTERNAL_ROUTINE

Continue reading "DB2 Certification: Restoring a database and understanding database privileges..."

Comment on this blog entry


DB2 Certification: Creating objects from the Control Center and understanding Import command options

IDUG North America and the free certification opportunities it presents are just weeks away. Brush up by glancing through these certification sample questions and many others. All questions are from the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC Press, and are reprinted with permission. Check back each week for more.

QUESTION 33
Which of the following objects can NOT be created from the Control Center?

A. Buffer pool
B. Event monitor
C. Trigger
D. User-defined Function

QUESTION 34
Which of the following IMPORT command options will cause the Import utility to acquire a table-level lock after every commit?

A. ALLOW NO ACCESS
B. ALLOW READ ACCESS
C. ALLOW WRITE ACCESS
D. ALLOW FULL ACCESS

Continue reading "DB2 Certification: Creating objects from the Control Center and understanding Import command options..."

Comment on this blog entry


DB2 Certification: Making configuration changes and executing the create table command

Keep up your certification preparation with this new set of sample questions, which originally appeared in the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC Press. All questions are reprinted with permission. Check back each week for more, and try past questions here.

QUESTION 31
Which of the following commands will recommend and make configuration changes for an instance named DB2INST1?

A. AUTOCONFIGURE USING db2inst1 APPLY
B. AUTOCONFIGURE USING mem_percent 60 APPLY db2inst1
C. AUTOCONFIGURE USING mem_percent 60 APPLY DBM ONLY
D. AUTOCONFIGURE USING mem_percent 60 APPLY DB AND DBM

QUESTION 32
If the following CREATE DATABASE command is executed:

CREATE DATABASE sales ON /mnt/data1, /mnt/data2
COLLATE USING IDENTITY
CATALOG TABLESPACE MANAGED BY SYSTEM USING (‘mnt/syscat’);

Which of the following statements is NOT true about the resulting database?

A. Automatic storage is enabled for the database
B. An SMS table space will be used to hold the system catalog
C. User data will be stored on /mnt/data1 and /mnt/data2
D. Metadata for the database will be stored on /mnt/data2

Continue reading "DB2 Certification: Making configuration changes and executing the create table command..."

Comment on this blog entry


DB2 DBA Certification Sample Questions: Backing up a database without affecting workloads; understanding privileges

As conference season approaches, it's time to step up your studying. Try these sample questions to help you prepare for the DB2 9 DBA certificiation exam. The questions originally appeared in the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC Press, and are reprinted with permission. Check back each week for more, and try past questions here.

QUESTION 29
Which of the following commands can be used to backup a database named PAYROLL, in such a way that workloads against the database are not impacted by more than 25%?

A. BACKUP DATABASE payroll ONLINE TO D:\backups UTIL_IMPACT_PRIORITY 25
B. BACKUP DATABASE payroll ONLINE TO D:\backups UTIL_IMPACT_LIM 25
C. BACKUP DATABASE payroll ONLINE TO D:\backups UTIL_IMPACT_PRIORITY 75
D. BACKUP DATABASE payroll ONLINE TO D:\backups UTIL_IMPACT_PRIORITY 75

QUESTION 30
A user named USER1 is granted DBADM authority. Assuming no other authorities/privileges have been granted and all privileges have been revoked from the group PUBLIC, if the following SQL statement is executed:

REVOKE DBADM ON DATABASE FROM user1

What authorities/privileges will user USER1 have?

A. None
B. CONNECT
C. SYSCTRL
D. CREATETAB

Continue reading "DB2 DBA Certification Sample Questions: Backing up a database without affecting workloads; understanding privileges..."

Comments(5)


DB2 DBA Certification Sample Questions: Using the Tools Settings notebook and deleting all records from a specific table

Here are more sample questions to help you prepare for the DB2 9 DBA certificiation exam. The questions originally appeared in the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC Press, and are reprinted with permission. Check back each week for more, and try past questions here.

QUESTION 27
Which of the following operations can NOT be performed using the Tools Settings notebook?

A. Define replication environments.
B. Change the font used to display text and menu options.
C. Set the default scheduling scheme.
D. Configure Health Status Beacons.

QUESTION 28
A database administrator wants to delete all records found in a table named DEPARTMENT. If the DEPARTMENT table resides in a database that is stored on an AIX server, which of the following commands can be used to accomplish this objective?

A. LOAD FROM null OF DEL INSERT INTO department
B. LOAD FROM null OF DEL REPLACE INTO department
C. LOAD FROM /dev/null OF DEL INSERT INTO department
D. LOAD FROM /dev/null OF DEL REPLACE INTO department

Continue reading "DB2 DBA Certification Sample Questions: Using the Tools Settings notebook and deleting all records from a specific table..."

Comments(7)


DB2 DBA Certification Sample Questions: Configuring server communications and understanding SMS tablespaces

As the 20th IDUG convention nears, you might be considering taking advantage of the free certification exams that will be offered there. If you're considering the DB2 9 DBA certificiation exam, try your hand at these sample certification questions from the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC Press and reprinted with permission. Check back each week for more, and try past questions here.

Given the following information about a DB2 server:

Instance name: db2inst1
Port number: 60000
Service name: db2c_db2inst1
Host name: db2host
Host TCP/IP address: 10.205.15.100
Protocol: TCP/IP
Database name: PROD_DB

Assuming the following entry has been made to the services file:

db2c_db2inst1 60000/tcp

Which two of the following commands must be executed to correctly configure communications for the server?

A. UPDATE DBM CFG USING SVCENAME db2c_db2inst1
B. UPDATE DBM CFG USING SVCEPORT 60000
C. db2set DB2COMM=TCPIP
D. UPDATE DBM CFG USING NNAME db2host
E. db2set DB2COMM=TCP/IP

QUESTION 26
Which of the following is NOT a true statement about SMS table spaces?

A. Regular data and long data cannot be split across multiple table spaces.
B. Storage space is allocated by the operating system as it is needed.
C. Containers can be added to or deleted from existing table spaces using the ALTER TABLESPACE command.
D. Only directory containers can be used for storage; file and device containers cannot be used.

Continue reading "DB2 DBA Certification Sample Questions: Configuring server communications and understanding SMS tablespaces..."

Comment on this blog entry


DB2 9 for Linux, UNIX, and Windows DBA Certification Exam Sample Questions

Spring is here, and daylight is lasting longer. Why not use the extra time to prepare for the DB2 9 DBA certificiation exam? Here are more sample certification questions from the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC Press and reprinted with permission. Check back each week for more, and try past questions here.

QUESTION 23
The following command was executed in an attempt to return a database named SAMPLE to the state it was in at 9:30 AM on July 1, 2007:

ROLLFORWARD DB sample TO 2007-07-01-09.30.00.000000 AND STOP

During execution, the following error was returned:

SQL4970N Roll-forward recovery on database SAMPLE cannot reach the specified stop point (end-of-log or point-in-time) because of missing or corrupted log file(s) on database partition(s) “0”. Roll-forward recovery processing has halted on log file S0000007.LOG.

Which of the following options can be added to the ROLLFORWARD command to resolve the problem?

A. END OF LOGS
B. OVERFLOW LOG PATH
C. ALTERNATE LOG PATH
D. MIRROR LOG PATH

QUESTION 24
User USER1 needs to remove a view named ORDERS_V, which is based on a table named ORDERS, from the SALES database. Assuming user USER1 does not hold any privileges, which of the following privileges must be granted before user USER1 will be allowed to drop the view?

A. DROP privilege on the ORDERS_V view
B. CONTROL privilege on the ORDERS table
C. DROP privilege on the ORDERS_V view
D. CONTROL privilege on the ORDERS_V view

Continue reading "DB2 9 for Linux, UNIX, and Windows DBA Certification Exam Sample Questions..."

Comment on this blog entry


DB2 9 DBA Certification Exam: DB2 Indexes and Create Table Statements

Here are more questions from the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC Press and reprinted with permission. To prepare for the DB2 9 Database Administration exam, try these questions. Check back each week for more. In the meantime, you can and try past questions here.

QUESTION 21
Which two of the following are valid indexes that are supported by DB2?

A. Spatial grid indexes
B. Static bitmap indexes
C. Dynamic bitmap indexes
D. Page-based indexes
E. Multidimensional range-clustered indexes

QUESTION 22
The table EMPLOYEES was created by executing the following command:

CREATE TABLE employees (empid INTEGER NOT NULL PRIMARY KEY,
name VARCHAR(25))

Assuming the file EMPDATA.DEL contains the following data:

100, “Kim Moutsos”
100, “Dwaine Snow”
200, “Rebecca Bond”
300, “Phil Gunning”
400, “Paul Zikopoulos”

If the following commands are executed:

CREATE TABLE emp_exp LIKE EMPLOYEES;
LOAD FROM empdata.del OF DEL
INSERT INTO EMPLOYEES
FOR EXCEPTION emp_exp;

Which of the following statements is true?

A. The table EMPLOYEES will contain four rows; the table EMP_EXP will be empty.
B. The table EMPLOYEES will contain five rows; the table EMP_EXP will contain five rows.
C. The table EMPLOYEES will contain four rows; the table EMP_EXP will con-tain one row.
D. The table EMPLOYEES will contain five rows; the table EMP_EXP will contain one row.

Continue reading "DB2 9 DBA Certification Exam: DB2 Indexes and Create Table Statements..."

Comments(4)


DB2 9 DBA Certification Exam: DB2 Discovery and index keys on XML content

As conference season approaches (IDUG North America is coming up in May), you might be starting to think about taking advantage of the free certification exams offered at these shows. These questions, reprinted with permission from the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC Press, should help you prepare. Check back each week for more questions, and try past questions here.

QUESTION 19
A database server has one instance named DB2INST1 and two databases named SALES and PAYROLL. Which of the following commands will allow the DB2INST1 instance and the SALES database, but prevent the PAYROLL database from being seen by DB2 Discovery?

A. UPDATE DBM CFG USING DISCOVER_INST SEARCH;
UPDATE DB CFG FOR sales DISCOVER_DB SEARCH;
UPDATE DB CFG FOR payroll USING DISCOVER_DB DISABLE;
B. UPDATE DBM CFG USING DISCOVER_INST ENABLE;
UPDATE DB CFG FOR sales DISCOVER_DB ENABLE;
UPDATE DB CFG FOR payroll USING DISCOVER_DB DISABLE;
C. UPDATE DBM CFG USING DISCOVERY SEARCH;
UPDATE DB CFG FOR sales DISCOVER_DB ENABLE;
UPDATE DB CFG FOR payroll USING DISCOVER_DB DISABLE;
D. UPDATE DBM CFG USING DISCOVERY ENABLE;
UPDATE DB CFG FOR sales DISCOVER_DB ENABLE;
UPDATE DB CFG FOR payroll USING DISCOVER_DB DISABLE;

QUESTION 20
If the following CREATE INDEX statements are executed:

CREATE INDEX cust_zip_idx ON customer(custinfo)
GENERATE KEY
USING XMLPATTERN '/customerinfo/addr/zip-pcode'
AS SQL DOUBLE;

CREATE INDEX cust_city_idx ON customer(custinfo)
GENERATE KEY
USING XMLPATTERN '/customerinfo/addr/city'
AS SQL VARCHAR(40);

And the following XML documents are inserted into the CUSTOMER table:

<?xml version="1.0" encoding="UTF-8" ?>
<customerinfo xmlns="http://crecord.dat. id="1000">
<name>John Doe</name>
<addr country="United States">
<street>25 East Creek Drive</street>
<city>Raleigh</city>
<state-prov>North Carolina</state-prov>
<zip-pcode>27603</zip-pcode>
</addr>
<phone type="work">919-555-1212</phone>
<email>john.doe@yahoo.com</email>
</customerinfo>

<?xml version="1.0" encoding="UTF-8" ?>
<customerinfo xmlns="http://crecord.dat. id="1010">
<name>Jane Smith</name>
<addr country="United States">
<street>2120 Stewart Street</street>
<city></city>
<state-prov>South Carolina</state-prov>
<zip-pcode>29501</zip-pcode>
</addr>
<phone type="work">843-555-3434</phone>
<email>jane.smith@aol.com</email>
</customerinfo>

How many index keys will be generated?

A. 1
B. 2
C. 3
D. 4

Continue reading "DB2 9 DBA Certification Exam: DB2 Discovery and index keys on XML content ..."

Comment on this blog entry


DB2 9 DBA Certification Exam: Logging index operations for recovery, and package privileges

Here are more sample certification questions from the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC Press. The questions are reprinted with permission. Check back each week for more, and try past questions here.

QUESTION 17
Which of the following commands will ensure that index creation, recreation, and reorganization operations against a database named SAMPLE will be logged so that indexes can be reconstructed during roll-forward recovery operations or high availability disaster recovery (HADR) log replay procedures?

A. UPDATE DB CFG FOR sample USING INDEXREC ON
B. UPDATE DB CFG FOR sample USING LOGINDEXMAINT ON
C. UPDATE DB CFG FOR sample USING INDEXOPS ON
D. UPDATE DB CFG FOR sample USING LOGINDEXBUILD ON

QUESTION 18
Which of the following privileges allows a user to generate a package for an embedded SQL application and store it in a database?

A. BIND
B. BINDADD
C. CREATE_EXTERNAL_ROUTINE
D. CREATE_NOT_FENCED_ROUTINE

Continue reading "DB2 9 DBA Certification Exam: Logging index operations for recovery, and package privileges..."

Comment on this blog entry


DB2 9 Certification Study Questions: DB2 diagnostics log file and data row compression

Here are more questions from the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC Press, to help you prepare for the certification test. The questions are reprinted with permission. Check back each week for more, and try past questions here.

QUESTION 13
Which of the following statements about the DB2 Diagnostics Log File is NOT true?

A. Once created, the DB2 Diagnostics Log File grows continuously.
B. If the DB2 Diagnostics Log File is deleted, a new one will be created.
C. The db2diag utility can be used to filter and format the information stored in the DB2 Diagnostics Log File.
D. If the DB2DIAG_RESTART DB2 Database Manager configuration parameter is set to YES, the DB2 Diagnostics Log File will be deleted and recreated whenever an instance is restarted.

QUESTION 14
Which of the following statements is NOT valid when discussing data row compression?

A. Data row compression can lead to disk I/O savings and improved buffer pool hit ratios.
B. Compressing data at the row level is advantageous because it allows repeating patterns that span multiple columns within a row to be replaced with shorter symbols.
C. Data row compression for a table can be enabled by executing the ALTER TABLE statement with the COMPRESS YES option specified.
D. Only data in a table enabled for data row compression is compressed; data in corresponding indexes and transaction logs is not compressed.

Continue reading "DB2 9 Certification Study Questions: DB2 diagnostics log file and data row compression..."

Comment on this blog entry


DB2 9 DBA Certification Study Questions: DB2 configuration and stored procedure calling privileges

Here are more questions from the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC Press, to help you prepare for the certification test. The questions are reprinted with permission. Check back each week for more, and try past questions here.

QUESTION 11
If the following SQL statement is executed:

UPDATE DB CFG FOR sample USING BLK_LOG_DSK_FUL YES

What will happen?

A. The SAMPLE database will be configured to use infinite logging.
B. The SAMPLE database will not automatically allocate additional storage space when the active log directory becomes full.
C. Log files for the SAMPLE database will be backed up automatically whenever a full backup image of the SAMPLE database is made.
D. Transactions running against the SAMPLE database will not be rolled back if they receive a disk full error.

QUESTION 12
User USER1 has the privileges needed to invoke a stored procedure named GEN_RESUME. User USER2 needs to be able to call the procedure--USER1 and all members of the group PUBLIC should no longer be allowed to call the procedure. Which of the following statement(s) can be used to accomplish this?

A. GRANT EXECUTE ON ROUTINE gen_resume TO user2 EXCLUDE user1, PUBLIC
B. GRANT EXECUTE ON PROCEDURE gen_resume TO user2;
REVOKE EXECUTE ON PROCEDURE gen_resume FROM user1, PUBLIC;
C. GRANT CALL ON ROUTINE gen_resume TO user2 EXCLUDE user1, PUBLIC
D. GRANT CALL ON PROCEDURE gen_resume TO user2;
REVOKE CALL ON PROCEDURE gen_resume FROM user1, PUBLIC;

Continue reading "DB2 9 DBA Certification Study Questions: DB2 configuration and stored procedure calling privileges..."

Comment on this blog entry


DB2 9 DBA Exam Sample Questions: The dbls command and the Design Advisor

If DB2 9 DBA certificiation is on your list of resolutions this year, spend some time looking over some sample questions to help you prepare. Here are more questions from the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC Press. The questions are reprinted with permission. Check back each week for more, and try past questions here.

QUESTION 9
Which of the following best describes the function of the db2ls command?

A. It retrieves information about the DB2 products that have been installed on a particular server.
B. It locks a DB2 system and limits access to users who hold System Administrator authority.
C. It generates a list of all remote servers that have been cataloged on a client workstation.
D. It returns the location of the system catalog for a particular database.

QUESTION 10
The Design Advisor can be used to analyze SQL from which two of the following?

A. The EXPLAIN_STATEMENT table
B. A file containing a workload
C. The SYSIBM.SYSPLANS system catalog table
D. The EXPLAIN_STREAM table
E. The ADVISE_WORKLOAD table

Continue reading "DB2 9 DBA Exam Sample Questions: The dbls command and the Design Advisor..."

Comments(1)


DB2 9 DBA Exam Sample Questions: Terminating applications and adding storage containers

Here's a quick way to stay on track with your preparation for the DB2 9 DBA certification exam, even at this busy time of year: Try these sample questions from the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC Press. The questions are reprinted here with permission. Check back each week for more, and try past questions here.

QUESTION 7
A LIST APPLICATIONS command returned the following output:

A. FORCE APPLICATION (146, 147, 148)
B. FORCE APPLICATION (LOCAL.DB2.070601164915,
LOCAL.DB2.070601164914, LOCAL.DB2.070601164913)
C. FORCE APPLICATION (db2taskd, db2stmm, db2bp.exe)
D. FORCE ALLPICATION ALL
E. FORCE ALL APPLICATIONS

QUESTION 8
If the following CREATE DATABASE command is executed:

CREATE DATABASE payroll ON C:

Which of the following commands will add new storage containers to the PAYROLL database?

A. ALTER TABLESPACE ADD STORAGE D:\data1, D:\data2
B. ALTER DATABASE ADD STORAGE D:\data1, D:\data2
C. ALTER TABLESPACE ADD CONTAINERS D:\data1, D:\data2
D. ALTER DATABASE ADD CONTAINERS D:\data1, D:\data2

Continue reading "DB2 9 DBA Exam Sample Questions: Terminating applications and adding storage containers..."

Comments(3)


DB2 9 DBA Exam Sample Questions: Recovering a database and LBAC

How ready are you for the DB2 9 DBA certification exam? Find out by testing your knowledge against these sample questions from the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC Press. The questions are reprinted here with permission. Check back each week for more, and try past questions here.

Continue reading "DB2 9 DBA Exam Sample Questions: Recovering a database and LBAC..."

Comment on this blog entry


DB2 9 DBA Exam Sample Questions: Monitor switch settings and the Import utility

Practice for the DB2 9 DBA certification exam by trying your hand at these two sample questions from the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC Press. The questions are reprinted here with permission. Check back each week for more, and try past questions here.

QUESTION 3
A user issues the following commands:

UPDATE DBM CFG USING DFT_MON_SORT ON;
UPDATE MONITOR SWITCHES USING UOW ON;
UPDATE DBM CFG USING DFT_MON_TIMESTAMP ON;
UPDATE MONITOR SWITCHES USING BUFFERPOOL ON;

Assuming no other monitor switches have been set, if the DB2 instance is stopped and restarted, which of the following database monitor switches will be set?

A. SORT, UOW
B. UOW, BUFFERPOOL
C. SORT, TIMESTAMP
D. TIMESTAMP, BUFFERPOOL

QUESTION 4
Which of the following is NOT a true statement about the Import utility?

A. Worksheet Format (WSF) formatted files are supported.
B. All row transactions are recorded in the database’s transaction log files.
C. System catalog tables can be targets.
D. Data can be imported into a host database through DB2 Connect.

Continue reading "DB2 9 DBA Exam Sample Questions: Monitor switch settings and the Import utility..."

Comment on this blog entry


DB2 9 DBA Exam Sample Questions: Disabling the Task Center and understanding CREATE TABLESPACE options

The DB2 database administration exam can be a challenge, even to experienced DBAs. Practicing in advance, with sample questions that resemble the kinds of questions on the actual exam, is one of the best ways I know of to prepare. Each week, I'll be posting two new sample questions and their detailed answers. The questions come from the book DB2 9 for Linux, UNIX, and Windows Database Administration: Certification Study Guide, published by MC Press, and are reprinted here with permission.

Try your hand at these, and come back each week for more. You can also find DB2 9 Fundamentals exam sample questions in the archives.

Roger E. Sanders

QUESTION 1
A database administrator wants to temporarily disable the Task Center. Which of the following can be used to achieve this objective?

A. Assign the value OFF to the SCHED_ENABLE registry variable
B. Assign the value OFF to the SCHED_ENABLE parameter in the DB2 Database Manager configuration
C. Assign the value OFF to the SCHED_ENABLE parameter in the database con-figuration for the TOOLSDB database
D. Assign the value OFF to the SCHED_ENABLE parameter in the DAS (ADMIN) configuration

QUESTION 2
Which of the following options can be specified with the CREATE TABLESPACE state-ment to create a DMS table space that can automatically expand beyond its original storage definition?

A. AUTORESIZE YES
B. RESIZE YES
C. EXTEND YES
D. EXPAND YES

Continue reading "DB2 9 DBA Exam Sample Questions: Disabling the Task Center and understanding CREATE TABLESPACE options..."

Comment on this blog entry


DB2 9 Fundamentals: Sample certification questions

Try your hand at the next batch of questions from DB2 9 Fundamentals Certfication Study Guide, reprinted with permission of MC Press.

Question 7

A table named DEPARTMENT has the following columns:

DEPT_ID
DEPT_NAME
MANAGER
AVG_SALARY

Which of the following is the best way to prevent most users from viewing AVG_SALARY data?

A. Encrypt the table’s data
B. Create a view that does not contain the AVG_SALARY column
C. Revoke SELECT access for the AVG_SALARY column from users who should not see AVG_SALARY data
D. Store AVG_SALARY data in a separate table and grant SELECT privilege for that table to the appropriate users

Question 8
In which of the following scenarios would a stored procedure be beneficial?

A. An application running on a remote client needs to be able to convert degrees Celsius to degrees Fahrenheit and vice versa
B. An application running on a remote client needs to collect three input values, perform a calculation using the values provided, and store the input data, along with the results of the calculation in two different base tables
C. An application running on a remote client needs to track every modification made to a table that contains sensitive data
D. An application running on a remote client needs to ensure that every new employee that joins the company is assigned a unique, sequential employee number

Continue reading "DB2 9 Fundamentals: Sample certification questions..."

Comments(3)


DB2 9 Fundamentals Certification Study Guide: Sample questions for exam 730

Here are two more questions from my book DB2 9 Fundamentals Certification Study Guide, published by MC Press and reprinted here with permission.

Question 5

Which type of key is defined on the child table to implement a referential constraint?

A. Unique key
B. Primary key
C. Foreign key
D. Composite key

Question 6

A table contains a list of all seats available at a football stadium. A seat consists of a section number, a seat number, and whether or not the seat has been assigned. A ticket agent working at the box office generates a list of all unassigned seats. When the agent refreshes the list, it should only change if another agent assigns one or more unassigned seats. Which of the following is the best isolation level to use for this application?

A. Repeatable Read
B. Read Stability
C. Cursor Stability
D. Uncommitted Read

Continue reading "DB2 9 Fundamentals Certification Study Guide: Sample questions for exam 730..."

Comments(8)


New DBI Certified Performance Hero Program

Today DBI announced general availability of Brother-Panther(TM) and Brother-Eagle Enterprise Edition for DB2 LUW, and launched a new Performance Hero certification program that is complimentary to IBM certification and allows DBAs to demonstrate their tuning skills to employers and peers. Read the full press release.

Continue reading "New DBI Certified Performance Hero Program..."

Comment on this blog entry


More sample questions from the DB2 9 Fundamentals Certification Study Guide

Question 3

Which of the following is a valid wildcard character in a LIKE clause of a SELECT statement?

A. %
B. *
C. ?
D. \

The answer and another sample question follow.

Continue reading "More sample questions from the DB2 9 Fundamentals Certification Study Guide..."

Comment on this blog entry


DB2 9 Fundamentals Certification

In my opinion, one of the best ways to prepare for the DB2 9 Fundamentals certification exam (Exam 730) is by answering sample questions that are presented in the same format that you will see when you take the certification exam. Every two weeks, in this section, you will find new sample questions, along with comprehensive answers for every question. (It’s not enough to know which answer is correct; it’s also important to know why the answer is correct and why the other choices are wrong!)

All of the questions presented here were developed by analyzing the final set of questions that were chosen for the DB2 9 Fundamentals certification exam (Exam 730). (I was a member of the team that developed the DB2 9 Fundamentals certification exam so I had access to every question!)

These questions are taken from my book DB2 9 Fundamentals Certification Study Guide, published by MC Press, and are reprinted here with permission.

I hope you find this material helpful.

Roger E. Sanders

Continue reading "DB2 9 Fundamentals Certification..."

Comments(4)