Quiz
DBq8
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (20)
1 A(n) ________ is a routine that converts a primary key value into a record address.
- Arecord index calculator
- Bindex pointer program
- Chashing algorithm
- Dpointing algorithm
2 Database access frequencies are estimated from:
- Atransaction volumes.
- Buser logins.
- Csecurity violations.
- Drandom number generation.
3 A requirement to begin designing physical files and databases is:
- Anormalized relations.
- Bphysical tables created.
- Cimplementation complete.
- Dall datatypes determined.
4 A method that speeds query processing by running a query at the same time against several partitions of a table using multiprocessors is called:
- Amultiple partition queries.
- Bperpendicular query processing.
- Cparallel query processing.
- Dquery optimization.
5 Which type of file is most efficient with storage space?
- ASequential
- BHashed
- CIndexed
- DClustered
6 Designing physical files requires ________ of where and when data are used in various ways.
- Amaps
- Bdescriptions
- Ckeys
- Dhints
7 Which type of file is easiest to update?
- ASequential
- BHashed
- CIndexed
- DClustered
8 A form of denormalization where the same data are purposely stored in multiple places in the database is called:
- Adata duplication.
- Bdata replication.
- Cadvanced placement.
- Dhorizontal partitioning.
9 A file organization where files are not stored in any particular order is considered a:
- Ahashed file organization.
- Bhash key.
- Cmulti-indexed file organization.
- Dheap file organization.
10 A detailed coding scheme recognized by system software for representing organizational data is called a(n):
- ADBMS code.
- Bdata type.
- CSQL.
- DDB layout.
11 An appropriate datatype for one wanting a fixed-length type for last name would include:
- AVARCHAR.
- BCHAR.
- CBLOB
- DDATE.
12 In which type of file is multiple key retrieval not possible?
- ASequential
- BHashed
- CIndexed
- DClustered
13 The value a field will assume unless the user enters an explicit value for an instance of that field is called a:
- Adefault value.
- Bnull value.
- Crange control.
- Dgurand.
14 Which of the following is an objective of selecting a data type?
- ARepresent a small number of possible values
- BMaximize storage space
- CLimit security
- DImprove data integrity
15 An integrity control supported by a DBMS is:
- Asubstitute estimates.
- Bsecurity.
- Crange control.
- DGUI guards.
16 Within Oracle, the named set of storage elements in which physical files for database tables may be stored is called a(n):
- Aextent.
- Btable.
- Ctablespace.
- Dpartition.
17 A(n) ________ is a field of data used to locate a related field or record.
- Akey
- Bindex
- Clock
- Dpointer
18 Distributing the rows of data into separate files is called:
- Anormalization.
- Bhorizontal partitioning.
- Cvertical partitioning.
- Dfile allocation.
19 An appropriate datatype for adding a sound clip would be:
- AVARCHAR.
- BCHAR.
- CBLOB.
- DDATE.
20 The smallest unit of application data recognized by system software is a:
- Afield.
- Brow
- Cdata type
- Dcolumn
Information
- Description
- Quiz on DBq8, created by Jose Martinez on 01/05/2022.
- Author
- Jose Martinez
- Language
- English
- Views
- 0
- Tags
- Rating
- No ratings yet Rate this quiz