Question # 1

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

Choose an answer

Queries

Forms

Reports

Tables

The case block ends with:

Choose an answer

End Select

End case

Break

Case else

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 are basic data distribution strategies?

Choose an answer

Centralized

Partitioned

Replication

All

We can make two way decisions with the help of

Choose an answer

if

nested

if-else

all

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

Choose an answer

database integrity

homonyms

normalization

mutually exclusive data

------------ 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 constraint between two attributes is called:

Choose an answer

Functional relation

Attribute dependency

Functional dependency

Functional relation constaint

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

How many table views are available in MS Access?

Choose an answer

1

3

2

4

The goal of normalization is to:

Choose an answer

Get stable data structure

Increase number of relation

Increase redundancy

Remove constraints

C was developed in the year:

Choose an answer

1970

1972

1976

1995

The scope of a variable refers to its:

Choose an answer

Length

Name

Accessibility

Data type

The columns of a table correspond to:

Choose an answer

Table

Record

Field

Cell

The operator that is used in decision making is

Choose an answer

increment operator

decrement operator

condition operator

none

In 3NF, a non key attribute must not depend on a

Choose an answer

non key attribute

key attribute

composite key

sort key

The type of expression x > y is

Choose an answer

arithmetic

logical

relational

conditional

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