Hello students welcome to Msbte News in this article we have provided 22521 Advanced Database Management System Mcq Online Test. This Advanced Database Management System Mcq Questions with Answers is ideal for students who are in Diploma in Computers Engineering 2nd Year students.

With this Database Management System Multiple Choice Questions 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 Questions pdf is 100% accurate.

In Below Given Database Management System 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.

Advanced Database Management System Mcq Online Test

1) ________ is a modelling technique based upon a theory that if you buy a certain group of items you are more likely to buy another group of items
A. Market Basket Analysis
B. Education
C. CRM
D. None of the above

Correct!

Wrong!

2) A _______ on a data item can either have locked or unlocked states.
A. Binary lock
B. Shared Lock
C. None of the above

Correct!

Wrong!

3) Data mining holds great potential to improve 
A. Market Basket Analysis
B. health systems
C. Education
D. None of the above

Correct!

Wrong!

4) The ______ operations are used to add new documents into the collection.
A. Read
B. Update
C. Create
D. None of the above

Correct!

Wrong!

5) It is used to retrieve the documents from the collection.
A. Read operations
B. Update operation
C. Create operation
D. Both a and b

Correct!

Wrong!

6) Why is the following statement erroneous?

SELECT dept_name, ID, avg (salary)

FROM instructor

GROUP BY dept_name;
A. Dept_id should not be used in group by clause
B. Group by clause is not valid in this query
C. Avg(salary) should not be selected
D. None

Correct!

Wrong!

7) After groups have been established, SQL applies predicates in the ___________ clause, allowing aggregate functions to be used.
A. Where
B. Having
C. Group by
D. With

Correct!

Wrong!

8) What does a foreign key combined with a primary key create?
A. Network model between the tables that connect them
B. Parent-Child relationship between the tables that connects them
C. One to many relationship between the tables that connects them
D. All of the mentioned

Correct!

Wrong!

9) Which of the following is correct regarding the file produced by a spreadsheet?
A. can be used as it is by the DBMS
B. stored on disk in an ASCII text format
C. all of the mentioned
D. none of the mentioned

Correct!

Wrong!

10) When the “ROLLUP” operator for expression or columns within a “GROUP BY” clause is used?
A. Find the groups that make up the subtotal in a row
B. Create group-wise grand totals for the groups indicated in a GROUP BY clause
C. Group expressions or columns specified in a GROUP BY clause in one direction, from right to left, for computing the subtotals
D. To produce a cross-tabular report for computing subtotals by grouping phrases or columns given within a GROUP BY clause in all available directions

Correct!

Wrong!

11)  ______ resembles Create view.
A. Create table . . . as
B. Create view as
C. Create table . . .like
D. With data

Correct!

Wrong!

12) Which of the following is the subset of SQL commands used to manipulate Oracle Structures, including tables?
A. Data Described Language
B. Data Retrieval Language
C. Data Manipulation Language
D. Data Definition Language

Correct!

Wrong!

13)  __________ command is used in SQL to issue multiple CREATE TABLE, CREATE VIEW and GRANT statements in a single transaction.
A. CREATE CLUSTER
B. CREATE PACKAGE
C. CREATE SCHEMA
D. All of the mentioned

Correct!

Wrong!

14) What separates the physical aspects of data storage from the logical aspects of data representation?
A. Data
B. Schema
C. Constraints
D. Relationships

Correct!

Wrong!

15) Which of the following schemas defines a view or views of the database for particular users?
A. External
B. Conceptual
C. Internal
D. None of these

Correct!

Wrong!

16) Which of the following is an object-oriented feature?
A. Inheritance
B. Abstraction
C. Polymorphism
D. All of these

Correct!

Wrong!

17) Association of unknown instances with known instances is a process of………….technique
A. Memory based reasoning
B. Link analysis
C. Neural network
D. Genetic algorithm

Correct!

Wrong!

18) Forward propagation network is a structure of……………..
A. Memory based reasoning
B. Link analysis
C. Neural network
D. Genetic algorithm

Correct!

Wrong!

19) Fraud detection is an application of
A. Data warehousing
B. Data mining
C. Both I and ii
D. None of the above

Correct!

Wrong!

20)  …………….uncovers relationships and patterns in the existing data
A. Data mining
B. Data warehouse
C. OLAP
D. None of the above

Correct!

Wrong!

21) Which of the following clauses specifies the table or tables from where the data has to be retrieved?
A. Where
B. Table
C. From
D. None of these

Correct!

Wrong!

22) Which of the following can be used to get those items that fall within a range?
A. IN
B. BETWEEN
C. DISTINCT
D. LIKE

Correct!

Wrong!

23) Which of the following is not a relational algebraic operation that does not form the set theory?
A. UNION
B. INTERSECTION
C. CARTESIAN PRODUCT
D. SELECT

Correct!

Wrong!

24) Which is the symbol used to denote the SELECT operation?
A. Sigma
B. Rho
C. Pi
D. None of the above

Correct!

Wrong!

25) What will be the number of columns of CARTESIAN PRODUCT if the participating

relations have 5 and 7 columns respectively?
A. 5
B. 12
C. 35
D. None of the above

Correct!

Wrong!

26) Which of the following is the operation that is used if we are interested in only certain attributes or columns of a table?
A. SELECT
B. PROJECT
C. UNION
D. JOIN

Correct!

Wrong!

27)  …………….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!

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

29) NoSQL databases have predefined schema
A. True
B. False

Correct!

Wrong!

30) In Structured Data type scaling database is difficult
A. True
B. False

Correct!

Wrong!

Share the quiz to show your results !

Subscribe to see your results

22521 Test 2 Advanced DataBase Management System

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

%%description%%

%%description%%

Loading…

Advanced Database Management System Multiple Choice Questions

Database Management System Mcq Questions with 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. 

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