Nt1330 Unit 1 Study Guide

31. Which level of RAID refers to disk mirroring with block striping?
a) RAID level 1
b) RAID level 2
c) RAID level 0
d) RAID level 3
Answer: a

32. A unit of storage that can store one or more records in a hash file organization is denoted as
a) Buckets
b) Disk pages
c) Blocks
d) Nodes

Answer: a
33. The file organization which allows us to read records that would fulfill the join condition by using one block read is
a) Heap file organization
b) Consecutive file organization
c) Clustering file organization
d) Hash file organization
Answer: c

34. What are the exact features of a distributed database?
a) Is always connected to the internet
b) Always requires more than three machines
c) Users see the data in one global schema.
d) Have to require the physical location of the data when an update is done

Each table space in an Oracle database consists of one or more files called
a) Records
b) name space
c) data files
d) PFILE
Answer: c

36. The management information system (MIS) structure with one main computer system is called a
a) Ordered MIS structure
b) Scattered MIS structure
c) Centralized MIS structure
d) Decentralized MIS structure
Answer: c

37. A top-to-bottom relationship among the items in a database is recognized by a
a) Hierarchical schema
b) Network schema
c) Relational schema
d) None of the above
Answer: a

38. Which one of the following RDBMS supports full-fledged client server application development?
a) dBase V
b) Oracle 7.1
c) FoxPro 2.1
d) Ingress
Answer: b
39. Choose one approach to standardization storing of data?
a) MIS
b) Organized