论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2005-06-26 23:04 |只看该作者 |倒序浏览

700考试真题-1
CE  1.  Which two of the following results from a successful ROLLBACK statement?
(Select 2)
A. The current unit of work is restarted.
B. Existing database connections are released.
C.  Locks held by the current unit of work are released.
D.  Tables in LOAD PENDING for the current unit of work are released.
E.  Changes made by the current unit of work since the last COMMIT points are undone.

？CD  2.  Which two of the following are enforced by the database to restrict specific values from being inserted into a column in a particular table?
A. Index.
B. Stored procedure.
C.  Referential constraint.
D.  A view with check option.
E.  External scalar function.

C  3.  Given the table T1 created by
  CREATE TABLE t1
(Id INTEGER NOT NULL GENERATES ALWAYS AS IDENTITY.
C1 CHAR (10) NOT NULL.
C2 CHAR (10)
  Which of the following INSERT statements will succeed?
A. INSERT INTO t1 VALUES(‘abc’, NULL)
B. INSERT INTO t1 VALUES(1, ‘abc’, NULL)
C.  INSERT INTO t1 (c1, c2) VALUES (‘abc’, NULL)
D.  INSERT INTO t1 (c1, c2) VALUES (NULL, ‘def’)

A  4.  Given the following DDL statements,
CREATE TABLE tab1 (a INT, b INT, c INT)
CREATE VIEW v1 AS SELECT a, b, c FROM tab1
WHERE a>;250 WITH CHECK OPTION
Which of the following INSERT statements will fail?
A.  INSERT INTO v1 VALUES (200, 2, 3)
B.  INSERT INTO v1 VALUES (300, 2, 3)
C.  INSERT INTO tab1 VALUES (350, 2, 3)
D.  INSERT INTO tab1 VALUES (250, 2, 3)

C  5.  Given the following column requirement:
Col1 Numeric Identifier –From 1 to 1000000
Col2 Job Code-Variable 1 to 2 characters long
Col3 Job Description –Variable, 1 to 100 characters long
Col4 Job Length –Length of Job in seconds
Which of the following will minimize the disk space allocated to store the records if Job Description has an average length of 65?
A. CREATE TABLE tab1(col1 INT,col2 CHAR(2),col3 CHAR(100),col4 INT)
B. CREATE TABLE tab1(col1 INT ,col2 VARCHAR(2),col3 CHAR(100),col4 INT)
C.  CREATE TABLE tab1 (col1 INT, col2 CHAR (2), col3 VARCHAR (100), col4 INT)
D.  CREATE TABLE tab1 (col1 INT, col2 VARCHAR (2).col3 VARCHAR (100).col4 INT)

A  6.  Which of the following DB2 data types is used to store 50 MB of binary data as a single value?
A.  BLOB(二进制大对象)
B.  CLOB(字符型大对象)
C.  DBCLOB
D.  GRAPHIC

B  7.  Given the following users and groups with no privileges on table t1:

GroupA          GroupB
----------          ---------
  user1             user4
  user2             user5
  user3
Which of the following commands gives all users in the above groups the ability to create a view on table t1?
A. GRANT SELECT ON TABLE t1 TO ALL
B.  GRANT SELECT ON TABLE t1 TO PUBLIC
C.  GRANT REFEREFCES ON TABLE t1 TO ALL
D.  GRANT SELECT ON TABLE t1 TO USER GroupA.GroupB

B  8.  Given the following existing user defined functions:
  GEN.FN1(INT,CHAR) RETURNS CHAR
  GEN.FN1(INT) RETURNS INT
  GEN.FN1(CHAR) RETURNS DOUBLE
USERA need to execute GEN.FN1 (INT, CHAR) RETURNS CHAR.
Which of the following statements successfully grants the require privilege?
A. GRANT EXECUTE ON FUNCTION gen.fn1TO usera
B.  GRANT EXECUTE ON FUNCTION gen.fn1 (INT, CHAR) TO usera
C.  GRANT EXECUTE ON FUNCTION gen.fn1 RETURNS CHAR TO usera
D.  GRANT EXECUTE ON FUNCTION gen.fn1 (INT, CHAR) RETURNS CHAR TO usera

C  9.  An administrator issues:
GRANT ALL PRIVILEGES ON TABLE appl.tab1 TO user1 WITH GRANT OPTION
Which of the following statements is USER1 authorized to execute?
A. GRANT DROP ON TABLE appl.tab1 TO user8
B. GRANT OWNER ON TABLE appl.tab1 TO user8
C.  GRANT INSERT ON TABLE appl.tab1 TO user8
D.  GRANT CONTROL ON TABLE appl.tab1 TO user8

C  10.  Given the following table definition:
STAFF
Id  INTEGER
Name CHAR(20)
Dept INTEGER
Job CHAR(20)
Years INTEGER
Salary DECINAL(10,2)
Comm. DECINAL(10,2)
Which of the following statements will return all of the records by job with the salaries in descending order?
A. SELECT*FROM staff ORDER BY salary DESC.job
B. SELECT*FROM staff GROUP BY salary DESC.job
C.  SELECT*FROM staff ORDER BY job。salary DESC
D.  SELECT*FROM staff GROUP BY job.salary DESC

B  11.  Given tables that are defined in the following way
  Table1
   Col1 INT
   Col2 CHAR (30)
  Table2
   Col1 INT
   Col2 CHAR (30)
Which of the following statements will insert all the rows in TABLE2 into TABLE1?
A. INSERT INTO table1(table2.col1,table2.col2)
B. INSERT INTO table1SELECT col1, col2 FROM table2
C. INSERT INTO table1 VALUES(SELECT col1,col2FROM table2)
D.  INSERT INTO table1 (col1, col2) VALUES (SELECT col1, col2 FROM table2)

D  12.  Given the following two tables
  TAB1                         TAB2
C1 C2                      CX CY
---- -----                   ------ -----
A    11                      A    21
B    12                      C    22
C    13                      D    23

The following results are desired:
C1 C2 CX    CY
----- ----- ---- -----
A    11    A    21
C    13    C    22
--    --    D    23
Which of the following joins will yield the desired results?
A. SELECT*FROM tab1 INNER JOIN tab2 ON c1=cx
B. SELECT*FROM tab2 FULL OUTER JOIN tab1 ON c1=cx
C. SELECT*FROM tab2 RIGHT OUTER JOIN tab1 ON c1=cx//左连接
D.  SELECT*FROM tab1 RIGHT OUTER JOIN tab2 ON c1=cx

？C  13.  What does the following statement do?
GRANT REFERENCES (col1) ON TABLE tt1TO user7
A. Gives USER7 the ability to refer to column COL1of table T.T1 in views or select statements
B. Gives USER7 the ability to refer to column COL1of table T.T1 on user-defined function calls
C.  Gives USER7 the ability to define referential integrity on table T.T1 using column COL1 as the parent key
D.  Gives USER7 the ability to define referential integrity on table T.T1 using column COL1 as the foreign key

D  14.  A developer is building a Solaris application that will access DB2 UDB for OS/390 or OS/400 servers.
Which of the following products is required to be installed on the Solaris system in order to build the application?
A. DB2Connect Personal Edition
B. DB2 Personal Developers Edition
C. DB2 UDB Workgroup Server Edition
D. DB2 Universal Developer’s Edition

A  15.  For which of the following database objects can locks be obtained?
A.  A row
B.  A column
C.  A sequence
D.  A function

D  16.  Where are referential constraint definitions stored?
A. The user tables
B. The explain tables
C. SYSIBM SYSTRIGGERS
D. The system catalog tables

DE  17.  When establishing client-server communication, which two of the following can be used to verify passwords?
A. Catalog Tables
B. Access Control List
C. Application Programs
D.  DRDA Application Server
E.  Client Operating System

B  18.  A client application on OS/390 or OS/400 must access a DB2 server on Windows at a minimum, which of the following products is required to be on the DB2 server?
A.  DB2 Connect Enterprise Edition
B.  DB2 UDB Workgroup Server Edition
C.  DB2 Personal Edition
D.  DB2 Connect Enterprise Edition andDB2 UDB Enterprise Server Edition

C  19.  Given the following SQL statement:
GRANT INDEX, REFERENCES (col1) ON TABLE tab1 TO USER usera
Which of the following identifies what USERA is allowed to do?
A. Add a check constraint to TAB1.
B. Define a primary key and unique constraint on TAB1.
C.  Define an index on TAB1 and a foreign key that points to COL1.
D.  Issue a SELECT statement that uses an index to access data from TAB1.

D  20.  Given the following statements:
CREATE TABLE t1
(C1 INTEGER,
C2 INTEGER,
C3 DECIMAL (15, 0))
INSERT INTO t1 VALUES (0, 1, 3.0)
Which of the following will cause C1 to be incremented each time a row is added to the T2 table?
A. ALTER TABLE t1
   ADD CHECK (t2)
   C1=c1+1
B. CREATE VIEW v1 (c1)
      AS (SELECT COUNT(*) FROM t2)
C.  ALTER TABLE t1
   ADD FOREIGN KEY (C1)
   REFERENCES t2
   ON INSERT CASCADE
D.  CREATE TRIGGER t1
AFTER INSERT ON t2
FOR EACH ROW MODE DB2SQL
UPDATE t1 SET c1=c1+1

？C 21.  Given the following statements:
CREATE TABLE t1 (col1 INT NOT NULL);
ALTER TABLE t1 ADD CONSTRAINT t1_ck CHECK (coll in (1, 2, 3));
INSERT INTO t1 VALUES (3);
CREATE TABLE t2 LIKE t1;
DROP TABLE t1;
Which of the following is the result of these statements?
A. Both tables are dropped
B. T2 is an empty table with the check constraint.
C.  T2 is an empty table without the check constraint.
D.  T2 contains 1 row and is defined with the check constraint.
E.  T2 contains 1 row a.nd is defined without the check constraint

A 22.  Given the following table definitions:
  DEPARTMENT
Deptno    CHAR (3)
Deptname CHAR (30)
Mgrno    INTEGER
Admrdept CHAR (3)
   EMPLOYEE
      Empno    INTEGER
      Firstname CHAR (30)
      Midinit    CHAR (30)
      Lastname    CHAR (30)
      Workdept    CHAR (3)
Given that the result set should only include employees with a department, which of the following statements will list each employee’s number, last name, and deptname?
A.  SELECT e.empno, e.lastname, d.deptname
FROM employe e department d
WHERE e.workdept=d.deptno
B.  SELECT e.empno, e.lastname, d.deptname
FROM employee e LEFT OUTER JOIN deptnament d
ON e.workdept=d.deptno

C.  SELECT e.empno, e.lastname, d.deptname
FROM employee e FULL OUTER JOIN deptnament d
ON e.workdept=d.deptno
D.  SELECT e.empno, e.lastname, d.deptname
FROM employee e RIGHT OUTER JOIN department d
WHERE e.workdept=d.deptno

C 23.  Given the following statements:
  CREATE TABLE mytab
(col1 INT NOT NULL PRIMARY KEY
col2 CHAR (64),
col3 CHAR (32),
col4 INT NOT NULL,
CONSTRAIT c4 UNIQUE (col4, col1))
How many indexes are needed to support the table definition?
A.  0
B.  1
C.  2
D.  3
E.  4

？A 24.  Which of the following is the outcome of the following SQL statements?
CREATE TABLE employee (empno INT empname CHAR (30))
CREATE UNIQUE INDEX empno_ind ON employee (empno)
A.  Every value for EMPNO will be different.
B.  Multiple NULLvalue are allowed in the EMPNO column.
C.  An additional unique index cannot be created on the EMPLOYEE table.
D.  INSERT statements on the EMPLOYEE table will result in clustered data.

B  25.  Given the following tables:
TABLEA                            TABLEAB
Empid    name                   empid    weeknumber paycheck
1       USER1                   1          1          2000.00
2       USER2                   1          2       3000.00
                                 2          1          2000.00

TABLEB was defined as follows:
  CREATE TABLE tablea | empid CHAR (3),
                  Weeknumber CHAR (3),
                  Paycheck DECIMAL (6, 2|,
   CONSTRAINT const1 FOREIGN KEY (empid)
   REFERENCES tablea | empid) ON DELETE CASCADE)
How many rows would be deleted from TABLEB if the following command was issued?
DELETE FROM tablea WHERE empid=’2’
A.  0
B.  1
C.  2
D.  3

B 26.  At a minimum, which of the following products must be installed to provide a single point of control through?
The Control Center for local and remote DB2 data sources?
A. DB2 Runtime Client
B.  DB2 Administration Client
C.  DB2 Enterprise Server Edition
D.  DB2 Connect Enterprise Edition

D 27.  Which of the following deletion rules on CREATE TABLE will prevent parent table rows from being deleted if a dependent row exists?
A.  ON DELETE CASCADE
B.  ON DELETE ROLLBACK
C.  ON DELETE SET NULL
D.  ON DELETE NO ACTION

D 28.  Given the following statements from two embedded SQL programs:
Program 1:
CREATE TABLE mytab (col1 INT, col2 CHAR (24))
COMMIT
Program 2:
INSERT INTO mytab VALUES (20989,’JOE Smith’)
INSERT INTO mytab VALUES (21334,’Amy Johnson’)
COMMIT
DELETE FROM mytab
ROLLBACK
INSERT INTO mytab VALUES (23430,’Jason French’)
ROLLBACK
INSERT INTO mytab VALUES (20993,’Samantha Jones’)
COMMIT
DELETE FROM mytab WHERE col1=20993
ROLLBACK

Assuming Program 1 ran to completion and then Program 2 ran to completion, how many records will be returned by executing the following statement?
SELECT*FROM mytab
A.  0
B.  1
C.  2
D.  3
E.  4

D 29.  Which of the following tools is used to develop and deploy stored procedures?
A.  Task Center
B.  Control Center
C.  Command Center
D.  Development Center

B 30.  Given the two following tables
POINTS
Name                            Point
Wayne gretzky                   244
Jaromit Jagr                      168
Bobby Occ                      129
Bobby Hull                         93
Brett Hull                         121
Mario Lemieux                      189

PIM
Name                            PIN
Mats Sundin                      14
Jaromit Jagr                         16
Bobby Orr                         12
Mark Messier                      32
Brett Hull                         66
Mario Lemieux                      23
Joe Sakic                         94
Which of the following statements will display the name, points and PIM for players in either table?
A.  SELECT points .name, points points, pim.name .pim.pim
  FROM points INNER JOIN pim ON points .name=pim.name
B.  SELECT points .name, points point, pim.name .pim.pin
  FROM points FULL OUTER JOIN pim ON points .name=pim.name
C. SELECT points .name,points points ,pim.name .pim.pim
FROM points LEFT OUTER JOIN pim ON points .name=pim.name
D.  SELECT points .name,points points, pim.name .pim.pim
  FROM points RIGHT OUTER JOIN pim ON points .name=pim.name

D  31.  Given table T1 with 100 rows, which of the following queries will retrieve 10 rows from table T1?
A. SELECT*FROM t1 MAXIMUM 10 ROWS
B. SELECT*FROM t1 TOP 10 ROWS ONLY
C. SELECT *FROM t1 OPTIMIZE FOR 10 ROWS
D.  SELECT*FROM t1 FETCH FIRST 10 ROWS ONLY

A 32.  Communications is being manually established from a Windows 2000 client through a DB2
Connect gateway to a DB2 host system.
Which or the following does NOT have to be cataloged on the gateway?
A.  The client //客户端不需要被编目
B.  The node where the data source resides
C.  The data source on the DB2 database server
D.  The Database Connection Service (DCS) database

