Question # 1

_______________ 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 is NOT included in the definition of an entity?

Choose an answer

Person

Object

Concept

Action

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 basic data distribution strategy?

Choose an answer

Centralized

Partitioned

Replication

All

An advantage of partitioning is:

Choose an answer

Efficiency

Extra space

Reliabilty

Accuracy

Which of the following activities are involved in data analysis?

Choose an answer

Data flow diagram

Decision Tables

Decision Trees

All

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

A file is stored in:

Choose an answer

RAM

ROM

Cache

Hard disk

Format specifier starts with the symbol

Choose an answer

#

%

*

all

A data model is :

Choose an answer

A logical representation of the structure of the database

Shown as an entity-relationship diagram

Transformed into tables and relationships

All

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

The number of variables that can be used in printf ( ) function are

Choose an answer

one

many

three

zero

Which is used to display yes/no values:

Choose an answer

Check box

Option buttons

Both a & b

None of these

Escape sequence starts with the character

Choose an answer

%

/

#

none

The relationship can be:

Choose an answer

One-to-one

One-to-many

Many-to-many

All

Which of the following are ingredients of data modeling?

Choose an answer

Entities

Attributes

Relationship

All

The function clrscr ( ) is defined in

Choose an answer

stdio.h

math.h

canio.h

graphic.h

Getch stands for:

Choose an answer

Go character

Give character

Get character

All of these

Which of the following is basic data distribution strategy?

Choose an answer

Centralized

Partitioned

Replication

All

An index may be created on:

Choose an answer

Primary key

Secondary key

Foreign key

All

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

Choose an answer

Entity

Attribute

Identifier

Relationship

-------------------- defines the nature of the relationship

Choose an answer

cardinality

entities

modality

none of these

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

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

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer