Today's Topic DataBasics Most Repeated Objective MCQs With Answers

DataBase Most Repeated Objective MCQs With Answers

Q1) A collection of raw facts and figures is called:

1. Data
2. Information
3. Processing
4. Output

Answer:Date

Explanation:Short Defination Of Data: A collection of raw facts and figures is called Data. So the right answer is Data.

Q2) Arithmetic manipulation of data is known as

1. Summarizing
2. Classifying
3. Sorting
4. Calculations

Answer:Calculations

Explanation: Calculations can only be performed on Arithmetic equations Numaric data which alson known as Number data e.g(0-9)

Q3) A data base is an organized collected of data

1. Physically
2. Loosely
3. Random
4. Logically

Answer:Logically

Explanation:Data base is a collection of Logically connected data.

Q4) Data that cause inconsistency lacks

1. Good Data
2. Data integrated
3. Data redundancy
4. Data anomaly

Answer:Data integrated

Explanation:Data integrated

Q5) SQL stands for:

1. Sort Query list
2. Self Quantifying language
3. Structure Query Language
4. Self Quantitative Language

Answer:Structure Query Language

Explanation: Structure Query Language is the language which is used to intract with the data base (SQL can add,delete,update records from database)

Q6) Which of the following program is used to produce an on-screen or printed document from the database

1. Data Dictionary
2. Backup
3. Query language
4. Report Generator

Answer:Report Generator

Explanation:Report Generator Is a tool or object that can be used to Generate different repors by fetching data from e DB (DataBase)

Q7) A technique of physically arranging records of a file on secondary storage devices is called:

1. Physical pointer
2. Retrieval program
3. file organization
4. Update program

Answer:File Organization

Explanation:File Organization is the process to arrange records of a file on physical or secondary storage

Q8) Which of the following is not a file from usage point of view

1. Master file
2. Transaction file
3. Index sequential file
4. Backup File

Answer: Index Sequential file

Explanation: Index Sequential file is a structured dile whic is used to store the Indexess of the records

Q9) Which represents a collection of concepts that are used to describe the structure of a database?

1. Data ware house
2. Data structure
3. Data model
4. Data type

Answer:Data model

Explanation:Data model. Is the actual structure that illustrats the concepts of the data to be stored in the database

Q10) Which one of the following data model is more flexible?

1. Network Model
2. Hierarchical Model
3. Relation Model
4. Object Data Model

Answer:Relation Model

Explanation:Network Model

Q11) Which of the following data is least flexible?

1. Hierarchical data model
2. Object data model
3. Relational data model
4. Network data model

Answer: Hierarchical data model

Explanation: Hierarchical data model

Q12) Data inconsistency is caused by:

1. Organized data
2. Integrated data
3. Data Redundant
4. Independent Data

Answer:Data Redundant

Explanation:Data Redundant

Q13) A loical grouping of characters is:

1. Record
2. Field
3. File
4. DataBase

Answer:Field

Explanation:Field

Q14) A ____ can store text only.

1. Binary
2. Text File
3. Transaction File
4. Program File

Answer:Text File

Explanation:Text File

Q15) The processed data is called:

1. Object
2. Information
3. Independent data
4. Transaction File

Answer:Information

Explanation:Information

Q16) The manipulated and processed data is called:

1. Obiect
2. Information
3. Knowledge
4. Data

Answer:Information

Explanation:Information

Q17) Storage and retrieval of data is related to:

1. Data Capturing
2. Data Manipulation
3. Managing Output
4. Analysis Result

Answer:Analysis Result

Explanation:Analysis Result

Q18) The process of arranging data in a logical sequence is called:

1. Sorting
2. Summarizing
3. Capturing
4. Classifying

Answer:Sorting

Explanation:Sorting

Q19) A set of related records that represents a unit of data is:

1. File
2. Record
3. Field
4. Databise

Answer:File

Explanation:File

Q20) A collection of related data field is called:

1. File
2. Database
3. Attributes
4. Record

Answer:Record

Explanation:Record

Q21) Which file is used to store information that remains constant for a long time?

1. Data file
2. Master file
3. Transaction files
4. Backup file

Answer:Master file

Explanation:Master file

Q22) Which of the following may be a temporary file?

1. Master File
2. Data File
3. Transaction File
4. Program File

Answer:Transaction File

Explanation:Transaction File

Q23) In text file data is stored in

1. ASCII- Code
2. Binary Code
3. Octal Code
4. Text Code

Answer:ASCII- Code

Explanation:ASCII- Code

Q24) Which one of the following type of file requires largest processing time?

1. Sequential file
2. Random file
3. Direct Access file
4. Indexed Sequential file

Answer:Sequential file

Explanation:Sequential file

Q25) Data can be recovered in case of loss by using:

1. Master File
2. Transaction File
3. Backup File
4. Data File

Answer:Backup File

Explanation:Backup File

Q26) A database containing all students in a class would store basic data of students in:

1. Record
2. Field
3. Cell
4. File

Answer:Record

Explanation:Record

Q27) The extension of image file is

1. .exe
2. .bmp
3. .doc
4. .ppt

Answer:bmp

Explanation:bmp

Q28) Which of the following is also known as data set?

1. Record
2. Field
3. File
4. Module

Answer:File

Explanation:File

Q28) A type of file that contains data is called:

1. Data File
2. Program File
3. Image File
4. Query File

Answer:Data File

Explanation:Data File

Q29) The smallest meaningful unit of Data in a Database is called:

1. Byte
2. Record
3. Character
4. Field

Answer:Character

Explanation:Character

Q30) A set of related files created and managed by a DBMS is called:

1. Field
2. Record
3. Database
4. Module

Answer:Database

Explanation:Database

Q31) Which of the following database model is also referred as inverter tree?

1. Hierarchical
2. Network
3. Relational
4. Object

Answer:Hierarchical

Explanation:Hierarchical

Q32) Database development process involve mapping of conceptual data model into:

1. Hierarchal data Mode
2. Implementation Model
3. Network data Model
4. Object Oriented data model

Answer:Hierarchal data Mode

Explanation:Hierarchal data Mode