B  33.  Given the following CREATE TABLE statement:
CREATE TABLE t1
(col1 INTEGER NOT NULL CONSTRAINT chk1 UNIQUE,
col2 DATE NOT NULL CHECK (col2<=CURRENT_DATE),
col3 CHARACTER(12

NOT NULL WITH DEFAULT USER,
col4 VARCHAR(300) NOT NULL WITH DEFAULT)
.The definition of which column caused the statement to fail?
A. COL1
B.  COL2
C.  COL3
D.  COL4

B 34.  Which of the following isolation levels most frequently acquires a table level lock during an index scan?
A.  Read Stability
B.  Repeatable Read
C.  Cursor Stability
D.  Uncommitted Read

?D 35.  A stored procedure has been created with the following statement
CREATE PROCEDURE P1 (IN VAR1 VARCHAR (10), INOUT VAR2 VARCHAR (10), OUT VAR3
INT)
From the command line processor (CLP). Which is the correct way to call this procedure?
A. Call P1 (?,?,?)
B.  Call P1 (“DB2”,?,?)
C.  Call P1(“DB2”,”DB2”,?)
D.  Call P1(‘DB2’,’DB2’,?)//参数用单引号

C 36.  Which of the following products can be used to perform a dictionary-based search?
A. DB2 XML Extender //提供用XML定义的文本的查找
B. B.DB2 AVI Extender
C.  DB2 Text Extender //文本扩展器
D.  DB2 Spatial Extender//存储多维的信息

A 37.  Given the table:
COUNTRY
NAME       CITIES       PERSON
Argentina       10             1
Canada          20             2
Cuba             10             2
Germany          0             1
France          5             7
And, given the statement
SELECT cities, name FROM country
Which of the following clauses must be added to the statement for it to return rows sorted by NAME and the sorted by CITIES?
A.  ORDER BY 2, 1
B.  GROUP BY 2, 1
C.  ORDER BY 1, 2
D.  GROUP BY 1, 2

A 38.  An application is bound with uncommitted read isolation level it issues a request that retrieves 20 rows out of 200000 in the table, which of the following describes the rows that are locked as a result of this request?

A.  None of the rows are locked
B.  The retrieved rows are locked
C.  The last row of the result set is locked
D.  The rows not previously updated by another application are locked

A 39.  A user wishes to store a numeric with a maximum value of 100,000 which data type will allow the user to store these values while using the least amount of storage?
A.  BIGINT
B.  INTEGER
C.  IDENTITY
D.  SMALLINT

BC 40. Which two of the following can be done using the ALTER TABLE statement?

A.  define a trigger
B.  define a primary key
C.  add a check constraint
D.  add a non-unique index
E.  change a column’s name

D 41.  Given the following information:
Create table tab4 (c1 char(4), c2 integer)
Insert into tab4 values (‘123’,345)
Update tab4 set (c1,c2)=(‘null’,0)
What will be the result of the following statement if issued in the Command Line Processor?
Select *from tab4

A.  c1 c2
--- ------
- 0
1 record (s) selected
B. C1 C2
----- -------
123 345
1 record (s) selected
C. C1 C2
----- -------
123 0
1 record (s) selected
D. C1 C2
----- -------
null 0
1 record (s) selected

B 42. Given the following SQL Statements:’
Create table tab1 (col1 int )
Insert into tab1 values (null)
Insert into tab1 values (1)
Create table tab2 (col1 int)
Insert into tab2 values (null)
Insert into tab2 values (1)
Select count (*) from tab1
Where col1 in
Which of the following is the result of the SELECT COUNT (*)(select col1 from tab2)
Statement?
A. 0
B. 1
C. 2
D. null

C 43.  A user defined function named F.FOO has an input parameter of an integer. USER4 executes the following SQL statement:
SELECT col1.col2from t.tab1 where f.foo (col1) <6;
Which of the following statements grants USER4 the privilege needed to be able to execute the user defined function?
A.  GRANT USE ON FUNCTION F.FOO (INT) TO USER4
B.  GRANT SELECT ON FUNCTION F.FOO (INT) TO USER4
C.  GRANT EXECUTE ON FUNCTION F.FOO (INT) TO USER4
D.  GRANT REFERENCES ON FUNCTION F.FOO (INT) TO USER4

D 44.  Given the following:
create table tab1 (c1 char (3) with default null, c2 integer);
insert into tab1(c2) values (345)
What will be the result of the following statement if issued from the command line processor?
Select* from tab1;
A. C1 C2
   ----- -------
0 record (s) selected

B. C1 C2
   ----- -------
   123    345
1 record (s) selected
C. C1    C2
----- -------
345
1 record (s) selected
D. C1    C2
----- -------
      345
1 record (s) selected

A 45. Given the following:
A table contains a list of all seats on an airplane A seat consists of a seat number and whether or not it is assigned An airline agent lists all the unassigned seats on the plane .No one should be able to assign a seat that is in the agent’s current list .If the agent refreshes the list from the table .the list should only change if Which of the following isolation levels should be used for this application?
A.  Read stability
B.  Repeatable read
C.  Cursor stability
D.  Uncommitted read

CE 46. Given that table T1 has defined on it a primary key .three foreign keys ,four indexe,two check constraints three views and an alias . The following  CREATE  TABLE statement executed successfully
CREATE TABLE a1 LIKE TABLE t1
Which two of the following statements describe how table A1 is created?
A.  Check constraints on table T1 were copied to table A1.
B.  The primary key definition on table t1 was copied to table a1.
C.  None of the keys, indexes check constraints, views .or the alias was copied to table a1
D.  Indexes of the same descoption as those on table t1 were automatically created on table a1.
E.  Table a1 contains columns of the same name, data types and null characteristics as table T1

A 47.  To catalog a TCP/IP database connection to a remote DB2 server which of the following pieces of information is needed?
A.  hostname
B.  password
C.  authorization-id
D.  operating system version

A 48.  Given the table definitions
defin1:
id    smallint not null
name varchar(30)
hired date
defin2:
depitd smallint not null
name varchar(30)
started date
Assuming that neither table is empty, which of the following statements will insert data successfully into table defin1?
A.  insert into defin1 (id) values (1)
B.  insert into defin1 (name) values (‘Florence’)
C.  insert into defin1 (id.hired) as select distinct 1. current date from defin2
D.  insert into defin1 (name .hired ) select distinct ‘florennce’.current date from defin2

D 49.  Which of the following tools maintains a history of all executed statements/commands for the current session within the tool?
A.  Journal
B.  SQL assist
C.  Health Center
D.  Command Center

?D 50.  A unit of work is using an isolation level of Cursor stability, and allows scanning through the table more than once within the unit of work which of the following can occur during processing of this unit of work?
A.  it can access uncommitted changes made by other transactions
B.  it can update uncommitted changes made by other transactions
C.  the rows that is has updated can be changed by other transactions from one scan to the next
D.  the rows that it has accessed can be changed by other transactions from one scan to the next

?BE 51.  A view defined on a table for users to do which two of the following?
A.  Avoid allocating more disk space per database
B.  Restrict user’s access to a subset of the table data
C.  Produce an action as a result of a change to a table
D.  Provide faster access to the data than querying the table
E.  Ensure the rows remain within the scope of the definition

C 52. Which of the following tools is used to create and build stored procedures?
A.  SQL  Assist
B.  Task Center
C.  Development Center  //与存储过程（stored procedures）有关都选
D.  Replication Center

B 53.  An application is bound with Read Stability isolation level .It issues a request that retrieves 20 rows out of 200000 in the table, which of the following describes the rows that are locked as a result of this request?

A.  None of the rows are locked
B.  The retrieved rows are locked.
C.  The last row of the result set is locked
D.  The rows not previously updated by another application are locked

?CE 54.  Which two of the following types of storage management methods are supported by DB2 OLAP Server?

A.  Object
B.  Network
C.  Relational
D.  Hierarchical
D. Multi-dimensional

      700-2真题

C 1.  Which of the following tools can be used to identify inefficient(效率低的) SQL statements without executing them?
A. QMF
B. Task Center
C. Visual Explain//可视化解释器
D. Development Center

D 2. USERA needs to be able to read rows from TAB1 and add new rows to TAB1. Which of the following statements will give USERA only the needed privileges(特权)?
A. GRANT SELECT ON TABLE tab1 TO usera
B. GRANT SELECT, ALTER ON TABLE tab1 TO usera
C. GRANT ALL PRIVILEGES ON TABLE tab1 TO usera
D. GRANT SELECT, INSERT ON TABLE tab1 TO usera

?B 3. Given the statement:
CREATE TABLE t1
      (C1 CHAR (3)
         CONSTRAINT c1
         CHECK (c1 IN ('A01','B01','C01'))
         )
DB2 verifies that the table checks constraint is met during which of the following actions?
A. Reorganizing the table.
B. Updating any row in the table.
C. Adding an insert trigger to the table.
D. Creating a unique index for the table.

B 4.  Given the following:
A table contains a list of all seats on an airplane. A seat consists of a seat number and whether or not it is assigned. An airline agent lists all the unassigned seats on the plane. When the agent refreshes the list from the table, the list should not change.
Which of the following isolation levels should be used for this application?
A. Read Stability
B. Repeatable Read
C. Cursor Stability
D. Uncommitted Read

A 5. Given the following information:
  CREATE TABLE tab1 (c1 CHAR (4), c2 INTEGER)
  INSERT INTO tab1 VALUES ('123', 345)
  UPDATE tab1 SET (c1, c2) = (NULL, 0)
What will be the result of the following statement if issued in the Command Line Processor?
  SELECT * FROM tab1;

A. C1 C2 ---- ------------ 0 1 record(s) selected.
B. C1 C2 ---- ----------- 123 345 1 record(s) selected.
C. C1 C2 ---- ----------- NULL 0 1 record(s) selected.
D. C1 C2 ---- ----------- 123 0 1 record(s) selected.

A 6.  Given table EMPLOYEE with columns EMPNO and SALARY, and table JOB with columns ID and TITLE, what is the effect of the following statement?
UPDATE employee SET salary = salary * 1.15
  WHERE salary < 15000 OR
  EXISTS (SELECT 1 FROM job WHERE job.id = employee.empno AND job.title = 'MANAGER')
A. Employees who make less than 15,000 and all managers are given salary increases.
B. Only employees who are managers that make less than 15,000 are given salary increases.
C. Employees who are not managers and who make less than 15,000 are given salary increases.
D. Only employees who are not managers or make less than 15,000 are given salary increases

B 7.  Which of the following occurs if an application ends abnormally during an active unit of work?
A. The unit of work is committed
B. The unit of work is rolled back
C. The unit of work remains active
D. The unit of work moves to pending state

D 8. Which of the following is used to build and manage a heterogeneous Data Warehouse environment?
A. Data Joiner
B. Control Center
C. Workload Manager
D. DB2 Warehouse Manager

B 9.  A unit of work is using an isolation level of Read Stability. An entire table is scanned twice within the unit of work.
Which of the following can be seen on the second scan of the table?
cs A. Rows removed by other processes
rs B. Rows added to a result set by other processes
cs C. Rows changed in a result set by other processes
Ur D. Rows with uncommitted changes made by other processes

A 10.  Given the tables:
  TABLEA                TABLEB
  empid name          empid  weeknumber  paycheck
  1    USER1          1    1          1000.00
  2    USER2          1    2          1000.00
                        2    1          2000.00
  TABLEB was defined as follows:
CREATE TABLE tableb (empid CHAR (3),
                     weeknumber CHAR (3),
                     paycheck DECIMAL (6, 2),
   CONSTRAINT const1 FOREIGN KEY (empid)
   REFERENCES tablea (empid) ON DELETE RESTRICT)
How many rows would be deleted from tableb if the following command was issued?
DELETE FROM tablea WHERE empid = '2'
A. 0
B. 1
C. 2
D. 3

C 11.  Given the SQL statement:
ALTER TABLE table1 ADD col2 INT WITH DEFAULT
Which of the following is the result of the statement?
A. The statement fails because no default value is specified.
B. A new column called COL2 is added to TABLE1 which would have a null value if selected.
  C. A new column called COL2 is added to TABLE1 which would have a value of zero if selected.
  D. A new column called COL2 is added to TABLE1 which would require the default value to be set before working with the table.

A 12.  Assuming the proper privileges, which two of the following would allow access to data in a table T1 using the name A1?
(Select 2)
A. CREATE ALIAS a1 FOR t1
  B. CREATE TABLE a1 LIKE t1
  C. CREATE INDEX a1 ON t1 (col1)
  D. CREATE VIEW a1 AS SELECT * FROM t1
  E. CREATE TRIGGER trig1 AFTER INSERT ON t1 FOR EACH ROW MODE DB2SQL INSERT INTO a1

C 13.  Which of the following will grant just DML operations on table T.T4 to all users?
A. GRANT ALL PRIVILEGES ON t.t4 TO PUBLIC
B. GRANT ALL PRIVILEGES ON t.t4 TO ALL USERS
C. GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE t.t4 to PUBLIC
D. GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE t.t4 TO ALL USERS

C 14.  Which type of key is defined on the dependent table to implement referential constraints?
A. Unique key
B. Primary key
C. Foreign key
D. Composite key

D 15.  Given a user defined function, U.UDF1, that takes an input parameter of type INTEGER, and USER6 running the following SQL statement:
SELECT w.udf1 (col6) FROM t.tab1 WHERE col4 = 'ABC'
Which of the following statement(s) would allow USER6 to execute the statement?
A. GRANT ALL PRIVILEGES ON TABLE t.tab1 TO user6
B. GRANT SELECT ON TABLE t.tab1 TO user6
GRANT USE ON FUNCTION u.udf1 (INT) TO user6
C. GRANT SELECT ON TABLE t.tab1 TO user6
GRANT REFERENCES ON FUNCTION u.udf1 (INT) TO user6
D. GRANT ALL PRIVILEGES ON TABLE t.tab1 TO user6
GRANT EXECUTE ON FUNCTION u.udf1 (INT) TO user6

C 16.  Given these columns from the DEPARTMENT table:
deptno CHAR(3)  NOT NULL
deptname CHAR(20) NOT NULL
mgrno CHAR(6)
admrdept CHAR(3)
location CHAR(20) NOT NULL
Which of the following will select the rows that do not have a value in the MGRNO column?

A. SELECT * FROM department WHERE mgrno = ' '
B. SELECT * FROM department WHERE mgrno = NULL
C. SELECT * FROM department WHERE mgrno IS NULL
D. SELECT * FROM department WHERE mgrno IS UNKNOWN

D 17.  Given the following SQL statement:
GRANT REFERENCES ON TABLE tab1 TO USER usera
Which of the following describes what USERA is allowed to do?
A. Create a read-only view using TAB1.
B. Alter TAB1 to add a check constraint.
C. Define a primary key or unique constraint on TAB1.
D. Define a dependent table where TAB1 is the parent.

A    18.  Given the following DDL statement:
CREATE TABLE newtab1 LIKE tab1
Which of the following would occur as a result of the statement execution?
A. NEWTAB1 would have the same column names and attributes as TAB1
B. NEWTAB1 would have the same column names, attributes, and data as TAB1
C. NEWTAB1 would have the same column names, attributes, indexes, and constraints as TAB1
D. NEWTAB1 would have the same column names, attributes, and referential integrity as TAB1

C 19. Which of the following tools is used to create subscription sets and add subscription-set members to subscription sets?
A. Journal
B. License Center
C. Replication Center
D. Development Center

B    20.  Table T1 should only allow values of 1, 2, and 3 in column C1. Which of the following will cause the database manager to enforce this business requirement?
A. Delete trigger on T1
B. Check constraint on C1
C. Table level lock on T1
D. Update permission on C1

DE 21.  Which two of the following can be done using the ALTER TABLE statement?
(Select 2)
A. Add a trigger.
B. Define an index.
C. Drop a table alias.
D. Add an INTEGER column.
E. Define a unique constraint.

D 22.  Given the following statements from two embedded SQL programs:
  Program 1:
  CREATE TABLE mytab (col1 INT, col2 CHAR(24))
  COMMIT
  Program 2:
  INSERT INTO mytab VALUES( 20989,'Joe Smith')
  COMMIT
  INSERT INTO mytab VALUES( 21334,'Amy Johnson')
  DELETE FROM mytab
  COMMIT
  INSERT INTO mytab VALUES( 23430,'Jason French')
  ROLLBACK
  INSERT INTO mytab VALUES( 20993,'Samantha Jones')
  COMMIT
  DELETE FROM mytab WHERE col1=20993
  ROLLBACK
Assuming Program 1 ran to completion and then Program 2 ran to completion, which of the following records would be returned by the statement:
SELECT * FROM mytab?
A. 20989, Joe Smith
B. 21334, Amy Johnson
C. 23430, Jason French
D. 20993, Samantha Jones
E. No records are returned.

A 23.  Which of the following actions describes when SQL indexes can be explicitly referenced by name within an SQL statement?
  A. When dropping the index.
B. When altering the index.
  C. When selecting on the index.
D. When inserting using the index.

D 24.  Given the following two tables:
TAB1                         TAB2
C1    C2                      CX    CY
--- ----                   -----  ----
A    11                      A    21
B    12                      C    22
C    13                      D    23
The following results are desired:
C1    C2 CX    CY
---- ----  ---- ----
A    11 A    21
B    12 -    -
C    13 C    22
Which of the following joins will yield the desired results?
  A. SELECT * FROM tab2 LEFT OUTER JOIN tab1 ON c1=cx
  B. SELECT * FROM tab1 INNER JOIN tab2 ON c1=cx
  C. SELECT * FROM tab2 FULL OUTER JOIN tab1 ON c1=cx
  D. SELECT * FROM tab1 LEFT OUTER JOIN tab2 ON c1=cx

D 25.  Which of the following extenders allows data to be presented in a three-dimensional format?
  A. DB2 AVI Extender
B. DB2 XML Extender
  C. DB2 Text Extender
D. DB2 Spatial Extender

D 26.  Given the create statements:
CREATE DISTINCT TYPE kph AS INTEGER WITH COMPARISONS
CREATE DISTINCT TYPE mph AS INTEGER WITH COMPARISONS
CREATE TABLE speed_limits
(route_num SMALLINT,
canada_sl KPH NOT NULL,
us_sl       MPH NOT NULL)
Which of the following is a valid query?
  A. SELECT route_num FROM speed_limits WHERE canada_sl >; 80
  B. SELECT route_num FROM speed_limits WHERE canada_sl >; kph
  C. SELECT route_num FROM speed_limits WHERE canada_sl >; us_sl
  D. SELECT route_num FROM speed_limits WHERE canada_sl >; kph(80)

?D 27.  Given the following UPDATE statement:
UPDATE address2 SET house_building=
(SELECT building FROM address1
WHERE address2.id = address1.id)
WHERE house_building IS NULL
Which of the following describes the result of the statement?
A. The statement will succeed.
B. The statement will fail because a subquery cannot exist in an UPDATE statement.
C. The statement will succeed only if ADDRESS1.ID and ADDRESS2.ID are defined as primary keys.
D. The statement will succeed if the data retrieved from the subquery does not have duplicate values for ADDRESS1.ID.

C 28. A table called EMPLOYEE has the following columns:
  NAME
  DEPARTMENT
  PHONE_NUMBER
Which of the following will allow USER1 to modify the PHONE_NUMBER column?
A. GRANT INDEX (phone_number) ON TABLE employee TO user1
B. GRANT ALTER (phone_number) ON TABLE employee TO user1
C. GRANT UPDATE (phone_number) ON TABLE employee TO user1
D. GRANT REFERENCES (phone_number) ON TABLE employee TO user1

C 29.  A developer is building a Windows embedded SQL application that will access DB2 UDB for OS/390 or OS/400 servers. Which of the following products is required to be installed on the Windows system in order to build the application?
A. DB2 UDB Personal Edition
  B. DB2 Connect Personal Edition
  C. DB2 Personal Developer's Edition
  D. DB2 UDB Workgroup Server Edition

?C 30.  A database administrator has supplied the following information:
Protocol: TCP/IP
Port Number: 446
Host Name: ZEUS
Database Name: SAMPLE
Database Server Platform: OS/400
Which are the appropriate commands to set up the ability to connect to the database?
A. CATALOG TCPIP NODE zeus REMOTE zeus SERVER 446 OSTYPE os400 DATABASE sample;
B. CATALOG TCPIP DATABASE sample REMOTE zeus SERVER 446 OSTYPE os400;
CATALOG DATABASE dcssam AS sample AT NODE zeus AUTHENTICATION dcs;
C. CATALOG TCPIP NODE zeus REMOTE zeus SERVER 446 OSTYPE os400;
CATALOG DCS DB dcssam AS sample;
CATALOG DATABASE dcssam AS sample AT NODE zeus AUTHENTICATION dcs;
D. CATALOG TCPIP NODE sample REMOTE sample SERVER 446 OSTYPE os400;
CATALOG DCS DB sample AS dcssam;
CATALOG DATABASE dcssam AS sample AT NODE zeus AUTHENTICATION dcs;

B 31.  Given the two following table definitions:
ORG
   deptnumb    INTEGER
   deptname    CHAR(30)
   manager       INTEGER
   division    CHAR(30)
   location    CHAR(30)
STAFF
   id          INTEGER
   name          CHAR(30)
   dept          INTEGER
   job          CHAR(20)
   years       INTEGER
   salary       DECIMAL(10,2)
   comm          DECIMAL(10,2)
Which of the following statements will display each department, by name, and the total salary of all employees in the department?
A. SELECT a.deptname, SUM(b.salary)  FROM org a, staff b  WHERE a.deptnumb=b.dept  ORDER BY a.deptname
B. SELECT a.deptname, SUM(b.salary)  FROM org a, staff b  WHERE a.deptnumb=b.dept  GROUP BY a.deptname
C. SELECT a.deptname, SUM(b.salary)  FROM org a INNER JOIN staff b  ON a.deptnumb=b.dept  ORDER BY a.deptname
D. SELECT b.deptname, SUM(a.salary)  FROM org a INNER JOIN staff b  ON a.deptnumb=b.dept  GROUP BY a.deptname

？B 32.  A client application on OS/390 or OS/400 must access a DB2 server on AIX. At a minimum, which of the following products is required to provide DRDA Application Server functionality on the DB2 server?
A. DB2 Connect Enterprise Edition
B. DB2 UDB Workgroup Server Edition
C. DB2 Connect Enterprise Edition and DB2 UDB Workgroup Server Edition
D. DB2 Connect Enterprise Edition and DB2 UDB Enterprise Server Edition

A 33.  Given the following table definition:
STAFF
  id    INTEGER
  name      CHAR(20)
  dept      INTEGER
  job       CHAR(20)
  years INTEGER
  salary    DECIMAL(10,2)
  comm      DECIMAL(10,2)
Where the job column contains job types: manager, clerk, and salesperson.
Which of the following statements will return the data with all managers together, all clerks together, and all salespeople together in the output?
A. SELECT * FROM staff ORDER BY job
B. SELECT job, name FROM staff GROUP BY name, job
C. SELECT * FROM staff GROUP BY name, job, id, dept, years, salary, comm
D. SELECT * FROM staff ORDER BY name, job, id, dept, years, salary, comm

A 34.  Which of the following SQL statements can remove all rows from a table named COUNTRY?
A. DELETE FROM country
B. DELETE TABLE country
C. DELETE * FROM country
D. DELETE ALL FROM country

D 35.  USER3 has created table TAB1 and has no additional authorities.
Which of the following statements is USER3 authorized to execute?
A. GRANT LOAD ON TABLE tab1 TO user8
B. GRANT CONTROL ON TABLE tab1 TO user8
C. GRANT OWNERSHIP ON TABLE tab1 TO user8
D. GRANT ALL PRIVILEGES ON TABLE tab1 TO user8

AC 36.  Given the following table definitions:
  CREATE TABLE employee
(empid INT NOT NULL PRIMARY KEY,
emp_fname CHAR(30),
emp_lname CHAR(30)
)
  CREATE TABLE payroll
  (empid INTEGER,
weeknumber INTEGER,
paycheck DECIMAL(6,2),
CONSTRAINT fkconst FOREIGN KEY (empid)
REFERENCES employee (empid) ON DELETE SET NULL,
CONSTRAINT chk1
CHECK (paycheck>;0  AND weeknumber BETWEEN 1 and 52))
The appropriate indexes exist to support the tables created with the previous CREATE statements. Which two of the following operations can cause the enforcement of a constraint defined on PAYROLL?
(Select 2)
A. Update of a row in PAYROLL
B. Deletion of a row in PAYROLL
C. Deletion of a row in EMPLOYEE
D. Addition of a new column to PAYROLL
E. Rollback of a row deletion on PAYROLL

B 37.  When granted to USER1, which of the following will allow USER1 to ONLY access table data?
A. Administrative authority
B. SELECT privilege on the table
C. REFERENCES privilege on the table
D. SELECT privilege WITH GRANT OPTION on the table

C 38.  A stored procedure has been created with the following statement:
CREATE PROCEDURE P1(INOUT VAR1 VARCHAR(10))...
From the command line processor (CLP), which is the correct way to call this procedure?
A. Call P1 (?)
B. Call P1 (DB2)
C. Call P1 ('DB2')
D. Call P1 ("DB2"

BE 39.  Which two of the following SQL data types should be used to store a small binary image?
(Select 2)
A. CLOB
B. BLOB
C. VARCHAR
D. GRAPHIC
E. VARCHAR FOR BIT DATA

C 40.  USER1 indicates that when running the following command from their client:
DB2 CONNECT TO sample USER user1
They receive the following error message:
SQL1013N The database alias name or database name "SAMPLE" could not be found. SQLSTATE=42705
Assuming a valid password was entered when prompted, which of the following is the cause of the error?
  A. SAMPLE is not listening for incoming connections from clients.
  B. The DB2 client version is not compatible with the server version.
  C. The client's database directory does not contain an entry SAMPLE.
  D. The client's node directory has an entry in it that points at a non-existent server.

B 41.  Table T1 has a column C1 char(3) that contains strings in upper and lower case letters. Which of the following queries will find all rows where C1 is the string 'ABC' in any case?
A. SELECT * FROM t1 WHERE c1 = 'ABC'
B. SELECT * FROM t1 WHERE UCASE (c1) ' =ABC'
C. SELECT * FROM t1 WHERE IGNORE_CASE (c1 = 'ABC')
D. SELECT * FROM t1 WHERE c1 = 'ABC' WITH OPTION CASE INSENSITIVE

D 42. Assuming the database has no distinct types, which of the following is an invalid data type on CREATE TABLE?
A. CLOB
B. DOUBLE
C. NUMERIC
D. DATETIME

？A 43.  Given the two following tables:
  Tablename: NAMES
  Name                   Number
  Wayne Gretzky          99
  Jaromir Jagr       68
  Bobby Orr               4
  Bobby Hull             23
  Brett Hull             16
  Mario Lemieux          66
  Steve Yzerman          19
  Claude Lemieux         19
  Mark Messier       11
  Mats Sundin            13
  Tablename

OINTS
  Name                   Points
  Wayne Gretzky          244
  Jaromir Jagr       168
  Bobby Orr          129
  Bobby Hull          93
  Brett Hull             121
  Mario Lemieux          189
  Joe Sakic               94
Which of the following statements will display the player's name, number and points for all players with an entry in both tables?
  A. SELECT names.name, names.number, points.points
FROM names INNER JOIN points ON names.name=points.name
  B. SELECT names.name, names.number, points.points
FROM names FULL OUTER JOIN points ON names.name=points.name
  C. SELECT names.name, names.number, points.points
FROM names LEFT OUTER JOIN points ON names.name=points.name
  D. SELECT names.name, names.number, points.points
FROM names RIGHT OUTER JOIN points ON names.name=points.name

A 44.  Which of the following products is designed for analyzing data with more than two dimensions?
A. DB2 OLAP Server
B. DB2 Warehouse Manager
C. DB2 Relational Connect
D. DB2 Data Links Manager

B 45.  Given the following table definition:
STAFF
  id    INTEGER
  name    CHAR(20)
  dept    INTEGER
  job    CHAR(20)
  years INTEGER
  salary DECIMAL(10,2)
  comm    DECIMAL(10,2)
Which of the following SQL statements will return a result set that satisfies these conditions?
Displays the total number of employees in each department

Displays the corresponding department ID for each department

Includes only departments with at least one employee receiving a commission (comm) greater than 5000

Sorted by the department employee count from greatest to least
A. SELECT dept, COUNT(*) FROM staff GROUP BY dept HAVING comm >; 5000 ORDER BY 2 DESC
B. SELECT dept, COUNT(*) FROM staff
WHERE comm >; 5000
GROUP BY dept, comm
ORDER BY 2 DESC
C. SELECT dept, COUNT(*) FROM staffF GROUP BY dept HAVING MAX(comm) >; 5000 ORDER BY 2 DESC
D. SELECT dept, comm, COUNT(id) FROM staff WHERE comm >; 5000 GROUP BY dept, comm ORDER BY 3 DESC

B 46.  Which of the following DB2 data types CANNOT be used to contain the date an employee was hired?
A. CLOB
B. TIME
C. VARCHAR
D. TIMESTAMP

C 47.  Which of the following DB2 UDB isolation levels will lock no rows during read processing?
A. Read Stability
B. Repeatable Read
C. Uncommitted Read
D. Cursor Stability

C(D) 48.  Given that the following statements were executed in order:
  CREATE TABLE tab1 (c1 CHAR (1))
  INSERT INTO tab1 VALUES ('b')
  CREATE VIEW view1 AS SELECT c1 FROM tab1 WHERE c1 ='a'
  INSERT INTO view1 VALUES ('a')
  INSERT INTO view1 VALUES ('b')
How many rows would be returned from the following statement?
  SELECT c1 FROM tab1
A. 0
B. 1
C. 2 //理论上
D. 3 //答案有争议//做的实验

B 49.  Given the following SQL statements:
  CREATE TABLE birthday1
   (day INT CHECK(day BETWEEN 1 AND 31),
   month INT CHECK(month BETWEEN 1 AND 6),
   year INT)
  CREATE TABLE birthday2
   (day INT CHECK(day BETWEEN 1 AND 31),
   month INT CHECK(month BETWEEN 7 AND 12),
   year INT)
  CREATE VIEW birthdays AS
   SELECT * FROM birthday1
   UNION ALL //不删除重复行，若是UNION就删除重复行
   SELECT * FROM birthday2
  INSERT INTO birthday1 VALUES( 22,10, 1973)
  INSERT INTO birthday1 VALUES( 40, 8, 1980)
  INSERT INTO birthday1 VALUES( 8, 3, 1990)
  INSERT INTO birthday1 VALUES( 22, 10, 1973)
  INSERT INTO birthday1 VALUES( 3, 3, 1960)

What will be the result of the following SELECT statement?
  SELECT COUNT(*) FROM birthdays
A. 0
B. 2
C. 3
D. 5

A 50.  For which of the following database objects can locks be obtained?
A. Table（行和表可以被锁定）
B. Trigger
C. Column
D. User-defined Data Type

D 51.  Given the following statements:
  CREATE TABLE t1
  (c1 INTEGER,
c2 INTEGER,
c3 DECIMAL(15,0 ))
  INSERT INTO t1 VALUES (1, 2, 3.0)
Which of the following will cause C1 to be decremented each time a row is deleted from the T2 table?
A. ALTER TABLE t1    ADD CHECK(t2)    c1 = c1 - 1
B. CREATE VIEW v1 (c1)    AS (SELECT COUNT(*) FROM t2)
C. ALTER TABLE t1    ADD FOREIGN KEY (c1) REFERENCES t2 ON DELETE CASCADE
D. CREATE TRIGGER trig1    AFTER DELETE ON t2    FOR EACH ROW MODE DB2SQL    UPDATE t1 SET c1 = c1 – 1

C 52.  An embedded SQL application is bound with Cursor Stability isolation level. It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following describes the locks that are held as a result of this request?
A. None of the rows are locked.
B. The retrieved(检索)rows are locked.
C. The last row accessed is locked.
D. The rows not previously updated by another application are locked.

A 53.  An application bound with isolation level Uncommitted Read updates a row. Which of the following is true regarding row locking in this application?
  A. The application acquires no row locks.
  B. The row lock is released when the cursor accessing the row is closed.
  C. The row lock is released when the application issues a COMMIT statement.
  D. The row lock is released when the cursor accessing the row is moved to the next row.

A 54.  To set up a client that can access DB2 UDB through DB2 Connect Enterprise Edition, which of the following is the minimum software client that must be installed?
A. DB2 Runtime Client
B. DB2 Personal Edition
C. DB2 Administration Client
D. DB2 Application Development Client

700考试题_3
A 1 .  To set up a client that can access DB2 UDB through DB2 Connect Enterprise Edition, which of the following is the minimum software client that must be installed?
A. DB2 Runtime Client       B. DB2 Personal Edition
C. DB2 Administration Client D. DB2 Application Development Client

B  2.  A client application on OS/390 or OS/400 must access a DB2 server on AIX.  At a minimum, which of the following products is required to provide DRDA Application Server functionality on the DB2 server?
A. DB2 Connect Enterprise Edition
B.  DB2 UDB Workgroup Server Edition
C. DB2 Connect Enterprise Edition and DB2 UDB Workgroup Server Edition
D. DB2 Connect Enterprise Edition and DB2 UDB Enterprise Server Edition

C  3.  A developer is building a Windows embedded SQL application that will access DB2 UDB for OS/390 or OS/400 servers.  Which of the following products is required to be installed on the Windows system in order to build the application?
A. DB2 UDB Personal Edition       B. DB2 Connect Personal Edition
C. DB2 Personal Developer's Edition D. DB2 UDB Workgroup Server Edition

D  4. Which of the following tools maintains a history of all executed statements/commands for the current session within the tool?
A. Journal B. SQL Assist  C.Health Center  D. Command Center

A  5. Which of the following products is designed for analyzing data with more than two dimensions?
A. DB2 OLAP Server B.  DB2 Warehouse Manager
C. DB2 Relational Connect D. DB2 Data Links Manager

C  6. Which of the following tools is used to create and build stored procedures?
A. SQL Assist B. Task Center C. Development Center
D. Replication Center

C  7. Which of the following tools is used to create subscription sets and add subscription-set members to subscription sets?
A. Journal
B. License Center
C. Replication Center
D. Development Center

CE  8. Which two of the following types of storage management methods are supported by DB2 OLAP Server?
A. Object
B.  Network
C.  Relational
D. Hierachical
E. Multi-dimensional

D  9. Which of the following is used to build and manage a heterogeneous Data Warehouse environment?
A. DataJoiner
B.  Control Center
C. Workload Manager
D. DB2 Warehouse Manager

C  10. Which of the following products can be used to perform a dictionary-based search?
A. DB2 XML Extender
B. DB2 AVI Extender
C. DB2 Text Extender
D. DB2 Spatial Extender

D  11. Which of the following extenders allows data to be presented in a three-dimensional format?
A. DB2 AVI Extender
B. DB2 XML Extender
C. DB2 Text Extender
D. DB2 Spatial Extender

DE  12. When establishing client-server communication, which two of the following can be used to verify passwords?
A. Catalog Tables
B. Access Control List
C. Application Programs
D. DRDA Application Server
E. Client Operating System

B 13. When granted to USER1, which of the following will allow USER1 to ONLY access table data?
A. Administrative authority
B. SELECT privilege on the table
C. REFERENCES privilege on the table
D. SELECT privilege WITH GRANT OPTION on the table

B  14.Given the following users and groups with no privileges on table t1:
  GroupA       GroupB
  ------       ------
  user1          user4
  user2          user5
  user3
Which of the following commands gives all users in the above groups the ability to create a view on table t1?
A. GRANT SELECT ON TABLE t1 TO ALL
B. GRANT SELECT ON TABLE t1 TO PUBLIC
C. GRANT REFERENCES ON TABLE t1 TO ALL
D. GRANT SELECT ON TABLE t1 TO USER GroupA, GroupB

D 15.Given a user defined function, U.UDF1, that takes an input parameter of type INTEGER, and USER6 running the following SQL statement:
SELECT w.udf1(col6) FROM t.tab1 WHERE col4 = 'ABC'
Which of the following statement(s) would allow USER6 to execute the statement?
A. GRANT ALL PRIVILEGES ON TABLE t.tab1 TO user6
B. GRANT SELECT ON TABLE t.tab1 TO user6
GRANT USE ON FUNCTION u.udf1(INT) TO user6
C. GRANT SELECT ON TABLE t.tab1 TO user6
GRANT REFERENCES ON FUNCTION u.udf1(INT) TO user6
D. GRANT ALL PRIVILEGES ON TABLE t.tab1 TO user6
GRANT EXECUTE ON FUNCTION u.udf1(INT) TO user6

C  16.Which of the following will grant just DML operations on table T.T4 to all users?
A. GRANT ALL PRIVILEGES ON t.t4 TO PUBLIC
B. GRANT ALL PRIVILEGES ON t.t4 TO ALL USERS
C. GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE t.t4 to PUBLIC
D. GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE t.t4 TO ALL USERS

A  17. Communications is being manually established from a Windows 2000 client through a DB2 Connect gateway to a DB2 host system.
Which of the following does NOT have to be cataloged on the gateway?
A. The client
B. The node where the data source resides
C. The data source on the DB2 database server
D. The Database Connection Service (DCS) database

C  18.  USER1 indicates that when running the following command from their client:
DB2 CONNECT TO sample USER user1
They receive the following error message:
SQL1013N  The database alias name or database name "SAMPLE" could not be found.  SQLSTATE=42705
Assuming a valid password was entered when prompted, which of the following is the cause of the error?
A. SAMPLE is not listening for incoming connections from clients.
B. The DB2 client version is not compatible with the server version.
C. The client's database directory does not contain an entry SAMPLE.
D. The client's node directory has an entry in it that points at a non-existent server.

C  18. A database administrator has supplied the following information:
• Protocol: TCP/IP
• Port Number: 446
• Host Name: ZEUS
• Database Name: SAMPLE
• Database Server Platform: OS/400
Which are the appropriate commands to set up the ability to connect to the database?
A. CATALOG TCPIP NODE zeus REMOTE zeus SERVER 446 OSTYPE os400 DATABASE sample;
B. CATALOG TCPIP DATABASE sample REMOTE zeus SERVER 446 OSTYPE os400;
CATALOG DATABASE dcssam AS sample AT NODE zeus AUTHENTICATION dcs;
C. CATALOG TCPIP NODE zeus REMOTE zeus SERVER 446 OSTYPE os400;
CATALOG DCS DB dcssam AS sample;
CATALOG DATABASE dcssam AS sample AT NODE zeus AUTHENTICATION dcs;
D. CATALOG TCPIP NODE sample REMOTE sample SERVER 446 OSTYPE os400;
CATALOG DCS DB sample AS dcssam;
CATALOG DATABASE dcssam AS sample AT NODE zeus AUTHENTICATION dcs;
A 19.To catalog a TCP/IP database connection to a remote DB2 server which of the following pieces of info

文库|博客

axjlxy

白手起家

论坛徽章:: 0

2楼 [报告]

发表于 2005-06-26 23:10 |只看该作者

有答案的DB2 700，701题库

A 1. DB2 Enterprise Server Edition (ESE) is running on Linux and needs to validate the userids and passwords on the z/OS server for the DB2 clients connecting to DB2 for z/OS. Which of the following authentication levels satisfies this while providing authentication for other DB2 clients at the DB2 ESE server?
A. DCS
B. DRDA
C. HOST
D. CLIENT
E. SERVER

C 2. To permit all users from any DB2 UDB client to connect to the database, which of the following is required in the database's instance?
A. Set trust_clntauth = Client, trust_allclnts=No
B. Set trust_clntauth = Server, trust_allclnts=No
C. Set trust_clntauth = Client, trust_allclnts=Yes
D. Set trust_clntauth = Server, trust_allclnts=Yes}

C 3. A DB2 UDB server has 64-bit UNIX installed.  Which of the following is required to update a 32-bit instance to a 64-bit instance after installing the 64-bit DB2 UDB code?
A.  Issue the db2icrt command
B.  Issue the db2start command
C.  Issue the db2iupdt command
D.  Issue the db2iconv command

D 3. In which of the following locations must userids and passwords be defined if using authentication SERVER?
A. The node directory on the server
B. The system catalog on the server
C. The PASSWORD table in the database
D. The operating system on the server

D 4. Given an application with the embedded static SQL statement:
   INSERT INTO admin.payroll (employee, salary) VALUES ("Becky Smith",80000)
Which of the following privileges must a user hold to run the application?
A. ALTER on the table
B. INSERT on the table
C. DBADM on the database
D. EXECUTE on the package

D 5.AUTHENTICATION=SERVER_ENCRYPT allows DB2 to encrypt which of the following?
A. data
B. userid
C. password
D. userid and password

C 6. Which of the following allows the user "manager" (who is a regular user) to control access to schema "city"?
A. CREATE SCHEMA city RESTRICT manager
B. CREATE SCHEMA city GRANT TO manager
C. CREATE SCHEMA city AUTHORIZATION manager
D. CREATE SCHEMA city, when logged on as user "manager"}

