EJECT is used for creating a new page in the compiler listing.
True
False
For successful execution of REWRITE stmt, the direct access file must be opened in _____ mode.
I
O
I-O
O-I
ASCENDING/DESCENDING KEY data item cannot be floating point items.
The SYNCHRONIZED LEFT / RIGHT clause which specifies alignment of elementary data item on storage boundary can be specified for data items defined with USAGE IS INDEX.
The maximum size of a Tablespace can be
64 Gb
32 Gb
8 Kb
4 Kb
Which one is not a pre-compile parameter
Level
Host()
APost
Time
Which parameter decides the allocation size for the tablespace
Numpart
SegSize
Both 1 & 2
None of the above
________is a collection of direct access volumes all of the same device type.
Storage Group
Database
Synonym
view
________means another name for the table, but is private to the user who created it.
Aliases
Opens all tablespaces and acquires all tablespace locks when the plan is allocated
ACQUIRE(USE)
ACQUIRE(ALLOCATE)
RELEASE(COMMIT)
RELEASE(DEALLOCATE)