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 21 of 23

Explore more Topics under UGC CBSE NET Exam

Q201.
Data Scrubbing is

a.

A process to upgrade the quality of data after it is moved into a data warehouse.

b.

A process to reject data from the data warehouse and to create the necessary indexes.

c.

A process to load the data in the data warehouse and to create the necessary indexes.

d.

A process to upgrade the quality of data before it is moved into a data warehouse.

Discuss
Answer: (d).A process to upgrade the quality of data before it is moved into a data warehouse.
Q202.
An attribute A of datatype varchar(20) has the value ‘xyz’, and the attribute B of datatype char(20) has the value “lmnop”, then the attribute A has ............... spaces and attribute B has ............... spaces.

a.

3,5

b.

20,20

c.

3,20

d.

20,5

Discuss
Answer: (c). 3,20
Q203.
Data warehouse contains ............... data that is never found in operational environment.

a.

Summary

b.

Encoded

c.

Encrypted

d.

Scripted

Discuss
Answer: (a).Summary
Q204.
.................. command is used to remove a relation from SQL database.

a.

Drop table

b.

Delete table

c.

Remove table

d.

Update table

Discuss
Answer: (a).Drop table
Q205.
Which of the following statement/s is/are true?

(i) Facebook has the world’s largest Hadoop Cluster.
(ii) Hadoop 2.0 allows live stream processing of Real time data.

Choose the correct answer from the code given below:

a.

(i) only

b.

(ii) only

c.

Both (i) and (ii)

d.

Neither (i) nor (ii)

Discuss
Answer: (c).Both (i) and (ii)
Q206.
Consider the relation schema R = (A,B,C,D,E,F) on which the following functional dependencies hold:

A → B
B, C → D
E → C
D → A

What are the candidate keys of R?

a.

AE and BE

b.

AE, BE and DE

c.

AEF, BEF and BCF

d.

AEF, BEF and DEF

Discuss
Answer: (d). AEF, BEF and DEF
Q207.
Consider the following sequence of two transactions on a bank account (A) with initial balance 20,000 that transfers 5,000 to another account (B) and then apply 10% interest.

(i) T1 start
(ii) T1 A old = 20,000 new 15,000
(iii) T1 B old = 12,000 new = 17,000
(iv) T1 commit
(v) T2 start
(vi) T2 A old = 15,000 new = 16,500
(vii) T2 commit

Suppose the database system crashes just before log record (vii) is written. When the system is restarted, which one statement is true of the recovery process?

a.

We must redo log record (vi) to set A to 16,500.

b.

We must redo log record (vi) to set A to 16,500 and then redo log records (ii) and (iii).

c.

We need not redo log records (ii) and (iii) because transaction T1 is committed.

d.

We can apply redo and undo operations in arbitrary order because they are idempotent.

Discuss
Answer: (b).We must redo log record (vi) to set A to 16,500 and then redo log records (ii) and (iii).
Q208.
Consider the following tables (relations).

Primary keys in the tables are shown using underline. Now, consider the following query:

SELECT S.Name, Sum (P.Marks)
FROM Students S, Performance P
WHERE S.Roll-No = P.Roll-No
GROUP BY S.Name

The number of rows returned by the above query is

a.

0

b.

1

c.

2

d.

3

Discuss
Answer: (c).2
Q209.
A clustering index is defined on the fields which are of type:

a.

non-key and ordering

b.

non-key and non-ordering

c.

key and ordering

d.

key and non-ordering

Discuss
Answer: (a).non-key and ordering
Q210.
In RDBMS, which type of Join returns all rows that satisfy the join condition?

a.

Inner Join

b.

Outer Join

c.

Semi Join

d.

Anti Join

Discuss
Answer: (a).Inner Join
Page 21 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!

Wireless and Mobile Communications

Get to grips with modern communication technologies with our Wireless and Mobile...

MS Office

Master the suite of productivity tools with our MS Office MCQs. From Word and Excel...

Formal Languages and Automata Theory

Discover the mathematical models of computation with our Formal Languages and...

Object Oriented Programming

Enhance your coding skills with our Object Oriented Programming MCQs. Understand...

Discrete Mathematics

Refine your mathematical skills essential for computer science with our Discrete...

Big Data Computing

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

Digital Logic Design

Understand the foundation of digital computers with our Digital Logic Design MCQs....

Hadoop

Dive into the world of big data with our Hadoop MCQs. Cover key concepts including...

IT Fundamentals

Navigate the basics of information technology with our IT Fundamentals MCQs. Get a...