PrepAway - Latest Free Exam Questions & Answers

Which statement about SMS table spaces is correct?

Which statement about SMS table spaces is correct?

PrepAway - Latest Free Exam Questions & Answers

A.
The system catalog cannot be stored in an SMS table space.

B.
Tables, large objects (LOBs), and indexes can each reside in separate SMS table spaces.

C.
SMS table spaces are recommended when you have small tables that are not likely to grow
quickly.

D.
Extents are more likely to be contiguous with SMS table spaces than they are with DMS table
spaces.

Explanation:


Leave a Reply