Scribd
Upload
17 views1 page

DBMS (Pgdca)

The document outlines the model examination for PGDCA in DBMS (SQL, ORACLE) at Gurukul College, Pathalgaon for the academic year 2023-24. It includes five compulsory questions covering various topics such as DBMS, database models, relational algebra, normalization, and query languages. Each question carries equal marks, with options provided for some questions.

Uploaded by

Mahabeer Rana
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
17 views1 page

DBMS (Pgdca)

The document outlines the model examination for PGDCA in DBMS (SQL, ORACLE) at Gurukul College, Pathalgaon for the academic year 2023-24. It includes five compulsory questions covering various topics such as DBMS, database models, relational algebra, normalization, and query languages. Each question carries equal marks, with options provided for some questions.

Uploaded by

Mahabeer Rana
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

GURUKUL COLLEGE PATHALGAON DISTRICT-JASHPUR GURUKUL COLLEGE PATHALGAON DISTRICT-JASHPUR

MODEL EXAMINATION 2023-24 MODEL EXAMINATION 2023-24


PGDCA PGDCA
DBMS (SQL, ORACLE) DBMS (SQL, ORACLE)
Max Marks: 100 Time: 3 Hours Max Marks: 100 Time: 3 Hours

Note: Attempt all five questions. One question from each unit is compulsory. Note: Attempt all five questions. One question from each unit is compulsory.
All questions carry equal marks. All questions carry equal marks.
Q.1> What do you mean by DBMS? Explain data base models in detail. Q.1> What do you mean by DBMS? Explain data base models in detail.
Or Or
Explain database with its elements and components and also discuss why Explain database with its elements and components and also discuss why DBMS
DBMS is better than file system. is better than file system.
Q.2> Explain the following terms: Q.2> Explain the following terms:
(I) Candidate key and foreign key (II) Mapping constraint (I) Candidate key and foreign key (II) Mapping constraint
Or Or
What is E-R model? Explain special features of E-R model. What is E-R model? Explain special features of E-R model.
Q.3> What is importance of relational algebra? Explain the relational algebra Q.3> What is importance of relational algebra? Explain the relational algebra operations
operations in detail. in detail.
Or Or
What is joins? Explain natural joins, equi joins, outer joins in detail with What is joins? Explain natural joins, equi joins, outer joins in detail with example.
example. Q.4> What do you mean by Normalization? What is its need and explain various forms
Q.4> What do you mean by Normalization? What is its need and explain various of Normalization with Suitable example.
forms of Normalization with Suitable example. Or
Or (a) What do you mean by functional dependency, fully functional dependency
(a) What do you mean by functional dependency, fully functional multivalued and join dependency? Explain in detail.
dependency multivalued and join dependency? Explain in detail. (b) Write short notes and define the non-loss decomposition with examples.
(b) Write short notes and define the non-loss decomposition with Q.5> What do you mean by commercial query language.
examples. Or
Q.5> What do you mean by commercial query language. Explain in detail PL-SQL/TSQL.
Or
Explain in detail PL-SQL/TSQL.

You might also like