On This Page

This set of DataBase Management System (DBMS) Multiple Choice Questions & Answers (MCQs) focuses on Database Management System Set 7

Q1 | A                  in a table represents a relationship among a set of values.
  • column
  • key
  • row
  • entry
Q2 | The term                is used to refer to a row.
  • attribute
  • tuple
  • field
  • instance
Q3 | For each attribute of a relation, there is a set of permitted values, called the                   of that attribute.
  • domain
  • relation
  • set
  • schema
Q4 | A domain is atomic if elements of the domain are considered to be                           units.
  • different
  • indivisbile
  • constant
  • divisible
Q5 | Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?
  • candidate key
  • sub key
  • super key
  • foreign key
Q6 | Consider attributes ID, CITY and NAME. Which one of this can be considered as a super key?
  • name
  • id
  • city
  • city, id
Q7 | A            is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.
  • rows
  • key
  • attribute
  • fields
Q8 | An attribute in a relation is a foreign key if the                key from one relation is used as an attribute in that relation.
  • candidate
  • primary
  • super
  • sub
Q9 | The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as a primary key is called                              
  • referential relation
  • referencing relation
  • referenced relation
  • referred relation
Q10 | The              is the one in which the primary key of one relation is used as a normal attribute in another relation.
  • referential relation
  • referencing relation
  • referenced relation
  • referred relation
Q11 | A                    integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.
  • referential
  • referencing
  • specific
  • primary
Q12 | The           operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.
  • select
  • join
  • union
  • intersection
Q13 | The result which operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match.
  • join
  • cartesian product
  • intersection
  • set difference
Q14 | The               operation performs a set union of two “similarly structured” tables
  • union
  • join
  • product
  • intersect
Q15 | The most commonly used operation in relational algebra for projecting a set of tuple from a relation is
  • join
  • projection
  • select
  • union
Q16 | The                operator takes the results of two queries and returns only rows that appear in both result sets.
  • union
  • intersect
  • difference
  • projection
Q17 | A                  is a pictorial depiction of the schema of a database that shows the relations in the database, their attributes, and primary keys and foreign keys.
  • schema diagram
  • relational algebra
  • database diagram
  • schema flow
Q18 | The                    provides a set of operations that take one or more relations as input and return a relation as an output.
  • schematic representation
  • relational algebra
  • scheme diagram
  • relation flow
Q19 | Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database?
  • dml(data manipulation langauge)
  • ddl(data definition langauge)
  • query
  • relational schema
Q20 | To remove a relation from an SQL database, we use the              command.
  • delete
  • purge
  • remove
  • drop table
Q21 | Updates that violate                      are disallowed.
  • integrity constraints
  • transaction control
  • authorization
  • ddl constraints
Q22 | The              clause allows us to select only those rows in the result relation of the           clause that satisfy a specified predicate.
  • where, from
  • from, select
  • select, from
  • from, where
Q23 | The subset of a super key is a candidate key under what condition?
  • no proper subset is a super key
  • all subsets are super keys
  • subset is a super key
  • each subset is a super key
Q24 | Which one of the following attribute can be taken as a primary key?
  • name
  • street
  • id
  • department
Q25 | Which one of the following cannot be taken as a primary key?
  • id
  • register number
  • dept_id
  • street