Sara1977
Beginner
Joined: 25 Apr 2004
Posts: 7
Topics: 4
|
 Posted: Mon Jul 05, 2004 11:35 pm Post subject: DB2:Certification Questions: |
 |
|
Hi,
I have taken a sample test for DB2 certification. I would like to know the answers for the following Qs!!
| Code: |
-----------------------------------------------------------------------------------
When deleting multiple rows from a table with a self-referencing constraint, what will happen if you use a DELETE RESTRICT rule?
A deadlock will occur.
The delete will occur.
Self-referencing constraints are not allowed.
An endless loop will occur.
The delete will not occur.
------------------------------------------------------------------------------------
CREATE TABLE EMPLOYEE
(ID SMALLINT NOT NULL ,
SSN CHAR(11) NOT NULL ,
NAME VARCHAR(35) NOT NULL,
ADDRESS VARCHAR(255) NOT NULL,
PRIMARY KEY(ID))
IN MYDATABS.MYTABLSP
You want to create a foreign key on the table called "employee". How many different foreign keys could be created referencing the employee table in the sample code above?
1. 1
2. 2
3. 3
4. 4
5. unlimited
---------------------------------------------------------------------------------
What type of SQL statement is the CALL statement?
1. Data Manipulation Language, DML
2. Data Definition Language, DDL
3. Data Control Language, DCL
4. Data Access Language, DAS
5. Data Invocation Language, DIL
---------------------------------------------------------------------------------
Which the following is NOT true about DSN1COMP?
1. It can be used to estimate the benefits of tablespace compression.
2. It can be used to estimate the benefits of indexspace compression.
3. It does not require the DB2 sub-system to be operational at execution time.
4. It can use a tablespace or tablespace partition as input.
5. It can use an image copy as input.
---------------------------------------------------------------------------------
In response to a severe deadlocking problem, which of the following is NOT a part of the resolution process?
1. Review all tablespace LOCKSIZE specifications.
2. Review of the commit/restart logic.
3. Convert all indexes from TYPE I to TYPE 2 indexes.
4. Change all application plans to be bound with ISOLATION(UW).
5. Review of the sequence used to apply table updates.
---------------------------------------------------------------------------------
When using stogroup defined objects, which utility will NOT re-allocate the underlying VSAM datasets
1. REORG
2. LOAD REPLACE
3. LOAD RESUME
4. LOAD REPLACE ENFORCE NO
5. RECOVER INDEX
---------------------------------------------------------------------------------
What is the minimum authority required to load a table?
1. SYSADM
2. SYSCTRL
3. SYSMAINT
4. DBADM
5. DBCTRL
---------------------------------------------------------------------------------
1. CREATE TABLE EMPLOYEE
2. (SSN CHAR(9) NOT NULL WITH DEFAULT,
3. PHONE_EXT CHAR(4) CONSTRAINT NUMBER CHECK
4. (PHONE_EXT NOT BETWEEN '5555', '6666'
5. AND PHONE_EXT <= '9999');
Which line in the sample code above is incorrect?
1. Line 3
2. Line 5
3. Line 4
4. Line 1
5. Line 2
---------------------------------------------------------------------------------
What is the main benefit of an image copy taken with SHRLVL CHANGE?
1. It prompts the operator when a tape mount change is required
2. It allows for OBID, PSID, DBID modification,
3. Any restore using an image copy created using this option will proceed faster.
4. It allows for concurrent table alteration via DDL
5. Applications are allowed to update tables that are being image copied.
---------------------------------------------------------------------------------
In the more recent releases of DB2, what corresponds to the DB2 version 2 definition for bufferpool?
1. Hiperpool
2. EDM pool
3. RID pool
4. Sort pool
5. Virtual pool
---------------------------------------------------------------------------------
A plan has been granted to PUBLIC. What should the CACHESIZE BIND parameter be set to in order to accommodate 50 concurrent users?
1. 0
2. 50
3. 82
4. 400
5. 512
---------------------------------------------------------------------------------
What is the minimum isolation level which ensures that any row that was changed by another application process cannot be read until it is committed by that application process?
1. Read Stability
2. Cursor Stability
3. Read Sequential
4. Repeatable Read
5. Uncommitted Read
---------------------------------------------------------------------------------
Which of the following describes a difference between INSTALL SYSADM and SYSADM?
1. INSTALL SYSADM can be granted via DCL, SYSADM cannot be granted
2. SYSADM has more authority over the DB2 directory and catalog than does INSTALL SYSADM
3. SYSADM can run CATMAINT and INSTALL SYSADM cannot run CATMAINT
4. SYSADM is a DB2 authorization level, INSTALL SYSADM is not an authorization level.
5. SYSADM can be revoked via DCL, INSTALL SYSADM cannot be revoked via DCL
---------------------------------------------------------------------------------
What is the default definition for a decimal data type
if the scale and precision is NOT specified?
1.(9,0)
2.(9,2)
3.(5,2)
4.(5,0)
5.(0,0)
---------------------------------------------------------------------------------
After starting DB2 compression for a segmented
tablespace containing multiple tables, the actual
space savings turn out to be less than the
pre-compression estimate. What would cause this
occurrence?
1.The pre-compression estimate was based on running
DSN1COMP against an image copy of the tablespace.
2.The compress dictionary does not exist since the REORG
was performed with the KEEPDICTIONARY option.
3.The full compression does not take place until the
next time the DB2 sub-system is stopped an re-started.
4.The tablespace's compression dictionary is based on
the first table loaded and may not be optimal for the
other tables.
5.The application program that inserted rows into the
table had the COMPRESS option set to NO
---------------------------------------------------------------------------------
|
Have A Great Day...
Best Regards,
Sara. |
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
