Database Management System (DBMS) is one of the most important subjects in* UGC NET Computer Science and Application* national level examination for Paper II. In July, 2018, approximately 10 questions of 2 marks each have been asked which sums upto 20 marks. Among the given topics in syllabus, following topics as mentioned in Figure given below are important and scoring.

*have been the most important topics in DBMS and 21 questions from each of these have been asked in last 14 years.*

**Normalization and SQL**### Important Topics in DBMS

includes questions related to 2nd Normal Form, 3rd Normal Form, BCNF and MVD.**Normalization**- From
, interpretation of queries is very important segment.**SQL** - This has been followed by
in which questions related to strict recoverable, Thomas write back etc have been asked frequently.**transaction and recovery** - Next,
are important topics on which 12 and 13 question have been asked in last 14 years**Candidate keys and ER model** - Similarly,
and**specialization/ generalization**are two important topics and from each 9 questions have been picked up in last 14 years. From decomposition,*decomposition*is less important than**lossless decomposition**.**dependency preserved** - Followed by
,**Data Models, Relational Algebra and Relational Calculus**and**Relational Schema**containing 4 questions each in previous years.**DBA/DML** - Most of the questions are related to
and**keys**.**constraints** - These days constraint based questions are being asked. Identifying
s another important subject from which 12 questions have been asked in last 14 years.**candidate key i** - There was one question out of the way related to
*Data flow diagrams*few years ago. But exceptions can be there. - Statement questions for True/ False are 95% given from the above topics only.

### Advanced Topics in DBMS

There are few topics which are consistent or are uprising in recent years. These important topics in DBMS are

**ER model****Normalization****Candidate Keys****Transaction and Recovery****Decomposition****Relational Schema, Algebra and Tuple**

If each candidate touch all these topics and study thoroughly, one can easily attempt 90-95% of the questions from DBMS.

Good Luck!

Pingback: casino games online

DanielSoadesays:https://cvvforsale.ru – cvvshoplist

RichardTigsays:https://cheapcvv.ru – ybfstoredumps

BrendanCoxsays:https://creditcarddumps.pl – dumpsshop2018

Irvingduhsays:https://cvvforsale.ru – cvvshopforum

MichaelNogsays:https://cvvdumps.pl – selldumpswithpin

Irvingduhsays:https://cvvstore.pl – rescatordumps

Petertefsays:https://creditcarddumps.pl – bestccdumpssite

Phillipcaurisays:https://cvvstore.pl – paypalcvvshop

akekRewsays:https://dumpsstore.pl – buycreditcarddumps

sfeglonsays:https://cvvshoplv.pl – cccvvdumps

MichaelNogsays:https://dumpsstore.pl – cardingdumps

DanielSoadesays:https://unicctordomain.ru – cardingdumpswithpin

RichardTigsays:https://uniccwebsite.ru – atmdumpswithpinshop

BrendanCoxsays:https://xaker.pl – cvvdumpswebsite

Irvingduhsays:https://storecvv.ru – ferumccshop

MichaelNogsays:https://uniccnewdomain2018.ru – buydumpswithpin2018

Irvingduhsays:https://uniccreddit.ru – topccshop

Petertefsays:https://stockhousedumpshop.ru – ccbuyforcarding

Phillipcaurisays:https://storecc.pl – dumpswithpinlegit

akekRewsays:https://uniccwebsite.ru – unicccvv

sfeglonsays:https://uniccfreecc.ru – cvvcardingsites

MichaelNogsays:https://uniccbazarlogin.ru – cvvshop2019

Petertefsays:https://unicc.kz – benumb cc shop

akekRewsays:https://cvvshop.in – cvv vbv shop

BrendanCoxsays:https://xakersoft.ru – dump cards with pin

sfeglonsays:https://validccshop.tk – goodshop dumps

DanielSoadesays:https://feshop.tk – fullz card

DanielSoadesays:https://unicc.kz – fullz card

RichardTigsays:https://unicc.kz – cvv shop 2018

BrendanCoxsays:https://skladelok.ru/shop/елка-элитная-золото-пвх – ель искусственная купить