Basics of DBMS 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),
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