E 7. Which of the following is required to use the IMPORT utility to import data into a table?
A. SYSCTRL authority
B. LOAD authority on the table
C. ALTER privilege on the table
D. IMPORT authority on the table
E. INSERT privilege on the table

D 8. Which of the following authorities can be used to roll forward through database logs, but NOT restore a backup image into a new database?
A. DBADM
B. SYSADM
C. SYSCTRL
D. SYSMAINT

DE  9. Which two of the following identify which users have SYSCTRL authority?
A. The node directory
B. The system catalog
C. The database configuration
D. The operating system security
E. The database manager configuration

C 10. Given the following statement:
"DROP TABLE payroll.employee"
returns the following message:
SQL0551N  "USER1" does not have the privilege to perform operation
"DROP" on object "

AYROLL.EMPLOYEE."  SQLSTATE=42501
Which of the following will correct the situation?
A. GRANT DROP AUTHORITY TO user1
B. GRANT DROPIN ON SCHEMA user1 TO user1
C. GRANT DROPIN ON SCHEMA payroll TO user1
D. GRANT DROPIN ON SCHEMA employee TO user1

B 11.Given an application with the embedded static SQL statement:
  INSERT INTO admin.payroll (employee, salary) VALUES ("Joe Smith",30000)
Which of the following table privileges must be held on admin.payroll to successfully bind the application?
A. ALTER
B. INSERT
C. UPDATE
D. BINDADD
E. EXECUTE

