Computer Applications in CE-Sem5-Sept-2019
|
|
 |
Name ……………………………
Roll
No ……………………….
|
SAINTGITS COLLEGE OF APPLIED SCIENCES
INTERNAL ASSESSMENT EXAMINATION, SEPTEMBER2019
Department of
CORPORATE ECONOMICS, Semester 5
COMPUTER
APPLICATIONS IN CORPORATE ECONOMICS-II- Answer key
Total : 80 marks Time:3Hours
Section
A
Answer any 10 questions.
Each question carries 2 marks.
1. What
is a web browser.
.
A web browser, or simply "browser," is an
application used to access and view websites.
2.Write the difference between Primary key and Foreign key
A primary
key is a candidate key that is most appropriate to be the main reference key
for the table. A foreign key is a field that points to the primary key of
another table.
3.List the names of different search engines available today.
Google ,yahoo
4.What is slide
transition?
A slide transition is
the visual effect that occurs when you move from one slide to
the next during a presentation.
5.How
to prepare bulleted list and numbered list in power point 2007?
On the Home tab, in the Paragraph group,
click Bullets 
or Numbering 
.
or Numbering .
6.What are the different controls in form?
text
box,label,listbox,combobox,drop down
box,commandbutton,checkbox,optionbox,togglebox,hyper link control,image hyper link,scrolling
text control
7.Define relational database and give an example?
relational database (RDB) is a collective set of multiple data
sets organized by tables, records and columns. RDBs establish a well-defined
relationship between database tables.- Example
8.What is a webpage?
A web
page or webpage is a document commonly written in
HTML (Hypertext Markup Language) that is accessible through the Internet or
other networks using an Internet browser.
9.Explain
WWW.
WORLD
WIDE WEB
10.What is a query?
Queries
are used to search for and grab data from one or more of the table, perform
certain actions on the database and even performs a variety of calculations
depending on user needs.
11.What
is meant by a tuple?
Each raw of a table is called a
tuple or record
12.What is a theft?
Stealing something (10x2=20)
Section B
Answer any six of the following. Each question
carries 5 marks.
13.Explain the data types
in Access.
Brief introduction of Access
datatypes- Text-Memo-Number-Data/ Time- Currency-Auto
number-Yes/No-Hyperlink-Attachments-OLE Object
14.Explain the objects in
Access
Introduction about
access-figure-explanation about:- Tables, Quries, Forms, Report, Macros,
Modules
15.Explain
the types of cybercrimes.
Theft,Virus,Internet Hoaxes,cyber
warfare,Malware
16.Explain different features of DBMS?
Introduction-Data
can be shared-redumdancy ca be moinimized-inconsistancy can be
avoided-Transaction support can be provided- Integrity can be maintained-
conflicting requirements can be balanced-standard can be enforced- efficient
data access- data administration- concurrent access and crash recovery-reduced
application development time
17.What is power point?
What are its features?
PowerPoint is a complete presentation
Graphics package. It gives everything that we need to produce a
professional-looking presentation. PowerPoint offers word
processing software, outlining, drawing, graphing, and presentation management
tools- all designed to be easy to use and learn.
18.Explain application of computer in medical field.
Medical
imaging- Electronic health record- Computer assisted surgery- Faster and
cheaper communication- daily functioning
19.Explain the type of
queries in access
Introduction about queries- Select
query- Parameter query- cross tab query-Action query
20. Explain application of computer in
payroll
Employee information storage
Automatic salary calculation
Report generation
21. Explain working of E-mail?
Working of E-mail
Email working follows the client server approach. In this client
is the mailer i.e. the mail application or mail program and server is a device
that manages emails.
Following example will take you through the basic steps involved
in sending and receiving emails and will give you a better understanding of
working of email system:
·
Suppose person A wants to send an email message to person B.
·
Person A composes the messages using a mailer program i.e. mail
client and then select Send option.
·
The message is routed to Simple Mail Transfer Protocol to
person B’s mail server.
·
The mail server stores the email message on disk in an area
designated for person B.
(6x5=30)
Section C.
Answer any two of the
following.
Each question carries
15 marks
22.
Explain different types of Electronic payment system.
Credit
card
Debit
card
Mobile
Payment
Electronic
Fund Transfer
E-wallet
23.Explain
the different components of MS power point
Ribbon
Title
Bar
Navigation
Pane
Note
Pane
Slide
Pane
Status
Bar
24.Explain different types of forms and form controls.
Forms
in Access are like display cases in stores that make it easier to view or get
the items that you want. Since forms are objects through which you or other
users can add, edit, or display the data stored in your Access desktop
database, the design of your form is an important aspect. If your Access
desktop database is going to be used by multiple users, well-designed forms is
essential for efficiency and data entry accuracy.
Three
purpose of access form- types of forms-form areas-form tool box:-text
box,label,listbox,combobox,drop down
box,commandbutton,checkbox,optionbox,togglebox,hyper link control,image hyper
link,scrolling text control
25.Explain
the different components of MS ACCESS. (2 x 15=30)
Introduction on MS Access-
explanation about different types ofcomponents
of access- command button-Office button-Title bar-ribbon- contextual command
tab-gallery-quick access tool bor-navigation pane-status bar-mini tool bar--
Figure
_____________________
Comments
Post a Comment