On This Page

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

Q1 | The entity relationship set is represented in E-R diagram as
  • double diamonds
  • undivided rectangles
  • dashed lines
  • diamond
Q2 | The Rectangles divided into two parts represents
  • entity set
  • relationship set
  • attributes of a relationship set
  • primary key
Q3 | Weak entity set is represented as
  • underline
  • double line
  • double diamond
  • double rectangle
Q4 | We indicate roles in E-R diagrams by labeling the lines that connect                         to                      
  • diamond , diamond
  • rectangle, diamond
  • rectangle, rectangle
  • diamond, rectangle
Q5 | An entity set that does not have sufficient attributes to form a primary key is termed a
  • strong entity set
  • variant set
  • weak entity set
  • variable set
Q6 | For a weak entity set to be meaningful, it must be associated with another entity set, called the
  • identifying set
  • owner set
  • neighbour set
  • strong entity set
Q7 | If you were collecting and storing information about your music collection, an album would be considered a(n)            
  • relation
  • entity
  • instance
  • attribute
Q8 | What term is used to refer to a specific record in your music database; for instance; information stored about a specific album?
  • relation
  • instance
  • table
  • column
Q9 | Which one of the following can be treated as a primary key in teaches relation?
  • id
  • semester
  • sec_id
  • year
Q10 | The primary key in the section relation is
  • course_id
  • sec_id
  • both course_id and sec_id
  • all the attributes
Q11 | The relation with primary key can be created using
  • create table instructor (id, name)
  • create table instructor (id, name, primary key(name))
  • create table instructor (id, name, primary key (id))
  • create table instructor ( id unique, name )
Q12 | How can the values in the relation teaches be deleted?
  • drop table teaches;
  • delete from teaches;
  • purge table teaches;
  • delete from teaches where id =’null’;
Q13 | In the above teaches relation ” Select * from teaches where Year = ‘2010’” displays how many rows?
  • 2
  • 4
  • 5
  • 1
Q14 | The relation changes can be got back using                  command
  • flashback
  • purge
  • delete
  • getback
Q15 | Let us consider phone_number ,which can take single or several values . Treating phone_numberas an                    permits instructors to have several phone numbers (including zero) associated with them.
  • entity
  • attribute
  • relation
  • value
Q16 | The total participation by entities is represented in E-R diagram as
  • dashed line
  • double line
  • double rectangle
  • circle
Q17 | Given the basic ER and relational models, which of the following is INCORRECT?
  • an attribute of an entity can have more than one value
  • an attribute of an entity can be composite
  • in a row of a relational table, an attribute can have more than one value
  • in a row of a relational table, an attribute can have exactly one value or a null value
Q18 | Which of the following indicates the maximum number of entities that can be involved in a relationship?
  • minimum cardinality
  • maximum cardinality
  • erd
  • greater entity count
Q19 | In E-R diagram generalization is represented by
  • ellipse
  • dashed ellipse
  • rectangle
  • triangle
Q20 | What is a relationship called when it is maintained between two entities?
  • unary
  • binary
  • ternary
  • quaternary
Q21 | Which of the following is a low level operator?
  • insert
  • update
  • delete
  • directory
Q22 | Key to represent relationship between tables is called
  • primary key
  • secondary key
  • foreign key
  • none of the mentioned
Q23 | A window into a portion of a database is
  • schema
  • view
  • query
  • data dictionary
Q24 | A primary key is combined with a foreign key creates
  • parent-child relation ship between the tables that connect them
  • many to many relationship between the tables that connect them
  • network model between the tables that connect them
  • none of the mentioned
Q25 | The entity set person is classified as student and employee. This process is called
  • generalization
  • specialization
  • inheritance
  • constraint generalization