Database Management System Set 7

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)

Learning Mode Previous Next
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.
Q2 | The term                is used to refer to a row.
Q3 | For each attribute of a relation, there is a set of permitted values, called the                   of that attribute.
Q4 | A domain is atomic if elements of the domain are considered to be                           units.
Q5 | Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?
Q6 | Consider attributes ID, CITY and NAME. Which one of this can be considered as a super key?
Q7 | A            is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.
Q8 | An attribute in a relation is a foreign key if the                key from one relation is used as an attribute in that relation.
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                              
Q10 | The              is the one in which the primary key of one relation is used as a normal attribute in another 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.
Q12 | The           operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.
Q13 | The result which operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match.
Q14 | The               operation performs a set union of two “similarly structured” tables
Q15 | The most commonly used operation in relational algebra for projecting a set of tuple from a relation is
Q16 | The                operator takes the results of two queries and returns only rows that appear in both result sets.
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.
Q18 | The                    provides a set of operations that take one or more relations as input and return a relation as an output.
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?
Q20 | To remove a relation from an SQL database, we use the              command.
Q21 | Updates that violate                      are disallowed.
Q22 | The              clause allows us to select only those rows in the result relation of the           clause that satisfy a specified predicate.
Q23 | The subset of a super key is a candidate key under what condition?
Q24 | Which one of the following attribute can be taken as a primary key?
Q25 | Which one of the following cannot be taken as a primary key?
Previous Next