Solved question paper for RDBMS Dec-2008 (DIPLOMA 3rd)

Home
psbte
diploma
it
3rd
rdbms
Dec-2008

Solved Question Paper

Relational database management system Dec-2008

PSBTE • DIPLOMA • Information Technology • 3rd • Dec-2008

RDBMS for Punjab State Board of Technical Education Diploma in Engineering Information Technology 3rd semester helps students view subject-wise previous year question papers and old papers for exam practice. Using these papers can make revision easier, show how questions are usually asked, and help students understand the exam pattern for semester 3 preparation. BRpaper is not the official website of Punjab State Board of Technical Education or any board or university. It only helps students find and access previous year question papers and related exam preparation material for this subject.

Question papers (year-wise) Solutions

Solved Questions

Solved

Which of the following is a reason to model data?

MCQ Dec-2008 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
If an entity can belong to only one lower level entity, then the constraint is called

MCQ Dec-2008 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
The common column is eliminated in

MCQ Dec-2008 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
In SQL, testing whether a subquery is empty is done using

MCQ Dec-2008 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.

Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are

MCQ Dec-2008 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
The cost of reading and writing temporary files while evaluating a query can be reduced by

MCQ Dec-2008 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
A transaction is in state after the final statement has been executed.

MCQ Dec-2008 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
In multiple granularity of locks SIX lock is compatible with

MCQ Dec-2008 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.

The statement that is executed automatically by the system as a side effect of the modification of the database is

MCQ Dec-2008 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
The normal form that is not necessarily dependency preserving is

MCQ Dec-2008 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
Briefly describe the different kinds of users of a DBMS.

Short Answer Dec-2008 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
May 2020 Explain the various types of DBMS users?

May 2019 Explain the various users of the Database?

May 2018 Explain various types of DBMS users.

May 2017 Briefly describe the different kinds of users of DBMS?

May 2017 Briefly describe the different kinds of users of DBMS?

May 2015 Explain the various types of DBMS users.

May 2008 What are the different types of database end users? Discuss the main activities of each.
Explain the following. Give an example: Superkey

Short Answer Dec-2008 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
Dec 2015 Explain Super Key with example.

Dec 2010 Explain the meaning of following with suitable examples: Super key

Explain the following. Give an example: Weak entity set

Short Answer Dec-2008 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
May 2016 What do you mean by a weak entity set?
Explain the following. Give an example: Attribute inheritance

Short Answer Dec-2008 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
Define the concept of aggregation. Give two examples where this concept is useful.

Short Answer Dec-2008 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
Define a relation.

Short Answer Dec-2008 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
May 2008 Define a relation.

Define atom of domain relational calculus.

Short Answer Dec-2008 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
Derive the union rule, decomposition rule and the pseudo transitivity rule using the three Armstrong’s axioms.

Long Answer Dec-2008 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
Define multivalued dependency. What do you understand by trivial multivalued dependency?

Short Answer Dec-2008 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
Given R(A, B, C, D, E) and the set of multivalued dependencies: A ->-> BC, B ->-> CD, E ->-> AD, is R in 4NF? Justify your answer. If it is not, decompose R into 4NF.

Long Answer Dec-2008 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.

Given the relations R(A, B, C) and S(C, D, E, F), give an expression in tuple relational calculus that is equivalent to: σC=4(R)

Short Answer Dec-2008 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
Dec 2008 Given the relations R(A, B, C) and S(C, D, E, F), give an expression in tuple relational calculus that is equivalent to: σA,B(R)

Dec 2008 Given the relations R(A, B, C) and S(C, D, E, F), give an expression in tuple relational calculus that is equivalent to: R ⋈ S

Dec 2008 Given the relations R(A, B, C) and S(C, D, E, F), give an expression in tuple relational calculus that is equivalent to: R ∪ S
Given the relations R(A, B, C) and S(C, D, E, F), give an expression in tuple relational calculus that is equivalent to: σA,B(R)

Short Answer Dec-2008 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
Dec 2008 Given the relations R(A, B, C) and S(C, D, E, F), give an expression in tuple relational calculus that is equivalent to: σC=4(R)

