adplus-dvertising

Welcome to the DBMS MCQs Page

Dive deep into the fascinating world of DBMS with our comprehensive set of Multiple-Choice Questions (MCQs). This page is dedicated to exploring the fundamental concepts and intricacies of DBMS, a crucial aspect of UGC CBSE NET Exam. In this section, you will encounter a diverse range of MCQs that cover various aspects of DBMS, from the basic principles to advanced topics. Each question is thoughtfully crafted to challenge your knowledge and deepen your understanding of this critical subcategory within UGC CBSE NET Exam.

frame-decoration

Check out the MCQs below to embark on an enriching journey through DBMS. Test your knowledge, expand your horizons, and solidify your grasp on this vital area of UGC CBSE NET Exam.

Note: Each MCQ comes with multiple answer choices. Select the most appropriate option and test your understanding of DBMS. You can click on an option to test your knowledge before viewing the solution for a MCQ. Happy learning!

DBMS MCQs | Page 7 of 23

Explore more Topics under UGC CBSE NET Exam

Q61.
Consider the following relation:

Works (emp_name, company_name, salary)
Here, emp_name is primary key.

Consider the following SQL query:

Select emp_name
From Works T
where salary>(select avg (salary)
from Works S
where T.company_name=
S. Company_name)

The above query is for following:

a.

Find the highest paid employee who earns more than the average salary of all employees of his company

b.

Find the highest paid employee who earns more than the average salary of all the employees of all the companiesFind the highest paid employee who earns more than the average salary of all the employees of all the companiesFind the highest paid employee who earns more than the average salary of all the employees of all the companies

c.

Find all employees who earn more than the average salary of all employees of all the companies

d.

Find all employees who earn more than the average salary of all employees of their company

Discuss
Answer: (d).Find all employees who earn more than the average salary of all employees of their company
Q62.
DBMS provides the facility of accessing data from a database through

a.

DDL

b.

DML

c.

DBA

d.

Schema

Discuss
Answer: (b).DML
Q63.
Relational database schema normalization is NOT for:

a.

reducing the number of joins required to satisfy a query

b.

eliminating uncontrolled redundancy of data stored in the database

c.

eliminating number of anomalies that could otherwise occur with inserts and deletes

d.

ensuring that functional dependencies are enforced

Discuss
Answer: (a).reducing the number of joins required to satisfy a query
Q64.
Consider the following statements regarding relational database model:

(a) NULL values can be used to opt a tuple out of enforcement of a foreign key.
(b) Suppose that table T has only one candidate key. If Q is in 3NF, then it is also in BCNF.
(c) The difference between the project operator (P) in relational algebra and the SELECT keyword in SQL is that if the resulting table/set has more than one occurrences of the same tuple, then P will return only one of them, while SQL SELECT will return all.

One can determine that:

a.

(a) and (b) are true

b.

(a) and (c) are true

c.

(b) and (c) are true

d.

(a), (b) and (c) are true

Discuss
Answer: (d).(a), (b) and (c) are true
Q65.
Consider the following Entity-Relationship (E-R) diagram and three possible relationship sets (I, II and III) for this E-R diagram.

If different symbols stand for different values (e.g., t1 is definitely not equal to t2), then which of the above could not be the relationship set for the E-R diagram ?

a.

I only

b.

I and II only

c.

II only

d.

I, II and III

Discuss
Answer: (a).I only
Q66.
Consider a database table R with attributes A and B. Which of the following SQL queries is illegal ?

a.

SELECT A FROM R;

b.

SELECT A, COUNT(*) FROM R;

c.

SELECT A, COUNT(*) FROM R GROUP BY A;

d.

SELECT A, B, COUNT(*) FROM R GROUP BY A, B;

Discuss
Answer: (b).SELECT A, COUNT(*) FROM R;
Q67.
Which of the following statements is/are True regarding some advantages that an object-oriented DBMS (OODBMS) offers over a relational database?

I. An OODBMS avoids the “impedance mismatch” problem.
II. An OODBMS avoids the “phantom” problem.
III. An OODBMS provides higher performance concurrency control than most relational databases.
IV. An OODBMS provides faster access to individual data objects once they have been read from disk.

a.

II and III only

b.

I and IV only

c.

I, II, and III only

d.

I, III and IV only

Discuss
Answer: (b).I and IV only
Q68.
The Global conceptual Schema in a distributed database contains information about global relations. The condition that all the data of the global relation must be mapped into the fragments, that is, it must not happen that a data item which belongs to a global relation does not belong to any fragment, is called :

a.

Disjointness condition

b.

Completeness condition

c.

Reconstruction condition

d.

Aggregation condition

Discuss
Answer: (b).Completeness condition
Q69.
Suppose database table T1(P, R) currently has tuples {(10, 5), (15, 8), (25, 6)} and table T2 (A, C) currently has {(10, 6), (25, 3), (10, 5)}. Consider the following three relational algebra queries RA1, RA2 and RA3.

The number of tuples in the resulting table of RA1, RA2 and RA3 are given by:

a.

2, 4, 2 respectively

b.

2, 3, 2 respectively

c.

3, 3, 1 respectively

d.

3, 4, 1 respectively

Discuss
Answer: (d).3, 4, 1 respectively
Q70.
Consider the table R with attributes A, B and C. The functional dependencies that hold on R are : A → B, C → AB. Which of the following statements is/are True?

I. The decomposition of R into R1(C, A) and R2(A, B) is lossless.
II. The decomposition of R into R1(A, B) and R2(B, C) is lossy.

a.

Only I

b.

Only II

c.

Both I and II

d.

Neither I nor II

Discuss
Answer: (c).Both I and II
Page 7 of 23

Suggested Topics

Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

Cyber Security

Understand the fundamentals of safeguarding digital assets with our Cyber Security...

R Programming

Unleash the power of statistical computing with our R Programming MCQs. Topics cover...

UNIX

Become proficient with the Unix operating system using our UNIX MCQs. Learn about...

Software Engineering

Learn about the systematic approach to developing software with our Software...

Microprocessor

Understand the heart of your computer with our Microprocessor MCQs. Topics include...

DBMS

Get a firm grasp on database systems with our DBMS MCQs. Explore relational...

Visual Basic

Enhance your knowledge of Microsoft's event-driven programming language with our...

Big Data Computing

Enhance your understanding of Big Data Computing with our comprehensive MCQs. Explore...

CompTIA PenTest+ Certification Exam PT0 002

Prepare for the CompTIA PenTest+ PT0-002 exam with our targeted MCQs. Covering...