computer MCQs - 12th class Chapter 02 Mcqs

1

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

A

Field

B

File

C

Record

D

Data

2

A unit of data consisting of one or more characters is known as a?

A

Record

B

File

C

Field

D

Table

3

In the context of a database, what is another name for a row?

A

Attribute

B

Column

C

Tuple

D

Relation

4

Which of the following evolved from the traditional File Management System (FMS)?

A

Spreadsheets

B

Word Processors

C

Databases

D

Operating Systems

5

What is the term for any thing about which you want to keep information in the database?

A

Attribute

B

Entity

C

Relation

D

Schema

6

In a relational database, files or datasets are termed as?

A

Rows

B

Tuples

C

Columns

D

Tables

7

Which property of a relation states that no two rows can be identical?

A

Order of Rows is insignificant

B

No duplicate rows exist

C

Columns are atomic

D

Order of Columns is insignificant

8

A two-dimensional array or table of data containing descriptive information about an entity is called a?

A

View

B

Index

C

Relation

D

Key

9

What is created to keep data safe and secure from unauthorized users?

A

Indexes

B

Views

C

Keys

D

Tables

10

Which SQL command is used to create a view?

A

SELECT VIEW

B

CREATE VIEW

C

MAKE VIEW

D

ALTER VIEW

11

What is a single or combination of one or more fields used to point to or retrieve data rows?

A

Index

B

View

C

Key

D

Pointer

12

The attribute or combination of attributes that uniquely identifies a row in a relation is the?

A

Foreign Key

B

Secondary Key

C

Composite Key

D

Primary Key

13

An attribute in a table whose values must match a primary key in another table is a?

A

Primary Key

B

Candidate Key

C

Foreign Key

D

Sort Key

14

The table in which a foreign key is found is called the?

A

Parent table

B

Master table

C

Dependent table

D

Index table

15

Who is responsible for the entire data of an organization and develops overall functional requirements?

A

Database Administrator (DBA)

B

End-User

C

System Analyst

D

Data Administrator (DA)

16

Who is the technically expert person responsible for the design, implementation, and maintenance of the database?

A

Data Administrator (DA)

B

User

C

Database Administrator (DBA)

D

Programmer

17

What does 'atomic' mean in the context of relation properties?

A

All columns must be numeric

B

All intersections of rows and columns must have a single value

C

The table cannot be divided

D

Each row has a unique identifier

18

In the relational database model, fields are also known as?

A

Records

B

Tuples

C

Attributes

D

Relations

19

What is another term for a record in a database structure?

A

Tuple

B

Attribute

C

Column

D

Data Object

20

Which key is used to physically sequence the stored data according to need?

A

Primary Key

B

Foreign Key

C

Sort Key

D

Candidate Key

21

A key that consists of two or more attributes is known as a?

A

Primary Key

B

Composite Key

C

Secondary Key

D

Foreign Key

22

The order of columns in a relation/table is?

A

Significant

B

Fixed

C

Insignificant

D

Alphabetical

23

The order of rows in a table is?

A

Based on primary key by default

B

Significant

C

Insignificant

D

Chronological

24

In File Management Systems, each field is given a fixed or variable-length sequence of?

A

Bits

B

Bytes

C

Integers

D

Strings

25

A person who uses the computer for a specific need without in-depth technical knowledge is a(n)?

A

DBA

B

DA

C

End-user

D

Developer

26

Which key is a non-unique field used as an alternate key for retrieval?

A

Primary Key

B

Secondary Key

C

Foreign Key

D

Composite Key

27

What are collections of tables with some traditional files and other necessary data objects termed as?

A

A Database

B

A Schema

C

A System

D

An Application

28

Foreign key relationships are the basis for establishing which types of relationships?

A

1:1 or 1:M

B

M:M

C

Hierarchical

D

Network

29

Which key has the property of uniqueness and could be chosen as the primary key?

A

Sort Key

B

Foreign Key

C

Secondary Key

D

Candidate Key

30

The Data Administrator (DA) serves as a bridge between users and?

A

Management

B

Data processing staff

C

Hardware vendors

D

External auditors

31

What does a DBA need to safeguard for the database?

A

Its physical location

B

Its color scheme

C

Its security and access rights

D

Its marketing plan

32

The concept of databases evolved from which system?

A

Network Management System

B

File Management System

C

Content Management System

D

Operating System

33

In the STUDENT table example, STUD_NO and STUD_NAME are examples of what?

A

Rows

B

Relations

C

Tables

D

Attributes

34

What is another name for a table in a relational database?

A

Relation

B

Tuple

C

View

D

Schema

35

What is the main purpose of an Index in a database?

A

To store data backups

B

To enforce security rules

C

To make the system run smooth and fast

D

To define user roles

36

The values of fields in FMS are determined within their allocated?

A

Network addresses

B

Memory addresses

C

Disk sectors

D

Cache lines

37

In the example 'CREATE VIEW STUDENT_VIEW_01', what does the view show?

A

All students

B

Only female students

C

Only male students

D

Students in a specific course

38

In the PATIENT table example, what attribute can be used as the Primary Key?

A

PNAME

B

PHCODE

C

PATNO

D

STATUS

39

In the PHYSICIAN table, PHCODE is the?

A

Foreign Key

B

Secondary Key

C

Primary Key

D

Composite Key

40

In the PATIENT table, PHCODE is a?

A

Primary Key

B

Foreign Key

C

Candidate Key

D

Sort Key

41

The DBA must possess good __________ skills to handle complex software and hardware issues.

A

Communication

B

Managerial

C

Technical

D

Financial

42

A key that is the same as a Candidate/Alternate key but may not be unique by itself is a?

A

Foreign Key

B

Composite Key

C

Primary Key

D

Sort Key

43

In the given diagrams, a collection of related fields like 'Employee Number' and 'Employee Name' for one person is a?

A

File

B

Database

C

Record

D

Field

44

What does the acronym FMS stand for?

A

File Manipulation System

B

Field Management System

C

File Management System

D

Field Manipulation System

45

The Data Administrator is responsible for developing the __________ design for each database.

A

Physical

B

Technical

C

Conceptual

D

Logical

46

What is another name for columns in a database?

A

Rows

B

Items

C

Tuples

D

Occurrences

47

A view is constructed as needed from?

A

Backup files

B

Stored relations

C

Log files

D

External data

48

The database administrator is responsible for the design, implementation, operation, management and __________ of the database.

A

Marketing

B

Sales

C

Maintenance

D

Deletion