1. Data: Facts, figures, statistics etc.
2. Record: Collection of related data items,
3. Table or Relation: Collection of related records.
4. Database: Collection of related relations.

Solved Example: 9130-01

Which one is not a database management software? (RSMSSB LDC Official Paper I Aug 2018)

A. Oracle

B. Drupal

C. MySQL

D. MS Access

Drupal is a Content Management Software (CMS) whereas Oracle, mySQL and MS Access are Database Management Software.

Correct Answer: B

Solved Example: 9130-02

A ______ is a column in a table that contains a specific piece of information within a record. (HSSC Police Constable Sept 2021 Evening)

A. Reports

B. Field

C. Datasheet

D. Filter

Correct Answer: B

Solved Example: 9130-03

Which of the following employee attributes can be considered as multi-valued as well as composite? (UPPCL AE CS 2019 Nov 2019)

A. Social security number

B. Designation

C. Date of birth

D. Telephone

Correct Answer: D

General Steps in Data Science:

1. Data Collection: Defining the attributes to be collected and selecting proper methodology for data collection.
2. Data Preparation: Consists data cleaning to eliminate inconsistencies in data, such as missing values, blank columns, abrupt values, incorrect data format. It also includes data pre-processing, where we remove outliers, replace null values and normalizing the data.
3. Model Planning: Utilize data visualization techniques, to get a better idea of the distribution of the data.
4. Model Building: Use different combination of attributes to make various decision trees, for having mximum efficiency.
5. Operationalize: To run a small pilot project to check wheether the results are appropriate
6. Communicate Results: Sharing the results for further deployment and processing.

Solved Example: 9133-01

What is the main function of the electronic spread sheet? (MP Vyapam Sub-Engineer Electrical April 2016 Shift I)

A. Filtering

B. Merging

C. Sorting

D. All of Above

Correct Answer: D

Solved Example: 9133-02

The process of quantifying data is referred to as:

A. Decoding

B. Structure

C. Enumeration

D. Coding

Correct Answer: C

Solved Example: 9133-03

What is a hypothesis?

A. A statement that the researcher wants to test through the data collected in a study

B. A research question the results will answer

C. A theory that underpins the study

D. A statistical method for calculating the extent to which the results could have happened by chance

Correct Answer: A

Solved Example: 9133-04

If the null hypothesis is false then which of the following is accepted?

A. Alternative Hypothesis.

B. Anull Hypothesis

C. Full Hypothesis

D. Critical Region Hypothesis

Correct Answer: A