Hello students welcome to Msbte News in this article we have provided 22319 Dbms Mcq Questions and Answers Pdf. This Dbms Mcq Question bank with answers pdf is ideal for students who are in 2nd Year Of Diploma in Computers Engineering Course.

With this Dbms multiple choice Questions with answers pdf you will get to know what exactly you have to write in the msbte final exams. And all though you will get answers solved by msbte board so the answers in Dbms Mcq pdf is 100% accurate.

In Below Given Database management Mcq Online Test we have selected 30 Important Questions apparently chosen from last 2 years papers. This Database management Questions and answers pdf will help you understand the basic rules of Online Mcq Exam and paper pattern of 22319 Mcq Questions. Below we have provided Mcq in dbms Download Link Feel free to Download and Get Yourself Prepared for Upcoming Exams.

Database management system Mcq Questions and Answer

1) Advantages of PL/SQL:
A. PL/SQL is a portable and high transaction processing language.
B. Data isolation
C. Atomicity problems
D. Integrity problems

Correct!

Wrong!

2) Which of the following provides the ability to query information from the database and insert tuples into, delete tuples from, and modify tuples in the database?
A. DML(Data Manipulation Language)DML(Data Manipulation Language)
B. DDL(Data Definition Language)
C. Query
D. Relational Schema

Correct!

Wrong!

3) What is a database?
A. Organized collection of information that cannot be accessed, updated, and managed
B. Collection of data or information without organizing
C. Organized collection of data or information that can be accessed, updated, and managed
D. Organized collection of data that cannot be updated

Correct!

Wrong!

4) Advantages of functions in PL/SQL
A. Easy access of data
B. Easy recovery
C. Work can be divided into smaller modules so that it can be manageable and also enhances the readability of the code.
D. Flexibility

Correct!

Wrong!

5) The given Query can be replaced with ____________:

SELECT name  

FROM instructor1  

WHERE salary <= 100000 AND salary >= 90000; 
A. SELECT name FROM instructor1 WHERE salary BETWEEN 100000 AND 90000
B. SELECT name FROM instructor| WHERE salary BETWEEN 90000 AND 100000;
C. SELECT name FROM instructor1 WHERE salary BETWEEN 90000 AND 100000;
D. SELECT name FROM instructor! WHERE salary <= 90000 AND salary>=100000;

Correct!

Wrong!

6) Types of normalization are
A. First normal form(1NF)
B. Second normal form(2NF)
C. Third normal form(3NF)
D. Boyce & Codd normal form (BCNF)
E. All of the above

Correct!

Wrong!

7)  In which of the following formats data is stored in the database management system?
A. Image
B. Text
C. Table
D. Graph

Correct!

Wrong!

8) Explain String functions
A. COUNT
B. Lower(char)
C. MAX()
D. MIN()

Correct!

Wrong!

9) The term “NTFS” refers to which one of the following?
A. New Technology File System
B. New Tree File System
C. New Table type File System
D. Both A and C

Correct!

Wrong!

10) Which one of the following refers to the copies of the same data (or information) occupying the memory space at multiple places.
A. Data Repository
B. Data Inconsistency
C. Data Mining
D. Data Redundancy

Correct!

Wrong!

11) Which of the following is a feature of the database?
A. No-backup for the data stored
B. User-interface provided
C. Lack of Authentication
D. Store data in multiple locations

Correct!

Wrong!

12) In general, a file is basically a collection of all related______.
A. Rows & Columns
B. Fields
C. Database
D. Records

Correct!

Wrong!

13) Which of the following is known as a set of entities of the same type that share the same properties, or attributes?
A. Relation set
B. Tuples
C. Entity set
D. Entity Relation model

Correct!

Wrong!

14) Which one of the following is a type of Data Manipulation Command?
A. Create
B. Alter
C. Delete
D. All of the above

Correct!

Wrong!

15)  _____________ is a hardware component that is most important for the operation of a database management system.
A. Microphone
B. High speed, large capacity disk to store data
C. High-resolution video display
D. Printer

Correct!

Wrong!

16) The term “TCL” stands for_____.
A. Ternary Control Language
B. Transmission Control Language
C. Transaction Central Language
D. Transaction Control Language

Correct!

Wrong!

17) In the relational table, which of the following can also be represented by the term “attribute”?
A. Entity
B. Row
C. Column
D. All of the above

Correct!

Wrong!

18) The database management system can be considered as the collection of ______ that enables us to create and maintain the database.
A. Translators
B. Programs
C. Keys
D. Language activity

Correct!

Wrong!

19) The term “DFD” stands for?
A. Data file diagram
B. Data flow document
C. Data flow diagram
D. None of the above

Correct!

Wrong!

20) The term “ODBC” stands for_____
A. Oral database connectivity
B. Oracle database connectivity
C. Open database connectivity
D. Object database connectivity

Correct!

Wrong!

21) The architecture of a database can be viewed as the ________
A. One level
B. Two-level
C. Three-level
D. Four level

Correct!

Wrong!

22) Which one of the following keywords is used to find out the 

number of values in a column?
A. TOTAL
B. COUNT
C. SUM
D. ADD

Correct!

Wrong!

23) Which one of the following is commonly used to define the overall design of the database?
A. Application program
B. Data definition language
C. Schema
D. Source code

Correct!

Wrong!

24) Which one of the following commands is used to modify a column inside a table?
A. Instance & Relation
B. Relation & Schema
C. Domain & Schema
D. Schema & Instance

Correct!

Wrong!

26) DELETE Command  is a DDL Data Definition Language)   command
A. True
B. False

Correct!

Wrong!

27) Primary key is an attribute or set of attributes used to identify an entity from an entity set. All the values of a primary key should be unique and null values are not allowed.
A. True
B. False

Correct!

Wrong!

28) Implicit cursors are generated and used by the system during the manipulation of a DML query.
A. True
B. False

Correct!

Wrong!

29) TRUNCATE Command is a DML (Data Manipulation Language) command.
A. True
B. False

Correct!

Wrong!

30) The Exception section is used to indicate termination of the PL/SQL block. It is mandatory
A. True
B. False

Correct!

Wrong!

Share the quiz to show your results !

Subscribe to see your results

DBMS TEST 3

I got %%score%% of %%total%% right

%%description%%

%%description%%

Loading…

This is the end of Database management system Mcq Online Test.

Dbms Mcq Questions and Answers Pdf

DBMS Mcq Pdf (Download)

Msbte News Social accounts

We provide regular updates about msbte on our social accounts For latest msbte diploma updates you can follow our page on Instagram @msbtenews and Facebook @msbtediplomaupdates. we solve your queries by message on our social accounts so do follow our social accounts if you have any queries related to diploma and engineering courses. 

Latest Diploma Jobs (View Here)

Thankyou for Visiting Msbte News.

msbte news.com is created to help msbte diploma students to find study resources, which are very much needed for diploma students while preparing for the exam. msbtenews.com will provide all msbte mcq question bank with answers which are provided by msbte.org.in. with these model question and answer papers students gets a rough idea about paper pattern and marks distribution.

LEAVE A REPLY

Please enter your comment!
Please enter your name here