Question # 1

The operator that needs one operand is called

Choose an answer

unary

binary

ternary

all

The rows of a relations can be of ___________ order.

Choose an answer

Any

Same

Sorted

Constant

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

An attribute is also known as a:

Choose an answer

Table

Row

Relation

Field

The number of characters in variable field is:

Choose an answer

Constant

Variable

10

100

The number of characters in fixed-length field is:

Choose an answer

Constant

Variable

10

100

The functions that are defined by programmer are called:

Choose an answer

User-defined

Subprograms

Subroutines

Built-in functions

The foreign key is found in:

Choose an answer

Parent table

Dependent table

Pivot table

Index table

Which loop statement executes the body of loop at least once?

Choose an answer

do-white

While

For

None of these

All the intersection of rows and columns must have:

Choose an answer

Single value

Constant value

Multiple values

No value

A two-dimensional table of data is called a

Choose an answer

group

set

declaration

relation

Which is a loop statement?

Choose an answer

If

If-else

Switch

None of these

Which is not a logical operator?

Choose an answer

||

!

!=

&&

The views are used :

Choose an answer

To hide columns

To hide rows

To hide complex SQL statements

Al of the above

Which type of variable can store real value

Choose an answer

int

long int

char

Float

The foreign key is found in

Choose an answer

parent table

dependent table

pivot table

index table

Which of the following is not a valid variable name ?

Choose an answer

Roll No

Roll-No

Roll #

How many types of relationship are there?

Choose an answer

2

3

4

5

A table most has

Choose an answer

primary key

secondary key

composite key

sort key

A table should have :

Choose an answer

Primary key

Secondary key

Composite key

Sort key

A table is a two-dimensional structure that consists of:

Choose an answer

x and y co-ordinates

Matrix elements

Rows and columns

Intersection of data

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

Choose an answer

Table

View

Relation

Tuple

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

Choose an answer

Choose an answer

Choose an answer

Choose an answer

Choose an answer