Hello students welcome to Msbte News in this article we have provided 22521 Advanced Database Management System Objective Questions with Answer. This Advanced Database Management System Mcq Questions with Answers Pdf is ideal for students who are in 3rd Year of Diploma in Computers Engineering.
With this Advanced Database Management System Multiple Choice Questions and Answers 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 Advanced Database Management System Mcq 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
Advanced Database Management System Objective Questions
1) What’s the use of a two phase locking protocol?
A. It offers Concurrency Control
B. Two Phase Locking offers serializability.
C. It checks for local and global deadlocks and solve them by resuming transactions to their initial states
D. All of the above
Correct!
Wrong!
2) Any action that will compromise the integrity and confidentiality of a resource is an intrusion
A. Research Analysis
B. Fraud Detection
C. Intrusion Detection
D. Both a and b
Correct!
Wrong!
3) Benefits of No-SQL
A. Breadth of functionality
B. Easy to Scale
C. No legacy code
D. All of the above
Correct!
Wrong!
4) Billions of dollars have been lost to the action of _____
A. Frauds
B. Financial Banking
C. Intrusion Detection
D. Research Analysis
Correct!
Wrong!
5) Application of data mining
A. Education
B. Healthcare
C. CRM
D. All of the above
Correct!
Wrong!
6)Â _______Â is done by a business analyst, onsite technical lead & client.
A. Requirement Analysis
B. Project Planning
C. Requirement gathering
D. None of the above
Correct!
Wrong!
7) The user IDs can be added or removed using which of the following fixed roles?
A. db_sysadmin
B. db_accessadmin
C. db_securityadmin
D. db_setupadmin
Correct!
Wrong!
8) The traditional storage of data organized by the customer, stored in separate folders in filing cabinets is an example of ______________ type of ‘database’ management system.
A. Object-oriented database management system
B. Relational database management system
C. Network database management system
D. Hierarchical database management system
Correct!
Wrong!
8) Which of the following is not the utility of DBMS?
i) Backup ii) Loading iii) Process Organization iv) File organization
A. i, ii, and iv only
B. i, ii and iii only
C. i, iii and iv only
D. All i, ii, iii, and iv
Correct!
Wrong!
10) Which of the following is correct according to the technology deployed by DBMS?
A. Pointers are used to maintain transactional integrity and consistency
B. Cursors are used to maintain transactional integrity and consistency
C. Locks are used to maintain transactional integrity and consistency
D. Triggers are used to maintain transactional integrity and consistency
Correct!
Wrong!
11) What is the function of the following command?
Delete from r where P;
A. Clears entries from relation
B. Deletes relation
C. Deletes particular tuple from relation
D. All of the mentioned
Correct!
Wrong!
12) The query specifying the SQL view is said to be updatable if it meets which of the following conditions?
A. select clause contains relation attribute names but not have expressions, aggregates, or distinct specification
B. from clause has 1 relation
C. query does not have group by or having clause
D. All of the mentioned
Correct!
Wrong!
13) Which of the following is the best way to represent the attributes in a large db?
A. Dot representation
B. Concatenation
C. Relational-and
D. All of the mentioned
Correct!
Wrong!
14) Which of the following functions construct histograms and use buckets for ranking?
A. Ntil()
B. Newtil()
C. Rank()
D. All of the mentioned
Correct!
Wrong!
15) Which of the following is a database element?
A. Data
B. Constraints and schema
C. Relationships
D. All of these.
Correct!
Wrong!
16) What scheme defines how and where the data are organized in a physical data storage?
A. External
B. Internal
C. Conceptual
D. None of these.
Correct!
Wrong!
17) A collection of data designed to be used by different people is called.
A. Database
B. RDBMS
C. DBMS
D. None of these
Correct!
Wrong!
18) Which technique is based on linking of variables
A. Cluster detection
B. Decision trees
C. Link analysis
D. All of the above
Correct!
Wrong!
19) In ……………technique, data splits at decision points based on entropy
A. Cluster detection
B. Decision trees
C. Link analysis
D. All of the above
Correct!
Wrong!
20) Data mining applications include
A. Customer segmentation
B. Market basket analysis
C. Risk management
D. All of the above
Correct!
Wrong!
21) …………….is a best source of data for a data mining operation
A. OLAP
B. Data warehouse
C. OLTP
D. None of the above
Correct!
Wrong!
22) …………….steps comprise the knowledge discovery process
A. 3
B. 4
C. 5
D. 6
Correct!
Wrong!
23)Â How many tables can be joined to create a view?
A. 1
B. 2
C. Database dependent
D. None of these
Correct!
Wrong!
24) Which of the following constitutes a basic set of operations for manipulating relational data?
A. Predicate calculus
B. Relational algebra
C. Relational calculus
D. None of the above
Correct!
Wrong!
25) Which of the following is not a relational algebraic operation that is developed specifically for the relational databases?
A. SELECT
B. UNION
C. JOIN
D. PROJECT
Correct!
Wrong!
26) Which of the following operations need the participating relations to be union compatible?
A. UNION
B. INTERSECTION
C. DIFFERENCE
D. All of the above
Correct!
Wrong!
27) What will be the number of columns of CARTESIAN PRODUCT if the participation relations have 5 and 20 rows respectively?
A. 5
B. 20
C. 25
D. 100
Correct!
Wrong!
28) Which of the following schemas defines a view or views of the database for particular users?
A. External
B. Conceptual
C. Internal
C. Internal
Correct!
Wrong!
29)Â A complex data type is usually a composite of other existing data types.
A. True
B. False
Correct!
Wrong!
30) Data warehouse life-cycle is used to indicate the phases & their relationship through which the data warehouse system goes.
A. True
B. False
Correct!
Wrong!
Share the quiz to show your results !
Subscribe to see your results
22521 Test 1 Advanced DataBase Management System
I got %%score%% of %%total%% right
%%description%%
%%description%%
Loading…
Advanced Database Management System Mcq Questions with Answers Pdf
Database Management System Multiple Choice Questions and Answers Pdf (Download)
Database Management System Question Paper: (View Here)
Database Management System Answer Paper: (View Here)
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.
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.
