有答案1套英文试题

mamahe

B1．Which of the following in a Visual Explain graph indicates that intra-partition

parallelism is being used in the access plan?

A)        Sort table queues
B)        Local table queue
C)        Remote table queue
D)        Look-ahead table queue
B2．Which of the following file formats allows for the creation of a table during import?

A)        ASC
B)        IXF
C)        MDB
D)        WSF
C3．Which of the following settings enables archival logging?

A)        Set the LOGSECOND database parameter to 2
B)        Set the ARCHIVELOG database parameter to YES
C)        Set the LOGRETAIN database parameter to RECOVERY
D)        Set the LOGPATH database parameter to the archived destination
A4．Which of the following is TRUE of System Managed Space (SMS) table spaces?

A)        Space is not allocated until required
B)        Containers may be on either system files or raw devices
C)        SMS table spaces allow LOBs to be cached in the buffer pool
D)        SMS table spaces may be split up by data type (LOBs, index, data)
BC5．Which two of the following provide sufficient authority to perform a restore to a new

database?

A)        DBADM
B)        SYSADM
C)        SYSCTRL
D)        SYSMAINT
E)        RESTORE_DB
B6．Which of the following statements is TRUE when defining an index with ALLOW REVERSE

SCANS?

A)        Two indexes are created
B)        Index can have INCLUDE columns
C)        Index must be created in ascending order
D)        Optimizer must create a temporary table for the reverse scan
A 7．Given the following:
  
   Node 1 entry:
  Node name             = DB2SERV
  Comment               = My TCPIP connection
  Protocol              = TCPIP
  Hostname              = db2inst1
  Service name          = db2svce     
Which of the following commands should be executed before updating the DBM configuration for

this instance?

A)        ATTACH TO db2serv  
B)        ATTACH TO db2inst1  
C)        CONNECT TO db2serv  
D)        CONNECT TO db2inst1     
AD8．Which two of the following enforces each row in a table to be distinct?

A)        A primary key
B)        An identity column
C)        A check constraint
D)        A unique constraint
E)        A bidirectional index
A9．Which of the following commands is required to update an instance on UNIX or Linux to use

a newly installed fixpak?

A)        db2iupdt
B)        db2icrt
C)        db2imigr
D)        db2iconv
D10．Which of the following CREATE VIEW options indicates that any updated or inserted row

must qualify against the view definition and will be rejected if it does not conform?  

A)        SET INTEGRITY  
B)        GENERATED ALWAYS  
C)        CONSTRAINT CHECK  
D)        WITH CHECK OPTION  
B11．To enable a client to connect to a database on a DB2 server using TCP/IP, which of the

following must be performed on the client?

A)        Ping the database server.
B)        Catalog the instance as a TCPIP node.
C)        Catalog the database as a TCPIP database.
D)        Set the DB2COMM registry variable to include TCPIP.
A12．Given the following information:
  
    Database server timezone is Atlantic Time
  Client timezone is Central European Time   
The following command is issued from the client:
       ROLLFORWARD DB MYDB TO 2003-10-03-15.13.01.000000 USING LOCAL TIME
Which time is used on the rollforward command?

A)        Atlantic Time  
B)        Central European Time  
C)        UTC time on the client  
D)        UTC time on the server  
B13．When creating an index, which of the following allows DB2 to attempt to maintain a

physical ordering of the table data?


A)        Use the PCTFREE parameter
B)        Designate as clustering index
C)        Specify that it is the PRIMARY KEY
D)        Use the ALLOW REVERSE SCANS parameter
C14．Given a table space creation statement that does not indicate the size of its

containers, which of the following table space types was created by DB2?

A)        DMS
B)        LOB
C)        SMS
D)        LARGE
E)        INDEX

A15．Given the following table definitions:  
       PC                           EMPLOYEES
       serial_num     INT           employee_num    INT NOT NULL PRIMARY KEY
       model_num      INT           employee_name   CHAR(20)
       owner_id       INT
