Sequential retrieval on a primary key for sequential file storage has which of the following features? Slow Very fast Impractical Moderately fast TRUE ANSWER : ? YOUR ANSWER : ?
When storage space is scarce and physical records cannot span pages, creating multiple physical records from one logical relation will minimize wasted storage space. False True TRUE ANSWER : ? YOUR ANSWER : ?
What is the best data type definition for Oracle when a field is alphanumeric and has a fixed length? CHAR NUMBER LONG VARCHAR2 TRUE ANSWER : ? YOUR ANSWER : ?
Data-volume and frequency-of-use statistics are not critical inputs to the physical database design process. True False TRUE ANSWER : ? YOUR ANSWER : ?
What is the best data type definition for Oracle when a field is alphanumeric and has a length that can vary? CHAR VARCHAR2 LONG NUMBER TRUE ANSWER : ? YOUR ANSWER : ?
A pointer is a detailed coding scheme recognized by system software for representing organizational data. True False TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following is not a factor to consider when switching from small to large block size? The length of all of the fields in a table row Block contention The number of columns Random row access speed TRUE ANSWER : ? YOUR ANSWER : ?
It is usually not very important to design the physical database to minimize the time required by users to interact with the information systems. True False TRUE ANSWER : ? YOUR ANSWER : ?
Hashing algorithm converts a primary key value into a record address. True False TRUE ANSWER : ? YOUR ANSWER : ?
Two basic constructs to link one piece of data with another piece of data: sequential storage and pointers. False True TRUE ANSWER : ? YOUR ANSWER : ?