DBMS MCQ Questions and Answers
DBMS MCQ questions with answers form a vital part of technical exams and campus interviews. This topic explores database concepts, normalization, SQL queries, transaction management, and ER models. Practicing programming questions and answers from this section strengthens your database design and query optimization skills. These questions are frequently asked in GATE, Infosys, TCS, and Wipro assessments, making them essential for students and professionals alike. Detailed solutions and explanations make this section perfect for both beginners and advanced learners aiming to master database management fundamentals.
DBMS MCQ
Showing 10 of
527 questions
251. Which of the following statement(s) is/are correct in relation to database applications? a. An enterprise database is intended to support organisation-wide operations and decision-making. b. An organisation can have multiple databases which are separate departmental databases or as an enterprise database. c. Usually, work group databases are larger than departmental databases. d. Data warehouse is an integrated decision support database whose content is derived from the various operationa
- a,c and d
- a,b and d
- c, d
- b,d
252. Which of the following is/are describing the proper order of data access methods of Relational Database, Hierarchical Database and the Network databases? a. Supports direct access to a specific record and is difficult to access multiple records related to a single record. b. Supports access to multiple records related to a single record and is dependent on pre defined physical pointers. c. Supports hierarchical and non-hierarchical data relationships and is dependent on predefined physical p
- a,c and d
- d, c and b
- b, c and d
- d and b
253. Which of the following describe(s) the features of distributed databases? These databases are stored on computers at multiple locations and are not interconnected by a network. These databases form a single logical database that is spread physically across computers in multiple locations that are connected by a data communication link. Homogeneous type of distributed databases use the same type of database management system at each location. All users access the database through one globa
- a,c and d
- a, c
- b, c and d
- d and b
254. With respect to the database development process, identify function(s) applicable to the logical design stage. a. Identify scope of database requirements for the proposed information system. b. Analyse in detail the transactions, forms, displays, and inquiries (database views) required by the business functions supported by the database and integrate those views into conceptual data model. c. Transform the combined and reconciled data specifications into basic or atomic elements following we
- a,c and d
- a, c
- b, c and d
- d and b
255. Which of the following is/are true in relation to the database design process? a. Identification of entities, their attributes, relationships, and business rules is carried out at the conceptual design stage. b. A weak entity is an entity that exists independently of other regular entity types. c. Relationship instance is an association between entity instances, where each relationship instance includes exactly one entity from each participating entity type. d. Cardinality constraint spec
- a,c and d
- a, c
- b, c and d
- d and b
256. The data type of a field is usually one of the standard data types used in programming. Which of the following data types may result in use of variable-length records?
- Floating point
- Boolean
- Date and time
- String of characters
257. Which of the following is (are) correct with respect to file systems? a. A logical record is concerned with efficient storage of information in the secondary storage devices. b. The efficiency of a file system depends on how efficiently operations such as retrieve, insert, update, delete may be performed on the information stored in the file. c. A sequential file system turns out to be quite efficient for an application where most of the storage and retrieval of records are performed sequen
- a,c and d
- b and d
- b and c
- d and a
258. A file organisation essentially means organisation of records in the file. Which of the following technique(s) is (are) used for indexed file organisations? (a) Heap (b) Sequential (c) B+ tree (d) ISAM
- a,c and d
- b and d
- c,d
- d and a
259. Which of the following step(s) is (are) true for sequential file organisation when attempting to insert a record (i) Locate the record in the file that comes before the record to be inserted in search key order (ii) If there is a free record (that is a space left after a deletion) within the same block as the located record insert the new record there. Otherwise, insert the new record in an overflow block (iii) Adjust the pointers if the new record is inserted in an overflow block, otherw
- Only (i) is true
- Only (i) and (ii) are true
- Only (i) and (iii) are true
- Only (ii) and (iii) are true
260. Practitioners are the people responsible for the database system and its associated application software. Which of the following person(s) is a (are) practitioner(s)? (a) System Designer (b) Programmer/Analyst (c) Departmental heads (d) Information System Manager
- a,c and d
- c and d
- a,b and d
- d and b