and the query:
     SELECT employee_name, serial_num
     FROM employees, pc
     WHERE owner_id = employee_num
Creating an index on which of the following may speed up this query?

A)        OWNER_ID  

B)        SERIAL_NUM  

C)        EMPLOYEE_NUM  

D)        EMPLOYEE_NAME   
A16．Which of the following table space creation statements enables container space to be

allocated as required?



A)        CREATE REGULAR TABLESPACE ts1 MANAGED BY SYSTEM USING ('d:\contain3', 'g:\contain4')

B)        CREATE INCREMENTAL TABLESPACE ts1 MANAGED BY DATABASE USING (DEVICE '/dev/rdev11' 24000)

C)        CREATE REGULAR TABLESPACE ts1 MANAGED BY DATABASE USING (DEVICE '/dev/rdev23' 150000)
EXTENTSIZE 1

D)        CREATE LARGE TABLESPACE ts1 MANAGED BY SYSTEM USING ('d:\contain1', 'g:\contain2')
EXTENTSIZE 1
C17．For messages written using the db2AdminMsgWrite API, the component listed in the

notification log will be which of the following?



A)        User Function

B)        Application ID

C)        User Application

D)        Admin Message API
D18．Given database configuration parameter:  
     AUTORESTART=OFF
     Transaction ABC was updating data at the time that the server crashed.
What will happen to the changes made by transaction ABC that had not committed at the time

the server crashed?

A)        At first connection attempt to the database, uncommitted changes made by transaction ABC
will be committed.  

B)        At first connection attempt to the database, uncommitted changes made by transaction ABC  will be rolled back.  

C)        When the administrator issues a RESTART DB command, uncommitted changes made by transaction  ABC will be committed.  

D)        When the administrator issues a RESTART DB command, uncommitted changes made by transaction  ABC will be rolled back.   
C19．Given an activated database, when does a database log file become inactive?



A)        When the log file is full

B)        When the log file is archived

C)        When the log file is no longer required for restart recovery

D)        When the log file is full and the next log file is being processed
D20．Which of the following operating systems CANNOT be used as a trusted client?



A)        AIX

B)        z/OS

C)        Linux

D)        Windows ME
C21．Which of the following can occur when a view is created on a DB2 table?



A)        Memory usage is reduced

B)        Data access time is increased

C)        Data access control is increased

D)        Query compilation time is reduced
B22．

A non-administrative user has successfully connected to the database.  At what level are the

privileges defined that control the access this user has to the data?



A)        The DB2 instance level

B)        The database object level

C)        The operating system level

D)        The database directory level
C23．Which of the following can be used to move a DB2 database from Windows 2000 to Linux?



A)        BACKUP the database on Windows 2000 and RESTORE it on Linux.

B)        Copy the files that make up all user table spaces from Windows 2000 to Linux.

C)        Use DB2MOVE to automate exporting the tables on Windows 2000 and loading them on Linux.

D)        Use DB2LOOK with the -e option to capture the DDL and data for each table in a format that  can be imported to DB2 on Linux.
B24．Given database configuration parameters of:
  
    LOGRETAIN=NO
  USEREXIT=NO   
Which of the following commands is valid?

A)        BACKUP DB MYDB ONLINE TO /backups  

B)        RESTORE DB MYDB FROM /backups REDIRECT  

C)        BACKUP DB MYDB TABLESPACE (MYTS) TO /backups  

D)        RESTORE DB MYDB TABLESPACE (MYTS) FROM /backups   
A25．Given a database named MYDB that contains table space MYTS.  An offline database backup

of database MYDB was started at 1am and completed at 3am.

Which of the following commands will restore from the offline backup and allow users to

successfully connect to the database MYDB after the restore completes?



A)        RESTORE DB mydb FROM /backups

B)        RESTORE DB mydb ONLINE FROM /backups

C)        RESTORE DB mydb FROM /backups AND STOP

D)        RESTORE DB mydb TABLESPACE (MYTS) FROM /backups WITHOUT ROLLING FORWARD
CD26．Which two of the following steps are required on the DB2 server to allow remote client

