Overview of database systems

Question 1

What does DBMS ?

Answer 1

Software or technology used to manage data from database.

Question 2

What does Hierarchical database do ?

Answer 2

Follows the progression of data being categorised in ranks or levels, where in data is categorized by a common point of linkage.

Question 3

What do DBMS do ?

Answer 3

Store, organise and access data

Question 4

How the ranking in a Hierarchical database work ?

Answer 4

Two entities of data will be lower in rank, and the commonality would assume a higher rank.

Question 5

What is the disadvantage of Hierarchical database ?

Answer 5

Not easily salable

Question 6

Why is Hierarchical database not easily salable ?

Answer 6

because the addition of data elements requires lengthy traversal through the database.

Question 7

What kind of records are allowed in Network Database?

Answer 7

Multiple parent and child records

Question 8

Which database allow for more natural relationship between records and entities ?

Answer 8

Network Database

Question 9

What form for relationships represents Network database ?

Answer 9

net-like form where a single element can point to multiple data elements and can itself be pointed to by multiple data elements.

Question 10

What are the capabilities of Information in Object-Oriented database?

Answer 10

database is capable of being represented as an object which response as an instance of the database model.

Question 11

What is Berkeley DB Software library ?

Answer 11

embedded database software library for key/value data

Question 12

How is information in the Relational database connected ?

Answer 12

Every piece of information has a relationship with every other piece of information

Question 13

In what database every value has a unique identity in a form of a record?

Answer 13

Relational database

Question 14

What is Primary key

Answer 14

a unique identifier assigned to each record within a database table

Question 15

How are rows in relational database linked?

Answer 15

every row of data in the database is linked with another row using a primary key

Question 16

How are tables connected in relational database?

Answer 16

Every table is linked with another table using a foreign key

Question 17

What is foreign key ?

Answer 17

column that refers to the primary key/unique key of another table).

Question 18

Where and why are relational databases widely integrated ?

Answer 18

web app interfaces to serve as ideal repositories for user data

Question 19

What the elements in relational database represents ?

Answer 19

Rows represent the records and columns represent attributes for each record.

Question 20

How is data in relational database inserted, manipulated and retrieved ?

Answer 20

By using SQL

Question 21

What are them most common DBMS for relational databases

Answer 21

MySQL, SQLite, Oracle and Microsoft SQL Server

Question 22

Where Cloud Databases are used ?

Answer 22

where data requires a virtual environment for storing and executing over the cloud platforms. (SaaS,PaaS,etc.)

Question 23

What are the most common DBMS for Cloud databases?

Answer 23

Amazon Web Services(AWS), Google Cloud Platform(GCP), Microsoft Azure, Science Soft

Question 24

What databases are stored, located and maintained at a single location?

Answer 24

Centralized databases

Question 25

Advantages of Centralized databases

Answer 25

Data security, reduced redundancy, consistency, more secure for fetching data

Question 26

Disadvantages of centralized databases

Answer 26

Size is too large-increasing response and retrieval time, Not easy to manipulate

Question 27

Who are personal databases designed for ?

Answer 27

A single user

Question 28

Where do personal databases collect and store data ?

Answer 28

On its own system

Question 29

Advantages of Personal databases

Answer 29

Easy to handle, Less space needed

Question 30

Which database is used for creating, updating and deleting the database in a real-time.

Answer 30

Operational database

Question 31

What are operational databases designed for ?

Answer 31

executing and handling the daily data operation in organizations and for business purposes.

Question 32

Advantages pf operational databases

Answer 32

- Easy to fetch - Structured data - Real-time processing

Question 33

What does No SQL database do ?

Answer 33

provides a mechanism for storage and retrieval of data

Question 34

How is data modeled in no SQL database

Answer 34

in means other than the tabular relations used in a relational database.

Question 35

Which database makes some operations faster by different structures than in relational database?

Answer 35

No SQL databases

Question 36

On what depends the suitability of no SQL database ?

Answer 36

The kind of problem to be solved

Question 37

What are the attributes of no SQL databases?

Answer 37

Simplicity of design, simpler horizontal scaling to clusters or machines (addition of extra nodes or machines to infrastructure in response to a change in demand).

Question 38

What is a machine ?

Answer 38

a device whose basic function is managing access to a database. Provides faster application processing through the offloading of the database access to this dedicated device.

Question 39

Advantages of no SQL databases

Answer 39

Scalability and high availability

Question 40

Disadvantages of no SQL databases

Answer 40

- Open-source database - GUI is not available - Backup is a weak point - Large document size

Question 41

How do Flat file databases store their records?

Answer 41

Usually contains a single row or record per line

Question 42

Disadvantages of Flat file databases

Answer 42

Text-based, lacks indexes and explicit information about relationships between data

Question 43

Examples of flat file databases

Answer 43

/etc/passwd file on UNIX, describing one user account per line Comma-separated value (CSV) files, which are common data exchange format, with commas used as delimiters (character separating columnar data). Some no SQL databases utilize flat files to store data in JSON (JavaScript Object Notation) format.

Question 44

What is JSON

Answer 44

Standard text-based format for representing structured data based on JavaScript Object syntax. Commonly used for transmitting data in web applications. Can be used independently from JavaScript.