Q-1.Differentiate
between desktop applications and web applications.
Ans:
|
Web Applications |
Desktop Applications |
|
Deployment and
up-gradation for a web-based application require deployment on a single set
of server machines. |
Deployment and any up-gradation/patch
are done on individual client machines separately. |
|
Web applications can
be accessed from anywhere, so there is no location constraint. |
As desktop are
confined to a standalone machine, so they can be only accessed from the
machines they are deployed in. |
|
Web applications are
platform-independent, they can work in different types of platforms with the
only requirement of a web browser. |
Desktop applications
need to be developed separately for different platform machines. |
|
Web applications are
at higher security risks as they are inherently designed to increase
accessibility. |
Desktop
applications, on the other hand, have better authorization and administrators
have better control, hence more secure. |
|
Web applications
rely heavily on internet connectivity, for there operation. |
Desktop applications
don’t require the internet for their operations. Some applications just
require internet connectivity at the time of updations. |
Q-2.What
are the advantages and disadvantages of using open source software ?
Ans:
Open source software can be define
as a development process which allow user to get the source code and modify it
according to his need.
Advantages:
-Free To Use
-Freedom without
limitations
-Created
by skillful and talented people.
-Cheaper
than commercially marketed products.
-Highly
reliable.
-Following of
standards
-No Complex
Licensing
Disadvantages:
-Vulnerable
to malicious users.
-Might not
be as user-friendly as commercial versions.
-Don’t
come with extensive support.
Q-3.Write
the functionalities of operating system.
Ans:
An Operating system (OS) is a software which acts as an
interface between the end user and computer hardware. Every computer must have
at least one OS to run other programs.
Functionalities
of operating system is:
- Protected and supervisor mode
- Program Execution
- Memory
management Virtual Memory Multitasking
- Processor
Management –
- Device
Management
- Security
- Internal
time clock control.
- Handling
I/O operations
- Manipulation
of the file system
- Error
Detection and handling
- Resource
allocation
- Information
and Resource Protection etc
Q-4.What is primary key and foreign key ?
Ans: Primary Key: A
primary key is a field in a table which uniquely identifies each row/record in
a database table. Primary keys must contain unique values. A primary key column
cannot have NULL values.
A table can have only one primary key, which may consist of
single or multiple fields. When multiple fields are used as a primary key, they
are called a composite key.
CREATE TABLE CUSTOMERS(
ID INT NOT NULL,
NAME VARCHAR
(20) NOT NULL,
AGE INT NOT NULL,
ADDRESS CHAR (25) ,
SALARY DECIMAL (18, 2),
PRIMARY KEY (ID)
);
Foreign Key: A
foreign key is a key used to link two tables together. This is sometimes also
called as a referencing key.
A Foreign Key is a column or a combination of columns whose
values match a Primary Key in a different table.
Q-5.Write
short notes on Website, Internet & Intranet , IP address, DNS server and
BIOS .
Ans:
Website: A
website is a collection of publicly accessible, interlinked Web pages that
share a single domain name. Websites can be created and maintained by an individual,
group, business or organization to serve a variety of purposes. Together, all
publicly accessible websites constitute the World Wide Web.
Internet :The internet is a globally connected
network system that uses TCP/IP to transmit data via various types of media.
The internet is a network of global exchanges – including private, public,
business, academic and government networks – connected by guided, wireless and
fiber-optic technologies.
Intranet:An intranet is a private network
contained within an enterprise that is used to securely share company
information and computing resources among employees. An intranet can also be
used to facilitate working in groups and teleconferences.
IP address:An Internet Protocol address (IP
address) is a logical numeric address that is assigned to every single
computer, printer, switch, router or any other device that is part of a
TCP/IP-based network.
DNS server: A DNS server is a computer server that contains a database
of public IP addresses and their associated hostnames, and in most cases serves to resolve, or translate, those
names to IP addresses as requested. DNS servers run special software and
communicate with each other using special protocols.
BIOS: BIOS ( Basic Input/Output
System and also known as the System BIOS, ROM
BIOS or PC BIOS) is firmware used to perform hardware initialization during the
booting process (power-on startup), and to provide runtime services for
operating systems and programs.
Q-6.Whst
is URL.
Q-7.Write
the activities after clicking on URL and before showing that web page step by
step.
Ans:
0 মন্তব্যসমূহ