Database Management System (DBMS) MCQ Questions and answers

A

Admin • 833.24K Points
Coach

Q. 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

(A) one-to-many
(B) one-to-one
(C) many-to-many
(D) many-to-one

A

Admin • 833.24K Points
Coach

Q. 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.

(A) one-to-many
(B) one-to-one
(C) many-to-many
(D) many-to-one

A

Admin • 833.24K Points
Coach

Q. Data integrity constraints are used to:

(A) control who is allowed access to the data
(B) ensure that duplicate records are not entered into the table
(C) improve the quality of data entered for a speciﬁc property
(D) prevent users from changing the values stored in the table

A

Admin • 833.24K Points
Coach

Q. Establishing limits on allowable property values, and specifying a set of acceptable, predeﬁned options that can be assigned to a property are examples of:

(A) attributes
(B) data integrity constraints
(C) method constraints
(D) referential integrity constraints

A

Admin • 833.24K Points
Coach

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

(A) all phone numbers must include the area code
(B) certain ﬁelds are required (such as the email address, or phone number) before the record is accepted
(C) information on the customer must be known before anything can be sold to that customer
(D) then entering an order quantity, the user must input a number and not some text (i.e., 12 rather than ‘a dozen’)

A

Admin • 833.24K Points
Coach

Q. is a special type of integrity constraint that relates two relations & maintains consistency across the relations.

(A) entity integrity constraints
(B) referential integrity constraints
(C) domain integrity constraints
(D) domain constraints

A

Admin • 833.24K Points
Coach

Q. Which one of the following uniquely identiﬁes the elements in the relation?

(A) secondary key
(B) primary key
(C) foreign key
(D) composite key

A

Admin • 833.24K Points
Coach

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

(A) local key
(B) primary key
(C) composite key
(D) foreign key

A

Admin • 833.24K Points
Coach

Q. is preferred method for enforcing data integrity

(A) constraints
(B) stored procedure
(C) triggers
(D) cursors

A

Admin • 833.24K Points
Coach

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

(A) double diamonds
(B) undivided rectangles
(C) dashed lines
(D) diamond

Database Management System (DBMS) MCQs with answers Page - 63

Q. 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

Q. 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.

Q. Data integrity constraints are used to:

Q. Establishing limits on allowable property values, and specifying a set of acceptable, predeﬁned options that can be assigned to a property are examples of:

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

Q. is a special type of integrity constraint that relates two relations & maintains consistency across the relations.

Q. Which one of the following uniquely identiﬁes the elements in the relation?

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

Q. is preferred method for enforcing data integrity

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

Add MCQ in this Category

Browse Categories