DMBS Database Management Systems MCQ Set 5

At the beginning of DBMS’s fourth MCQ set, we have discussed two elements of the Database Management System. In this section, we will last element of DBMS i.e. Indexing. To make more understand we are adding some of the components for user-friendliness.

Indexing: Indexing is a data structure technique to efficiently retrieve records from database files based on some attributes on which the indexing has been done. Indexing on database systems is similar to the one we see indexing in books. Indexing is based on its indexing attributes. if the index is built on the order ‘key field of file it’s called primary indexes. Generally, it is the primary key of the relation. And of the index is built on ordering non-key filed of file it is called clustering index. Now let start our fourth set of MCQ.

81. A part of a database that stores only one type of data is

A. ReportB. Field
C. QueryD. Record

82. Which of the following may not be a database?

A. Data presented in the table in MS word documentsB. Data Entered in Excel Spreadsheet
C. A Presentation created in PowerpointD. A Telephone diary

83. A database can be best described as

A. Organized collection of dataB. Useful presentation of data
C. Graphical representation of dataD. All of the above

84. Which of the following term is least related to the database.

A. AttributesB. Tuples
C. RelationshipD. Columns

85. Collection of related records in a database is known as

A. FileB. Bench
C. TableD. Relationship

86. The task of arranging data in order is called

A. SearchingB. Sorting
C. OrderingD. Shorting

87. Each record is constituted by a number of individual data items which are called

A. FieldsB. Data Types
C. RelationsD. Tables

88. Which of the following is not a database object in MS Access?

A. TablesB. Query
C. ReportRelationship

Leave a Reply