Question # 1

The type of expression x > y is

Choose an answer

arithmetic

logical

relational

conditional

Which form of dependency is removed n 3NF?

Choose an answer

Functional

Non-functional

Associative

Transitive

Which is a possible value of flag?

Choose an answer

-

+

Space

All of these

A rule that states each foreign key value must match a primary key value in the other relation is called:

Choose an answer

Referential integrity constraints

Key match rule

Entity key group rule

Foreign/ primary match rule

The scope of a variable refers to its:

Choose an answer

Length

Name

Accessibility

Data type

Which are basic data distribution strategies?

Choose an answer

Centralized

Partitioned

Replication

All

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 program structure that executes program statements in order is

Choose an answer

selection

sequence

repetition

iteration

Database integrity refers to the

Choose an answer

correctness of data

consistency of data

both a and b

none of these

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

Choose an answer

Insertion

Deletion

Modification

All

Which can be previewed on the screen before printing?

Choose an answer

Report

Form

Sub-form

None

Any array script should be:

Choose an answer

Int

Float

Double

Array

C was developed in the year:

Choose an answer

1970

1972

1976

1995

A constraint between two attributes is called:

Choose an answer

Functional relation

Attribute dependency

Functional dependency

Functional relation constaint

The entity integrity rule states that:

Choose an answer

No primary key attribute can be null

Each entity must have a primary key

Primary key must have only one attribute

None

------------------- is created when two different names are used for the same information

Choose an answer

synonyms

homonyms

mutually exclusive data

redundant information

A functional dependency between two or more non-key attributes is called:

Choose an answer

Partial functional dependency

Partial non-key dependency

Transitive dependency

None

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

Choose an answer

Choose an answer

Choose an answer