几道701的题，欢迎大家来讨论

ericwu

In trying to backup database SAMPLE, the following message is received:

SQL1035N The database is currently in use. SQLSTATE=57019

Which of the following should be done to attempt to get the backup to complete successfully?

  A. Stop the instance

  B. Reset the connection

  C. Quiesce the database

  D. Reissue command with the OFFLINE option

_____________________________________________________
Given a database named MYDB that contains table space MYTS. An offline database backup of database MYDB was started at 1am and completed at 3am.
Which of the following commands will restore from the offline backup and allow users to successfully connect to the database MYDB after the restore completes?

  A. RESTORE DB mydb FROM /backups

  B. RESTORE DB mydb ONLINE FROM /backups

  C. RESTORE DB mydb FROM /backups AND STOP

  D. RESTORE DB mydb TABLESPACE (MYTS) FROM /backups WITHOUT ROLLING FORWARD

_____________________________________________________
How can the amount of data returned when listing the tables in the Control Center be limited?

  A. Use the filter feature of the Details pane.

  B. Use the filter feature of the Tables folder.

  C. Create your tables in different table spaces.

  D. Use the Customize Columns feature of the Details pane

_____________________________________________________
When does a newly created table space become available for use?

  A. After restarting the instance

  B. As soon as the database is reactivated

  C. As soon as the creation statement completes

  D. When everyone disconnects and reconnects to the database

_____________________________________________________
Which of the following can occur when a view is created on a DB2 table?

  A. Memory usage is reduced

  B. Data access time is increased

  C. Data access control is increased

  D. Query compilation time is reduced
_____________________________________________________
Given the following table definitions:
PC
serial_num  INT  PRIMARY KEY
model_num   INT
owner_id    INT

EMPLOYEES
employee_num   INT NOT NULL
employee_name  CHAR(20)
   
and the query:
SELECT employee_name, serial_num
     FROM employees, pc
     WHERE owner_id = employee_num

Creating an index on which of the following may speed up this query?

  A. OWNER_ID

  B. SERIAL_NUM

  C. EMPLOYEE_NUM

  D. EMPLOYEE_NAME
__________________________________________________
Which of the following commands ensures that connected users will not have to wait for indexes to be recreated?

  A. UPDATE DB CFG USING INDEXREC access

  B. UPDATE DB CFG USING INDEXREC restart

  C. UPDATE DBM CFG USING INDEXREC system

  D. UPDATE DBM CFG USING INDEXREC immediate
__________________________________________________
Which of the following in a Visual Explain graph indicates that intra-partition parallelism is being used in the access plan?

  A. Sort table queues

  B. Local table queue

  C. Remote table queue

  D. Look-ahead table queue
_______________________________________________
Which of the following will capture explain snapshots for an embedded static SQL application?

  A. The EXPLAIN YES bind option

  B. The EXPLSNAP YES bind option

  C. The SET CURRENT EXPLAIN SNAPSHOT YES command

  D. The SET CURRENT EXPLAIN SNAPSHOT EXPLAIN command
_____________________________________________________
For messages written using the db2AdminMsgWrite API, the component listed in the notification log will be which of the following?

  A. User Function

  B. Application ID

  C. User Application

  D. Admin Message API
_____________________________________________________
Which of the following is a characteristic of creating a table using the IXF file format for data exported using a SELECT * statement?

  A. Check constraints are preserved

  B. Catalog statistics are preserved

  C. Primary key definitions are preserved

  D. Foreign key definitions are preserved