Exam Tiger
APTITUDE TESTS - MENTAL ABILITY - SOLVED OBJECTIVE MCQ SETS - QUESTION ANSWER - PDF STUDY MATERIALS - SHORTCUT TIPS
LANGUAGE

Database Management System (DBMS)

Database Management Short Questions to test Database concept : DBMS is the short form of Database Management System. DBMS is a collection of computer programs that helps us to create and manage database. Database is collection of data and Managing database includes storing, querying, updation, and administration of databases. So, a DBMS software is a combination of two things, a Database and the Management System. End users interacts with a Databases with the help of a computer software application called front-end application, like forms, touch screens, etc. Databases are used widely in banking sector, computerized medical stores, online shopping portals, Railways & Airways Reservation Systems, ATMs, etc.

Example of some popular DBMS tool includes MS Access, MySql, Sql Server, Oracle, etc. MS Access is very popular among common Database needs, whereas for Advanced Database Management System Sql Server and Oracle are preferred. However, most of the web application uses MySql as backend database.


Database Management System (DBMS) Multiple Choice (MCQ) objective question with answer keys

Here you will find a list of common important questions on database management system (dbms) in multiple choice question (MCQ) style with answer. These frequently asked sample questions are given with correct choice of answer that you can check instantly. Presently we have added total 4 sets of questions on database management system (dbms) for you to practice. We will keep adding more questions and provide this question bank in PDF format, so that you can download them instantly in E-book style.

The following section consists of objective multiple choice questions (mcq) on database management system (dbms) with answers.


INSTRUCTION: CLICK ON THE OPTION (A, B, C, D) TO SELECT IT AS YOUR ANSWER.


Q. What do you mean by one to many relationship between Teacher and Class table?
A.
One class may have many teachers
B.
One teacher can have many classes

C.
Many classes may have many teachers
D.
Many teachers may have many classes


Show Answer
Q. What are the different view to present a Table ?
A.
Datasheet View
B.
Design View

C.
Pivote TableView
D.
All Of Above


Show Answer
Q. In one-to-many relationship the table on 'many' side is called _______
A.
Parent
B.
Child

C.
Sister
D.
Master


Show Answer
Q. In which state one gathers and list all the necessary fields for the database design project.
A.
Data Definition
B.
Data Refinement

C.
Establishing Relationship
D.
None Of The Above


Show Answer
Q. Which of the following enables us to view data from a table based on a specific criterion
A.
Form
B.
Query

C.
Macro
D.
Report


Show Answer



Advertisement


eXTReMe Tracker