PGDCA MSCCS-02 MCA-102 CAWD
June Examination 2016
MSCS/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 spread-sheet?
Give the difference between same and same as option.
What is book mark?
What do you mean by slides?
Name the types of relationships in DBMS.
Define transaction.
What is the role of database administration?
(viii) Name some transaction control commands.
484
PGDCA MSCCS-02 MCA-102 CAWD 600 3 (P.T.O.)
PGDCA MSCCS-02 MCA-102 CAWD 600 3 (Contd.)
484
Write the syntax of SELECT statement.
What is anchor tag?
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.
Write short note about paragraph formatting.
What is macro? How to record a macro in word?
What are the basic printing options provided by MS Power
Point.
How can you change a table in design view of MS-Access?
What do you mean by data independence? Compare
physical data independence and logical data independence.
What do you mean by Join? Explain different types of joins.
Explain the basics of XML.
What is the advantage of slide master? How we can add
action buttons in a presentation?
PGDCA MSCCS-02 MCA-102 CAWD 600 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 is virus? Discuss various types of viruses.
11) What do you mean by Database Management System?
Discuss Database System Architecture with neat diagram.
12) How to put a formula in MS Excel? Discuss various formula's
used in MS-Excel with example.
13) What is normalization? Discuss various types of normal forms
with example.