Question # 1

The SQL statement to create a view is:

Choose an answer

CREATE VIEW

MAKE VIEW

SELECT VIEW

INSERT VIEW

Which of the following symbol is used with % sign to display output left-justified:

Choose an answer

-

/

\

L

Which of the following key does not hold uniqueness property ?

Choose an answer

candidate key

foreign key

primary key

Secondary key

Conditional operator is also called:

Choose an answer

True operator

Ternary-operator

Truth operator

All of these

All of the following are components of physical database design EXCEPT:

Choose an answer

Data volume and usage anylisis

Data distribution strategy

File organization

Normalize the relations

The expression in define directive:

Choose an answer

Can only be changed at the end of the program

Cannot be changed but can be redefined

Cannot be assigned a value

Cannot be changed

The logical not operator denoted by is

Choose an answer

Ternary operator

Unary operator

a=a+b

b=b+a

Which of the following can be used as flag value

Choose an answer

+

#

-

all

the integer, long and short data types are known as:

Choose an answer

Integer data types

Non-integral data types

float data types

Non-numeric data types

The name cannot exceed characters in length

Choose an answer

64

50

56

70

The type of files from functional point of view include:

Choose an answer

Program file

Data file

a and b

None of these

A calculated field ,,,,,,,,,(select all that apply)

Choose an answer

...............is a bound control

...............is a control that contains an expression

...............can perform calculations on field's values

..............can perform calculations on explicit values

Which of the following is not a good primary key

Choose an answer

Social security number

Order number

Zip code

STD ID number

The operator that is used in decision making is

Choose an answer

increment operator

decrement operator

condition operator

none

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

Choose an answer

do-white

While

For

None of these

Which of the following keys us not unique:

Choose an answer

Candidate key

Forein key

Primary key

Secondary key

Which of the following is also known as data set?

Choose an answer

Record

Field

File

Module

Object used to retrieve data from database is called:

Choose an answer

Forms

Repons

Queries

Tables

More Classes

Other Links

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