A 12.  An administrator issues the following statement:
  GRANT ALTER ON TABLE address TO smith
After the statement is completed, which of the following actions can the user SMITH perform?
A. Add constraints to the table
B. Issue ALTER TRIGGER on the table
C. Drop columns from the ADDRESS table
D. Decrease the size of columns in the table

A 13. Which of the following can be done by a user who is granted the CONTROL privilege on an INDEX?
A. Drop the index
B. Alter the index
C. Add columns to the index
D. Create an index extension on the index

C 14. Which of the following actions will occur when issuing the command FORCE APPLICATION ALL?
A. No new database connections are allowed
B. Uncommitted units of work are committed
C. Uncommitted units of work are rolled back
D. Disconnect warning messages are sent to connected users

CE  14.  Which two of the following must be done in order to allow DB2 databases on a server to be detected by DB2 clients?
A. Run the Configuration Assistant at the database server
B. Set AUTHENTICATION=CLIENT in the database manager configuration
C. Ensure the database configuration parameter DISCOVER_DB is set to ENABLE
D. Ensure the database manager configuration parameter DISCOVER is set to ENABLE
E. Ensure the database manager configuration parameter DISCOVER_INST is set to ENABLE

D 15. Which of the following must be set to restrict clients from being able to discover any DB2 instances on a server?
A. DISCOVER_DB parameter to DISABLE
B. DISCOVER_INST parameter to DISABLE on a DB2 instance
C. DB2 Administration Server configuration parameter SEARCH to DISABLE
D. DB2 Administration Server configuration parameter DISCOVER to DISABLE

B 16. There is an instance on a server that needs to be discovered.  The two databases in the instance are PAYROLL and CERTIFY.  The PAYROLL database should not be seen.  Which of the following will meet this requirement?
A. Set the DAS configuration parameter DISCOVER to DISABLE.
Set the DISCOVER_DB parameter in the CERTIFY database configuration file to ENABLE.
B. Set the DAS configuration parameter DISCOVER to SEARCH.
Set the DISCOVER_DB parameter in the PAYROLL database configuration file to DISABLE.
C. Set the DAS configuration parameter DISCOVER to SEARCH.
Set the DISCOVER_INST parameter in the PAYROLL database configuration file to DISABLE.
D. Set the DAS configuration parameter DISCOVER to DISABLE.
Set the DISCOVER_INST parameter in the CERTIFY database configuration file to ENABLE.}

A 17. The status of jobs scheduled by the Task Center can be monitored using which of the following?
A. Journal
B. Health Center
C. Snapshot Monitor
D. Information Catalog Center}

