3-Information System Architecture and Software

Question 1

Function performed by OS

Answer 1

•Access to peripheral devices • Storage management• process management • Resource allocation• Communication • Security.

Question 2

Cluster mode

Answer 2

active-passive mode : One computer is active, and the remaining stay passive.

active-active : All computers are active

Question 3

what is failover

Answer 3

When in active-passive mode, a passive computer takes over when a active computer fails.

Question 4

Directory

Answer 4

A structure that is used to store files. A file system contains one or more directories.

Question 5

A file

Answer 5

A sequence of zero or more characters that are stored as a whole

Question 6

What control are contained in DBMS

Answer 6

Authentication and access control - permitting control over which users may access what data.

Question 7

Data Definition Language (DDL)

Answer 7

Used to define the structure of the data contained in a database

Question 8

Type of DBMSs

Answer 8

Relational object, hierarchical

Question 9

Primary Key

Answer 9

field in the table whose values are unique in the table

Question 10

Foreign Key

Answer 10

A field in a record in one that can reference a primary key in another table.

Question 11

Referential Integrity

Answer 11

In relational database, a row cannot be deleted from a table if there are records in other tables whose foreign keys reference the row to be deleted.

Question 12

Relational Database Security

Answer 12

• Access Controls -limit read and write access
• encryption - to encrypt some field of the data
• audit logging- to permit an admin to view some or all activities that take place in a database

Question 13

Utility software

Answer 13

broad class of programs that support the development or use networks, information systems, OS and applications.

Question 14

Type of networks

Answer 14

• Personal area network (PAN) : Used by a single individual.
• Local area network (LAN) : Connect computers and devices together in a small building or residence.
• Campus Area Network (CAN) : Interconnection of LANs of an organization that has buildings in close proximity.
• Metropolitan Area Network (MAN) : A network that spans a city or regional area.
• Wide Area Network (WAN) ;Network whose size ranges from regional to international.

Question 15

Network based services

Answer 15

Protocols and utilities that facilitate system-and network resource utilization.

Question 16

Email servers

Answer 16

Collect, store, and transmit e-mail message from person to person

Question 17

File servers

Answer 17

provide centralized storage of files for use among groups of users.

Question 18

Two dominant network model in use

Answer 18

OSI and TCP/IP

Question 19

OSI model

Answer 19

Open Systems Interconnection Model, consist of seven layers:

Question 20

What are the seven layers

Please Do Not Throw Sausage Pizza Away

Answer 20

1• Physical
2• Data link
3• Network
3• Transport 
4• Session
5• Presentation
7 • Application