WeCP DBMS Quiz – 1

Question 1

Time: 00:00:00
Generalization follows :

Top-Down Approach

Top-Down Approach

Bottom-Up Approach

Bottom-Up Approach

None of the Above

None of the Above

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 2

Time: 00:00:00
Which one of the following is an example of DBMS?

PostgreSQL

PostgreSQL

IBM DB2

IBM DB2

Oracle

Oracle

All of the above

All of the above

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 3

Time: 00:00:00
Which clause in SQL is used to specify the number of tuples present in a database table?

numberOfTuples

numberOfTuples

tupleNum

tupleNum

numRow

numRow

rownum

rownum

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 4

Time: 00:00:00
All the dynamic web application over the internet uses :

One-tier Architecture

One-tier Architecture

Two-tier Architecture

Two-tier Architecture

Three-tier Architecture

Three-tier Architecture

N-tier Architecture

N-tier Architecture

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 5

Time: 00:00:00
Which one of the following is not a DBMS models?

Flat File

Flat File

Operational

Operational

Network

Network

Relational

Relational

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 6

Time: 00:00:00
Which Data Model uses many to many relationship :

Hierarchical Model

Hierarchical Model

Network Model

Network Model

Both A and B

Both A and B

Neither A nor B

Neither A nor B

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 7

Time: 00:00:00
How do we represent derived attributes in ER Diagrams?

Double Horizontal Oval

Double Horizontal Oval

Oval with the attribute name underlined inside the oval

Oval with the attribute name underlined inside the oval

Horizontal Dashed Oval

Horizontal Dashed Oval

None of the above

None of the above

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 8

Time: 00:00:00
__________ attribute can be divided further into more than one attribute.

Key Attributes

Key Attributes

Composite Attributes

Composite Attributes

Derived Attributes

Derived Attributes

Multi-valued Attributes

Multi-valued Attributes

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 9

Time: 00:00:00
Which type of cardinality is there in “students are studying in a college”.

One to One

One to One

One to many

One to many

Many to one

Many to one

Many to many

Many to many

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 10

Time: 00:00:00
Relationship between two entities of the same type is called :

Unary Relationship

Unary Relationship

Binary Relationship

Binary Relationship

Ternary Relationship

Ternary Relationship

Recursive Relationship

Recursive Relationship

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

["0","40","60","80","100"]
["Need more practice!","Keep trying!","Not bad!","Good work!","Perfect!"]

Personalized Analytics only Availble for Logged in users

Analytics below shows your performance in various Mocks on PrepInsta

Your average Analytics for this Quiz

Rank

-

Percentile

0%

Completed

0/0

Accuracy

0%

Comments