Q.1

A _____ means that one record in a particular record type is related to only one record of another record type.

  • One-to-one relationship
  • One-to-many relationship
  • Many-to-one relationship
  • Many-to-many relationship
  • None of the above
Q.2

In SQL, which command(s) is(are) used to create a synonym for a schema object?

  • CREATE SCHEMA
  • CREATE SYNONYM
  • CREATE SAME
  • All of the above
  • None of the above
Q.3

The model for a _____ resembles the hierarchical model in many respects.

  • Network database
  • Relational database
  • Distributed database
  • Hierarchical database
  • None of the above
Q.4

In SQL, the CREATE TABLESPACE is used

  • to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace
  • to create a database trigger
  • to add/rename data files, to change storage
  • All of the above
  • None of the above
Q.5

In SQL, which command is used to make permanent changes made by statements issue since the beginning of a transaction?

  • ZIP
  • PACK
  • COMMIT
  • SAVE
  • None of the above
Q.6

Periodically adding, changing and deleting file records is called file

  • Updating
  • upgrading
  • restructuring
  • renewing
  • None of the above
Q.7

If the record management system allows you to edit values before they are recorded on disk, you can

  • correct spelling changes before they are recorded
  • change the name of a field
  • change the width of a field
  • All of the above
  • None of the above
Q.8

The relational model uses some unfamiliar terminology. A tuple is equivalent to a:

  • record
  • field
  • file
  • data base
  • data item
Q.9

A large computer information system maintains many different computer files. Which amongst them is called a perpetual file?

  • Specialized file
  • Log file
  • Master file
  • Update file
  • None of the above
Q.10

A file produced by a spreadsheet

  • is generally stored on disk in an ASCII text format
  • can be used as it by the DBMS
  • can be used for graphic
  • All of the above
  • None of the above
Q.11

A ____ Contains the smallest unit of meaningful data, so you might call it the basic building block for a data file.

  • File structure
  • Records
  • Fields
  • Database
  • None of the above
Q.12

In the DBM approach, application programs perform the

  • storage function
  • processing functions
  • access control
  • All of the above
  • None of the above
Q.13

An audit trail

  • is used to make back-up copies
  • is the recorded history of operations performed on a file
  • can be used to restore lost information
  • All of the above
  • None of the above
Q.14

A race condition occurs when

  • Two concurrent activities interact to cause a processing error
  • two users of the DBMS are interacting with different files at the same time
  • both (a) and (b)
  • All of the above
  • None of the above
Q.15

A _____ database does not use pointers or physical links, but instead finds related records by examining the contents of fields.

  • Network
  • Hierarchical
  • Relational
  • Object-Oriented
  • None of the above
Q.16

If you want your database to include methods, you should use a _____ database.

  • Network
  • Distributed
  • Hierarchical
  • Object-Oriented
  • None of the above
Q.17

A set of programs that handle a firm's data base responsibilities is called a

  • Data Base Management System (DBMS)
  • Data Base Processing System (DBPS)
  • Data Management System (DMS)
  • All of the above
  • None of the above
Q.18

In SQL, which command is used to remove a stored function from the database?

  • REMOVE FUNCTION
  • DELETE FUNCTION
  • DROP FUNCTION
  • ERASE FUNCTION
  • None of the above
Q.19

A form defines

  • where data is placed on the screen
  • the width of each field
  • both (a) and (b)
  • All of the above
  • None of the above
Q.20

In SQL, which command is used to create a database user?

  • ADD USER TO DATABASE
  • MK USER
  • CREATE USER
  • All of the above
  • None of the above
Q.21

An indexing operation

  • sorts a file using a single key
  • sorts file using two keys
  • establishes an index for a file
  • both (b) and (c)
  • None of the above
Q.22

In SQL, which command(s) is(are) used to redefine an index's future storage allocation

  • ALTER INDEX
  • REDEFINE INDEX
  • MODIFY INDEX
  • DO INDEX
  • None of the above
Q.23

Which of the following is a serious problem of file management systems?

  • difficult to update
  • lack of data independence
  • data redundancy
  • program dependence
  • All of the above
Q.24

In SQL, which of the following is not a data Manipulation Language Commands?

  • DELETE
  • SELECT
  • UPDATE
  • CREATE
  • None of the above
Q.25

Which of the following is not characteristic of a relational database model?

  • tables
  • treelike structure
  • complex logical relationships
  • records
  • None of the above
Q.26

In any hierarchy of data organization, the smallest entity to be processed as a single unit is called

  • data field
  • data record
  • data file
  • database
  • None of the above
Q.27

Long-range planning report produced in an MIS are primarily designed for

  • top management
  • middle management
  • lower management
  • All of the above
  • None of the above
Q.28

The database administration function includes

  • application programming
  • computer operations management
  • database access planning
  • All of the above
  • None of the above
Q.29

Which of the following is true of a network structure?

  • It is a physical representation of the data
  • It allows a many-to-many relationship
  • It is conceptually simple
  • It will be the dominant data base of the future
  • None of the above
Q.30

When performing a look-up operation using a form

  • you enter the search value into the form
  • you look at each form sequentially until you see the one you want
  • you type the key in an entry line, and the correct form is displayed
  • All of the above
  • None of the above
0 h : 0 m : 1 s