[go: up one dir, main page]
Scribd
Upload
51 views2 pages

MCSL-210 (Set-3)

The document outlines the structure of a practical exam for the Post Graduate Diploma in Computer Applications (PGDCA), focusing on DBMS and Java Lab. It consists of two sections, each lasting one hour, with specific tasks related to database table creation and SQL queries in the DBMS section, and a Java programming task in the Java Lab section. Each section carries a total of 25 marks, including a viva-voce component.

Uploaded by

sunilsingh6439j
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
51 views2 pages

MCSL-210 (Set-3)

The document outlines the structure of a practical exam for the Post Graduate Diploma in Computer Applications (PGDCA), focusing on DBMS and Java Lab. It consists of two sections, each lasting one hour, with specific tasks related to database table creation and SQL queries in the DBMS section, and a Java programming task in the Java Lab section. Each section carries a total of 25 marks, including a viva-voce component.

Uploaded by

sunilsingh6439j
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/ 2

MCSL-210 (Set-3)

POST GRADUATE DIPLOMA IN COMPUTER APPLICATIONS


(PGDCA-NEW)
DBMS and Java Lab

Duration: 2 hours Maximum Marks: 50

Note: 1. There are two sections in this paper.


2. Each section is of 1-hour duration.
3. Attempt only that section(s) in which you are not yet successful.

SECTION-1: DBMS Lab

Note: Answer the following question. It carries 20 marks and the viva-voce is of 5
marks.

1. Create the following tables with the fields given below:

COLLAGE (Col_ID, Col_Name, City)


STUDENT (Student_ID, Name, Coll_ID, Programme, Age)
Use appropriate data types for all the fields. Select appropriate a primary
keys. Insert at least 10 meaningful records in the tables.
Answer the following queries based on above table using SQL:
i) List students name and programme who have registered in college
whose Col_ID = 2001.
ii) Find average age of students who have registered in “MCA”
programme.
iii) Display total number of students whose college is in “Delhi”.
iv) Display name and Student-ID of all the students whose age is more
than 22 years.

SECTION-2: Java Lab

Note: Answer the following question. It carries 20 marks and the viva-voce is of 5
marks.

2. Write Java program which read/take an string as input and display its length.
Also this program should have methods to reverse the string and to check
whether the input string is a palindrome or not. Use proper access specifiers
for class(es) and methods.

******

You might also like