PGDCA/MSCCS-02/MCA-102/CAWD
December 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.
Write the correct formula to add three number present in B2, B3 and B4 cell in MS-Excel.
What is Trojan horse?
What is the use of title tag in HTML?
List the features of Oracle.
Which symbol is used to represent entity in E-R diagram?
Who are End users?
What is the file extension of MS-Power Point?
484
PGDCA/MSCCS-02/MCA-102/CAWD 700 3 (P.T.O.)
PGDCA/MSCCS-02/MCA-102/CAWD 700 3 (Contd.)
484
(viii) What is the shortcut key to save a document?
What is Macro?
Give the difference between char and varchar.
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.
How we can validate data in MS-Excel? Write the steps with
example.
Write short note on computer antivirus.
What is XML? How XML is differ from HTML? Explain.
What is the importance of key in MS-Access? Describe various
keys used in MS-Access.
Explain the feature called "Format Painter" with suitable
example.
Explain the following:
Header and footer
Mail Merge
Describe the way to create a presentation using design
template with steps.
Give the overview of MS-Publisher. Also discuss some
application of MS-Publisher.
PGDCA/MSCCS-02/MCA-102/CAWD 700 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 Relational Algebra? Explain the following operations
in Relational Algebra:
Select operation
Project operation
Cartesian operation
Union operation
Intersection operation
11) Give an introduction to MS-Word. Also describe common
buttons of the standard toolbar of MS-Word.
12) What do you mean by "Markup Language"? Describe some
formatting tags with example.
13) Write short note on the following:
Spell checking and grammar
Chart in MS-Excel