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 13 of 38

Explore more Topics under DBMS

Q121.
Which two files are used during operation of the DBMS?

a.

query language and utilities

b.

data manipulation language and query language

c.

data dictionary and transaction log

d.

data dictionary and query language

Discuss
Answer: (c).data dictionary and transaction log
Q122.
When using a database management system, the first thing that you must do is to

a.

create a database file

b.

activate file editor

c.

load the software into your micro computer

d.

keep a floppy disk in readiness

Discuss
Answer: (c).load the software into your micro computer
Q123.
The highest level in the hierarchy of data organization is called

a.

data bank

b.

database

c.

data file

d.

data record

Discuss
Answer: (b).database
Q124.
Updating a database means

a.

revising the file structure

b.

reorganizing the database

c.

modifying or adding record occurrences

d.

All of the above

Discuss
Answer: (c).modifying or adding record occurrences
Q125.
The main idea behind computer files is that it is convenient to

a.

arrange them

b.

store information together

c.

create them

d.

access them

Discuss
Answer: (b).store information together
Q126.
The Management Information system (MIS) structure with one main computer system is called a

a.

hierarchical MIS structure

b.

distributed MIS structure

c.

centralized MIS structure

d.

decentralized MIS structure

Discuss
Answer: (c).centralized MIS structure
Q127.
What name is given to the collection of facts, items of information or data which are related in some way?

a.

Database

b.

Directory information

c.

Information tree

d.

Information provider

Discuss
Answer: (a).Database
Q128.
In a large DBMS

a.

each user can "see" only a small part of the entire database

b.

each user can access every sub¬schema

c.

each subschema contains every field in the logical schema

d.

All of the above

Discuss
Answer: (a).each user can "see" only a small part of the entire database
Q129.
An audit trail

a.

is used to make back-up copies

b.

is the recorded history of operations performed on a file

c.

can be used to restore lost information

d.

All of the above

Discuss
Answer: (b).is the recorded history of operations performed on a file
Q130.
The on-line, softcopy display a customer's charge account to respond to an inquiry is an examples of a

a.

forecasting report

b.

exception report

c.

regularly scheduled report

d.

on demand report

Discuss
Answer: (d).on demand report
Page 13 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!

Hadoop

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

Digital Image Processing (DIP)

Delve into the techniques of enhancing digital images with our Digital Image...

Operating System

Dive deep into the core of computers with our Operating System MCQs. Learn about...

MongoDB

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

MySQL Database

Enhance your knowledge of relational databases with our MySQL MCQs. Understand...

Embedded Systems

Dive into the world of specialized computing systems with our Embedded Systems MCQs....

Cloud Computing

Stay on top of the biggest trend in IT with our Cloud Computing MCQs. These questions...

Java Spring Framework

Enhance your Java development skills with our Spring Framework MCQs. Learn about...

Reverse Engineering

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