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)  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 
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)  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 
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 
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 
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 
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 
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 
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 
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 
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 
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 
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. 
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. 
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 
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 
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 
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 
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 
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

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

Files may be characterized by attributes such as ________.

Unicode ________.

Which of the following statements is true?

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

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

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

________ 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.

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

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

A block allocation scheme allocates files using ________.

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

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

Contiguous file allocation is most appropriate for ________.

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

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

The columns of a relation are known as ________.

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

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.

An inode stores ________.

Exploring Operating Systems and Distributed Computing: a Comprehensive Overview

Understanding Computer Systems and Programming Concepts

Understanding Processes and Threads in Operating Systems

Exploring Semaphores and Multithreading in Operating Systems

Exploring Thread Synchronization and Mutual Exclusion in Java

Concurrency and Deadlock in Database Systems: Exploring Monitor Implementation and Thread Synchronization in Java

Operating System Scheduling and Deadlock Prevention: a Comprehensive Guide

Understanding Processor Scheduling and Memory Management in Operating Systems

Memory Management in Operating Systems: Segmentation, Paging, and Strategies for Efficiency

Memory Management and Address Translation in Operating Systems

Memory Management and Page Replacement Strategies in Operating Systems

Disk Storage and Raid Technology

Exploring Performance Evaluation and Benchmarking in Computer Systems

Understanding Multiprocessor Organizations and System Performance

Understanding the Layers of the TCP/IP Protocol Stack

Understanding Distributed Systems and Operating Systems

Exploring Distributed File Systems and Grid Computing With NFS, AFS, Coda, and JXTA

Security Threats and Solutions in Cryptography and Access Control

Exploring the Linux Operating Systems Features and Functionality

In-Depth Analysis of Windows XP

Filters

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.

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

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