Q.1

In a large DBMS

  • each user can "see" only a small part of the entire database
  • each user can access every sub¬schema
  • each subschema contains every field in the logical schema
  • All of the above
  • None of the above
Q.2

Goals for the design of the logical schema include

  • avoiding data inconsistency
  • being able to construct queries easily
  • being able to access data efficiently
  • All of the above
  • None of the above
Q.3

An-owner-member set in the CODASYL specifications may have

  • only one owner but many owner occurrences
  • only one member but many member occurrence
  • more than one member but only one occurrence per member
  • All of the above
  • None of the above
Q.4

What is the name given to the database management system which is able to handle full text data, image data, audio and video?

  • Full media
  • Graphics media
  • Multimedia
  • Hypertext
  • None of the above
Q.5

Information can be transferred between the DBMS and a

  • spreadsheet program
  • word processor program
  • graphics program
  • All of the above
  • None of the above
Q.6

Data integrity control

  • is used to set upper and lower limits on numeric data
  • requires the use of passwords to prohibit unauthorized access to the file
  • has the data dictionary keep the date and time of last access last back-up, and most recent modification for all files
  • All of the above
  • None of the above
Q.7

In SQL, which command is used to add new rows to a table?

  • ALTER TABLE
  • ADD ROW
  • INSERT
  • APPEND
  • None of the above
Q.8

If a calculation is embedded in a form

  • the result of the calculations are stored with the form
  • the calculations are stored with the form
  • the result of the calculations are printed in report
  • All of the above
  • None of the above
Q.9

A network schema

  • restricts the structure to a one-to-many relationship
  • permits many-to-many relation¬ships
  • stores data in tables
  • All of the above
  • None of the above
Q.10

To have a file hold a list, it is necessary to

  • identify the records in the list
  • identify the name, width and type of the fields of each record.
  • decide which fields will be used as sort or index keys
  • All of the above
  • None of the above
Q.11

The logical data structure with a one-to-many relationship is a :

  • network
  • tree
  • chain
  • relational
  • None of the above
Q.12

Primitive operations common to all record management systems include

  • Print
  • Sort
  • Look-up
  • All of the above
  • None of the above
Q.13

Which of the following command(s) is(are) used to recompile a stored procedure in SQL?

  • COMPILE PROCEDURE
  • ALTER PROCEDURE
  • MODIFY PROCEDURE id) All of the above
  • None of the above
Q.14

A top-to-bottom relationship among the items in a database is established by a

  • Hierarchical schema
  • Network schema
  • Relational schema
  • All of the above
  • None of the above
Q.15

A number of related records that are treated as a unit is called

  • file
  • field
  • data
  • batch
  • None of the above
Q.16

Which of the following is not a relational database?

  • dBASE IV
  • 4th Dimension
  • FoxPro
  • Reflex
  • None of the above
Q.17

Sophisticated report generators can

  • print row-oriented reports
  • perform arithmetic operations
  • selectively retrieve and print portions of a list
  • All of the above
  • None of the above
Q.18

Updating a database means

  • revising the file structure
  • reorganizing the database
  • modifying or adding record occurrences
  • All of the above
  • None of the above
Q.19

In SQL, which command(s) is(are) used to enable/disable all triggers on a table?

  • ALTER TRIGGERS
  • ALTER TABLE
  • MODIFY TRIGGERS IN TABLE
  • All of the above
  • None of the above
Q.20

Each of data files has a _____ that describe the way the data is stored in the file.

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

Internal auditors should review data system design before they are

  • developed
  • implemented
  • modified
  • All of the above
  • None of the above
Q.22

After you _____ a record, many data management the environments require you to issue a command to save the changes you made.

  • Delete
  • Update
  • Sort key
  • Index
  • None of the above
Q.23

Sort/report generators

  • are faster than index/report generators
  • require more disk space than index/report generators
  • do not need to sort before generating a report
  • both (a) and (b)
  • None of the above
Q.24

What is the language used by most of the DBMSs for helping their users to access data?

  • High level language
  • Query language
  • SQL
  • 4GL
  • None of the above
Q.25

Data item characteristics that are important in data management include

  • punctuation
  • language
  • spelling
  • width
  • None of the above
Q.26

The data dictionary tells the DBMS

  • what files are in the database
  • what attribute are possessed by the data
  • what these files contain
  • All of the above
  • None of the above
Q.27

In SQL, which command(s) is(are) used to enable/disable a database trigger?

  • MODIFY USER
  • CHANGE USER
  • ALTER TRIGGER
  • All of the above
  • None of the above
Q.28

Which command is used to remove a table from the database in SQL?

  • DELETE TABLE
  • DROP TABLE
  • ERASE TABLE
  • UNATTACH TABLE
  • None of the above
Q.29

In SQL, the CREATE VIEW command is used

  • to recompile view
  • to define a view of one or more tables or views
  • to recompile a table
  • to create a trigger
  • None of the above
Q.30

A database management system might consist of application programs and a software package called

  • FORTRAN
  • AUTOFLOW
  • BPL
  • TOTAL
  • None of the above
0 h : 0 m : 1 s