DBMS-Introduction to Database Design Questions and Answers

DBMS-Introduction to Database Design

Showing 10 of 50 questions
1. What is the primary purpose of a database management system?
  • Data storage and retrieval
  • Network configuration
  • Hardware maintenance
  • Software development
Show Answer Report
2. Which of the following is NOT a characteristic of DBMS?
  • Data independence
  • Data security
  • No data redundancy
  • Concurrency control
Show Answer Report
3. What is data redundancy in database systems?
  • Unnecessary data duplication
  • Data encryption
  • Data compression
  • Data validation
Show Answer Report
4. Which data model represents data as tables?
  • Relational model
  • Hierarchical model
  • Network model
  • Object-oriented model
Show Answer Report
5. What is an entity in database design?
  • Real-world object
  • Database table
  • SQL query
  • Programming function
Show Answer Report
6. What is the purpose of a primary key?
  • Unique identification
  • Data sorting
  • Memory allocation
  • Network connection
Show Answer Report
7. Which normal form eliminates transitive dependencies?
  • Third Normal Form
  • First Normal Form
  • Second Normal Form
  • Boyce-Codd Normal Form
Show Answer Report
8. What is data abstraction in DBMS?
  • Hiding implementation details
  • Data encryption
  • Data compression
  • Data backup
Show Answer Report
9. Which SQL command is used to create a database?
  • CREATE DATABASE
  • MAKE DATABASE
  • NEW DATABASE
  • BUILD DATABASE
Show Answer Report
10. What is a foreign key?
  • References primary key
  • Unique identifier
  • Data validator
  • Index creator
Show Answer Report
Questions and Answers for Competitive Exams Various Entrance Test