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/10

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
Get Prepinsta Prime

Get all 200+ courses offered by Prepinsta

Never Miss an OffCampus Update

Get OffCampus Updates on Social Media from PrepInsta

Follow us on our Media Handles, we post out OffCampus drives on our Instagram, Telegram, Discord, Whatsdapp etc.

Get Hiring Updates
Amazon,Google,Delottie & 30+companies are hiring ! Get hiring Updates right in your inbox from PrepInsta

Get over 200+ course One Subscription

Courses like AI/ML, Cloud Computing, Ethical Hacking, C, C++, Java, Python, DSA (All Languages), Competitive Coding (All Languages), TCS, Infosys, Wipro, Amazon, DBMS, SQL and others.

Get over 200+ course One Subscription

Courses like AI/ML, Cloud Computing, Ethical Hacking, C, C++, Java, Python, DSA (All Languages), Competitive Coding (All Languages), TCS, Infosys, Wipro, Amazon, DBMS, SQL and others.

Get PrepInsta Prime Subscription

Get access to all the courses that PrepInsta offers, check the out below -

Companies

TCS, Cognizant, Delloite, Infosys, Wipro, CoCubes, KPMG, Amazone, ZS Associates, Accenture, Congnizant & other 50+ companies

Programming

Data Structures, Top 500 Codes, C, C++, Java Python & other 10+ subjects

Skills

Full Stack Web Development, Data Science, Machine Learning, AWS Cloud, & other 10+ skills and 20+ projects