DBMS MCQ Questions and Answers

Take Exam

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

41. Which of the following statements are for relational database

  • Data is represented in rows and columns
  • The data is stored as B-tree
  • Index and views are stored in Rows and Columns
  • None
Show Answer Report

42. Find the valid DML statements

  • Insert, Update, Erase
  • Insert, Update, Modify
  • Insert, Delete, Update
  • None
Show Answer Report

43. Which are the following statements are true for primary key

  • Primary key used for performing check constraints
  • It can
  • It can uniquely identify the row
  • None
Show Answer Report

44. Which are the following statements are true for foreign key

  • Foreign key used for performing check constraints
  • It can
  • It can uniquely identify the row
  • Foreign key maps always to a valid primary key
Show Answer Report

45. One of the cause of the failure of file system

  • Data availability
  • Fixed records
  • Sequential records
  • Lack of security
Show Answer Report

46. Transaction control means

  • Capability to manipulate the database
  • Capability to commit or rollback
  • Capability to change the structure of the table
  • None
Show Answer Report

47. Data integrity means

  • Column to maintain datatype specifies
  • Column to maintain length
  • Column to be not NULL
  • Column to be unique
Show Answer Report

48. What is not a feature of Hierarchical model

  • Child having a parent
  • Parent having parent
  • Parent may have any number of Childs
  • Child having more than one parent
Show Answer Report

49. Oracle 8i Here

  • Interface
  • Interaction
  • Internet
  • none of the above
Show Answer Report

50. Locks can be applicable for __________

  • views
  • indices
  • triggers
  • All of the above
Show Answer Report
Database
Questions and Answers for Competitive Exams Various Entrance Test