PGDCA/MSCCS-02/MCA-102/CAWD
June Examination 2017
MSCCS/PGDCA/CAWD/MCA I Year Examination
Application Software and Web Designing
Paper PGDCA/MSCCS-02/MCA-102/CAWD
Time 3 Hours Max. Marks 100
Note: The question paper is divided into three sections B and C. Write answers as per given instructions.
Section A 10 × 2 20
(Very Short Answer Questions)
Note: Answer all questions. As per the nature of the question delimit your answer in one word, one sentence or maximum upto 30 words. Each question carries 2 marks.
What do you mean by Data Redundancy?
What is Slide Master?
Give the uses of format pointer in MS-Excel 2000.
List the applications of MS-Publisher.
Give the difference between copy-paste and cut-paste.
What is HTTP?
Name two methods used in FORM tag.
(viii) What does MIN 10, 02, 25, 30) returns in MS-Excel?
484
PGDCA/MSCCS-02/MCA-102/CAWD 800 3 (P.T.O.)
PGDCA/MSCCS-02/MCA-102/CAWD 800 3 (Contd.)
484
How to link web pages through image in HTML?
What is the full form of XSL?
Section B 4 × 10 40
(Short Answer Questions)
Note: Answer any four questions. Each answer should not
exceed 200 words. Each question carries 10 marks.
When to use Pivot Table Report in MS-Excel 2000? Write the
steps to create a Pivot Table Report in MS-Excel 2000.
Discuss various different views, which helps while creating a
presentation.
Describe the features of oracle.
What is Referential Integrity? Discuss with the keys involve in
Referential Integrity.
What do you mean by Joins? Explain different types of Joins.
What is the purpose of absolute and relative address in
EXCEL? Explain using suitable example.
Write short note on Macro in MS-Excel 2000.
Write the steps to create Header and Footer in Word Processing
System. Also explain with suitable example.
PGDCA/MSCCS-02/MCA-102/CAWD 800 3
484
Section C 2 × 20 40
(Long Answer Questions)
Note: Answer any two questions. You have to delimit your each
answer maximum upto 500 words. Each question carries
20 marks.
10) What are the features of RDBMS? Describe the twelve
rules of an RDBMS (Codd's rules).
11) What is Computer Virus? Explain basic type of viruses in
computer. How we can prevent from those viruses?
12) What is Database? Explain the difference between a
file-oriented system and a database oriented system.
13) Give the defination of Mark-up language. Describe various
listing tags in HTML with suitable example.