adplus-dvertising

Welcome to the DBMS Basics MCQs Page

Dive deep into the fascinating world of DBMS Basics with our comprehensive set of Multiple-Choice Questions (MCQs). This page is dedicated to exploring the fundamental concepts and intricacies of DBMS Basics, a crucial aspect of DBMS. In this section, you will encounter a diverse range of MCQs that cover various aspects of DBMS Basics, from the basic principles to advanced topics. Each question is thoughtfully crafted to challenge your knowledge and deepen your understanding of this critical subcategory within DBMS.

frame-decoration

Check out the MCQs below to embark on an enriching journey through DBMS Basics. Test your knowledge, expand your horizons, and solidify your grasp on this vital area of DBMS.

Note: Each MCQ comes with multiple answer choices. Select the most appropriate option and test your understanding of DBMS Basics. You can click on an option to test your knowledge before viewing the solution for a MCQ. Happy learning!

DBMS Basics MCQs | Page 15 of 38

Explore more Topics under DBMS

Q141.
What is the abbreviation used for a software package that permits the users to create, retrieve and maintain records in a database?

a.

DASD

b.

FMS

c.

EMMS

d.

DBMS

Discuss
Answer: (d).DBMS
Q142.
Which of the following is not an advantage of the data-base approach?

a.

elimination of the data redundancy

b.

ability to associate related data

c.

increased security

d.

All of the above are advantages

Discuss
Answer: (d).All of the above are advantages
Q143.
It is more accurate to define a _____ as a variety of different record types that are treated as a single unit

a.

Database

b.

Table

c.

Record

d.

Flat File

Discuss
Answer: (a).Database
Q144.
Which of the following is not the responsibility of the utilities component of DBMS software?

a.

creating the physical and logical designs

b.

removing flagged records for deletion

c.

creating and maintaining the data dictionary

d.

monitoring performance

Discuss
Answer: (a).creating the physical and logical designs
Q145.
The database administration function includes

a.

application programming

b.

computer operations management

c.

database access planning

d.

All of the above

Discuss
Answer: (c).database access planning
Q146.
There are certain packages that allow people to define data items, place these items in particular records, combine the records into designated files and then manipulate and retrieve the stored data. What are they called?

a.

Data storage system

b.

Database management system (DBMS)

c.

Batch processing system

d.

Data communication package

Discuss
Answer: (b).Database management system (DBMS)
Q147.
Information can be transferred between the DBMS and a

a.

spreadsheet program

b.

word processor program

c.

graphics program

d.

All of the above

Discuss
Answer: (d).All of the above
Q148.
In order to use a DBMS, it is important to understand

a.

the physical schema

b.

all sub-schemas that the system supports

c.

one subschema

d.

both (a) and (b)

Discuss
Answer: (c).one subschema
Q149.
Administrate supervision of database activities is the responsibility of the

a.

Database administrator

b.

DP Manager

c.

DB Manager

d.

DP administration

Discuss
Answer: (a).Database administrator
Q150.
Database management systems are intended to:

a.

eliminate data redundancy

b.

establish relationships among records in different files

c.

manage file access

d.

All of the above

Discuss
Answer: (d).All of the above
Page 15 of 38

Suggested Topics

Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

SQL Server

Master Microsoft's database server with our SQL Server MCQs. Topics cover database...

MongoDB

Learn the leading NoSQL database with our MongoDB MCQs. Understand everything from...

Hadoop

Dive into the world of big data with our Hadoop MCQs. Cover key concepts including...

Formal Languages and Automata Theory

Discover the mathematical models of computation with our Formal Languages and...

Computer Architecture

Unveil the science behind computer design with our Computer Architecture MCQs. Topics...

Reverse Engineering

Strengthen your understanding of Reverse Engineering with our curated set of MCQs....

Web Technologies

Master the building blocks of the web with our Web Technologies MCQs. From HTML and...

MS Office

Master the suite of productivity tools with our MS Office MCQs. From Word and Excel...

Digital Communication

Master the basics of electronic communication with our Digital Communication MCQs....