access using TCP/IP?



A)        Catalog the client workstation

B)        Create a DB2 instance for TCP/IP

C)        Set the DB2COMM registry variable

D)        Update the database manager configuration

Update the database configuration for each database
B27．Which of the following configuration parameter settings will allow online table space

backups?



A)        LOGPRIMARY=ONLINE  USEREXIT=NO

B)        LOGRETAIN=RECOVERY  USEREXIT=NO

C)        DB_RECOVERY=NO  TBSP_RECOVERY=YES

D)        ONLINE_RECOVERY=YES  TBSP_RECOVERY=YES
BE28．Given the dynamic SQL statement:  
SELECT * FROM t1 WHERE customer = ?
Which two of the following tools can be used to examine the explain results for this

statement?

A)        dynexpln  

B)        db2exfmt  

C)        db2expln  

D)        Design Advisor  

E)        Visual Explain   
A29．Which of the following DB2 utilities provides the fastest method of adding large amounts

of data to a table?



A)        Load

B)        Import

C)        Fastload

D)        Replication
D30．Which of the following may result in a table queue in an access plan?



A)        Hash join

B)        Sort operation

C)        Nested loop join

D)        Intra-partition parallelism
D31．Which of the following tasks can the LOAD utility perform?



A)        Creating the table

B)        Reclustering the rows

C)        Altering table structure

D)        Collecting table statistics
D32．Which of the following authority levels can force users off the system?



A)        DBADM

B)        DBCTRL

C)        DBMAINT

D)        SYSCTRL

E)        SYSMAINT
AB33．Health Monitor alerts will be sent to which two of the following locations?



A)        Journal

B)        Health Center

C)        Visual Explain

D)        Command Center

E)        Recovery History File
D34．Given the following output from workstation WORK1:  
List node directory:
  
  Node name                     = REMOTEDB
  Directory entry type          = LOCAL
  Protocol                      = TCPIP
  Hostname                      = host1.ibm.com
  
  List database directory:
  
  Database alias                = RSAMP
  Database name                 = SAMPLE
  Node name                     = REMOTEDB
  Directory entry type          = Remote
  
Which of the following will backup the database SAMPLE from workstation WORK1?

A)        BACKUP DATABASE remote REMOTE remotedb  

B)        ATTACH TO rsamp; BACKUP DATABASE sample  

C)        CONNECT TO sample; BACKUP DATABASE sample  

D)        ATTACH TO remotedb; BACKUP DATABASE sample   
AD35．To see the DDL needed to create objects in an existing database you can do which two of

the following?



A)        Use the db2look utility.

B)        Run SELECT * FROM SYSCAT.TABLES.

C)        Click on Show DDL in Visual Explain

D)        Click on Generate DDL in the Control Center.

E)        Click on the Catalogs tab in the Control Center.

A36．In which of the following are the definitions of the tables stored in a DB2 database?

A)        The system catalogs

B)        The DB2DIAG.LOG file

C)        The recovery history file

D)        The database configuration
A37．Given the following table definition:
CREATE TABLE class_list
  (studentId INTEGER,
   grade INTEGER CONSTRAINT grade# CHECK (grade <= 100) NOT ENFORCED)   
and the following contents of the CLASS_LIST table:
STUDENTID                GRADE
-----------------  -----------
               98          100   
              123          123   
              101           98
How many records will be retrieved by the following statement? SELECT * FROM class_list WHERE grade = 123?  

A)        0

B)        1

C)        2

D)        3   
B38．Given the following  command:   
  BACKUP DATABASE sample TO e: WITH 5 BUFFERS
Which of the following is the size of the buffer used during the backup?

A)        5 4K pages  

B)        1024 4K pages  

C)        The value of DB2_BACKUPSZ registry variable  

D)        The value of BUFFPAGES Database configuration parameter   
A39．To store regular table data in one table space and index data in another table space, which of the following can be used?



A)        Two DMS tablespaces using files

