Database Management System Set 14

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 Database Management System Set 14

Q1 | Which relationship is used to represent a specialization entity?
  • isa
  • ais
  • onis
  • whois
Answer: isa
Q2 | The refinement from an initial entity set into successive levels of entity subgroupings represents a                  design process in which distinctions are made explicit.
  • hierarchy
  • bottom-up
  • top-down
  • radical
Answer: top-down
Q3 | There are similarities between the instructor entity set and the secretary entity set in the sense that they have several attributes that are conceptually the same across the two entity sets: namely, the identifier, name, and salary attributes. This process is called
  • commonality
  • specialization
  • generalization
  • similarity
Answer: generalization
Q4 | If an entity set is a lower-level entity set in more than one ISA relationship, then the entity set has
  • hierarchy
  • multilevel inheritance
  • single inheritance
  • multiple inheritance
Answer: multiple inheritance
Q5 | A                            constraint requires that an entity belong to no more than one lower- level entity set.
  • disjointness
  • uniqueness
  • special
  • relational
Answer: disjointness
Q6 | Consider the employee work-team example, and assume that certain employees participate in more than one work team. A given employee may therefore appear in more than one of the team entity sets that are lower level entity sets of employee. Thus, the generalization is                            
  • overlapping
  • disjointness
  • uniqueness
  • relational
Answer: overlapping
Q7 | The completeness constraint may be one of the following: Total generalization or specialization, Partial generalization or specialization. Which is the default?
  • total
  • partial
  • should be specified
  • cannot be determined
Answer: partial
Q8 | Functional dependencies are a generalization of
  • key dependencies
  • relation dependencies
  • database dependencies
  • none of the mentioned
Answer: key dependencies
Q9 | Which of the following is another name for a weak entity?
  • child
  • owner
  • dominant
  • all of the mentioned
Answer: child
Q10 | Which is the main relation which is used in the university database which is referenced by all other relation of the university?
  • teaches
  • course
  • department
  • section
Answer: department
Q11 | The department relation has the an entry budget whose type has to be replaced by
  • varchar (20)
  • varchar2 (20)
  • numeric (12,2)
  • numeric
Answer: numeric (12,2)
Q12 | In the above DDL command the foreign key entries are got by using the keyword
  • references
  • key reference
  • relating
  • none of the mentioned
Answer: references
Q13 | Identify the error in the section relation
  • no error
  • year numeric (4,0)
  • building varchar (15)
  • sec_id varchar (8)
Answer: no error
Q14 | Which of the following can be used as a primary key entry of the instructor relation.
  • dept_name
  • name
  • id
  • all of the mentioned
Answer: id
Q15 | In the section relation which of the following is used as a foreign key?
  • course_id
  • course_id,sec_id
  • room_number
  • course_id,sec_id,room_number
Answer: course_id
Q16 | To replace the relation section with some other relation the initial step to be carried out is
  • delete section;
  • drop section;
  • delete from section;
  • replace section new_table ;
Answer: drop section;
Q17 | Select distinct Dept_name from instructor ; How many row(s) are displayed ?
  • 4
  • 3
  • 5
  • error
Answer: 4
Q18 | Which function is used to find the count of distinct departments?
  • dist
  • distinct
  • count
  • count,dist
Answer: dist
Q19 | Which function is used to identify the title with Least scope?
  • min(credits)
  • max(credits)
  • min(title)
  • min(salary)
Answer: min(credits)
Q20 | A domain is              if elements of the domain are considered to be indivisible units.
  • atomic
  • subatomic
  • substructure
  • subset
Answer: atomic
Q21 | Identify the composite attributes
  • salary
  • credits
  • section_id
  • none of the mentioned
Answer: none of the mentioned
Q22 | Which one is based on multi-valued dependency:
  • first
  • second
  • third
  • fourth
Answer: fourth
Q23 | If a relation is in BCNF, then it is also in
  • 1 nf
  • 2 nf
  • 3 nf
  • all of the mentioned
Answer: all of the mentioned
Q24 | If every non-key attribute is functionally dependent primary key, then the relation will be in
  • first normal form
  • second normal form
  • third form
  • fourth normal form
Answer: second normal form
Q25 | The term for information that describes what type of data is available in a database is:
  • data dictionary
  • data repository
  • index data
  • metadata
Answer: metadata
Previous Next