Question # 1

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

Structural constraints of a relationship type refer to

Choose an answer

identifying the owner entity type relevant to a given entity type

whether the existence of an entity depends on it being related to another entity via the relationship type.

the role that a participating entity from the entity type plays in each relationship instance

the constraints applicable in granting access to tables, columns and views in a database schema.

Only one type of constraint can be enforced in any table by CREATE command

Choose an answer

True

False

Not Sure

Which of the following is not true about De-normalization?

Choose an answer

It is the process of attempting to optimize the performance of a database

De-normalization is a technique to move from lower to higher normal forms of database modeling

It enhances the performance of DB

In de-normalization it is required to add redundant data.

Partitions may become unbalanced in:

Choose an answer

Range partitioning

Hash partitioning

List partitioning

Vertical partitioning

Who is responsible for authorizing access to the database, for coordinating and monitoring its use ?

Choose an answer

Database Designers

Database Administrators

End Users

Application Programmers

Which of the following is a correct way of selecting all the columns from a table called PERSONS?

Choose an answer

SELECT FROM * Persons

SELECT * FROM Persons

SELECT * WHERE Persons

SELECT WHERE * Persons

Which of the following is an example of volatile memory?

Choose an answer

RAM

ROM

Flash memory

CPU

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

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.

Consider the following statements. A. An entity integrity constraint states that no primary key value can be null. B. A referential integrity constraint is specified between two relations. C. A foreign key cannot be used to refer to its own relation. Identify which of the above statements is/are correct

Choose an answer

Only A

Only B

B and C

A and B

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