What is Database?

The database is a collection of inter-related data which is used to retrieve, insert and delete the data efficiently. It is also used to organize the data in the form of a table, schema, views, and reports, etc.For Example, a university database organizes the data about students, faculty, admin staff, etc. which helps in the efficient retrieval, insertion, and deletion of data from it.

Data Dictionary:

A data dictionary contains metadata i.e data about the database. The data dictionary is very important as it contains information such as what is in the database, who is allowed to access it, where is the database physically stored etc. The users of the database normally don't interact with the data dictionary, it is only handled by the database administrators.

The data dictionary in general contains information about the following −

• Names of all the database tables and their schemas.
• Details about all the tables in the database, such as their owners, their security constraints, when they were created etc.
• Physical information about the tables such as where they are stored and how.
• Table constraints such as primary key attributes, foreign key information etc.
• Information about the database views that are visible.

DBMS:

A DBMS is a collection of interrelated data and a set of programs to retrieve data from a database. It is an organized collection of data viewed as whole, instead of a group of separate unrelated files. The primary goal of DBMS is to provide an environment that is both convenient and efficient for user to store and retrieve database information.It provides protection and security to the database. In the case of multiple users, it also maintains data consistency.

E.g. MySQL, Oracle, FoxPro, dBASE, SyBase MS-Access. The purpose of database management system is to bridge the gap between information and data.

The basic processes that are supported by DBMS are as follows

(i) Specification of data types, structures and constraints to be considered in an application.

(ii) Storing the data.

(iii) Manipulation of the database

(iv) Querying the database to retrieve desired information.

(v) Updating the content of the database

In the Question:

Which of the following statement is incorrect about Data Dictionary?

(i) A data dictionary contains metadata

(ii) The data dictionary is very important as it contains information

(iii) The users of the database normally interact with the data dictionary

The Answer is only iii.

Hence the Option B is Correct.

A data dictionary contains metadata i.e data about the database. The data dictionary is very important as it contains information such as what is in the database, who is allowed to access it, where is the database physically stored etc. The users of the database normally don't interact with the data dictionary, it is only handled by the database administrators.

The data dictionary in general contains information about the following −

• Names of all the database tables and their schemas.
• Details about all the tables in the database, such as their owners, their security constraints, when they were created etc.
• Physical information about the tables such as where they are stored and how.
• Table constraints such as primary key attributes, foreign key information etc.
• Information about the database views that are visible.

In the Question:

Which of the following contains data descriptions and defines the name, data type and length of each field in the database ?

The Answer is Data dictionary. A data dictionary is a centralized repository of metadata. Metadata is data about data

Hence the Option A is Correct.

Database Management System (DBMS)

What is Database?

The database is a collection of inter-related data which is used to retrieve, insert and delete the data efficiently. It is also used to organize the data in the form of a table, schema, views, and reports, etc.For Example, a university database organizes the data about students, faculty, admin staff, etc. which helps in the efficient retrieval, insertion, and deletion of data from it.

DBMS:

A DBMS is a collection of interrelated data and a set of programs to retrieve data from a database. It is an organized collection of data viewed as whole, instead of a group of separate unrelated files. The primary goal of DBMS is to provide an environment that is both convenient and efficient for user to store and retrieve database information.It provides protection and security to the database. In the case of multiple users, it also maintains data consistency.

E.g. MySQL, Oracle, FoxPro, dBASE, SyBase MS-Access. The purpose of database management system is to bridge the gap between information and data.

In the Question:

What is the overall term for creating, editing, formatting, storing, retrieving a text document ?  [IBPS PO 2012]

The Answer is Database management.There are three main types of DBMS data models: relational, network, and hierarchical.

Hence the Option D is Correct.