Question # 1

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

Choose an answer

Non-transitive dependency

Full functional dependency

Partial dependency

Transitive dependency

Which of the following is true about TRUNCATE?

Choose an answer

Can be Rolled back.

Activates Triggers

is DML Command.

Resets identity of the table

An entity type is

Choose an answer

defined when the database is actually constructed

a specific type such as an integer, text, date, logical etc

a coherent set of similar objects that we want to store data on (e.g. STUDENT, COURSE, CAR)

defined by the database designer

Which of the following is NOT one of the ways of resolving deadlocks?

Choose an answer

Undoing all the updates made by the particular transaction which is the cause of deadlock.

A message is passed to the victim and depending on the system the transaction may or may not be started again automatically

Picking a list of all previously completed transactions and undoing all the updates.

Rollback `victim' transaction and restart it

Identify the correct statement.

Choose an answer

Referential integrity constraints check whether the primary key values are unique

Referential integrity constraints check whether an attribute value lies in the given range

Referential integrity constraints are specified between entities having recursive relationships

When Referential integrity rules are enforced, a tuple in one relation that refers to another relation must refer to an existing tuple.

Which feature of database provides conversion from inconsistent state of DB to a consistent state ensuring minimum data loss?

Choose an answer

User accessible catalog

Data processing

Authorization service

Recovery service

Which of the following is not true regarding Indexes?

Choose an answer

Index can be defined even when there is no data in the table

It support Range selections

It can be created using ‘Create Index’ statement

It can not be created on composite attributes

In a conceptual database model, which of the following most likely represents a valid identifier for a class grades?

Choose an answer

StudentID

StudentID, CourseID

StudentID, CourseID, InstructorID

StudentID, CourseSectionID

Which of the following concepts is applicable with respect to 3NF

Choose an answer

Full functional dependency

Any kind of dependency

Transitive dependency

Partial functional dependency

______ is a control that presents a set of choices from which a user can select one or more items; items can be text, graphics, or both.

Choose an answer

Text input

Report

Button

List box

Which of the following is true for the relational model?

Choose an answer

Degree of a relation is the number of rows in a relation

Null value is a blank or zero value given to an attribute value when its value is inapplicable or its value is unknown

Complex key is a key consisting of more than one attribute.

Constraint is a rule that restricts the values in a database.

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