Question # 1

In ERD model, the relationship between two entities is represented by a

Choose an answer

diamond symbol

rectangular box

oval symbol

line

An advantage of partitioning is:

Choose an answer

Efficiency

Extra space

Reliabilty

Accuracy

Which key does not have uniqueness property?

Choose an answer

Candidate

Foreign key

Primary key

Secondary key

Getch stands for:

Choose an answer

Go character

Give character

Get character

All of these

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

Conditional operator is also called:

Choose an answer

True operator

Ternary-operator

Truth operator

All of these

Which of the following is NOT included in the definition of an entity?

Choose an answer

Person

Object

Concept

Action

A \t is used for:

Choose an answer

New line

Tab

Back space

None of these

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 function clrscr ( ) is defined in

Choose an answer

stdio.h

math.h

canio.h

graphic.h

The output of the statement print ("%2f', 11.4519), is

Choose an answer

11.4519

11.45

11.51

11

Data type int contain bytes:

Choose an answer

10

4

2

1

Which of the following is a valid format specifier

Choose an answer

%10d

%7.2f

%-7f

all

_______________ refers to a method of database distribution in which different portions of database reside at different nodes in the network.

Choose an answer

Spliting

Partitioning

Replication

Dividing

An index may be created on:

Choose an answer

Primary key

Secondary key

Foreign key

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

on to one relationship

Which of the following is basic data distribution strategy?

Choose an answer

Centralized

Partitioned

Replication

All

Which component of physical database design refers to the consistency of data?

Choose an answer

Indexes

Integrity constaint

File organization

Data distribution strategy

More Classes

Other Links

Computer Science Ics Part 2 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