Question # 1

In relational database, table is also called:

Choose an answer

Table

Relation

File

Schema

How many types of loop structure are available in C?

Choose an answer

4

3

2

6

A relation is in 2NF if it is in 1NF and all its non-key attributes are:

Choose an answer

Dependent on part of the primary key

Dependent on the entire primary key

Independent on the primary key

Independent of any other relation

How many table views are available in MS Access?

Choose an answer

1

3

2

4

Which can be previewed on the screen before printing?

Choose an answer

Report

Form

Sub-form

None

A relation is in third normal form if it is in second normal form and:

Choose an answer

Dependent on part of the key

Dependent on the whole key

Independent of the key

Has no transitive dependencies

Which of the following is a decision making statement

Choose an answer

break

getch ( )

if

all

The attribute on the left side of the arrow in a functional dependency is called:

Choose an answer

Candidate key

Determinant

Foreign key

Primary key

Which form of dependency is removed in 2NF?

Choose an answer

Functional

Transitive

Associative

Partial

The 1NF describes the tabular format in which:

Choose an answer

All the key attributes are defined

No repeating groups in the table

All attributes are dependent on primary key

All

Two or more attributes with different name but same meaning create a problem:

Choose an answer

Homonyms

Synonyms

Aliases

Alternate attributes

The scope of a variable refers to its:

Choose an answer

Length

Name

Accessibility

Data type

Which object of database is used to retrieve data from database?

Choose an answer

Queries

Forms

Reports

Tables

Which are basic data distribution strategies?

Choose an answer

Centralized

Partitioned

Replication

All

Which of the following are anomalies that can be caused by redundancy in tables?

Choose an answer

Insertion

Deletion

Modification

All

More Classes

Other Links

ICS Part 2 Computer Science Chapter 4 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