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
2. Which of the following is NOT a characteristic of DBMS?
- Data independence
- Data security
- No data redundancy
- Concurrency control
3. What is data redundancy in database systems?
- Unnecessary data duplication
- Data encryption
- Data compression
- Data validation
4. Which data model represents data as tables?
- Relational model
- Hierarchical model
- Network model
- Object-oriented model
5. What is an entity in database design?
- Real-world object
- Database table
- SQL query
- Programming function
6. What is the purpose of a primary key?
- Unique identification
- Data sorting
- Memory allocation
- Network connection
7. Which normal form eliminates transitive dependencies?
- Third Normal Form
- First Normal Form
- Second Normal Form
- Boyce-Codd Normal Form
8. What is data abstraction in DBMS?
- Hiding implementation details
- Data encryption
- Data compression
- Data backup
9. Which SQL command is used to create a database?
- CREATE DATABASE
- MAKE DATABASE
- NEW DATABASE
- BUILD DATABASE
10. What is a foreign key?
- References primary key
- Unique identifier
- Data validator
- Index creator