Question # 1

Which is a possible value of flag?

Choose an answer

-

+

Space

All of these

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

Choose an answer

Queries

Forms

Reports

Tables

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

In 2NF, which form of dependency is removed ?

Choose an answer

associative

transitive

partial

functional

------------ is a constraint on primary values that states that no attribute of a primary key should contain nulls

Choose an answer

referential integrity

entity integrity

normalization

acronyms

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

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

Choose an answer

Homonyms

Synonyms

Aliases

Alternate attributes

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

Choose an answer

synonyms

homonyms

mutually exclusive data

redundant information

Any array script should be:

Choose an answer

Int

Float

Double

Array

The goal of normalization is to:

Choose an answer

Get stable data structure

Increase number of relation

Increase redundancy

Remove constraints

------------- is the process of converting complex data structures into simple and stable data structures

Choose an answer

database integrity

homonyms

normalization

mutually exclusive data

How many types of loop structure are available in C?

Choose an answer

4

3

2

6

Which can be previewed on the screen before printing?

Choose an answer

Report

Form

Sub-form

None

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

A constraint between two attributes is called:

Choose an answer

Functional relation

Attribute dependency

Functional dependency

Functional relation constaint

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

Choose an answer

Insertion

Deletion

Modification

All

Another term for a conditional operator is:

Choose an answer

Ternary

Binary

Byte

Iteration

More Classes

Other Links

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