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!

Computer Architecture

Unveil the science behind computer design with our Computer Architecture MCQs. Topics...

C Programming

Master one of the most widely used programming languages with our C Programming MCQs....

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...

Data Structures and Algorithms

Journey through the fundamentals of Data Structures and Algorithms with our extensive...

Systems Programming

Decode low-level programming with our Systems Programming MCQs. These questions delve...

Formal Languages and Automata Theory

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

Systems Analysis and Design Methods

Get familiar with the process of designing and improving business systems with our...

Operating System

Dive deep into the core of computers with our Operating System MCQs. Learn about...