Question # 1

Which of following is NOT generally the aim of data partitioning and placement of data?

Choose an answer

Reduce Workload

Balance Workload

Merging different relations

Speed up rate of useful works.

_______is a control that enables users to select one option from an associated list; users can also type an option.

Choose an answer

Combo box

Button

Text box

Static area

A relation (from the relational database model) consists of a set of tuples, which implies th

Choose an answer

Relational model supports multi-valued attributes whose values can be represented in sets.

for any two tuples, the values associated with all of their attributes may be the same

for any two tuples, the values associated with one or more of their attributes must differ.

all tuples in a particular relation may have different attributes.

Controlling redundancy in a database management system DOES NOT help to

Choose an answer

avoid duplication

avoid unnecessary wastage of storage space

avoid unauthorised access to data

avoid inconsistency among data

Identify which of the above statements is/are correct.

Choose an answer

Only A

Only B

Only B and C

Only A and B

In a conceptual model for a university, what type of relationship exists between Grade and Student entitie

Choose an answer

1:1

1:M

M:M

Ternary

Suppose there are 4 fields in a table named WORKER (Id, first_name, last_name, joining_year). Which of the following gives all the information of the workers who have joined after 1965?

Choose an answer

SELECT * FROM WORKER WHERE joining_Year>1965;

SELECT * FROM WORKER WHERE joining_Year>'1965';

SELECT * FROM WORKER AND joining_Year>'1965';

SELECT * WHERE joining_Year>1965;

A description on a particular collection of data using the given data model

Choose an answer

Database

Schema

None of the above

Relation

Select the correct statement among the following on proper naming of schema constructs:

Choose an answer

Entity type name applies to all the entities belonging to that entity type and therefore a plural name is selected for entity type.

In the narrative description of the database requirements, verbs tend to indicate the names of relationship types.

The nouns arising from a database requirement description can be considered as names of attributes.

Additional nouns which are appearing in the narrative description of the database requirements represent the weak entity type names.

Which of the following is not true about input forms?

Choose an answer

Provide an easy, effective, efficient way to enter data into a table

Especially useful when the person entering the data is not familiar with the inner workings

Provide different controls to add data into the tables

One input forms can populate one table at a time

Which of the following serves as a milestone or reference point in the log file?

Choose an answer

Constraints

Relations

Check points

Transactions identities

More Classes

Other Links

CS-403 Final Term Exams Preparation Virtual University 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