Database Interview Question

Database Interview Question

Table of Content

• Define date?
• Define Information?
• What is data processing?
• What is date capturing?
• What is data manipulation?
• What is meant by data classifying? Explain with example
• What is meant by reproduction?
• Define the term field?
• What is the importance of data type and size of field?
• Define the term Record.
• What is a file or data set?
• What is Master File?
• What is program file?
• What is random access file?

Define date?

A collection of facts and figures related to an object is called data. An Object may be a person, an organization, an event or any other things etc. Data may be in the form of text, numbers images, sounds, and videos.

Define information?

The processed data is called information. It provides useful meanings. Data is used as input for processing and information is the output of this processing.

What is data processing?

A series of activates performed on data to convert it into meaningful information is called data processing. Data processing is also called operation.

What is data capturing?

The process of collecting data and recording it in a form such that it can be processed easily is called data capturing.

What is data manipulation?

The process of applying different operations on the collected data to achieve the required results is called data manipulation.

What is meant by data classifying? Explain with example

The process of organizing data into groups or classes is called classifying data. For example the collected data of students of intermediate class of a college is organized into groups of ICS, FA, Pre-Medical, and Pre-Engineering etc. Each group or class is assigned a unique code. This code helps in accessing and processing data of a specific group.

What is meant by reproduction?

The process of making duplicate copies of output results is called reproduction usually, the output result is reproduced to distribute it to different persons or users.

Define the term field.

A set of related characters is called field. It represents one unit of data. Each field is given a unique name known as the field name. For Example, Roll_NO, Name, Address and marks a of a student of a class represent the fields.

What is the importance of data type and size of field?

Data type of a field specifies the type of data that can be stored in it. The maximum number of characters that can be stored in a field Is known as field size.

Define the term Record.

A collection of related fields is called record. A record is treated as a single unit. For example, a student’s record includes a set of fields that may contain Roll_No, Name Address and Phone etc.

What is a file or data set?

A collection of related records is called a file. These related records are treated as a single unit. A file is also known as data set. A collection of records of students of a college is an example of students file.

What is Master File?

Master file is the main file in the file system. It is created to maintain information that remains constant for a long period of time. Mater file is the latest update file it is update when any change in its contents is required. Once a master file in created it cannot become empty.

What is program file?

The files that contain the set of instructions in machine code to perform various tasks on data are known as program files. These are executable files. These files have the file extensions exe or com

What is random access file?

Direct files are also referred to as random files. In these files records are not stored in a sequence. Each record is stored by specifying a particular address or location within a file the address is calculated against the value of the key field of the record.