Question # 1

Which of the following is not a benefit of normalization?

Choose an answer

Minimize insertion anomolies

Minimize deletion anomolies

Minimize updation anomolies

Maximize redundancy

Which of the following is one of the purposes of using DML commands?

Choose an answer

Creating databases

Destroying databases

Inserting data in tables

Non of the above

The ER- data model is an example of:

Choose an answer

Physical database

Logical database

Relational database

Conceptual database

Which of the following is not true regarding DB transactions?

Choose an answer

A set of database operations that are processed partly

A database transaction is a logical unit of database operations

A database transaction must be atomic

A database transaction must contains the ACID property

The Entity Relation Model models

Choose an answer

Entities, Relationships and Processes

Entities and Relationships

Relationships

Entities

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.

A weak entity type

Choose an answer

must have total participation in an identifying relationship

does not have a key attribute(s)

both (a) and (b)

none of the above

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.

_______ is a control that users click to perform an action, set or toggle a state, or set an option.

Choose an answer

Button

Text box

Input form

Report

Which of the following SQL commands deletes a record of an employee with the employee_id 12345, from a table named PERSON.

Choose an answer

DELETE FROM person WHERE employee_id = ‘12345’

DELETE WHERE person FROM employee_id = 12345

DROP FROM person WHERE employee_id = 12345

DELETE WHERE person WHERE employee_id = 12345

Which of the following concepts is applicable with respect to 2NF?

Choose an answer

Full functional dependency

Any kind of dependency

Transitive dependency

Non-transitive dependency

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