Q. Which of the following data constraints would be used to specify that the value of a cell in one column must be less than the value of a cell in another column in the same row of the same table?

View solution

Q. A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n):

View solution

Q. Which is not true about surrogate keys?

View solution

Q. For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?

View solution

Q. Which constraint requires that the binary relationship indicate all combinations that must appear in the ternary relationship?

View solution

Q. Each entity is represented as a(n):

View solution

Q. For every relationship, how many possible sets of minimum cardinalities are there?

View solution

Q. If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.

View solution

Q. Which of the following column properties would be used to specify that cells in a column must contain a monetary value that is less than another monetary value in the same row?

View solution

Q. The type of diagram in which the operations are specified on objects is considered as

View solution

Q. Considering the binary relationships, the possible cardinality ratios are

View solution

Q. The attributes that can be arranged into hierarchy are called

View solution

Q. The set of all the entities having same attributes is classified as

View solution

Q. The set of values which specifies which values are to be assigned to individual entities is considered as

View solution

Q. The type of attributes that can be divided into smaller parts is classified as

View solution

Q. The particular database and the set of related programs which helps in implementation of updates and queries is called

View solution

Q. The detailed description on entity constraints, entity relationships and entity types is expressed in

View solution

Q. The types of partial constraints are

View solution

Q. The attributes which have only one value for a specific entity are called

View solution

Q. The phase in data designing in which the access paths and database indexes are specified is classified as

View solution