WorksheetsDBMS Quiz 2
Total questions: 60
Worksheet time: 30mins
How many triangles are there in given figure?
23
27
29
30
In a certain code MEAN is written as 8964 and NOBLE is written as 47529. How is LOAM written in that code?
2768
2758
2968
2468
Four friends were playing cards. Rahul was right to Riya. Soham was left to Soniya. Which of the following were partners?
Riya and Soniya
Rahul and Soniya
Soham and Riya
Soham and Rahul
If 3rd December, 1990 is Sunday. What day is 3rd January, 1991?
Tuesday
Wednesday
Thursday
Friday
A and B can complete a work in 6 days.A can alone do it in 10 days.Then B can alone do the work in how many days?
13.75 days
14 days
15 days
16 days
Pointing to a girl in a photograph,Arun said "Her mother's brother is the only son of my mother's father".How is the girl's mother related to Arun?
Mother
Sister
Aunt
Grandma
A man walked 2 km west of his house and then he turned south covering 4 km.Finally,he moved 3 km towards east and then he again 1 km west.How far is he from his initial position?
10 km
9 km
2 km
4 km
How many 3 digits numbers can be formed using the digits 1,2,3,4,5,7,9.
343
464
565
666
Find the odd man out
carrot
cucumber
onion
beetroot
In a certain code 'ROAR' is written as 'URDU'.How is 'URDU' written in that code?
VXDQ
XUGX
ROAR
VSOV
Fill the series 17,32,19,29,21,26,23,__,__
25,25
20,22
23,25
25,22
ELFA,GLHA,ILJA,_______,MLNA
OLPA
KLMA
LLMA
KLLA
What was the day of the week on 28th may 2006
sunday
monday
tuesday
wednesday
How is my father's mother's only daughter in law's sister related to me?
Aunt
sister
cousin
mother
Insert the missing number.
8, 7, 11, 12, 14, 17, 17, 22, (....)
27
20
22
24
Which of the following fraction is the largest?
7:8
13:16
31:40
63:80
Selecting Words
During Diwali the shops are ...... of people.
busy
full
crowded
bubbling
Selecting Words
Rohan and Rohit are twin brothers, but they do not look ......
unique
different
likely
alike
Selecting Words
Piyush behaves strangely at times and, therefore, nobody gets ...... with him.
about
through
along
up
Selecting Words
My uncle decided to take ...... and my sister to the market.
I
mine
me
myself
Selecting Words
Catching the earlier train will give us the ...... to do some shopping.
A....
chance
luck
possibility
occasion
Sentence Correction
He confidentially asked the crowd if they thought he was right and the crowd shouted that they did.
B.C.D.E.
that they had
that he is
that he didn't
No correction required
Sentence Correction
The intruder stood quietly for few moments
A.B.C.D.
for few time
for the few moments
for moments
for a few moments
Properties that describe the characteristics of entities are called:
entities
attributes
identifiers
relationships
Entities of a given type are grouped into a/an:
Database
Entity class
Attribute
ERD
Which of the following is NOT a basic element of all versions of the ER model?
entities
attributes
relationships
primary key
Entities can be associated with one another in which of the following?
entities
attributes
identifiers
relationships
The function that an entity plays in a relationship is called that entity’s _________.
Participation
Position
Role
Instance
The attribute name could be structured as an attribute consisting of first name, middle name and last name. This type of attribute is called :
Simple attribute
Composite attribute
Multi-valued attribute
Derived attribute
The attribute AGE is calculated from DATE_OF_BIRTH. The attribute AGE is:
Single valued
Multi valued
Composite
Derived
Which of the following can be a multi-valued attribute?
Phone_number
Name
Date_of_birth
All of these
In a relation between the entities the type and condition of the relation should be specified. That is called as ______ attribute.
Descriptive
Derived
Recursive
Relative
Entities can be associated with one another in which of the following?
entities
attributes
identifiers
relationships
Entity can be defined as:
Real world object
Relationship
Property
Square or rectangular box represents:
Attribute
Entity
Relationship
Relationship can be represented by:
Eclipse
Lines
Diamond symbol
Double Eclipse means:
Single valued attribute
Multi-valued attribute
Derived attribute
An entity is a
object of relation
present working model
thing in real world
model of relation
Which of the following is not a component of ER Model in DBMS?
entity
database
attribute
relationship
A relationship is
an item in an application
a meaningful dependency between entities
a collection of related entities
a related data
The expansion of ER Diagram is
Entity Relationship diagram
Entity Relative diagram
Entity Relation diagram
Entity Rationalized diagram
Entity is represented as
ellipse
double ellipse
rectangle
double rectangle
In one to many relationship, the entity that is on the one side of relationship is called
subtype
child
instance
parent
Property that describes the characteristics of entity is
entities
relationship
attributes
identifiers
Entities can be associated with one another in which of the following
attribute
identifiers
entities
relationship
By relation cardinality we mean
number of items in a relationship
number of relationships in which an entity can appear
number of items in an entity
number of entity sets which may be related to a given entity
If an entity appears in N relationship then it is
a 1:1 relationship
a 1:N relationship
a N:1 relationship
a N:M relationship
Rows of a relation is called
a relation row
an entity
a data structure
tuples
The columns of a relation
must be in specified order
may be in any order
with key field in first column
with largest width column last
Attributes are
properties of relationship
attributed to entities
properties of members of an entity set
In ER diagram relationships is represented by
circles
rectangles
ellipse
diamond shaped box
One entity may be
related to only one other entity
related to itself
related to only two other entities
related to many other entities
The data model which describes how the data is actually stored is
internal model
external model
logical model
none of these
Data about data is normally termed as
directory
data bank
meta data
none of the above
A view of database that appears to an application program is known as
schema
subschema
virtual table
none of the above
Collection of information stored in a database at a particular moment is
view
schema
instance
none of the above
DBA stands for
Data Bank Access
Database Access
Data Bank Administration
Database Administrator
Data items grouped together for storage purposes are called a :
Record
title
list
string
What is the language used by most of the DBMS for helping their users to access data ?
High level language
Query language
SQL
4GL
