GK One-Line Question & Answer

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

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

The department relation has the an entry budget whose type has to be replaced by

                         is preferred method for enforcing data integrity

In E-R diagram generalization is represented by

In the above DDL command the foreign key entries are got by using the keyword

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

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

Identify the error in the section relation

The Rectangles divided into two parts represents

Which of the following is a low level operator?

Which of the following can be used as a primary key entry of the instructor relation.

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

Key to represent relationship between tables is called

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

A window into a portion of a database is

Weak entity set is represented as

A primary key is combined with a foreign key creates

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

The entity set person is classified as student and employee. This process is called

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

Which relationship is used to represent a specialization entity?

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

The refinement from an initial entity set into successive levels of entity subgroupings represents a                  design process in which distinctions are made explicit.

The primary key in the section relation is

There are similarities between the instructor entity set and the secretary entity set in the sense that they have several attributes that are conceptually the same across the two entity sets: namely, the identifier, name, and salary attributes. This process is called

The relation with primary key can be created using

If an entity set is a lower-level entity set in more than one ISA relationship, then the entity set has

How can the values in the relation teaches be deleted?

A                            constraint requires that an entity belong to no more than one lower- level entity set.

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

Consider the employee work-team example, and assume that certain employees participate in more than one work team. A given employee may therefore appear in more than one of the team entity sets that are lower level entity sets of employee. Thus, the generalization is                            

The relation changes can be got back using                  command

The completeness constraint may be one of the following: Total generalization or specialization, Partial generalization or specialization. Which is the default?

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.

Functional dependencies are a generalization of

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

Which of the following is another name for a weak entity?

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

Which is the main relation which is used in the university database which is referenced by all other relation of the university?