Q.1

Large collections of files are called

  • fields
  • records
  • databases
  • file system
  • None of the above
Q.2

Which of the following is not true of the traditional approach to information processing?

  • There is common sharing of data among the various applications
  • It is file-oriented
  • Programs are dependent on the files
  • It is inflexible
  • All of the above are true
Q.3

A data dictionary is a special file that contains

  • the names of all fields in all files
  • the data types of all fields in all files
  • the widths of all fields in all files
  • All of the above
  • None of the above
Q.4

Embedded pointer provide

  • a secondary access path
  • a physical record key
  • an inverted index
  • All of the above
  • None of the above
Q.5

In SQL, which command is used to select data in rows and column from one or more tables?

  • CHOOSE
  • SELECT
  • LIST
  • BROWSE
  • None of the above
Q.6

In SQL, which command is used to add a column/integrity constraint to a table

  • ADD COLUMN
  • INSERT COLUMN
  • MODIFY TABLE
  • ALTER TABLE
  • None of the above
Q.7

In SQL, the _____ command is used to recompile a view

  • COMPILE VIEW
  • DEFINE VIEW
  • CREATE VIEW
  • ALTER VIEW
  • None of the above
Q.8

One data dictionary software package is called

  • DB/DC dictionary
  • TOTAL
  • ACCESS
  • any of the above
  • None of the above
Q.9

A _____ Contains fields of data about one entity.

  • Record
  • File
  • Fields
  • Document
  • None of the above
Q.10

A condition that led to the development of databases was

  • a demand for more data to support information needs
  • an increase in the amount of data handled by organizations
  • the proliferation of data files
  • All of the above
  • None of the above.
Q.11

A logical schema

  • is the entire database
  • is a standard way of organizing information into accessible parts
  • describes how data is actually stored on disk
  • All of the above
  • None of the above
Q.12

Which command is used to select distinct subject (SUB) from the table (BOOK)?

  • SELECT ALL FROM BOOK
  • SELECT DISTINCT SUB FROM BOOK
  • SELECT SUB FROM BOOK
  • All of the above
  • None of the above
Q.13

The language used in application programs to request data from the DBMS is referred to as the

  • DML
  • DDL
  • query language
  • All of the above
  • None of the above
Q.14

The index consists of

  • a list of keys
  • pointers to the master list
  • both (a) and (b)
  • All of the above
  • None of the above
Q.15

Batch processing is appropriate if

  • a large computer system is available
  • only a small computer system is available
  • only a few transactions are involved
  • All of the above
  • None of the above
Q.16

A file that is organized in uniform format is formally referred to as a _____ or a database file.

  • Document
  • Database
  • Record
  • Structured data file
  • None of the above
Q.17

Which of the following is a type of DBMS software?

  • database manipulation language
  • query language
  • utilities
  • report writer
  • All of the above
Q.18

A scheme describes

  • data elements
  • records and files
  • record relationships
  • All of the above
  • None of the above
Q.19

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

  • ALTER TRIGGER
  • ALTER DATABASE
  • ALTER TABLE
  • MODIFY TRIGGER
  • All of the above
Q.20

A list in alphabetical order

  • is in descending order
  • is in ascending order
  • is the result of a sort operation
  • both (b) and (c)
  • None of the above
Q.21

One approach to standardizing storing of data

  • MIS
  • structured programming
  • CODASYL specifications
  • All of the above
  • None of the above
Q.22

The _____ command is used to allocates an extent for the table in SQL

  • MODIFY ALLOCATES
  • MODIFY TABLE
  • ALTER TABLE
  • REDEFINE TABLE
  • None of the above
Q.23

Queries to a database

  • are written in English
  • can use aggregate functions like SUM and COUNT
  • both (a) and (b)
  • All of the above
  • None of the above
Q.24

The master list of an indexed file

  • is sorted in ascending order
  • contains only a list of keys and record numbers
  • has a number assigned to each record
  • both (b) and (c)
  • None of the above
Q.25

What is the abbreviation used for a software package that permits the users to create, retrieve and maintain records in a database?

  • DASD
  • FMS
  • EMMS
  • DBMS
  • None of the above
Q.26

A form can be used to

  • modify records
  • delete records
  • format printed output
  • All of the above
  • None of the above
Q.27

Data items grouped together for storage purposes are called a

  • record
  • title
  • list
  • string
  • None of the above
Q.28

A report form

  • appears on the computer monitor during data entry
  • is used during report generation to format data
  • both (a) and (b)
  • All of the above
  • None of the above
Q.29

In a relational schema, each tuple is divided into fields called

  • Relations
  • Domains
  • Queries
  • All of the above
  • None of the above
Q.30

If a piece of data is stored in two places in the database, then

  • storage space is wasted
  • changing the data is one spot will cause data inconsistency
  • it can be more easily accessed
  • both (a) and (b)
  • None of the above
0 h : 0 m : 1 s