22319 Database Management System Mcq Pdf

2
5359
Database management system mcq

Hello students welcome to Msbte News in this article we have provided 22319 Database Management System Mcq Questions and Answer. This DBMS Mcq Pdf Download is ideal for students who are in Diploma in Computers Engineering 2nd Year students.

With this 22319 Database Mcq Questions and 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 with Answers pdf is 100% accurate.

In Below Given Dbms Mcq Questions we have selected 30 Important Questions apparently chosen from last 2 years papers. This Dbms Mcq with Answers will help you understand the basic rules of Online Mcq Exam and paper pattern of 22319 Mcq Questions.

Database Mcq Questions and answers pdf

Database management system mcq
Database Management System Questions and Answers PDF download

22319 Database management system mcq

1) Advantages of DBMS
A. Reduction in Data redundancy
B. Data consistency and integrity
C. Data security
D. Privacy
E. All of the above

Correct!

Wrong!

2) Which of the following is generally used for performing tasks like creating the structure of the relations, deleting relations?
A. DML(Data Manipulation Language
B. Query
C. Relational Schema
D. DDL Data Definition Language

Correct!

Wrong!

3) What is the full form of DBMS?
A. Data of Binary Management System
B. Database Management System
C. Database Management Service
D. Data Backup Management System

Correct!

Wrong!

4) List string functions in SQL
A. Initcap(String)
B. Upper(String)
C. Lower(String)
D. Length(String)
E. Lpad(String,char,number)
F. Rpad(String,char,number)
G All of the above

Correct!

Wrong!

5) In the following Query, which of the following can be placed in the Query’s blank portion to display the salary from highest to lowest amount, and sorting the employees name alphabetically?

SELECT *  

FROM instructor  

ORDER BY salary ____, name ___; 
A. Ascending, Descending
B. Asc, Desc
C. Desc, Asc
D. All of the above

Correct!

Wrong!

6) List DCL command
A. GRANT
B. REVOKE
C. All of the above
D. None of the above

Correct!

Wrong!

7) Which type of data can be stored in the database?
A. Image oriented data
B. Text, files containing data
C. Data in the form of audio or video
D. All of the above

Correct!

Wrong!

8) disadvantages of typical file processing systems.
A. Data redundancy and inconsistency
B. Difficulty in accessing data
C. Data isolation
D. Integrity problems
All of the above

Correct!

Wrong!

9) Which of the following can be considered as the maximum size that is supported by FAT?
A. 8GB
B. 4GB
C. 4TB
D. None of the above

Correct!

Wrong!

10) Which of the following can be used to extract or filter the data & information from the data warehouse?
A. Data redundancy
B. Data recovery tool
C. Data mining
D. None of the above

Correct!

Wrong!

11)  Which of the following is a feature of DBMS?
A. Minimum Duplication and Redundancy of Data
B. High Level of Security
C. Single-user Access only
D. Support ACID Property

Correct!

Wrong!

12)  To which of the following the term “DBA” referred?
A. Data Bank Administrator
B. Database Administrator
C. Data Administrator
D. None of the above

Correct!

Wrong!

13) Which of the following is a component of the DBMS?
A. Data
B. Data Languages
C. Data Manager
D. All of the above

Correct!

Wrong!

14) Which of the following refers to the number of tuples in a relation?
A. Entity
B. Column
C. Cardinality
D. None of the above

Correct!

Wrong!

15) The values appearing in given attributes of any tuple in the referencing relation must likewise occur in specified attributes of at least one tuple in the referenced relation, according to _____________________ integrity constraint.
A. Referential
B. Primary
C. Referencing
D. Specific

Correct!

Wrong!

16) In which one of the following, the multiple lower entities are grouped (or combined together to form a single higher-level entity?
A. Specialization
B. Generalization
C. Aggregation
D. None of the above

Correct!

Wrong!

17) In a relational database, every tuple divided into the fields are known as the______.
A. Queries
B. Domains
C. Relations
D. All of the above

Correct!

Wrong!

18) Which one of the following commands is used for removing (or deleting) a relation from the SQL database?
A. Delete
B. Drop
C. Remove
D. All of the above

Correct!

Wrong!

19) Which one of the following commands is used to restore the database to the last committed state?
A. Savepoint
B. Rollback
C. Commit
D. All of the above

Correct!

Wrong!

20) Which one of the following refers to the total view of the database content?
A. Conceptual view
B. Physical view
C. Internal view
D. External view

Correct!

Wrong!

21) For what purpose the DML is provided?
A. Addition of new structure in the database
B. Manipulation & processing of the database
C. Definition of the physical structure of the database system
D. All of the above

Correct!

Wrong!

22)  Which of the following levels is considered as the level closed to the end-users?
A. Internal Level
B. External Level
C. Conceptual Level
D. Physical Level

Correct!

Wrong!

23) A computer security protocol for logging-in can be considered as the example of the ______ component of an information system.
A. Data
B. Software
C. Procedure
D. Hardware

Correct!

Wrong!

24) 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!

25) A table is a collection of related data held in table format. It is a set of data elements using a model of vertical columns and horizontal rows.
A. True
B. False

Correct!

Wrong!

26) Each table contains a field which is a data structure, used to hold the data. It can also be termed as an attribute.
A. True
B. False

Correct!

Wrong!

27) Hierarchical model Reflects M:N(many to many) relations 
A. True
B. False

Correct!

Wrong!

28) A cursor is a temporary work area created in system memory when an SQL statement is executed.
A. True
B. False

Correct!

Wrong!

29) Design of a database is called a schema. Schema is of three types: Physical schema, logical schema and view schema.
A. True
B. False

Correct!

Wrong!

30) The COMMIT command is used to undo transactions that have not already been saved to the database. 
A. True
B. False

Correct!

Wrong!

Share the quiz to show your results !

Subscribe to see your results

DBMS TEST 1

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

%%description%%

%%description%%

Loading…

This is the end of Database Management System 22319 Mcq Test papers.

Database management system DBMS Mcq Pdf Download

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.

2 Comments

Leave a reply

Please enter your comment!
Please enter your name here