Question 1

Which of the following is not an advantage of using a database system?

Accepted Answer

A)   Databases are not susceptible to attack due to the centralized control and location of data.
B)   Databases help eliminate redundant data.
C)   Databases allow access to shared data.
D)   Databases organize data by content instead of by pathname. A

Question 2

Files may be characterized by attributes such as ________.

Accepted Answer

A)   size
B)   priority
C)   activity
D)   both a and c D

Question 3

Unicode ________.

Accepted Answer

A)   is the internationally recognized standard character set popular in Internet and multilingual applications
B)   contains a 64-bit version to support the Chinese character set
C)   is compatible with the EBCDIC character set
D)   all of the above A

Question 4

Which of the following statements is true?

Accepted Answer

A)   Tabular noncontiguous file allocation yields good performance only when the file system cache is large.
B)   Indexed noncontiguous file allocation allows the file system to locate any block of file by following a bounded, small number of pointers.
C)   Tabular and indexed noncontiguous file allocation exhibit faster lookup times than contiguous file allocations.
D)   none of the above

Question 5

Which type of backup would be best suited for a mission-critical system that modifies a small number of files between backups?

Accepted Answer

A)   frequent physical backup
B)   infrequent logical backup
C)   frequent incremental backup
D)   infrequent incremental backup

Question 6

A ________ is the number of bits a processor can operate on at once.

Accepted Answer

A)   cache line
B)   byte
C)   word
D)   register

Question 7

A ________ view of data is concerned with the layout of file data on a storage device.

Accepted Answer

A)   physical
B)   device
C)   logical
D)   symbolic

Question 8

________ typically are used when the sequence in which records are to be processed can be anticipated; ________ generally are used when the sequence in which records are to be processed cannot be anticipated.

Accepted Answer

A)   Queued access methods, basic access methods
B)   Sequential access methods, basic access methods
C)   Basic access methods, queued access methods
D)   Basic access methods, sequential access methods

Question 9

Which of the following lists elements of the data hierarchy in order from smallest to largest?

Accepted Answer

A)   record, field, file system, database
B)   field, record, file system
C)   word, byte, record
D)   word, record, field

Question 10

Public access rights, by default, typically allow users to ________.

Accepted Answer

A)   read, execute and write a file
B)   read a file, but not execute or write it
C)   read and write a file, but not execute it
D)   read and execute a file, but not write it

Question 11

A block allocation scheme allocates files using ________.

Accepted Answer

A)   individual sectors
B)   blocks of noncontiguous sectors
C)   blocks of contiguous sectors
D)   none of the above

Question 12

Because data is written ________ in an LFS, each write times generally ________ compared to traditional file systems.

Accepted Answer

A)   nonsequentially, increase
B)   nonsequentially, decrease
C)   sequentially, increase
D)   sequentially, decrease

Question 13

Large block sizes generally ________ the number of I/O operations required to access file data; small block sizes generally ________ the amount of internal fragmentation.

Accepted Answer

A)   increase, increase
B)   increase, reduce
C)   reduce, increase
D)   reduce, reduce

Question 14

Contiguous file allocation is most appropriate for ________.

Accepted Answer

A)   CD-RWs
B)   magnetic disk drives
C)   DVD-Rs
D)   Contiguous allocation is equally appropriate for all of the above.

Question 15

Which of the following statements accurately describes operating system support for databases?

Accepted Answer

A)   Most operating systems modify file system management, memory management and interprocess communication to support multiple databases.
B)   Databases are too complicated to merit operating system support.
C)   Most operating systems modify file system management, memory management and interprocess communication to support a single databases.
D)   DBMS designers tend to bypass operating system services in favor of their own.

Question 16

Which of the following lists presents user classes in order from least restrictive to most restrictive?

Accepted Answer

A)   group, owner, public
B)   public, group, owner
C)   owner, group, public
D)   public, owner, group

Question 17

The columns of a relation are known as ________.

Accepted Answer

A)   keys
B)   attributes
C)   results
D)   domains

Question 18

A ________ enables users to find data items in a database.

Accepted Answer

A)   query language
B)   data manipulation language
C)   data definition language
D)   all of the above

Question 19

Transaction-based logging reduces the risk of data loss by using ________ transactions, which perform a group of operations in their entirety, or not at all.

Accepted Answer

A)   shadow
B)   virtual
C)   exclusive
D)   atomic

Question 20

An inode stores ________.

Accepted Answer

A)   a file's attributes
B)   the addresses for some of a file's data blocks
C)   pointers to continuation index blocks
D)   all of the above

Exam 13: Understanding File Systems and Database Systems: a Comprehensive Overview