ITE 3 Flashcards

1
Q

A set of computers sharing
resources located on or provided by network nodes.

A

Computer Networking

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Major Types of Computer Networks (3)

A

Local Area Network (LAN)
Metropolitan Area Network (MAN)
Wide Area Network (WAN)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

A computer network that
interconnects computers within a limited area such as a
residence, school, laboratory, university campus or office
building.

A

Local Area Network (LAN)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

A computer network that interconnects users with computer resources in a geographic region of the size of a metropolitan area.

A

Metropolitan Area Network (MAN)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

A telecommunications
network that extends over a large geographic area.

A

Wide Area Network (WAN)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

An organized collection of structured information, or data, typically stored electronically in a computer
system.

A

Database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Types of Database (12)

A

Centralized database.
Cloud database.
Relational database.
Distributed database.
Object-oriented database.
Network database.
NoSQL database.
Personal database.
Operational database
Enterprise database
Commercial database
Heirarchal database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

It is the type of database that stores data at a ___ database system. It comforts the users to access the stored data from different locations through several applications.

A

Centralized Database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Unlike a centralized database system, data is distributed among different database systems of an organization. These database systems are connected via communication links. Such links help the end-users to access the data
easily.

A

Distributed Database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Those database systems which execute on the same operating system and use the same application process and carry the same hardware devices.

A

Homogenous DDB

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Those database systems which execute on different operating systems under different application procedures and carries different hardware devices.

A

Heterogenous DDB

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

This database is based on the ____ data model, which stores data in the form of rows (tuple) and columns (attributes), and together forms a table(relation). A
____ database uses SQL for storing, manipulating, as well as maintaining the data.

A

Relational Database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

It’s a type of database that is used for storing a wide range of datasets. It is not a relational database as it stores data not only in tabular form but in several different ways. It came into existence when the demand for building modern applications increased.

A

NoSQL Database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

A type of database where data is stored in a virtual environment and executes over the cloud computing platform. It provides users with various cloud computing services (SaaS, PaaS, IaaS, etc.) for accessing the database.

A

Cloud Database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

The type of database that uses the object-based data model approach for storing data in the database system. The data is represented and stored as objects which are similar to the objects used in the object-oriented programming language.

A

Object-Oriented Database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

It is the type of database that stores data in the form of parent-children relationship nodes.

A

Hierarchical Database

17
Q

It is the database that typically follows the network data model. Here, the representation of data is in the form of nodes connected via links between them. Unlike the hierarchical database, it allows search record to have multiple children and parent nodes to form a generalized graph structure.

A

Network Database

18
Q

Collecting and storing data on the user’s system defines a ___ Database. This database is basically designed
for a single user.

A

Personal Database

19
Q

The type of database which creates and updates the database in real-time. It is basically designed for executing and handling the daily data operations
in several businesses. For example, an organization uses ___ databases for managing per day transactions.

A

Operational Database

20
Q

Disadvantages of Centralized Database(3)

A

The size of the centralized database is large, which increases the response time for fetching the data

It is not easy to update such an extensive database system.

If any server failure occurs, entire data will be lost, which could be a huge loss.

21
Q

Advantages of Centralized Database (4)

A

It has decreased the risk of data management.

Data consistency is maintained as it manages data in a central repository.

It provides better data quality, which enables organizations to establish data standards.

It is less costly because fewer vendors are required to handle the data sets.

22
Q

Advantages of Distributed Database (2)

A

Modular development is possible.

One server failure will not affect the entire dataset.

23
Q

is a database developed and maintained by a commercial entity that is generally made available to
customers and potential customers.

A

Commercial Database

24
Q

Properties of Relational Database (ACID)

A

Atomicity
Consistency
Isolation
Durability

25
Q

Types of NoSQL Database (4)

A

Key-Value Storage
Document-Oriented Database
Graph Databases
Wide-Column Stores

26
Q

It is the simplest type of database storage where it stores every single item as a key (or attribute name) holding its value, together.

A

Key-Value Storage

27
Q

A type of database used to store data as JSON-like document. It helps developers in storing data by using the same document-model format as used in the application code.

A

Document-Oriented Database

28
Q

It is used for storing vast amounts of data in a graph-like structure. Most commonly, social networking websites use this database.

A

Graph Databases

29
Q

It is similar to the data represented in relational databases. Here, data is stored in large columns together, instead of storing in rows.

A

Wide-Column Stores

30
Q

Advantages of NoSQL Database (4)

A
  • It enables good productivity in the application development as it is not required to store data in a structured format.
  • It is a better option for managing and handling large data sets.
  • It provides high scalability.
  • Users can quickly access data from the database through key-value.
31
Q

Advantages of Personal Database (2)

A

It is simple and easy to handle.

It occupies less storage space as it is small in size.

32
Q

Advantages of Enterprise Database (2)

A

Multi processes are support able over the Enterprise database.

It allows executing parallel queries on the system.