Question # 1

Which of the following is incorrect with respect to indexed sequential files?

Choose an answer

New records are added to an overflow file

Record in main file that precedes it is updated to contain a pointer to the new record

The overflow is merged with the main file during a batch update

Multiple indexes for the same key field cannot be setup

In a conceptual model for a university, what type of relationship exists between Grade and Student entitie

Choose an answer

1:1

1:M

M:M

Ternary

Which of the following is not a feature of TRANSACTION?

Choose an answer

Users should be able to regard the execution of each transaction as atomic

Each transaction, run by itself

must preserve the consistency of the database

dependant on other concurrent transactions

______ is a control that presents a set of choices from which a user can select one or more items; items can be text, graphics, or both.

Choose an answer

Text input

Report

Button

List box

Which of the following is INCORRECT statement concerning the database design process?

Choose an answer

During requirements collection and analysis phase, one can gather the data requirements of database users.

By referring to a high level data model, it is possible to understand the data requirements of the users, entity types, relationships and constraints.

Transformation of the high level data model into the implementation data model is called logical design or data model mapping

During the logical design phase of internal storage structures, access paths and file organization for the database files are specified.

Which of the following is correct regarding Dataflow diagram?

Choose an answer

Single DFD is required to represent a system

The dataflow must be bidirectional

Created at increasing levels of detail

Used to represent the relationships among the external entities

Which of the following is NOT a feature of Context DFD?

Choose an answer

one process (which represents the entire system)

all sources/sinks (external entities)

data flows linking the process to the sources and sinks (external entities)

sub-processes (which explain and decomposed the major process into small processes)

Who is responsible for authorizing access to the database, for coordinating and monitoring its use ?

Choose an answer

Database Designers

Database Administrators

End Users

Application Programmers

Consider two sets A and B. A contains 2 elements and B contains 3. How many elements do their cartesian product contains?

Choose an answer

6

9

5

4

Which of the following is disadvantage of chaining technique to handle the collisions?

Choose an answer

Unlimited Number of elements

Fast re-hashing

Overhead of multiple linked lists

Maximum number of elements must be known

Which of the following is not true about De-normalization?

Choose an answer

It is the process of attempting to optimize the performance of a database

De-normalization is a technique to move from lower to higher normal forms of database modeling

It enhances the performance of DB

In de-normalization it is required to add redundant data.

More Classes

Other Links

CS-403 Final Term Exams Preparation Virtual University MCQs With Answers

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer