- 论坛徽章:
- 0
|
Which utility can be used to examine the SQL statements within a bind file?
A.db2bfd
B.db2mtrk
C.db2look
D.db2advis
答案A
--
Recovering a single table space to a point in time:
A.requires archive log files from the last restorable backup.
B.is not possible, table spaces must be recovered to end of logs.
C.is not possible if the disks for that table space are not recoverable.
D.requires the sysadmin to connect to the target database prior to issuing the command.
答案A
--
A database named QA that was using archival logging crashed. An attempt to restart it failed with error code SQL0290N. Examination of the db2diag.log shows that the disk drive containing the system catalog table space SYSCATSPACE is not responding. Backup images of both the QA database and the SYSCATSPACE table space exist. After replacing the failed disk drive, what is the quickest method to bring the QA database back online?
A.Restore the QA database from the latest off-line backup image.
B.Restore the QA database from the latest off-line backup image and rollforward to end of logs.
C.Restore the System Catalog table space from the latest SYSCATSPACE backup image without rolling forward.
D.Restore the System Catalog table space from the latest SYSCATSPACE backup image and rollforward to end of logs.
答案D
--
Which of the following settings would allow 20 sorts with a maximum of 10MB each to run concurrently on a 64-bit instance?
A.Set the DB SHEAPTHRES to 50000 and the DB SORTHEAP to 2500.
B.Set the DBM SHEAPTHRES to 50000 and the DB SORTHEAP to 2500.
C.Set the DBM SHEAPTHRES to 50000 and the DBM SORTHEAP to 2500.
D.Set the DBM SHEAPTHRES_SHR to 50000 and the DBM SHEAPTHRES to 2500.
答案B
--
Which of the following is the correct command for obtaining detailed information about a table space, including its current status?
A.list tablespaces
B.list tablespaces show detail
C.list tablespace containers show detail
D.get snapshot for tablespace containers on sample
答案B
--
How many index keys are created by this index?
CREATE INDEX empindex on companyinfo(companydocs) GENERATE KEY USING XMLPATTERN '/company/emp/@id' AS SQL DOUBLE
if the XML column contains the following two documents:
Document for Company1:
<company name="Company1">
<emp id="31201" salary="60000" gender="Female">
<name>
<first>Laura</first>
<last>Brown</last>
</name>
<dept id="M25">
Finance
</dept>
</emp>
</company>
Document for Company2:
<company name="Company2">
<emp id="31664" salary="60000" gender="Male">
<name>
<first>Chris</first>
<last>Murphy</last>
</name>
<dept id="M55">
Marketing
</dept>
</emp>
<emp id="42366" salary="50000" gender="Female">
<name>
<first>Nicole</first>
<last>Murphy</last>
</name>
<dept id="K55">
Sales
</dept>
</emp>
</company>
A.0
B.2
C.3
D.4
答案C
--
A transaction that receives a log disk full error (SQL0968C) will fail and be rolled back. In order to prevent the roll back, which of the following should be done?
A.Set BLK_LOG_DSK_FUL to NO
B.Set BLK_LOG_DSK_FUL to YES
C.Decrease space for the active log directory
D.Reduce the LOGPRIMARY, LOGSECOND and LOGFILSIZ
答案B
--
A developer wants to create a new user-defined function for the FINANCE database using the Control Center. Which statement best describes how the developer should proceed?
A.Right-click the "User-Defined Functions" folder under the FINANCE database and select the "Create" option.
B.Right-click the "Routines" folder under the FINANCE database and select the "Create User-Defined Function wizard" option.
C.A user-defined function cannot be created using the Control Center. Proceed with using the Command Editor or the new DB2 V9 Developer Workbench.
D.Switch to the Control Center Development View, right-click the "User-Defined Function" folder under the FINANCE database, and select the "Create" option.
答案C
--
For a database that is enabled for automatic storage, which command will create a DMS tablespace TBSP_10 capable of storing 1 TB of data?
A.create tablespace TBSP_10 managed by database
B.create tablespace TBSP_10 managed by automatic storage
C.create regular tablespace TBSP_10 managed by automatic storage
D.create large tablespace TBSP_10 managed by database automatic storage
答案B
--
A database administrator needs an alert generated when table space TS1 is filled up to 70% and all other table spaces are filled up to 80%. How can the DBA accomplish this using the Health Center?
A.Change the Global Settings for all table spaces and then change the Object Settings for table space TS1.
B.Change the Global Settings for all table spaces and then change the Instance Settings for table space TS1.
C.Change the Instance Settings for all table spaces and then change the Object Settings for table space TS1.
D.Change the Instance Settings for all table spaces and then change the Tablespace Settings for table space TS1.
答案A
--
The DB2 instance "db2inst1" has been created in the /home/db2inst1 directory. If the DFTDBPATH database manager configuration parameter contains no value and the following command is executed: CREATE DATABASE newdb Where will the NODE0000 subdirectory of the database NEWDB reside?
A.In the /home/db2inst1 subdirectory
B.In the /home/db2inst1/newdb subdirectory
C.In the /home/db2inst1/db2inst1 subdirectory
D.In the /home/db2inst1/db2inst1/newdb subdirectory
答案C
--
Given the following situation:
Table space ts1 with tables t1, t2, t3
Table space ts2 with tables t4, t5
Tables t1 and t4 have defined referential integrity on them (t1 is the parent, t4 is the child)
What happens after restoring the table space ts1 and issuing the following command?
db2 rollforward db sample to 2006-06-16-14.21.56 and stop tablespace(ts1)
A.The roll forward is executed to the end of logs.
B.The roll forward is not executed and an error message is generated.
C.The roll forward is executed and table t4 is placed in set integrity pending state.
D.The roll forward is executed and tables t1 and t4 are placed in set integrity pending state.
答案C
--
USER1 needs to remove table TABLE1 from the PAYROLL database. Assuming USER1 has no privileges on TABLE1, which of the following must occur before USER1 will be allowed to drop the table?
A.A user with SYSADM authority must execute the statement “GRANT DELETE ON table1 TO user1”.
B.A user with DBADM authority must execute the statement “GRANT CONTROL ON table1 TO user1”.
C.A user granted DELETE … WITH GRANT OPTION privilege on TABLE1 must execute the statement “GRANT DELETE ON table1 TO user1”.
D.A user granted CONTROL … WITH GRANT OPTION privilege on TABLE1 must execute the statement “GRANT CONTROL ON table1 TO user1”.
答案B
--
Which of the following event monitor types is defined and active for all databases by default?
A.DATABASE
B.DEADLOCKS
C.BUFFERPOOLS
D.CONNNECTIONS
答案B
--
A DBA needs to populate table T1 with a large amount of data and wants to incur a minimal amount of logging. The DBA also needs to populate table T2 with data and make sure that constraints are enforced during population. What is the best approach for populating the tables?
A.LOAD data into table T1 LOAD data into table T2
B.IMPORT data into table T1 IMPORT data into table T2
C.IMPORT data into table T1 LOAD data into table T2
D.LOAD data into table T1 IMPORT data into table T2
答案D
--
The following statements have been executed:
CREATE TABLE empdata
(empno INT NOT NULL,
sex CHAR(1) NOT NULL CONSTRAINT sexok CHECK (sex IN ('M','F')) NOT ENFORCED ENABLE QUERY OPTIMIZATION)
INSERT INTO empdata VALUES (1, 'M'), (2, 'Q'), (3, 'Q'), (4, 'F'), (5, 'Q'), (6, 'K')
How many rows will the following query return?
SELECT * FROM empdata WHERE sex = 'Q'
A.0
B.1
C.2
D.3
答案A
--
Which one of the following data organization schemes should be used in isolation?
A.DISTRIBUTE BY HASH
B.PARTITION BY RANGE
C.ORGANIZE BY DIMENSIONS
D.ORGANIZE BY KEY SEQUENCE
答案D
--
A DBA needs to set the DIAGLEVEL configuration parameter to 4 while users are connected to the database. How can this change be implemented in a way that has a minimum impact to the environment?
A.Quiesce the database and update the parameter.
B.Attach to the instance and update the parameter.
C.Connect to the database in a single user mode and update the parameter.
D.Attach to the instance, update the parameter, stop and restart the instance.
答案B
--
As part of a high availability takeover strategy using HADR, the LOG INDEX BUILD table attribute for the APPLICANT table is set to OFF. What is the most likely effect of this change?
A.After failover, the APPLICANT table index may be rebuilt.
B.An attempt to create a unique index on the APPLICANT table will fail.
C.Index builds for the APPLICANT table on the primary system will take longer.
D.The LOGINDEXBUILD database configuration parameter overrides the table attribute.
答案A
--
A recovery of database DB1 is started by issuing RECOVER DATABASE DB1 TO END OF LOGS. The recovery fails during the rollforward phase. In order to continue the recovery from the point of failure, which of the following commands should be executed?
A.RECOVER DATABASE DB1 RESTART
B.RECOVER DATABASE DB1 TO END OF LOGS
C.RECOVER DATABASE DB1 TO END OF LOGS RESTART
D.RECOVER DATABASE DB1 CONTINUE TO END OF LOGS
答案B
--
A table named EMPLOYEE contains 100,000 records. The following query seems to take a long time to execute when it is run against the EMPLOYEE table:
SELECT EMPID FROM employee WHERE EMPID > 1000
A DBA creates an index on the EMPID column but performance does not improve. Which of the following operations will correct this problem?
A.REORG
B.REBIND
C.REORGCHK
D.RUNSTATS
答案D
--
Which of the following statements best describes DB2's table partitioning capability?
A.It does not work with DPF.
B.It is not allowed with MQTs.
C.It is the same as using UNION of multiple tables.
D.It improves performance through data partition elimination.
答案D
--
When a schema is explicitly created with the CREATE SCHEMA statement, which of the following is true?
A.The schema owner is assumed to be a user or a group.
B.The new schema owner is granted the privilege to explicitly create other schemas.
C.The schema owner is granted CREATEIN, DROPIN, and ALTERIN privileges on the schema with the ability to grant these privileges to other users.
D.The schema owner is granted CREATEIN, DROPIN, and ALTERIN privileges on the schema without the ability to grant these privileges to other users.
答案C
--
What is the correct method of obtaining the global information on DB2 systems and features installed on a DB2 V9 database server on Linux?
A.rpm
B.db2ls
C.db2gs
D.pkgadd
答案B
--
Which utility can be used to examine the SQL statements within a bind file?
A.db2bfd
B.db2mtrk
C.db2look
D.db2advis
答案A
--
Given a Table MYTAB with columns C1, C2 and C3. C1 must be unique, C2 is not unique. To get the best possible performance for the frequently issued SQL statement:
SELECT c1, c2 FROM mytab ORDER BY c1
Which of the following statements should be executed?
A.CREATE INDEX ix1 ON mytab (c1, c2)
B.CREATE INDEX ix1 ON mytab (c2, c1)
C.CREATE UNIQUE INDEX ix1 ON mytab(c1) CREATE INDEX ix2 ON mytab (c2)
答案D
--
Which of the following utilities provides a report of memory status for instances, databases, and agents?
A.db2mtrk
B.db2mchk
C.db2expln
D.db2memview
答案A
--
Which of the following commands will re-initialize the commit counter reported by the snapshot monitor?
A.RESET MONITOR ALL
B.ZERO MONITOR COUNTERS
C.ZERO MONITOR FOR COMMIT
D.RESET MONITOR FOR COMMIT
答案A
--
A user issues the following commands:
UPDATE DBM CFG USING DFT_MON_STMT ON
UPDATE MONITOR SWITCHES USING SORT ON
Then, later issues these commands:
UPDATE DBM CFG USING DFT_MON_LOCK ON
UPDATE MONITOR SWITCHES USING BUFFERPOOL ON
UPDATE MONITOR SWITCHES USING STATEMENT OFF
Assuming no other monitor switches have been set, if the DB2 instance is stopped and restarted, which of the following database monitor switches will be active?
A.STATEMENT, LOCK
B.STATEMENT, SORT
C.BUFFERPOOL, SORT
D.BUFFERPOOL, LOCK
答案A |
|
免费注册
发表于 2007-07-04 21:51
