Question # 1

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

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

Choose an answer

diamond symbol

rectangular box

oval symbol

line

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

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

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

Choose an answer

Table

Record

Entity

Attribute

Relationship are

Choose an answer

uni-directional

bi-directional

tri-directional

none of these

Types of translators are:

Choose an answer

Compiler

Interpreter

Assembler

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

An attribute is also known as:

Choose an answer

Table

Field

Row

Relation

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

Object used to retrieve data from database is called:

Choose an answer

Forms

Repons

Queries

Tables

Getch stands for:

Choose an answer

Go character

Give character

Get character

All 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

Conditional operator is alternative of:

Choose an answer

If

If-else

Nested if-else

None of these

In a loop semicolon is placed at the end of condition:

Choose an answer

While

For

Do-while

None of these

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

Choose an answer

Attribute

Relationship

Cardinality

Modality

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