Question # 1

A two-dimensional table of data is called a

Choose an answer

group

set

declaration

relation

Format specifier is started with:

Choose an answer

'?

&

%

None

Which of the following are properties of relations?

Choose an answer

Each attribute has a unique name

No two rows in a relation are identical

There are no multivalued attributes in a relation

All of the above

Which of the following is NOT a characteristic of relation?

Choose an answer

Each row is unique

The order of columns is significant

The order of rows is insignificant

Columns are all elemental or atomic

A virtual table that is constructed form other tables is called:

Choose an answer

Table

View

Relation

Tuple

The columns of a relations can be of ___________ order.

Choose an answer

Any

Same

Sorted

Constant

An attribute is also known as a:

Choose an answer

Table

Row

Relation

Field

SQL is used for:

Choose an answer

Data definition

Data manipulaton

Data control

All

Microsoft Access saves the database file with the extension:

Choose an answer

.mdb

.msdb

.madb

None of these

The foreign key is found in:

Choose an answer

Parent table

Dependent table

Pivot table

Index table

In relational database a table is also called a:

Choose an answer

Tuple

Relation

File

Schema

Which is related to modality?

Choose an answer

Optional

Mandatory

Unidirectional

Both A & B

The operator that needs one operand is called

Choose an answer

unary

binary

ternary

all

The views are used :

Choose an answer

To hide columns

To hide rows

To hide complex SQL statements

Al of the above

A table most has

Choose an answer

primary key

secondary key

composite key

sort key

A person, place, thing or event about which data is kept in the database is called:

Choose an answer

Attribute

Field

Record

Entity

A row of relation is called

Choose an answer

attribute

entity

tuple

both a & c

More Classes

Other Links

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