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.
Table of Contents
Database Mcq Questions and answers pdf
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.
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.
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.
Excellent question in question nank
Send meore mcq of DMS