Question # 1

All the intersection of rows and columns must have:

Choose an answer

Single value

Constant value

Multiple values

No value

A table should have :

Choose an answer

Primary key

Secondary key

Composite key

Sort key

A two-dimensional table of data is called a

Choose an answer

group

set

declaration

relation

Which of the following is not a valid variable name ?

Choose an answer

Roll No

Roll-No

Roll #

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

The columns of a table correspond to:

Choose an answer

Table

Record

Field

Cell

Microsoft Access saves the database file with the extension:

Choose an answer

.mdb

.msdb

.madb

None of these

The operator that needs one operand is called

Choose an answer

unary

binary

ternary

all

A form that contains the sub-form is called:

Choose an answer

Form

Main form

Report

None of these

In relational database a table is also called a:

Choose an answer

Tuple

Relation

File

Schema

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

CREATE command is used to create:

Choose an answer

Record

View

Report

Query

The foreign key is found in

Choose an answer

parent table

dependent table

pivot table

index table

SQL is used for

Choose an answer

data definition

data manipulation

a and b

searching record

An attribute is also known as a:

Choose an answer

Table

Row

Relation

Field

Which is a loop statement?

Choose an answer

If

If-else

Switch

None of these

A row of a relation is called:

Choose an answer

Attribute

Entity

Tuple

a and c

Insert command is used to insert:

Choose an answer

New table

New record

View

Dependences

The number of characters in fixed-length field is:

Choose an answer

Constant

Variable

10

100

The views are used :

Choose an answer

To hide columns

To hide rows

To hide complex SQL statements

Al of the above

A relation is known as

Choose an answer

table

tuple

relationship

attribute

More Classes

Other Links

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