Quiz
ICS121 CH5
This quiz has question types that open in the usual player.
Questions in this quiz (18)
1[blank_start]Data type[blank_end] - a detailed coding schemerecognized by system software.
- AData type
2[blank_start]Denormalization[blank_end] - Transforming normalized relations to non-normalized.
- ADenormalization
3[blank_start]Extent[blank_end] - Contiguous section of dsik space.
- AExtent
4[blank_start]Field[blank_end] - Smallest unit of application data recognizedby system software.
- AField
5[blank_start]File Organizations[blank_end] - technique for physically arranging reords of a file on secondary stage.
- AFile Organizations
6Hash index table - [blank_start]?[blank_end]
- A?
7Hashed file organizations - [blank_start]?[blank_end]
- A?
8[blank_start]Hashing algorithm[blank_end] - usually use division-remainder to determine record position.
- AHashing algorithm
9[blank_start]Horizontal Partitioning[blank_end] - Distribute rows of logical relation into several separate tables.
- AHorizontal Partitioning
10[blank_start]Index[blank_end] - a table or other data structure used to determine in a file the location of records that satisfy some condition.
- AIndex
11[blank_start]Indexed file organizations[blank_end] -storaged of records sequentially or non sequentially w/ an index that allows software to locate individual needs.
- AIndexed file organizations
12[blank_start]Join Index[blank_end] - popular in data warehouses.
- AJoin Index
13[blank_start]Physical File[blank_end] - a named portion of secondary memory allocated for the purpose of sorting physical records.
- APhysical File
14Pointer - [blank_start]?[blank_end]
- A?
15[blank_start]Secondary Key[blank_end] - other fields or combination of fields.
- ASecondary Key
16[blank_start]Sequential File Organization[blank_end] - always requires data to be stored.
- ASequential File Organization
17[blank_start]Tablespace[blank_end] - named logical storage unit in which data from multiple tabes/views/objects can be stored.
- ATablespace
18[blank_start]Vertical Partitioning[blank_end] - Distributing the columns of a logical relation int several separate tables.
- AVertical Partitioning
Information
- Description
- Quiz on ICS121 CH5, created by 2014068629 on 08/10/2015.
- Author
- 2014068629
- Language
- English
- Views
- 1
- Rating
- No ratings yet Rate this quiz