Question # 1

All of the following are components of physical database design EXCEPT:

Choose an answer

Data volume and usage anylisis

Data distribution strategy

File organization

Normalize the relations

An entity related to itself in an ERD model refers to

Choose an answer

recursive relationship

one-to-many relationship

many to many relationship

on to one relationship

An entity related to itself in an ERD model refers to :

Choose an answer

Recursive relationship

One-to-many relationship

Many-to-many relationship

One-to-one relationship

Relationship are

Choose an answer

uni-directional

bi-directional

tri-directional

none of these

Which of the following is basic data distribution strategy?

Choose an answer

Centralized

Partitioned

Replication

All

A technique for physically arranging the records of a file on secondary storage devices is called:

Choose an answer

Physical pointer

Retrieval program

File organization

Update program

An attribute is also known as:

Choose an answer

Table

Field

Row

Relation

A file is stored in:

Choose an answer

RAM

ROM

Cache

Hard disk

Which of the following are ingredients of data modeling?

Choose an answer

Entities

Attributes

Relationship

All

Which of the following is used to describe the characteristics of an object?

Choose an answer

Attribute

Relationship

Cardinality

Modality

Which of the following is used to associate entities with one another?

Choose an answer

Entity

Attribute

Identifier

Relationship

_______________ refers to a method of database distribution in which one database contains data that are included in another database.

Choose an answer

Splitting

Partitioning

Replication

Dividing

Which of the following activities are involved in data analysis?

Choose an answer

Data flow diagram

Decision Tables

Decision Trees

All

In a relational database a single piece of information is called:

Choose an answer

Table

Record

Entity

Attribute

Which key does not have uniqueness property?

Choose an answer

Candidate

Foreign key

Primary key

Secondary key

Object used to retrieve data from database is called:

Choose an answer

Forms

Repons

Queries

Tables

Local variables are also called:

Choose an answer

Automatic variables

Global variables

Grid Variables

None of these

In hybrid distribution, what types of fragments are stored at only one site?

Choose an answer

Critical fragments

Non-critical fragments

Critical and non-critical fragments

Only large fragments

More Classes

Other Links

ICS Part 2 Computer Science Chapter 3 Online Test 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

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer