66.
How does Label Based Access Control(LBAC) provide more granular access control?
- A.By providing row level access control
- B.By providing rowest level access control
- C.By defining access roles in external systems
- D.By providinng both now level and column level access control.
- Answer
- Report
Answer : [D]
67.
How can a DMS table space be created in a database such that as more data is stored in it, it can automatically expand beyond its original file storage definition ?
- A.By using RESIZE in the CREATE TABLESPACE statement
- B.By using AUTORESIZE YES in the CREATE TABLESPACE statement.
- C.Only SMS table spaces can dynamically expand based on its underlying statement
- D.This feature is turned on automatically for DMS table spaces and can be disabled by RESIZE NO by the ALTER TABLESPACE statment
- Answer
- Report
Answer : [B]
68.
In an OLTP environment, if a query joins two tables on their primary key, which of the following join methods is preferred ?
- A.Hash join
- B.Star join
- C.Merge join
- D.Nested-loop join
- Answer
- Report
Answer : [D]
69.
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
- Answer
- Report
Answer : [B]
70.
A DBA takes a full backup of the PRODUCTS database every Sunday. During the week, two other backups are taken, one on Tuesday and one on Thursday. The weekly backup images are retained for two months. The PRODUCTS database is about 800 GB, and minimal updates to the dataase occur during the week. Assuming that storage costs are the primary concern, which of the following commands would produce the smallest image for Thursday's backup ?
- A.BACKUP DATABASE PRODUCTS TO /fs1/products/backup COMPRESS
- B.BACKUP DATABASE PRODUCTS INCREMENTAL TO /fs1/products/backup
- C.BACKUP DATABASE PRODUCTS TO /fs1/products/backup EXCLUDE LOGS
- D.BACKUP DATABASE PRODUCTS INCREMENTAL DELTA TO/fs1/products/backup
- Answer
- Report
Answer : [D]
|
|
||||||||||||||||||||||||||||
