Ready to test your Knowledge?
Try out our new practice tests completely free!
exam preparation banner icon

Modern Database Management Study Set 2

Computing

Quiz 8 :

Physical Database Design and Database Infrastructure

Quiz 8 :

Physical Database Design and Database Infrastructure

search
arrow
While Oracle has responsibility for managing data inside a tablespace, the tablespace, as a whole, is managed by the:
Free
Multiple Choice
Answer:

Answer:

D

Tags
Choose question tag
close menu
arrow
A requirement to begin designing physical files and databases is:
Free
Multiple Choice
Answer:

Answer:

A

Tags
Choose question tag
close menu
arrow
The storage format for each attribute from the logical data model is chosen to maximize ________ and minimize storage space.
Free
Multiple Choice
Answer:

Answer:

C

Tags
Choose question tag
close menu
arrow
Database access frequencies are estimated from:
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
In which data model would a code table appear?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
A method for handling missing data is to:
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Sensitivity testing involves:
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
An integrity control supported by a DBMS is:
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
A key decision in the physical design process is:
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Within Oracle, the named set of storage elements in which physical files for database tables may be stored is called a(n):
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
The smallest unit of application data recognized by system software is a:
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Designing physical files requires ________ of where and when data are used in various ways.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
A contiguous section of disk storage space is called a(n):
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
All of the following are objectives when selecting a data type EXCEPT:
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
The value a field will assume unless the user enters an explicit value for an instance of that field is called a:
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
A detailed coding scheme recognized by system software for representing organizational data is called a(n):
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Which of the following is an objective of selecting a data type?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
An appropriate datatype for one wanting a fixed-length type for last name would include:
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
All of the following are valid datatypes in Oracle 12c EXCEPT:
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
An appropriate datatype for adding a sound clip would be:
Multiple Choice
Answer:
Tags
Choose question tag
close menu
Showing 1 - 20 of 167