PTU Old Question Papers MCA

I am MCA third semester student at PTU (Punjab Technical University). I need its old question papers. Would you please give me it as PDF file?

Some questions of PTU MCA third semester 2006 is given below:
1. (a) List the advantages of RDBMS. Or (b) what is meant by entity set? Explain with an
Example
2. (a) Write short notes on tuple relational calculus. Or (b) what is an index? How it is used in RDBMS?
3. (a) Compare data retrieval in network model and hierarchical model. Or (b) Explain the concept based on relational database design with respect to repetition of information.

Rests of the questions are available at the following attachment. To get more question download the attachment.

Attached Files Available for Download

PTU MCA 3rd SEM old Paper.pdf (68.9 KB, 167 views)

__________________
Answered By StudyChaCha Member

i am the student of mca third semester i want to see old question paper of mca from ptu
because i am nothingh about this

i am the student of mca third semester i want to see old question paper of mca from ptu
because i am nothingh about this subject

This site is good for any professional courses related to MCA, BCA, B.TECH, M.TECH etc.

MCA 3rd Semester RELATIONAL DATABASE MANAGEMENT 2006
Time: Three hours maximum: 100marks
PART A Answer all questions (8x5=40 marks)

1. (a) List the advantages of RDBMS. Or (b). What is meant by entity set? Explain with an
example

2. (a) Write short notes on tuple relational calculus. Or (b) what is an index? How it is
used in RDBMS?

3. (a) Compare data retrieval in network model and hierarchical model. Or (b) Explain the
concept based on relational database design with respect to repetition of information.
4. (a) What is view? Whether multiple view updations are applicable in RDBMS? Or (b).

Explain about aggregate operators in detail.
5. (a). Explain the anomalies in relation database design. Or (b) Explain the BCNF with
examples.

6. (a) Write short notes on snapshots. Or (b). What is RQBE? What is its role in database?

7. (a) Explain the theory of multi-valued dependencies. Or (b) Explain in detail about losslessjoin
decomposition.

8. (a). What is distributed database? Where it is in high demand? Or (b) Write down the
method of providing security to the relational database.
PART B Answer ALL questions (5x12=60 marks)

9. (a) Explain about different keys available in RDBMS and write down the significance
each key with an example. Or (b) explain the different access methods and storage
structures in RDBMS.

10. (a) Discuss the data modeling concepts in detail. Or (b). What is correlated sub query?
Illustrate with an example of a correlated sub query projection and union operation as
relational algebra expressions.

11. (a). Explain with example, the different operations in relational algebra. Or (b) Explain
the following terms: I) Full functional dependency. II) Temporal Relational model. III)
Repetition of information

12. (a) Explain in detail, the various stages involved in compiling a query with a neat
diagram. Or (b) describe the security issues and integrity factors regarding database systems.

13. (a) Explain how will you normalize the given table to the third normal form, by
assuming your own table. Or (b). Discuss in detail about database administration?

__________________
Answered By StudyChaCha Member

Will you please share the MCA Ist Sem Question Paper of Information Technology (IT) of Punjab Technical University (PTU)???

Punjab Technical University (PTU) was established by an act of State Legislature on 16 January 1997

Here I am sharing the MCA – IT Question paper of Punjab Technical University (PTU)

Ql) How data is represented in computers. Explain
Q2) What are the various components of a computer. Discuss with the help of a
block diagram.
Q3) what are the different type of memories of computer. Discuss.
Q4) How System software is different from application program. Explain with
example.
Q5) What are the various topologies of computer networks.
Q6) what is an internet. what are the services provided by internet.
Q7) How MIS is different from DSS. Explain with example.
8) What are the various applications of computers in business. Explain with
example.

Rest of the Questions are attached in below file which is free of cost


Address:
Punjab Technical University
Jalandhar- Kapurthala Highway,
Near Pushpa Gujral Science City,
Rasulpur, Punjab 144601 ‎
0182 266 2521 ‎

Map:

Attached Files Available for Download

	PTU MCA Ist Sem IT Question Paper 1.PDF (240.0 KB, 42 views)
	PTU MCA Ist Sem IT Question Paper 2.PDF (202.9 KB, 58 views)

__________________
Answered By StudyChaCha Member

As you required for the Punjab Technical University MCA question paper, here I am uploading a pdf file having the same. There is descriptive type of the questions available. Following is the content of attachment:

Q3) Write short note on:
(a) CPU storage devices.
(b) Assembly languages.

Q4) How can you classify the programming languages? What is the difference
and relation between machine code, assembly language and high level
languages?

Q5) Whatare the different types of operating systems available? Discuss in detail
~ about network operating system. .

Q6) Write short note on :
(a)' Network communication devices.
(b) World Wide Web.

Punjab Technical University MCA question paper




Image



Address
Punjab Technical University
Jalandhar- Kapurthala Highway, Near Pushpa Gujral Science City, Rasulpur, Punjab 144601 ‎
0182 266 2521
‎

__________________
Answered By StudyChaCha Member

Need PTU MCA 1st semester previous years solved exam papers. requested to you please provide