Basics of DBMS Set 1

Learning Mode Previous Next

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 suﬃcient 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 speciﬁc record in your music database; for instance; information stored about a speciﬁc album?

relation

instance

table

column

Q9 | Which one of the following can be treated as a primary key in teaches relation?

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?

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