HCL DBMS Quiz – 1

Question 1

Time: 00:00:00
Who invented the first database management system (DBMS)?

Charles Babbage

Charles Babbage

Sharon B. Codd

Sharon B. Codd

Edgar Frank Codd

Edgar Frank Codd

Charles Bachman

Charles Bachman

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 of the following isn't a database type?

Decentralized

Decentralized

Network

Network

Distributed

Distributed

Hierarchical

Hierarchical

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

Please login to submit your explanation

Start

Question 3

Time: 00:00:00
What is a database management system (DBMS)?

DBMS stores, modifies and retrieves data

DBMS stores, modifies and retrieves data

DBMS is a high-level language

DBMS is a high-level language

DBMS is a programming language

DBMS is a programming language

DBMS is a collection of queries

DBMS is a collection of queries

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

Please login to submit your explanation

Start

Question 4

Time: 00:00:00
Which of the following is not a Database Management system (DBMS)?

Google

Google

IBM DB2

IBM DB2

Microsoft Acess

Microsoft Acess

MySQL

MySQL

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 of the following is known as a set of entities of the same type that share the same properties, or attributes?

 Entity Relation model

 Entity Relation model

Entity set

Entity set

Tuples

Tuples

Relation set

Relation set

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

Please login to submit your explanation

Start

Question 6

Time: 00:00:00
What does a Relational Database Management system (RDBMS) consist of?

 Collection of Fields

 Collection of Fields

Collection of Keys

Collection of Keys

Collection of Tables

Collection of Tables

 Collection of Records

 Collection of Records

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

Please login to submit your explanation

Start

Question 7

Time: 00:00:00
 _____________ is a hardware component that is most important for the operation of a database management system.

High-resolution video display

High-resolution video display

High speed, large capacity disk to store data

High speed, large capacity disk to store data

Microphone

Microphone

Printer

Printer

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

Please login to submit your explanation

Start

Question 8

Time: 00:00:00
Which SQL command is used to delete a relation?

Remove

Remove

Purge

Purge

Delete

Delete

Drop table

Drop table

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

Please login to submit your explanation

Start

Question 9

Time: 00:00:00
Procedural language among the following is __________

 Tuple relational calculus

 Tuple relational calculus

Query language

Query language

Relational algebra

Relational algebra

Domain relational calculus

Domain relational calculus

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

Please login to submit your explanation

Start

Question 10

Time: 00:00:00
Which forms have a relationship that holds data about a single entity?

5NF

5NF

2NF

2NF

3NF

3NF

4NF

4NF

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%

Prime

Prime Video

Complete Video Course for HCL

For HCL
Get Prime Video

Prime

Prime Mock

Topic-Wise Full Mock for HCL

For HCL
Get Prime Mock