B)        Two SMS tablespaces using files

C)        Two SMS tablespaces using directories

D)        Two DMS tablespaces using directories

CE40．Which two of the following can collect statistics about tables or indexes?



A)        REORG

B)        ANALYZE

C)        RUNSTATS

D)        ALTER TABLE

E)        CREATE INDEX
D41．Which of the following actions is required before forcing a user off of a remote database?



A)        Catalog the remote database

B)        Quiesce the remote database

C)        Connect to the remote database

D)        Attach to the remote DB2 instance

E)        Update DB2INSTANCE environment variable

A42．Which of the following can add data to a table with a primary key defined and have all rows which violate the primary key constraint stored in an exception table?



A)        LOAD

B)        INSERT

C)        UPDATE

D)        IMPORT
B43．Given the following Advisor command:
  
  db2advis -d sample -F db2advis.in -L 30 -T 20   
Which of the following specifies the maximum space to be used for all recommended objects in the existing schema?

A)        20 MB  

B)        30 MB  

C)        20 GB  

D)        30 GB  

E)        Unlimited   

Given the following tables:  
               TEST_TAKEN
       ----------
       TestName               CHAR(50) NOT NULL
       TestNumber             INTEGER NOT NULL
       TestScore              INTEGER NOT NULL
       CandidateID            INTEGER NOT NULL

       CANDIDATE_DB2
       ------------
       CandidateName          CHAR(20) NOT NULL
       CandidateID            INTEGER NOT NULL
       Address                CHAR(100) NOT NULL
       CandidatePhoto         BLOB(1M)
And the following information:     
•        Candidate IDs are unique in the CANDIDATE_DB2 table      
•        A query which returns all addresses of individuals who have taken a DB2 test     
D44．Which of the following indexes will result in the minimum number of page reads?

A)        A unique index on test_taken (CandidateID, TestNumber)  

B)        A unique clustered index on candidate_db2 (Candidate ID, CandidateName)  

C)        A unique clustered index on test_taken (CandidateName) including (Address)  

D)        A unique index on candidate_db2 (CandidateID, CandidateName) including (Address)   
C45．In trying to backup database SAMPLE, the following message is received:  
  SQL1035N  The database is currently in use.  SQLSTATE=57019
Which of the following should be done to attempt to get the backup to complete successfully?

A)        Stop the instance  

B)        Reset the connection  

C)        Quiesce the database  

D)        Reissue command with the OFFLINE option   
B46．Given the table definitions:  
  CREATE TABLE employees  
  (employee_num INT NOT NULL PRIMARY KEY,
   employee_name    CHAR(20));

  CREATE TABLE inventory
  (serial_num INT NOT NULL PRIMARY KEY,
   model_num INT NOT NULL,  
   owner_id INT,
  FOREIGN KEY (owner_id)
  REFERENCES employees ON DELETE SET NULL);
and the statement:
  DELETE FROM employees WHERE employee_num = 1000
What happens to all rows in the inventory table where OWNER_ID is 1000 ?

A)        They are deleted  

B)        The OWNER_ID is set to null  

C)        OWNER_ID is set to the default value  

D)        They are placed in an exception table   
B47．Which of the following will capture explain snapshots for an embedded static SQL application?  

A)        The EXPLAIN YES bind option  

B)        The EXPLSNAP YES bind option  

C)        The SET CURRENT EXPLAIN SNAPSHOT YES command  

D)        The SET CURRENT EXPLAIN SNAPSHOT EXPLAIN command  
C48．Given the following:   
A System has twenty 4GB disk devices for the database.   
Table is named mytab   
mytab row data portion 17GB     
mytab index portion 23GB     
Two table spaces exist
      mydatats
      myindexts   
If the table was created as follows:
     CREATE TABLE mytab (...) IN mydatats INDEX IN myindexts
Given that containers cannot span devices, which of the following number of containers is sufficient to hold the expected amount of data for both rows and indexes?

A)        5  

B)        10  

C)        15  

D)        20