computer MCQs - 12th class Chapter 01 Mcqs

1

A collection of facts, figures, and statistics related to an object is called?

A

Information

B

Data

C

Operation

D

Process

2

The manipulated and processed data is called?

A

Data

B

Asset

C

Information

D

Report

3

Organizing data into classes or groups is known as?

A

Sorting

B

Summarizing

C

Classifying

D

Calculating

4

Arranging data in a logical sequence, either numerically or alphabetically, is called?

A

Classifying

B

Sorting

C

Summarizing

D

Capturing

5

Reducing masses of data to a more concise and usable form is called?

A

Calculations

B

Sorting

C

Data Capturing

D

Summarizing

6

Accessing or fetching stored data is known as which activity?

A

Reproduction

B

Retrieve

C

Storing

D

Communication

7

The activity of copying or making a duplicate of data is called?

A

Reproduction

B

Retrieval

C

Manipulation

D

Capturing

8

A collection of related fields treated as a single unit is called a?

A

File

B

Database

C

Record

D

Data set

9

A collection of related records treated as a single unit is called a?

A

Record

B

Field

C

File

D

Database

10

Which file type contains the latest updated information and never becomes empty?

A

Transaction File

B

Backup File

C

Master File

D

Program File

11

Which file type is often temporary and holds data prior to processing?

A

Master File

B

Transaction File

C

Backup File

D

Data File

12

The main purpose of this file is the protection of vital data.

A

Master File

B

Transaction File

C

Program File

D

Backup File

13

Files containing software instructions, like .exe or .com files, are called?

A

Data files

B

Program files

C

Backup files

D

Master files

14

Files with extensions like .doc, .xls, and .mdb are categorized as?

A

Program files

B

System files

C

Data files

D

Backup files

15

Which file organization method stores records one after another in sequence?

A

Direct

B

Random

C

Indexed Sequential

D

Sequential

16

Which file organization method requires comparatively more processing time?

A

Sequential

B

Random

C

Direct

D

Indexed Sequential

17

In which file organization is a record's address calculated against a key field?

A

Sequential

B

Direct or Random

C

Indexed Sequential

D

Master

18

Which file organization can be processed both sequentially and randomly?

A

Sequential

B

Direct

C

Indexed Sequential

D

Random

19

A collection of logically related data sets or files is a?

A

Record

B

File System

C

Database

D

DBMS

20

Which of the following is NOT a major component of a database system?

A

Hardware

B

Software

C

Internet

D

Personnels

21

Secondary Storage, I/O devices, and Processors are examples of which component?

A

Data

B

Software

C

Hardware

D

Personnels

22

Programmers, End users, and Database Administrators are part of which component?

A

Hardware

B

Software

C

Data

D

Personnels

23

Coordinating information from different files into a single logical file is called?

A

Data Integrity

B

Data Integration

C

Data Interdependence

D

Data Security

24

Ensuring consistency by keeping only one copy of a data item is related to?

A

Data Integration

B

Data Interdependence

C

Data Integrity

D

Data Sharing

25

The ability to change the data organization without reprogramming is called?

A

Data Integration

B

Data Integrity

C

Data Interdependence

D

Data Modeling

26

Which database model has the general shape of an organizational chart?

A

Network Model

B

Relational Model

C

Hierarchical Model

D

Object Model

27

The topmost node in a Hierarchical Model is referred to as the?

A

Leaf

B

Branch

C

Root

D

Node

28

In which model can a subordinate entity participate in many relationships?

A

Hierarchical Model

B

Network Model

C

Relational Model

D

Tree Model

29

Which model consists of a collection of simple files (relations) with no physical connections?

A

Hierarchical Model

B

Network Model

C

Relational Model

D

Inverted Tree

30

A system used for storing and manipulating databases is called a?

A

File System

B

Operating System

C

Database Management System (DBMS)

D

Spreadsheet

31

The ability of a DBMS to change in response to growing user needs is called?

A

Availability

B

Shareability

C

Evolvability

D

Integrity

32

The objective that different people can use the same data at the same time is?

A

Availability

B

Shareability

C

Evolvability

D

Integrity

33

Application programs not being aware of the physical implementation of data is called?

A

Data Security

B

Data Independence

C

Data Integrity

D

Data Complexity

34

A utility within the DBMS that rebuilds the database using a backup copy and a log of changes is used for?

A

Security

B

Recovery

C

Reporting

D

Querying

35

Which of the following is a disadvantage of DBMS?

A

Data Independence

B

Complex Relationships

C

Additional System Overhead

D

Data Security

36

Which database systems are most sensitive to changes in structure?

A

Relational

B

Network

C

Hierarchical

D

Object-oriented

37

A file that stores data definitions or a description of the data structure is the?

A

Log file

B

Backup file

C

Master file

D

Data Dictionary

38

What does SQL stand for?

A

Standard Query Language

B

Structured Query Language

C

Simple Query Language

D

System Query Language

39

Which feature is used to produce an on-screen or printed document from the database?

A

Query Language

B

Report Generator

C

Utilities

D

Data Dictionary

40

The person responsible for the database is the?

A

End User

B

Programmer

C

Analyst

D

Database Administrator

41

Arithmetic manipulation of data is called?

A

Sorting

B

Summarizing

C

Calculations

D

Classifying

42

A file with a .wks extension is typically created by what software?

A

Word Processor

B

Spread Sheet

C

Data base

D

Image editor

43

Which of the following is an image file extension?

A

wav

B

mpg

C

jpg

D

txt

44

The concept of a 'synonym' can arise in which file organization?

A

Sequential

B

Indexed Sequential

C

Direct or Random

D

Master

45

The structure of a Hierarchical model is often referred to as an?

A

Network

B

Web

C

Inverted Tree

D

Relational Table

46

In the Relational model, relationships are based on?

A

Pointer chains

B

Physical connections

C

Data content of entities

D

Structural links

47

The DBMS sits in between the application programs and the?

A

Hardware

B

User

C

Database

D

Network

48

Doing changes on which database model is fairly easy and less costly?

A

Hierarchical

B

Network

C

Relational

D

All of them

49

Commands like SELECT, INSERT, and UPDATE are part of?

A

A Report Generator

B

A Utility Program

C

A Query Language

D

A Data Dictionary

50

Which DBMS feature allows administrators to assign specific access privileges to users?

A

Access Security

B

Data Dictionary

C

Report Generator

D

Utilities