Q.1

What software packages are commonly used for businesses that have to track extensive lists of clients and inventory?

  • Special purpose packages
  • Custom made programs
  • Single function application packages
  • Data management packages
  • None of the above
Q.2

In order to use a record management system

  • You need to understand the low-level details of how information in stored
  • You need to understand the model the record management system uses.
  • Both (a) and (b)
  • All of the above
  • None of the above
Q.3

Which of the following is not the responsibility of the utilities component of DBMS software?

  • creating the physical and logical designs
  • removing flagged records for deletion
  • creating and maintaining the data dictionary
  • monitoring performance
  • None of the above
Q.4

Which of the following is not an advantage of the data-base approach?

  • elimination of the data redundancy
  • ability to associate related data
  • increased security
  • program/data independence
  • All of the above are advantages
Q.5

Which language has recently become the de-facto standard for interfacing application programs with relational database system?

  • Oracle
  • SQL
  • dBASE
  • 4GL
  • None of the above
Q.6

The activity of a file

  • is a low percentages of number of records added or deleted from a file
  • if high, reduces processing efficiency for sequential and nonsequential files
  • is a measure of the percentage of existing records updated during a run
  • refers to how closely the files fits into the allocated
  • None of the above.
Q.7

A computer file can be best described as

  • a single data item
  • a general collection of data items
  • an orderly collection of data items
  • a random collection of data items
  • None of the above
Q.8

A data dictionary doesn't provide information about:

  • where data is located
  • the size of the disk storage device
  • It allows a many-to-many relationship
  • It is conceptually simple
  • It will be the dominant data base of the future
Q.9

In SQL, the CREATE TABLE is used

  • to create a table, defining its columns, integrity constrains, and storage allocation
  • to add a column/integrity constraint to a table
  • to redefine a column
  • to change a table's storage characteristics
  • All of the above
Q.10

Versatile report generators can provide

  • Columnar totals
  • Subtotals
  • Calculations
  • All of the above
  • None of the above
Q.11

A good query system

  • can accept English language commands
  • allows non-programmers to access information stored in a database
  • can be accessed only by data processing professionals
  • both (a) and (b)
  • None of the above
0 h : 0 m : 1 s