Database Management System MCQs

In precedence of set operators, the expression is evaluated from

Which of the following is not outer join?

Find the ID, name, dept name, salary for instructors whose salary is greater than $80,000 .

A query in the tuple relational calculus is expressed as:

Which of the following symbol is used in the place of except?

“Find all students who have taken all courses offered in the Biology department.” The expressions that matches this sentence is :

In domain relaional calculus “there exist” can be expressed as

A set of possible data values is called

An ________ is a set of entities of the same type that share the same properties, or attributes.

Entity is a _________

The descriptive property possessed by each entity set is _________

The function that an entity plays in a relationship is called that entity’s _____________

The attribute name could be structured as an attribute consisting of first name, middle initial, and last name. This type of attribute is called

The attribute AGE is calculated from DATE_OF_BIRTH. The attribute AGE is

Which of the following can be a multivalued attribute?

Which of the following is a single valued attribute

In a relation between the entities the type and condition of the relation should be specified. That is called as______attribute.

_____________ express the number of entities to which another entity can be associated via a relationship set.

An entity in A is associated with at most one entity in B, and an entity in B is associated with at most one entity in A.This is called as

An entity in A is associated with at most one entity in B. An entity in B, however, can be associated with any number (zero or more) of entities in A.

Data integrity constraints are used to:

Establishing limits on allowable property values, and specifying a set of acceptable, predefined options that can be assigned to a property are examples of:

Which of the following can be addressed by enforcing a referential integrity constraint?

Which one of the following uniquely identifies the elements in the relation?

Drop Table cannot be used to drop a table referenced by a _________ constraint.

____________ is preferred method for enforcing data integrity

Which of the following gives a logical structure of the database graphically?

The entity relationship set is represented in E-R diagram as

The Rectangles divided into two parts represents

Consider a directed line(->) from the relationship set advisor to both entity sets instructor and student. This indicates _________ cardinality

We indicate roles in E-R diagrams by labeling the lines that connect ___________ to __________

An entity set that does not have sufficient attributes to form a primary key is termed a __________

Weak entity set is represented as

If you were collecting and storing information about your music collection, an album would be considered a(n) _____

What term is used to refer to a specific record in your music database; for instance; information stored about a specific album?

Which one of the following can be treated as a primary key in teaches relation?

The primary key in the section relation is

The query which selects the Course_id ‘CS-101’ from the section relation is

The relation with primary key can be created using

How can the values in the relation teaches be deleted?

In the above teaches relation ” Select * from teaches where Year = ‘2010’” displays how many rows?

The relation changes can be got back using ________ command.

Let us consider phone_number ,which can take single or several values . Treating phone_numberas an _________ permits instructors to have several phone numbers (including zero) associated with them.

The total participation by entities is represented in E-R diagram as

Given the basic ER and relational models, which of the following is INCORRECT?

Which of the following indicates the maximum number of entities that can be involved in a relationship?

In E-R diagram generalization is represented by

What is a relationship called when it is maintained between two entities?

Key to represent relationship between tables is called

A window into a portion of a database is