IBM Certification Question: Download IBM Certification PDF

Explain What are three advantages of fragmentation?

A. higher availability
B. reduced disk space requirements
C. parallel scans are possible with PDQ
D. finer granularity of archives and resources

A.higher availability

Previous Question	Next Question
Explain 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.	Explain With database logging, where are transaction records first placed? A. in a temporary database table B. in the logical log buffer C. in the primary chunk D. in the physical buffer