GK One-Line Question & Answer

Which relationship is used to represent a specialization entity?

Which function is used to identify the title with Least scope?

                           can help us detect poor E- R design.

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

A domain is              if elements of the domain are considered to be indivisible units.

What is the best way to represent the attributes in a large database?

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

Identify the composite attributes

Designers use which of the following to tune the performance of systems to support time-critical operations?

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

Which one is based on multi-valued dependency:

Thus a                of course data gives the values of all attributes, such as title and department, of all courses at a particular point in time.

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

If every non-key attribute is functionally dependent primary key, then the relation will be in

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 term for information that describes what type of data is available in a database is:

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

A data type that creates unique numbers for key columns in Microsoft Access is:

Functional dependencies are a generalization of

A dependency exist between two columns when

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

In the                      normal form, a composite attribute is converted to individual attributes.

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

A table on the many side of a one to many or many to many relationship must:

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

Functional Dependencies are the types of constraints that are based on             

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

A relation is in                          if an attribute of a composite key is dependent on an attribute of other composite key.

Identify the error in the section relation

What are the desirable properties of a decomposition

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

R (A,B,C,D) is a relation. Which of the following does not have a lossless join dependency preserving BCNF decomposition?

In the section relation which of the following is used as a foreign key?

The algorithm that takes a set of dependencies and adds one schema at a time, instead of decomposing the initial schema repeatedly is

To replace the relation section with some other relation the initial step to be carried out is

Which normal form is considered adequate for normal relational database design?

Select distinct Dept_name from instructor ; How many row(s) are displayed ?

Relation R with an associated set of functional dependencies, F, is decomposed into BCNF. The redundancy (arising out of functional dependencies) in the resulting set of relations is

Which function is used to find the count of distinct departments?

Which of the normal form is based on multivalued dependencies?