Database Systems MCQ Questions & Answers

91

Two files may be joined into a third file if

A) they have a row in common B) they have a field in common C) they have no records with the same value in the common field D) both (b) and (c) E) None of the above

Discuss

Answer & Solution

Answer: Option B

No explanation is given for this question. Let's Discuss on Board

92

Characteristic(s) of a distributed MIS structure is

A) interactive sharing of the workload B) a multiprocessing environment C) computers supporting local DP operations D) All of the above E) None of the above

Discuss

Answer & Solution

Answer: Option D

No explanation is given for this question. Let's Discuss on Board

93

The data-base environment has all of the following components except:

A) users B) separate files C) data base D) data-base administrator E) None of the above

Discuss

Answer & Solution

Answer: Option B

Solution:

In a database environment, the components typically include:

Users: Individuals who interact with the database to perform operations like querying and updating data.

Database: The structured collection of data that is managed and organized for efficient retrieval and manipulation.

Database Administrator: The person responsible for managing and maintaining the database system, ensuring its performance, security, and availability.

Separate Files: This is not considered a component of a modern database environment. Databases are designed to manage data within a centralized system rather than relying on multiple separate files.

Thus, Option B: separate files is the correct answer as it does not fit into the standard components of a database environment.

94

The way a particular application views the data from the data base that the application uses is a :

A) module B) relational model C) schema D) subschema E) None of the above

Discuss

Answer & Solution

Answer: Option D

No explanation is given for this question. Let's Discuss on Board

95

A compound key

A) is made up a several pieces of information B) uniquely identifies an item in a list C) both (a) and (b) D) is a combination of each unique key E) None of the above

Discuss

Answer & Solution

Answer: Option C

No explanation is given for this question. Let's Discuss on Board

96

The distinguishable parts of a record are called

A) files B) data C) fields D) database E) None of the above

Discuss

Answer & Solution

Answer: Option C

No explanation is given for this question. Let's Discuss on Board

97

Large collections of files are called

A) fields B) records C) databases D) file system E) None of the above

Discuss

Answer & Solution

Answer: Option C

No explanation is given for this question. Let's Discuss on Board

98

The index consists of

A) a list of keys B) pointers to the master list C) both (a) and (b) D) All of the above E) None of the above

Discuss

Answer & Solution

Answer: Option C

No explanation is given for this question. Let's Discuss on Board

99

In SQL, which command is used to select data in rows and column from one or more tables?

A) CHOOSE B) SELECT C) LIST D) BROWSE E) None of the above

Discuss

Answer & Solution

Answer: Option B

No explanation is given for this question. Let's Discuss on Board

100

A scheme describes

A) data elements B) records and files C) record relationships D) All of the above E) None of the above

Discuss

Answer & Solution

Answer: Option D

No explanation is given for this question. Let's Discuss on Board

Database Systems MCQ Questions & Answers | Computer Science