DBMS

Types of DBMS

The database is the collection of tables and records. There are 4 DBMS types which are widely used. To know more about types of DBMS explore the article further!!

Suggested Videos

Play
Play
Play
previous arrow
next arrow
previous arrownext arrow
Slider

 

 DBMS Types

There are four types of databases and are they are as follows:

Hierarchical Database

Data storage is in the form of a tree.  It collects all records together as a record type. These record types are the equivalent of tables in the relational model, and with the individual records being the equivalent of rows.

DBMS typesNetwork Database

In network databases, children are called members and parents are an occupier. The difference between each child or member can have more than one parent. A large digital computer mainly uses network database. The network database is more efficient. Therefore is similar to the hierarchical database.

DBMS typesRelational Database

In relational databases, the relationship between data files is relational. Hierarchical and network databases require the user to pass a hierarchy in order to access needed data. These databases connect to the data in different files by using common data numbers or a key field. Therefore relational database is the most popular database type.

Browse more Topics under Dbms

Object-oriented Database

In this type of DBMS, it uses programming languages like C, C++, and Java which is an object-oriented language.  Therefore, the object-oriented database derivation is the integrity of object-oriented programming language systems and consistent systems.

Solved Questions

Q1.   The hierarchical model is also called

  1. Tree structure
  2. Plex Structure
  3. Normalize Structure
  4. Table Structure

Answer: Tree Structure

Q2. The hierarchical database model uses the hierarchic sequence that always starts at

  1. the right side of the tree
  2. the left side of the tree
  3. the top of the tree
  4. the bottom of the tree

Answer: the left side of the tree, The hierarchical database model uses the sequence that always starts from the left of the tree. Therefore the left side of the tree is the answer.

Q3. A relational database consists of a collection of

  1. A. Tables
  2. B. Fields
  3. C. Records
  4. D. Keys

Answer: Tables, Fields are the column of the relation or tables. Records are each row in the relation. Keys are the constraints in a relation. Therefore Table is the answer.

Q4.For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.

  1. A. Domain
  2. B. Relation
  3. C. Set
  4. D. Schema

Answer: Domain, The values of the attribute should be present in the domain. The domain is a set of values permitted. Therefore Domain is the answer.

Q5. Database _________ _, which is the logical design of the database, and the database _______, which is a snapshot of the data in the database at a given instant in time.

  1.  Instance, Schema
  2.  Relation, Schema
  3.  Relation, Domain
  4.  Schema, Instance

Answer: Instance, Schema. An instance is an instance of time and schema is a representation. Hence Instance, Schema is the answer.

Practice Questions

Q1.  The tuples of the relations can be of ________ order.

  1. Any
  2. Same
  3. Sorted
  4. Constant

Answer: Any

Q2.Relational Algebra is a __________ query language that takes two relations as input and produces another relation as the output of the query.

  1. Relational
  2. Structural
  3. Procedural
  4. Fundamental

Answer: Procedural

2. Which of the following is a fundamental operation in relational algebra?

  1. Set intersection
  2. Natural join
  3. Assignment
  4. None of the mentioned

Answer: None of the mentioned

Q3. Which of the following is used to denote the selection operation in relational algebra?

  1.  Pi (Greek)
  2. Sigma (Greek)
  3. Lambda (Greek)
  4. Omega (Greek)

Answer: Pi

Q4. For select operation the ________ appear in the subscript and the ___________ argument appears in the parenthesis after the sigma.

  1. Predicates, relation
  2. Relation, Predicates
  3. Operation, Predicates
  4. Relation, Operation

Answer: Predicates, relation.

Share with friends

Customize your course in 30 seconds

Which class are you in?
5th
6th
7th
8th
9th
10th
11th
12th
Get ready for all-new Live Classes!
Now learn Live with India's best teachers. Join courses with the best schedule and enjoy fun and interactive classes.
tutor
tutor
Ashhar Firdausi
IIT Roorkee
Biology
tutor
tutor
Dr. Nazma Shaik
VTU
Chemistry
tutor
tutor
Gaurav Tiwari
APJAKTU
Physics
Get Started

2 responses to “Basics Of DBMS”

  1. yugandhar raju says:

    please add some more important practice questions.

  2. Manoj D N says:

    Very helpful for beginners…so happy to see this article and I revised a lot of things in very short time

Leave a Reply

Your email address will not be published. Required fields are marked *

Download the App

Watch lectures, practise questions and take tests on the go.

Customize your course in 30 seconds

No thanks.