Question # 1

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 person's name, birthday and social security number are examples of:

Choose an answer

Attributes

Entities

Relationships

Descriptors

The relationship can be:

Choose an answer

One-to-one

One-to-many

Many-to-many

All

Every relation must have:

Choose an answer

Primary key

Candidate key

Secondary key

All of these

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

Object used to retrieve data from database is called:

Choose an answer

Forms

Repons

Queries

Tables

Which key does not have uniqueness property?

Choose an answer

Candidate

Foreign key

Primary key

Secondary key

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

Choose an answer

diamond symbol

rectangular box

oval symbol

line

Which of the following activities are involved in data analysis?

Choose an answer

Data flow diagram

Decision Tables

Decision Trees

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

Escape sequence starts with the character

Choose an answer

%

/

#

none

Format specifier starts with the symbol

Choose an answer

#

%

*

all

Organizing the database in computer disk storage is done in:

Choose an answer

Logical design

Physical design

Analysis

Implimentation

An disadvantage of partitioning is:

Choose an answer

Complexity

Extra space and update time

Inconsistent access speed

All

Which of the following are ingredients of data modeling?

Choose an answer

Entities

Attributes

Relationship

All

Which of the following key does not hold uniqueness property ?

Choose an answer

candidate key

foreign key

primary key

Secondary key

Which of the following is basic data distribution strategy?

Choose an answer

Centralized

Partitioned

Replication

All

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

Choose an answer

Person

Object

Concept

Action

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

Data type int contain bytes:

Choose an answer

10

4

2

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

Customers,cars and parts are examples of:

Choose an answer

Entities

Attributes

Cardinals

Relashionships

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