A 18. {When scheduled using the Task Center, all of the following actions can be specified to take place upon completion or failure of the task, EXCEPT:
A. Create a new task.
B. Send an email or page.
C. Cancel other scheduled tasks.
D. Re-run the task that just completed.

B 19. What value should the NOTIFYLEVEL configuration parameter have in order to capture all notification messages?
A.5 B.4 C. 3 D. -1

B 20. Given the following notification message:
*
  2002-02-05-03.14.38.559911 Instance:db2inst1 Node:000
  PID:89198(db2agent (DB2PROD  ))
  Appid:*LOCAL.db2inst1.020205091435
  buffer pool services  sqlbStartPoolsErrorHandling Probe:39
  ADM6080E  The tablespace "ID" (ID "3"

, was put OFFLINE and in
  ROLLFORWARD_PENDING. Tablespace state is 0x"00004080".  1

  *
Which database does this message apply to?
A.  ID    B.  DB2PROD C.  db2inst1 D.  db2agent

C 21. Which of the following can have their default location changed when issuing the CREATE DATABASE command?
A.  Log files B. User tables C. Table spaces  D. Stored procedures

A 22. Given the following command:
CREATE DATABASE payroll ALIAS paynew ON path/drive
   USING CODESET codeset
   TERRITORY territory
   COLLATE USING IDENTITY
How is character data compared within the database?
A. Byte for byte
B. Based on the codeset
C. Based on the codepage
D. Based on the territory

D 23. After a successful table space restore command, which of the following states will the table space be in?
A. Restore pending
B. Recovery pending
C. Restore in progress
D. Roll forward pending

B 24. Which of the following statements is required to register a federated database source?
A. CREATE VIEW
B. CREATE WRAPPER
C. CREATE TRANSFORM
D. CREATE TYPE MAPPING

A 25. Given the following statements:
CREATE TABLE T1 (COL1 INT NOT NULL PRIMARY KEY, COL2 CHAR, COL3 CLOB (40K), COL4 VARCHAR(10));

CREATE UNIQUE INDEX IND_1 ON T1 (COL1, COL2) INCLUDE (COL3) ALLOW REVERSE SCANS;
The CREATE UNIQUE INDEX statement will fail because:
A. LOB columns cannot be used in an index.
B. A unique index cannot include an existing primary key.
C. Reverse scans are not supported on multi-column indexes.
D. INCLUDE columns are not supported in indexes that support REVERSE SCANS.

C 26. Given the following DDL statements:
   CREATE TABLE PERSON OF PERSON_T
            (REF IS OID USER GENERATED)
   CREATE TABLE EMP OF EMP_T UNDER PERSON
            INHERIT SELECT PRIVILEGES
   CREATE TABLE STUDENT OF STUDENT_T UNDER PERSON
            INHERIT SELECT PRIVILEGES
   CREATE TABLE STAFF (COL1 INT, COL2 INT)
  and
   INSERT one row into PERSON
   INSERT one row into EMP
   INSERT one row into STUDENT
   INSERT two rows into STAFF
How many rows will be returned after issuing the following SQL statement?
SELECT * FROM PERSON?
A.  1 B.  2 C.  3 D.  5 E. 10

B 27. Given the following DDL statements:
   CREATE TABLE person OF person_t
            (REF IS OID USER GENERATED)
   CREATE TABLE emp OF emp_t UNDER person
            INHERIT SELECT PRIVILEGES
   CREATE TABLE student OF student_t UNDER person
            INHERIT SELECT PRIVILEGES
Which of the following will drop all tables associated with the hierarchy?
A. Dropping the PERSON table
B. Dropping the table hierarchy called PERSON
C. Deleting all rows from the person hierarchy
D. Dropping all columns from the subtables STUDENT and EMP

CE  28.  Which two of the following objects can be changed with an ALTER statement?
A. Index
B. Trigger
C. Procedure
D. Constraint
E. Table space

B 30. Which of the following table space characteristics for a System Managed (SMS) table space can be modified with the ALTER TABLESPACE statement?
A. Extent size
B. Prefetch size
C. Size of an existing container
D. Location of an existing container

C 31. Which of the following is an advantage of an SMS table space?
A. The table space can use raw devices.
B. A table can be split across multiple table spaces.
C. Space for the objects in the table space is not allocated until required.
D. The size of the containers in the table space can be changed using the ALTER TABLESPACE statement.}

B 32. In a single partition database, which of the following commands or statements allows containers to be added to an SMS table space?
A. BACKUP DATABASE
B. RESTORE DATABASE
C. ALTER TABLESPACE
D. ADD TABLESPACE CONTAINER

A 33. Which of the following kinds of table spaces allows LOBs to use the filesystem cache?
A. An SMS table space
B. A user temporary table space
C. A system temporary table space
D. A DMS table space created with raw devices

A 34.  Which of the following commands will add the same amount of additional space for each container in a DMS table space named TSP1?
A. ALTER TABLESPACE tsp1 EXTEND ...
B. ALTER TABLESPACE tsp1 ENLARGE ...
C. ALTER TABLESPACE tsp1 ADD NEW STRIPE SET ...
D. ALTER TABLESPACE tsp1 BEGIN NEW STRIPE SET ...

B 35.  Given the following statement:
  CREATE TABLESPACE dms1 MANAGED BY DATABASE USING
(FILE 'dms01' 1024K)
How many pages will be created for the table space?
A.  128 B.  256 C. 512 D. 1024

AC 36.  Which two of the following ALTER TABLESPACE options can be used to reduce the amount of space associated with a DMS table space?
A. RESIZE
B. EXTEND
C. REDUCE
D. ADD TO STRIPE SET 1
E. BEGIN NEW STRIPE SET

B 37.  A DBA has created three related backup tasks in the Task Center. Which of the following tools can be used to edit the tasks?
A. Journal
B. Command Center
C. Control Center
D. Development Center

A 38. For tasks created and successfully executed in the Task Center, which of the following is the default output location?
A. Journal
B. System console
C. DB2 Command Window
D. User specified file

D 39. Given the following table definitions:
      CANDIDATE
      ---------
      CandidateName             CHAR(20) NOT NULL
      CandidateID                INTEGER NOT NULL
      Address                   CHAR(100) NOT NULL
      CandidatePhoto             BLOB(1M)

      TEST_TAKEN
      ----------
      TestName                   CHAR(50) NOT NULL
      TestNumber                INTEGER NOT NULL
      TestScore                INTEGER NOT NULL
      CandidateID                INTEGER NOT NULL
And the following information:
•  Candidate IDs are unique in the CANDIDATE table
•  Requirement to select all candidate IDs who have taken test number 701
Assuming no other indexes, which of the following indexes should be created to support the requirement?
A. Primary key on candidate (CandidateID) allowing reverse scans
B. Unique index on candidate (CandidateID) disallowing reverse scans
C. Clustered index on test_taken (CandidateID) allowing reverse scans
D. Index on test_taken (CandidateID, TestNumber) allowing reverse scans

B 40.  A table is experiencing frequent inserts. Which of the following options can defer how frequently DB2 must allocate additional index pages?
A. CLUSTER
B. PCTFREE
C. MINPCTUSED
D. SPECIFICATION ONLY

C 41. What is the purpose for creating a primary key on a table?
A. To ensure duplicate key values are entered
B. To support creation of a table check constraint
C. To support referential integrity between tables
D. To provide free space on each index page for new data

C 42.  Given the table definitions:
  CREATE TABLE employees
(employee_num INT NOT NULL PRIMARY KEY,
   employee_name CHAR(20));

  CREATE TABLE pc
(serial_num INT NOT NULL PRIMARY KEY,
   model_num INT,
   owner_id INT,
FOREIGN KEY (owner_id)
REFERENCES employees ON UPDATE RESTRICT);
and the statement:
  UPDATE pc SET owner_id = 1000 WHERE serial_num = 7654
Which of the following conditions must be met before the update will be successful?
A. Owner_id 1000 must exist in the pc table.
B. Owner_id 1000 must not exist in the pc table.
C. Employee_num 1000 must exist in the employees table.
D. Employee_num 1000 must not exist in the employees table.

B 43. Given statements issued in the following sequence:
  CREATE TABLE tab1 (col1 INT, col2 INT);
  CREATE VIEW  v1 AS SELECT * FROM tab1;
  ALTER  TABLE tab1 ADD col3 INT;

and contents of tab1:
  COL1 COL2 COL3
  ------ ------ ------
   1    2    3
   2    3    4
What is the result of issuing the following statement?
SELECT * FROM V1
A. SQL0204N "V1" is an undefined name.
B. COL1  COL2
----- -----
            1    2
            2    3
C.  COL1 COL2 COL3
------ ------ ------
            1    2    3
            2    3    4
D. SQL0575N View or materialized query table "V1" cannot be used because it has been marked inoperative.

A 44.  Which of the following DB2 objects allows multiple users to access data in a table with each user only being able to access certain portions of the data?
A. Views
B. Summary Tables
C. Dimension Tables
D. Table Constraints

BC 45. Given the following DDL statements:
  CREATE VIEW v1 AS SELECT col1 FROM tab1 WHERE col1>;10
  CREATE VIEW v2 AS SELECT col1 FROM v1 WITH CHECK OPTION
  CREATE VIEW v3 AS SELECT col1 FROM v2 WHERE col1<100
Which two of the following statements will fail?
A. INSERT INTO v1 VALUES (5)
B. INSERT INTO v2 VALUES (5)
C. INSERT INTO v3 VALUES (5)
D. INSERT INTO v3 VALUES (100)
E. INSERT INTO v3 VALUES (200)

C 46. Given the following table:
  TAB1
  NAMES                SALARIES
  -----------------    -------------------
  Joe Smith             32,456
  Mary James             56,010
  Pete Jones             155,900
  David Parson          21,500
and the following statements:
1)  REVOKE SELECT ON TABLE tab1 FROM PUBLIC
2)  REVOKE SELECT ON TABLE tab1 salaries FROM PUBLIC
3)  GRANT SELECT ON tab1v TO PUBLIC
4)  CREATE VIEW tab1v AS SELECT names FROM tab1
5)  CREATE VIEW tab1v AS SELECT salaries FROM tab1
Which of the statements and in what order must they be called to prevent normal users from seeing SALARIES, but allow them to see NAMES?
A. 1
B. 2
C. 1,4,3
D. 1,5,3

C 26.Which of the following database configuration parameter settings can improve the buffer pool hit ratio?
A. The index sort flag = YES  (INDEXSORT)
B. The catalog cache size >; 0  (CATALOGCACHE_SZ)
C. The number of I/O servers >; 0  (NUM_IOSERVERS)
D. The percentage of lock list per application>; 0  (MAXLOCKS)

A 27. Given an application that contains embedded static and dynamic SQL.
Which of the following will capture explain information for all statements in the application that can be examined with both Visual Explain and db2exfmt?
A. The EXPLSNAP ALL and EXPLAIN ALL bind options
B. The EXPLSNAP YES and EXPLAIN YES bind options
C. The SET CURRENT EXPLAIN SNAPSHOT YES and SET CURRENT EXPLAIN MODE YES statements
D. The SET CURRENT EXPLAIN SNAPSHOT ALL and SET CURRENT EXPLAIN MODE ALL statements}

C 28. Which of the following commands can be issued in a Command Line Processor (CLP) session to capture explain information for subsequent SQL statements that can be formatted using db2exfmt?
A. SET CURRENT SNAPSHOT YES
B. SET CURRENT QUERY EXPLAIN
C. SET CURRENT EXPLAIN MODE EXPLAIN
D. SET CURRENT EXPLAIN SNAPSHOT EXPLAIN

A 29.  Given the following export statement:
  EXPORT TO SAMPLE.DEL OF DEL SELECT * FROM SAMPLE
Which of the following column delimiters will be used in the output file after issuing this statement?
A. , (comma)
B.    (blank)
C. ; (semicolon)
D. " (double quote)

B 30.  Which of the following is a feature of the IMPORT utility?
A. Views can be created
B. Datalink columns can be imported
C. System catalog tables can be targets
D. REFRESH IMMEDIATE summary tables can be targets

D 31. Which of the following commands loads data into a table and updates the catalog statistics for that table?
A. LOAD FROM data.ixf OF IXF INSERT INTO dept1.assets STATISTICS YES
B. LOAD FROM data.ixf OF IXF CREATE INTO dept1.assets STATISTICS YES
C. LOAD FROM data.ixf OF IXF UPDATE INTO dept1.assets STATISTICS YES
D. LOAD FROM data.ixf OF IXF REPLACE INTO dept1.assets STATISTICS YES

BE 37.  Which two of the following are possible with LOAD?
A. Triggers are fired
B. Statistics are gathered
C. The target can be a nickname
D. Loaded data is captured for replication
E. Loaded data is copied for roll forward recovery

DE 32.  Which two of the following DB2 commands update information used by the optimizer when choosing an access path?
A. REORG
B. IMPORT
C. REBIND
D. RUNSTATS
E. CREATE INDEX

C 33. Given the following data from SYSCAT.TABLES:
  TABNAME    CARD NPAGES  FPAGES  OVERFLOW

  T1          1242    84    85       0
  ORG          8000    157    157       2
  SALES       844    19    19       45
  DEPARTMENT    767    23    23       5
Which of the following tables will benefit most from being reorganized?
A. T1
B. ORG
C. SALES
D. DEPARTMENT

AC 34.  When looking at SYSCAT.TABLES, which two of the following columns can indicate it is appropriate to run RUNSTATS?
A.    CARD
B.    CLUSTERED
C.    STATS_TIME
D.    CHECKCOUNT
E. CREATE_TIME

C 35. The FLUSH PACKAGE CACHE statement should be run after issuing which of the following commands?
A. REORG
B. DB2RBIND
C. RUNSTATS
D. CREATE TABLE UPDATE DATABASE CFG USING ...

A    36. Which of the following is supported by DB2MOVE?
A. Exporting and importing LOBs
B. Moving table space definitions
C. Moving logs to a stand-by database
D. Exporting and importing trigger definitions

A    37.Which of the following can the DB2 Design Advisor recommend?
A. Indexes for provided workload
B. Buffer pool assignments for table spaces
C. Optimal values for database memory configuration
D. Referential integrity constraints for selected tables

B    38.  Which of the following must occur to restore a database which has table space containers on invalid drives/devices?
A. Use roll forward recovery on the database
B. Use the REDIRECT option to restore the database
C. Use the RESTART DATABASE command on the database
D. Use the recovery history file to restore the database

BD 39. A backup image of the MYDB database exists in the <db2backup>; directory.  The following restore command was run:
  RESTORE DATABASE mydb FROM <db2backup>; INTO sample NEWLOGPATH <newlogpath>; REPLACE EXISTING
