Relational Modal Set 1

Computer Science Engineering (CSE),

Bachelor of Science in Computer Science FY (BSc CS),

Bachelor of Science in Computer Science SY (BSc CS),

Bachelor of Science in Information Technology SY (BSc IT),

Bachelor of Computer Applications (BCA),

Bachelor of Business Administration in Computer Applications (BBA [CA]),

Bachelor of Science in Information Technology (BSc IT),

Bachelor of Science in Computer Science (BSc CS),

Master of Business Administration (MBA)

Practice Mode Previous Next
On This Page

This set of DataBase Management System (DBMS) Multiple Choice Questions & Answers (MCQs) focuses on Relational Modal Set 1

Q1 | Which is a join condition contains an equality operator:
  • equijoins
  • cartesian
  • natural
  • left
Answer: equijoins
Q2 | Which of the following is not outer join?
  • left outer join
  • right outer join
  • full outer join
  • all of the mentioned
Answer: all of the mentioned
Q3 | The assignment operator is denoted by
  • ->
  • <-
  • 0
  • 0
Answer: <-
Q4 | Which of the following symbol is used in the place of except?
  • ^
  • v
  • ¬
  • ~
Answer: ¬
Q5 | Which of the following is the comparison operator in tuple relational calculus
  • ⇒
  • 0
  • ε
  • all of the mentioned
Answer: 0
Q6 | In domain relaional calculus “there exist”
  • (p1(x))
  • (p1(x)) Э x
  • v x (p1(x))
  • Э x (p1(x))
Answer: Э x (p1(x))
Q7 | A set of possible data values is called
  • attribute
  • degree
  • tuple
  • domain
Answer: domain
Q8 | An                  is a set of entities of the same type that share the same properties, or attributes.
  • entity set
  • attribute set
  • relation set
  • entity model
Answer: entity set
Q9 | Entity is a                    
  • object of relation
  • present working model
  • thing in real world
  • model of relation
Answer: thing in real world
Q10 | The attribute name could be structured as an attribute consisting of first name, middle initial, and last name. This type of attribute is called
  • simple attribute
  • composite attribute
  • multivalued attribute
  • derived attribute
Answer: composite attribute
Q11 | In a relation between the entities the type and condition of the relation should be specified. That is called as            attribute.
  • desciptive
  • derived
  • recursive
  • relative
Answer: desciptive
Q12 |                            express the number of entities to which another entity can be associated via a relationship set.
  • mapping cardinality
  • relational cardinality
  • participation constraints
  • none of the mentioned
Answer: mapping cardinality
Q13 | 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
  • one-to-many
  • one-to-one
  • many-to-many
  • many-to-one
Answer: one-to-one
Q14 | 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.
  • one-to-many
  • one-to-one
  • many-to-many
  • many-to-one
Answer: many-to-one
Q15 | Data integrity constraints are used to:
  • control who is allowed access to the data
  • ensure that duplicate records are not entered into the table
  • improve the quality of data entered for a specific property
  • prevent users from changing the values stored in the table
Answer: improve the quality of data entered for a specific property
Q16 | Establishing limits on allowable property values, and specifying a set of acceptable, predefined options that can be assigned to a property are examples of:
  • attributes
  • data integrity constraints
  • method constraints
  • referential integrity constraints
Answer: data integrity constraints
Q17 | Which of the following can be addressed by enforcing a referential integrity constraint?
  • all phone numbers must include the area code
  • certain fields are required (such as the email address, or phone number) before the record is accepted
  • information on the customer must be known before anything can be sold to that customer
  • then entering an order quantity, the user must input a number and not some text (i.e., 12 rather than ‘a dozen’)
Answer: information on the customer must be known before anything can be sold to that customer
Q18 |              is a special type of integrity constraint that relates two relations & maintains consistency across the relations.
  • entity integrity constraints
  • referential integrity constraints
  • domain integrity constraints
  • domain constraints
Answer: referential integrity constraints
Q19 | Which one of the following uniquely identifies the elements in the relation?
  • secondary key
  • primary key
  • foreign key
  • composite key
Answer: primary key
Q20 | Drop Table cannot be used to drop a table referenced by a                    constraint.
  • local key
  • primary key
  • composite key
  • foreign key
Answer: foreign key
Q21 |                          is preferred method for enforcing data integrity
  • constraints
  • stored procedure
  • triggers
  • cursors
Answer: constraints
Q22 | The attribute AGE is calculated from DATE_OF_BIRTH. The attribute AGE is
  • single valued
  • multi valued
  • composite
  • derived
Answer: derived
Q23 | Not applicable condition can be represented in relation entry as
  • na
  • 0
  • Null.
  • blank space
Answer: Null.
Q24 | Which of the following can be a multivalued attribute?
  • phone_number
  • name
  • date_of_birth
  • all of the mentioned
Answer: phone_number
Q25 | Which of the following is a single valued attribute
  • register_number
  • address
  • subject_taken
  • reference
Answer: register_number
Previous Next