Dec 2008 Given the relations R(A, B, C) and S(C, D, E, F), give an expression in tuple relational calculus that is equivalent to: R ⋈ S

Dec 2008 Given the relations R(A, B, C) and S(C, D, E, F), give an expression in tuple relational calculus that is equivalent to: R ∪ S
Given the relations R(A, B, C) and S(C, D, E, F), give an expression in tuple relational calculus that is equivalent to: R ⋈ S

Short Answer Dec-2008 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
Dec 2008 Given the relations R(A, B, C) and S(C, D, E, F), give an expression in tuple relational calculus that is equivalent to: σC=4(R)

Dec 2008 Given the relations R(A, B, C) and S(C, D, E, F), give an expression in tuple relational calculus that is equivalent to: σA,B(R)

Dec 2008 Given the relations R(A, B, C) and S(C, D, E, F), give an expression in tuple relational calculus that is equivalent to: R ∪ S
Given the relations R(A, B, C) and S(C, D, E, F), give an expression in tuple relational calculus that is equivalent to: R ∪ S

Short Answer Dec-2008 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
Dec 2008 Given the relations R(A, B, C) and S(C, D, E, F), give an expression in tuple relational calculus that is equivalent to: σC=4(R)

Dec 2008 Given the relations R(A, B, C) and S(C, D, E, F), give an expression in tuple relational calculus that is equivalent to: σA,B(R)

Dec 2008 Given the relations R(A, B, C) and S(C, D, E, F), give an expression in tuple relational calculus that is equivalent to: R ⋈ S

Give the result table for the SQL query: SELECT position, COUNT(staffNo) AS POS, my count FROM Staff

Short Answer Dec-2008 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
Give the result table for the SQL query: SELECT staffNo FROM Staff WHERE salary > (SELECT AVG(salary) FROM Staff)

Short Answer Dec-2008 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
Give the result table for the SQL query: SELECT staffNo FROM Property GROUP BY staffNo HAVING COUNT(*) > 1

Short Answer Dec-2008 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
Give the result table for the SQL statement: INSERT INTO Staff VALUES ('SG33', 'Assistant')

Short Answer Dec-2008 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.

Describe the four main ways of optimising disk block access.

Long Answer 7 Marks Dec-2008 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
Describe the algorithm for updating indices for a single level index when a record is inserted.

Long Answer Dec-2008 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
Describe the algorithm for updating indices for a single level index when a record is deleted.

Long Answer Dec-2008 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.
What will be the modification if there are multilevel indices?

Short Answer 8 Marks Dec-2008 • PSBTE DIPLOMA

Existing answers are stored as HTML; you can edit directly without converting to Markdown.

Explore all data

FAQ

Frequently Asked Questions

Answers about this subject, solved papers, and preparation.

Updated regularly

01 What can I find on this RDBMS subject page?

This page helps students find RDBMS previous year question papers and old papers for PSBTE Diploma in Engineering Information Technology 3rd semester.

02 How can RDBMS previous year papers help in exam preparation?

They help you revise key topics, understand the question style, and get familiar with the exam pattern used in previous semesters.

03 Can I use this page to find subject-wise IT 3rd semester papers?

Yes, this subject page is meant for students looking for subject-wise previous year question papers for PSBTE Diploma IT 3rd semester.

04 Are these official RDBMS papers from the board?

No. BRpaper is not the official website of Punjab State Board of Technical Education or any university or board.

05 Will this page help me find repeated or important questions?

Previous year papers can help you spot repeated question styles and commonly asked topics, which is useful for revision.

Solved question paper for RDBMS Dec-2008 (DIPLOMA 3rd)

Relational database management system Dec-2008

Solved Questions

Explore all data

PTU

PU Chandigarh

PSBTE

PSEB(School)

BFUHS

PU-PATIALA

GNDU

HPTSB

GTU

MDU

MRSPTU

CBSE(School)

BSEH

UBSE

PTU DISTANCE EDUCATION

Frequently Asked Questions