Which two of the following reflect the state of the SAMPLE database after the restore?
A. The database manager configuration file is over-written.
B. The system catalog tables for the database are replaced.
C. The LOGPATH database configuration parameter is retained.
D. The database configuration file for SAMPLE is over-written.
E. The authentication type for the database is reset to the default.
C    40. If a user accidentally drops a table and commits work, which of the following recovers the data from the dropped table?
A. Once committed, the data from the dropped table cannot be recovered
B. Obtain the transaction ID for the DROP TABLE statement and roll back the transaction
C. If DROPPED TABLE RECOVERY is enabled for the table space, restore table space, and roll forward
D. If DROPPED TABLE RECOVERY is not enabled for the table space, enable DROPPED TABLE RECOVERY, and restore table space and roll forward
A    41.To minimize database restart time due to rebuilding indexes, which of the following is the correct setting of the INDEXREC configuration parameter?
A. ACCESS
B. RESTART
C. REBUILD
D. DEFERRED

A    42.  Given the following information:
  Database manager configuration parameter INDEXREC = RESTART
  Database configuration parameter INDEXREC = SYSTEM
When will invalid indexes be rebuilt?
A. When the database restarts
B. When the last connection terminates
C. When the invalid index is first accessed
D. When the REORG INDEXES command is issued}

B    43.Which of the following is required to support infinite active log space?
A. USEREXIT = ON, LOGSECOND = 0
B. USEREXIT = ON, LOGSECOND = -1
C. LOGRETAIN = RECOVERY, LOGSECOND = 0
D. LOGRETAIN = RECOVERY, LOGSECOND = -1

C    44. Given the following DB2DIAG.LOG entry:
"Crash Recovery is needed."
Which of the following could be the cause for this entry?
A. A load failed
B. A restore failed
C. A hardware problem
D. A rollforward is required

BC 45. Given the following information:
  LIST HISTORY BACKUP ALL FOR  <database-alias>;

  SQL2160W  A damaged recovery history file has been replaced. Processing continued.
Which two of the following can be used to determine previous recovery activity on the database?
A. Re-issue the LIST HISTORY BACKUP command
B. Restore the database from previous backup
C. Restore recovery history file from previous backup
D. Restore just the catalog table space from a previous backup
E. Copy the DB2RHIST.ASC file from another database on the same instance

A    46. Which combination of database configuration parameters limits the database to version recovery only?
A. LOGRETAIN=NO USEREXIT=NO
B. LOGRETAIN=NO USEREXIT=YES
C. LOGRETAIN=RECOVERY USEREXIT=NO
D. LOGRETAIN=RECOVERY USEREXIT=YES

AE    47.Which two of the following are only possible using a redirected restore?
A. Redefining table space containers
B. Replacing a damaged recovery history file
C. Recovering table spaces in roll-forward pending
D. Specifying an alternate log path for roll forward
E. Restoring the database onto a different server with the same operating system}

A    48. Which commands are required to restore a Version 7 backup image of the database SAMPLE to a Version 8 instance?
A. RESTORE DATABASE sample FROM <backupdir>; INTO sample;
B. RESTORE DATABASE sample FROM <backupdir>; INTO sample;
DB2IMIGR;
C. RESTORE DATABASE sample FROM <backupdir>; INTO sample;
MIGRATE DATABASE sample;
D. RESTORE DATABASE sample FROM <backupdir>; INTO sample;
DB2IMIGR;
MIGRATE DATABASE sample;

D    49. An online database backup was started for database MYDB at 1 AM and completed at 3 AM.  Which of the following commands will restore the database from this backup image and allow connections to the database?
A. RESTORE DB mydb FROM <backupdir>;;
B. RESTORE DB mydb FROM <backupdir>; WITHOUT ROLLING FORWARD;
C. RESTORE DB mydb FROM <backupdir>;; ROLLFORWARD DATABASE mydb TO 1AM AND STOP;
D. RESTORE DB mydb FROM <backupdir>;; ROLLFORWARD DATABASE mydb TO END OF LOGS AND STOP;}

BD 50. Given the following information:
• A full database backup of DB1 was taken at 1:00PM.
• A table space TS1 was backed up at 1:15PM.
• A table in TS1 was dropped at 2:00PM.
Which two of the following commands are valid after restoring table space TS1 from the full database backup taken at 1:00PM?
A. ROLLFORWARD DATABASE db1 TO 1:15PM
B. ROLLFORWARD DATABASE db1 TO 2:30PM
C. ROLLFORWARD TABLESPACE ts1 TO 2:30PM
D. ROLLFORWARD DATABASE db1 TO END OF LOGS
E.    ROLLFORWARD TABLESPACE ts1 TO END OF LOGS

700考试题_4
1.Which of the following can be used to store images in a DB2 database?
A. DB2 AVI Extender
B. DB2 XML Extender
C. DB2 Text Extender
D. DB2 Spatial Extender

2. Which of the following statements will create an index and prevent table T1 from containing two or more rows with the same values for column C1?
A. CREATE UNIQUE INDEX ix1 ON t1 (c1)
B. CREATE DISTINCT INDEX ix1 ON t1 (c1)
C. CREATE UNIQUE INDEX ix1 ON t1 (c1,c2)
D. CREATE DISTINCT INDEX ix1 ON t1 (c1,c2)

3. Given a SELECT statement that has a GROUP BY clause.
The HAVING clause uses the same syntax as which other clause?
A. WHERE
B. UNION
C. SUBQUERY
D. ORDER BY

4. A developer is building an embedded SQL application on AIX that will access DB2 UDB for OS/390 or OS/400 servers.
Which of the following products is required to be installed on the AIX system in order to build the application?
A. DB2 Connect Personal Edition
B. DB2 Personal Developer's Edition
C. DB2 UDB Workgroup Server Edition
D. DB2 Universal Developer's Edition

5. A table has had check constraint enforcement turned off, and additional data has been inserted. Which of the following will perform data validation to ensure that column values are valid?
A. Add a trigger
B. Collect statistics
C. Reorganize the table
D. Enable check constraints

6. A table called EMPLOYEE has the following columns: name, department, and phone_number. Which of the following can limit read access to the phone_number column?
A. Using a view to access the table
B. Using a referential constraint on the table
C. Revoking access from the phone_number column
D. Defining a table check constraint on the table

7.The table STOCK has the following column definitions:

type       CHAR(1)
status    CHAR(1)
quantity INTEGER
price       DEC (7,2)

items are indicated to be out of stock by setting STATUS to NULL and QUANTITY and PRICE to zero.
Which of the following statements updates the STOCK table to indicate that all the items except for those with TYPE of "S" are temporarily out of stock?
  A. UPDATE stock SET status='NULL', quantity=0, price=0 WHERE type <>; 'S'
  B. UPDATE stock SET (status, quantity, price) = (NULL, 0, 0) WHERE type <>; 'S'
  C. UPDATE stock SET (status, quantity, price) = ('NULL', 0, 0) WHERE type <>;'S'
  D. UPDATE stock SET status = NULL, SET quantity=0, SET price = 0 WHERE type <>;'S'

8. Given the following statements:
CREATE TABLE t4
(c1 INTEGER NOT NULL,
c2 INTEGER,
c3 DECIMAL(7,2) NOT NULL,
c4 CHAR(20) NOT NULL);
CREATE UNIQUE INDEX i4 ON t4(c1,c3);
ALTER TABLE t4 ADD PRIMARY KEY (c1,c3);
Which of the following statements is TRUE?
A. The ALTER TABLE statement will fail.
B. The primary key will use the I4 unique index.
C. A primary index will need to be created on the composite key (C1,C3).
D. An additional unique index will automatically be created on the composite key (C1,C3).

9. Which of the following isolation levels will hold locks only on the rows in the answer set at the end of the query?
A. Read Stability
B. Repeatable Read
C. Cursor Stability
D. Uncommitted Read

10. Given the tables:
COUNTRY
ID  NAME  PERSON  CITIES
1  Argentina  1 10
2 Canada 2 20
3 Cuba  2 10
4 Germany  1 0
5 France  7 5
STAFF
ID  LASTNAME
1  Jones
2  Smith
How many rows would be returned using the following statement?
SELECT * FROM staff, country
A. 0
B. 2
C. 5
D. 7
E. 10

11. Given the following SQL statement:
GRANT EXECUTE ON PACKAGE proc1 TO usera WITH GRANT OPTION
Which two of the following describe what USERA is allowed to do?
A. Execute SQL statements in package PROC1
B. Grant any privilege on package PROC1 to other users
C. Grant bind privilege on package PROC1 to other users
D. Grant execute privilege on package PROC1 to other users
E. Access all of the tables referenced in package PROC1 from any program

12. USER2 has SELECT WITH GRANT OPTION on APPL.TAB1.
Which of the following statements is USER2 authorized to execute?
A. GRANT INSERT ON TABLE appl.tab1 TO user8
B. GRANT SELECT ON TABLE appl.tab1 TO user8
C. GRANT REFERENCES ON TABLE appl.tab1 user8
D. GRANT ALL PRIVILEGES on TABLE appl.tab1 TO user8

13. Given the following transaction in an embedded SQL application:
CREATE TABLE dwaine.mytab (col1 INT, col2 INT)
INSERT INTO dwaine.mytab VALUES (1,2)
INSERT INTO dwaine.mytab VALUES (4,3)
ROLLBACK
What is the result of issuing the following statement?
SELECT * FROM dwaine.mytab
A. SQLCODE -204 indicating that "DWAINE.MYTAB" is an undefined name.
B. COL1  COL2
------------  -----------
  0 record(s) selected.
C. COL1 COL2
------------ -----------
1 2 1 record(s) selected.
D. COL1 COL2
------------ -----------
1 2
4 3 2 record(s) selected.

14.Given the table:

STAFF
ID    LASTNAME
1    Jones
2    Smith
3    <null>;
Which of the following statements removes all rows from the table where there is a NULL value for LASTNAME?
  A. DELETE FROM staff WHERE lastname IS NULL
  B. DELETE FROM staff WHERE lastname = 'NULL'
  C. DELETE ALL FROM staff WHERE lastname IS NULL
  D. DELETE ALL FROM staff WHERE lastname = 'NULL'

15.Given the following statements:
CREATE TABLE t1 (id INTEGER, CONSTRAINT chkid CHECK (id<100))
INSERT INTO t1 VALUES (100)
COMMIT
Which of the following occurs as a result of issuing the statements?
  A. The row is inserted with ID having a NULL value.
  B. The row is inserted with ID having a value of 100.
  C. The row insertion with a value of 100 for ID is rejected.
  D. The trigger called chkid is activated to validate the data.

16.A stored procedure has been created with the following statement:
CREATE PROCEDURE P1(IN VAR1 INTEGER, OUT VAR2 VARCHAR(10))...
From the command line processor (CLP), which is the correct way to invoke this procedure?
  A. RUN P1 (10, ?)
  B. CALL P1 (10, ?)
  C. SELECT P1 (10, ?)
  D. EXECUTE P1 (10, ?)

17.Cataloging a remote database server from a Linux, UNIX, or Windows gateway is:
  A. performed to identify the location of the clients.
  B. performed to identify the server the DB2 database manager is on.
  C. never performed in DB2, as only one database per node is allowed, so cataloging a node automatically catalogs the database at that node.
  D. performed on a Linux, UNIX, or Windows machine to open the catalogs in the DB2 database server and present a user with a list of all accessible tables in that database.

18.An application using the Repeatable Read isolation level acquires an update lock. When does the update lock get released?
  A. When the cursor accessing the row is closed
  B. When the transaction issues a ROLLBACK statement
  C. When the cursor accessing the row is moved to the next row
  D. When the transaction changes are made via an UPDATE statement

19.Given a read-only application that requires consistent data for every query, which of the following isolation levels should it use to provide the most concurrency with other applications doing updates?
  A. Read Stability
  B. Repeatable Read
  C. Cursor Stability
  D. Uncommitted Read

20.Which of the following statements eliminates all but one of each set of repeated rows in the final result table?
  A. SELECT UNIQUE * FROM t1
  B. SELECT DISTINCT * FROM t1
  C. SELECT * FROM DISTINCT T1
  D. SELECT UNIQUE (*) FROM t1
  E. SELECT DISTINCT (*) FROM t1

21.A business has a requirement that a row not be deleted from the parent table if a row with the corresponding key value still exists in the child table. Which of the following delete rules would enforce this requirement?
  A. DELETE
  B. CASCADE
  C. RESTRICT
  D. SET NULL

22.When constraint checking is suspended or disabled, a table or table space (depending on platform) is placed in which of the following states?
  A. Paused
  B. Check pending
  C. Intent locked
  D. Constraint waiting

23.Which of the following DB2 components allows references to Oracle and DB2 databases in a single query?
  A. DB2 Query Patroller
  B. DB2 Warehouse Manager
  C. DB2 Relational Connect
  D. DB2 Connect Enterprise Edition

24.Which of the following has an object tree from which you can perform administrative tasks against database objects?
  A. Control Center
  B. Command Center
  C. Command Line Processor
  D. DB2 Administration Client

