Managing and Optimizing Informix
Dynamic Server Databases
Exam Questions, Answers,
I think it was tough but thanks to www.examcheats.net
. I purchased their study material and got through.
The stuff had drag and drops, exhibits and all that
is required for the exam.
Where are table spaces (tblspaces) created?
A. in dbspaces
B. in pages
C. in extents
D. in chunks
What is database administration NOT concerned with?
B. creating tables
C. accessing data
D. application building
Disk space for a table is allocated in one or more units
What is a chunk when using raw devices?
A. a contiguous unit of disk space
B. a dynamic unit of disk space
C. a location in shared memory
D. a data table
Which statement correctly changes the next extent size?
A. ALTER TABLE customer MODIFY NEXT SIZE 300
B. ALTER TABLE customer MODIFY NEXT EXTENT SIZE 300.
C. ALTER TABLE customer MODIFY EXTENT SIZE 300
D. ALTER TABLE customer NEXT SIZE 300
What is the system catalog?
A. A catalogued set of index criteria
B. A set of tables created by the administrator.
C. A set of tables that managed the operating system
D. A set of tables that describe the structure of the
With database logging, where are transaction records
A. in a temporary database table
B. in the logical log buffer
C. in the primary chunk
D. in the physical buffer
Where is fragment information stored?
A. in the system catalog tables
B. in the physical logs
C. in the reserved pages
D. in the first page of the database tblspace
Which two types of fragmentation are allowed in a CREATE
A. disk striping
D. round robin
Why is a hash function advantageous in an expression-based
A. Because it creates an even distribution of data.
B. Because it creates an unevn distribution of data.
C. Because it does not do expression testing
D. Because it places all data in one dbspace.
Which two happen when the ALTER FRAGMENT statement is
A. Transaction logging, if present is suspended.
B. The table is locked until the statement is completed.
C. The database is locked until the statement is complete.
D. For databases with logging the statement executes
as a single transaction
Which fragments an index by expression?
A. FRAGMENT BY EXPRESSION col_1
B. FRAGMENT BY EXPRESSION col_2>=10000IN dbspace
1 AND col_2>10000IN dbspace2
C. FRAGMMENT BY EXPRESSION col_1<10000 AND col_2
IN dbspace 2
D. FRAGMENT BY EXPRESSION col <20000 IN dbspace 1,
col> = 20000 IN dbspace 2
What are four valid logical and relational operators
that can be used with expression-based distribution?
In which two situations would you use a round robin
A. When all fragments must be second
B. To create uneven data distributions
C. When queries perform sequential scans and you have
little information about the data being stored.
D. When tables are accessed with a high degree of selectivity