Database Systems MCQ Questions & Answers

31

What is the abbreviation used for a software package that permits the users to create, retrieve and maintain records in a database?

A) DASD B) FMS C) EMMS D) DBMS E) None of the above

Discuss

Answer & Solution

Answer: Option D

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

32

Which of the following is not an advantage of the data-base approach?

A) elimination of the data redundancy B) ability to associate related data C) increased security D) program/data independence E) All of the above are advantages

Discuss

Answer & Solution

Answer: Option E

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

33

A data dictionary doesn't provide information about:

A) where data is located B) the size of the disk storage device C) It allows a many-to-many relationship D) It is conceptually simple E) It will be the dominant data base of the future

Discuss

Answer & Solution

Answer: Option B

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

34

Data encryption techniques are particularly useful for

A) reducing storage space requirements B) improving data integrity C) protecting data in data communication systems 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

35

It is more accurate to define a _____ as a variety of different record types that are treated as a single unit

A) Database B) Table C) Record D) Flat File E) None of the above

Discuss

Answer & Solution

Answer: Option A

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

36

A logical schema

A) is the entire database B) is a standard way of organizing information into accessible parts C) describes how data is actually stored on disk D) All of the above E) None of the above

Discuss

Answer & Solution

Answer: Option B

Solution:

A logical schema is a representation of the structure of a database in terms of how data is organized and related. It focuses on the design and organization of data elements and their relationships, abstracted from the physical storage.

Logical Schema Definition:
The logical schema defines how data is organized into tables, their attributes, and the relationships among them. It is concerned with the design and structure of the database as seen by users and applications, without regard to how the data is physically stored.

Option A: Entire Database
This describes the physical schema or the entire database, not the logical schema.

Option C: Describes How Data is Actually Stored
This refers to the physical schema, which deals with the actual storage of data on disk.

Option D: All of the Above
Since options A and C describe different aspects (physical schema) and are not part of the logical schema, this option is incorrect.

Option E: None of the Above
Since option B correctly describes the logical schema, this option is not applicable.

Therefore, the correct answer is Option B: is a standard way of organizing information into accessible parts.

37

Queries to a database

A) are written in English B) can use aggregate functions like SUM and COUNT C) both (a) and (b) D) All of the above E) None of the above

Discuss

Answer & Solution

Answer: Option B

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

38

In order to use a record management system

A) You need to understand the low-level details of how information in stored B) You need to understand the model the record management system uses. C) Both (a) and (b) D) All of the above E) None of the above

Discuss

Answer & Solution

Answer: Option B

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

39

In SQL, which command is used to select only one copy of each set of duplicable rows

A) SELECT DISTINCT B) SELECT UNIQUE C) SELECT DIFFERENT D) All of the above E) None of the above

Discuss

Answer & Solution

Answer: Option A

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

40

The physical location of a record is determined by a mathematical formula that transforms a file key into a record location in

A) a tree file B) an indexed file C) a hashed file D) a sequential file E) None of the above

Discuss

Answer & Solution

Answer: Option C

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

Database Systems MCQ Questions & Answers | Computer Science