25.Which two of the following SQL data types should be used to store double byte character data?(two)
  A. CLOB
  B. CHAR
  C. DBCLOB
  D. GRAPHIC
  E. VARCHAR

26.When using DB2 Connect, which of the following commands specifies the protocol information on how to connect to the host or to the server?
  A. CATALOG DCS
  B. CATALOG NODE
  C. CATALOG DATABASE
  D. CATALOG ODBC DATA SOURCE

27.A client application on OS/390 or OS/400 must access a DB2 server on Linux. At a minimum, which of the following products is required to be on the DB2 server?
  A. DB2 Connect Enterprise Edition
  B. DB2 UDB Enterprise Server Edition
  C. DB2 Connect Enterprise Edition and DB2 UDB Workgroup Server Edition
  D. DB2 Connect Enterprise Edition and DB2 UDB Enterprise Server Edition

28.A stored procedure has been built and deployed on the DB2 UDB server machine. What is the minimum software that must be installed to allow an application on the client to execute the stored procedure?
  A. DB2 Runtime Client
  B. DB2 Personal Edition
  C. DB2 Administration Client
  D. DB2 Application Development Client

29.Given that table T1 needs to hold specific numeric values up to 99999.99 in column C1.
  A. REAL
  B. INTEGER
  C. NUMERIC(7,2)
  D. DECIMAL(5,2)

30.Which of the following is a valid wildcard character in a LIKE clause of a SELECT statement?
  A. *
  B. _
  C. @
  D. ?

31.What is the difference between a unique index and a primary key?
  A. They are different terms for the same concept.
  B. Unique indexes can be defined over multiple columns.Primary keys must have only one column.
  C. Unique indexes can be defined in ascending or descending order. Primary keys must be ascending.
  D. Unique indexes can be defined over a column or columns that allow nulls. Primary keys cannot contain nulls

32.SQL source statements for which two of the following are stored in the system catalog?(2)
  A. Views
  B. Tables
  C. Indexes
  D. Triggers
  E. Constraints

33.Given the following transaction in an embedded SQL application:
CREATE TABLE dwaine.mytab (col1 INT, col2 INT)
INSERT INTO dwaine.mytab VALUES (1,2)
INSERT INTO dwaine.mytab VALUES (4,3)
ROLLBACK
What is the result of issuing the following statement?
SELECT * FROM dwaine.mytab
  A. SQLCODE -204 indicating that "DWAINE.MYTAB" is an undefined name.
  B. COL1  COL2
------------  -----------
  0 record(s) selected.
  C. COL1 COL2
------------ -----------
1 2 1 record(s) selected.
  D. COL1 COL2
------------ -----------
1 2
4 3 2 record(s) selected.

34.Given that table T1 needs to hold specific numeric values up to 99999.99 in column C1.
  A. REAL
  B. INTEGER
  C. NUMERIC(7,2)
D. DECIMAL(5,2)

35.CREATE TABLE tab1 (c1 CHAR(3) WITH DEFAULT '123',c2 INTEGER);
INSERT INTO tab1(c2) VALUES (123);
Which will be the result of the following statement when issued from the Command Line Processor?
SELECT * FROM tab1;
  A. C1 C2
--- -----------
0 record(s) selected.
  B. C1 C2
--- -----------
123 123
1 record(s) selected.
  C. C1 C2
--- -----------
   123
1 record(s) selected.
  D. C1 C2
--- -----------
- 123
1 record(s) selected.

36.Which two of the following SQL data types should be used to store double byte character data?(2)
  A. CLOB
  B. CHAR
  C. DBCLOB
  D. GRAPHIC
  E. VARCHAR

37.Which of the following can be used to store images in a DB2 database?
  A. DB2 AVI Extender
  B. DB2 XML Extender
  C. DB2 Text Extender
  D. DB2 Spatial Extender

38.CREATE TABLE tab1 (c1 CHAR(1))
INSERT INTO tab1 VALUES ('b')
CREATE VIEW v1 AS SELECT c1 FROM tab1 WHERE c1='a' WITH CHECK OPTION
INSERT INTO v1 VALUES ('a')
INSERT INTO v1 VALUES ('b')
How many rows would be returned from the statement, SELECT c1 FROM tab1?
  A. 0
  B. 1
  C. 2
  D. 3

39.A user creates the table TABLE1 with a referential constraint defined over column COL1. Which of the following statements would explicitly give USER1 the ability to read rows from the table?
  A. GRANT SELECT ON TABLE table1 TO user1
  B. GRANT ACCESS ON TABLE table1 TO user1
  C. GRANT REFERENCES TO user1 ON TABLE table1
  D. GRANT UPDATE (col1) TO user1 ON TABLE table1

40.A declared temporary table is used for which of the following purposes?
  A. To store intermediate results
  B. To share result sets between applications
  C. To provide an area for database manager sorts
  D. To create a backup copy of a database or table space

41.Which of the following statements will create an index and prevent table T1 from containing two or more rows with the same values for column C1?
  A. CREATE UNIQUE INDEX ix1 ON t1 (c1)
  B. CREATE DISTINCT INDEX ix1 ON t1 (c1)
  C. CREATE UNIQUE INDEX ix1 ON t1 (c1,c2)
  D. CREATE DISTINCT INDEX ix1 ON t1 (c1,c2)

42,Which of the following can duplicate the structure and related objects of a database table?
  A. Copy table
  B. Alter table
  C. Export table
  D. Generate DDL

43.A unit of work is using an isolation level of Uncommitted Read, and allows scanning through the table more than once within the unit of work. Which of the following can occur during processing of this unit of work?
  A. It can access uncommitted changes made by other transactions.
  B. It can update uncommitted changes made by other transactions.
  C. It can update rows and have those updated rows be changed by other transactions from one scan to the next.
  D. It can update rows and have those updated rows be committed by other transactions from one scan to the next.

44.Given the following tables:

NAMES
Name  Number
Wayne Gretzky
Jaromir Jagr
Bobby Orr
Bobby Hull
Brett Hull
Mario Lemieux
Steve Yzerman
Claude Lemieux
Mark Messier
Mats Sundin  99
68
4
23
16
66
19
19
11
13

POINTS
Name  Points
Wayne Gretzky
Jaromir Jagr
Bobby Orr
Bobby Hull
Brett Hull
Mario Lemieux  244
168
129
93
121
189

PIM
Name  PIM
Mats Sundin
Jaromir Jagr
Bobby Orr
Mark Messier
Brett Hull
Mario Lemieux
Joe Sakic  14
18
12
32
66
23
94
Which of the following statements will display the name, number, points and PIM for players with an entry in all three tables?
  A.
SELECT names.name, names.number, points.points, pim.pim FROM names INNER JOIN points ON names.name=points.name INNER JOIN pim ON pim.name=names.name
  B.
SELECT names.name, names.number, points.points, pim.pim FROM names OUTER JOIN points ON names.name=points.name OUTER JOIN pim ON pim.name=names.name
  C.
SELECT names.name, names.number, points.points, pim.pim FROM names LEFT OUTER JOIN points ON names.name=points.name LEFT OUTER JOIN pim ON pim.name=names.name
  D.
SELECT names.name, names.number, points.points, pim.pim FROM names RIGHT OUTER JOIN points ON names.name=points.name RIGHT OUTER JOIN pim ON pim.name=names.name

45.Given the following table definitions:
DEPARTMENT
deptno       CHAR(3)
deptname    CHAR(30)
mgrno I       NTEGER
admrdept    CHAR(3)

EMPLOYEE
empno       INTEGER
firstname    CHAR(30)
midinit       CHAR
lastname    CHAR(30)
workdept CHAR(3)

Which of the following statements will produce a result set satisfying these criteria?
* The empno and lastname of every employee
* For each employee, include the empno and lastname of their manager
* Includes employees both with and without a manager
  A.
SELECT e.empno, e.lastname FROM employee e LEFT OUTER JOIN (department INNER JOIN employee m ON mgrno = m.empno) ON e.workdept = deptno
  B.
SELECT e.empno, e.lastname, m.empno, m.lastname FROM employee e LEFT INNER JOIN (department INNER JOIN employee m ON mgrno = m.empno) ON e.workdept = deptno
  C.
SELECT e.empno, e.lastname, m.empno, m.lastname FROM employee e LEFT OUTER JOIN (department INNER JOIN employee m ON mgrno = m.empno) ON e.workdept = deptno
  D.
SELECT e.empno, e.lastname, m.empno, m.lastname FROM employee e RIGHT OUTER JOIN (department INNER JOIN employee m ON mgrno = m.empno) ON e.workdept = deptno

46.Given the following table definition and SQL statements:
CREATE TABLE table1 (col1 INT, col2 CHAR(40), col3 INT)
GRANT INSERT, UPDATE, SELECT, REFERENCES ON TABLE table1 TO USER usera
Which of the following SQL statements will revoke the privileges granted to user USERA on COL1 and COL2?
  A. REVOKE UPDATE ON TABLE table1 FROM USER usera
  B. REVOKE ALL PRIVILEGES ON TABLE table1 FROM USER usera
  C. REVOKE ALL PRIVILEGES ON TABLE table1 COLUMNS (col1, col2) FROM usera
  D. REVOKE REFERENCES ON TABLE table1 COLUMNS (col1, col2) FROM USER usera

Which of the following processes is NOT performed by DB2 Warehouse Manager?
  A. Query
  B. Loading
  C. Extraction
  D. Transformation

Which of the following DDL statements creates a table where employee IDs are unique?
  A. CREATE TABLE t1 (employid INTEGER)
  B. CREATE TABLE t1 (employid INTEGER GENERATED BY DEFAULT AS IDENTITY)
  C. CREATE TABLE t1 (employid INTEGER NOT NULL)
  D. CREATE TABLE t1 (employid INTEGER NOT NULL PRIMARY KEY)

Which of the following can duplicate the structure and related objects of a database table?
  A. Copy table
  B. Alter table
  C. Export table
  D. Generate DDL
DB2 UDB V8.1 for Linux, UNIX, and Windows Database Administration
Test 701 Objectives/Skills Measured on Test

1． Mary set a trigger and a notification method for an event monitor . Which one of the following must she also set to monitor an event?
A. time to collect
B. threshold value
C. collection interval
D. event type and severity
2. Maria has discovered that if address of ber domino site was entered incorrectly. In which one of the following places would she go to edit this?
A. the basics tab of the connection document
B. the if number field of the internet document
C. the internet protocols tab of the server document
D. the ports tab of the server document
3. The projects database needs to replicate to the box domain from the acme domain. The box and acme domains use hierarchical certificates based on different organizational certificates. Which one of the following is required for his database to be replicated.
A. cross certificates
B. a common domino directory
C. a replication security document
D. trusted non-hierarchical certificates
4 hans has a local replica of the projects database. He replicates with the application server in sao . hans notices that he has never received any updates to his local replica of the database since the database was created locally. which one of the following could be the cause of this?
A hans only has reader access to the projects database
B hans only has author access to the projects database
C the server is not listed in the acl with at least editor access
D otherdomainservers is not listed in the acl with at least editor access
5 tom is using the domino administrator to migrate cc:mail users and groups to notes mail. Which one of the following tasks does the upgrade utility not do ?
a create notes id for users
b convert the user’s cc:mail files to notes mail files
c convert the users cc:mail messages to notes mail messages
d convert the users cc:mail archive files to notes mail archive files.
6 Susan enabled SSL using TCP/IP port110 on a pop3 server. For which one of the following reasons should she specify different inbound port?
A port 110 is reserved for future use
B Port 110 permits POP3 clients not enabled for SSL to connect
C Additional enabled ports will maximize availability of the POP3 server
D Port 110 is only recognized by a small number of proprietary mail clients
7 cheng set up document archiving to prevent orphan documents from occurring. Which one of the following document archiving options did she choose to do this?
A archive all document marked as expired
B do not delete document that have responses
C archive document not modified or updated after x days
D delete all documents not read or accessed after x days
8 which one of the following ldap maintenance operations can be carried out on other databases by the administrator process?
A name additions
B name deletions
C name modifications
D none .each of these is a manual operation
9 tom , a calendaring and scheduling user, wants to accepts all invitations to meetings without selecting and accepting them manually. Which one of the following describes what the administrator would tell him to do?
A nothing  it happens automatically
B add calendaraccept =1 to his notes.ini file
C enable the autoprocess meetings scheduled agent calendar profile
D update the automatically process meetings field in calendar preferences
10 tom needs to see the hidden views in his domain’s domino directory. However ,he does not have designer access. Which one of the following should he do?
A press ctrl+alt and click the database icon
B press ctrl+alt and double click the database icon
C press ctrl+shift and double click the database icon
D press ctrl+shift and click the bookmark for tht domino directory