DBMS-Introduction to Database Design Questions and Answers

Practice Mode
Showing 10 of 50 questions
Q11
Which of the following is a DBMS software?
  • A MySQL
  • B Microsoft Word
  • C Adobe Photoshop
  • D Google Chrome
Answer: Option A
Explanation: MySQL is a popular open-source relational database management system.
Q12
What does ACID stand for in database transactions?
  • A Atomicity, Consistency, Isolation, Durability
  • B Accuracy, Completeness, Integrity, Durability
  • C Automation, Control, Integration, Design
  • D Analysis, Calculation, Interpretation, Data
Answer: Option A
Explanation: ACID properties ensure reliable processing of database transactions: Atomicity, Consistency, Isolation, Durability.
Q13
What is the role of DDL in database systems?
  • A Define database structure
  • B Manipulate data
  • C Control user access
  • D Backup database
Answer: Option A
Explanation: Data Definition Language (DDL) is used to define and modify database structure (CREATE, ALTER, DROP).
Q14
Which constraint ensures column cannot have NULL values?
  • A NOT NULL
  • B UNIQUE
  • C PRIMARY KEY
  • D CHECK
Answer: Option A
Explanation: NOT NULL constraint prevents a column from containing null values.
Q15
What is an ER diagram used for?
  • A Visual database design
  • B Data encryption
  • C Query optimization
  • D User authentication
Answer: Option A
Explanation: Entity-Relationship diagrams visually represent the logical structure of databases.
Q16
Which normal form deals with multivalued dependencies?
  • A Fourth Normal Form
  • B Third Normal Form
  • C Second Normal Form
  • D First Normal Form
Answer: Option A
Explanation: Fourth Normal Form (4NF) addresses multivalued dependencies in database design.
Q17
What is data integrity?
  • A Data accuracy and consistency
  • B Data storage size
  • C Data transmission speed
  • D Data encryption level
Answer: Option A
Explanation: Data integrity ensures accuracy, consistency, and reliability of data throughout its lifecycle.
Q18
Which SQL clause is used to filter records?
  • A WHERE
  • B FILTER
  • C CONDITION
  • D SEARCH
Answer: Option A
Explanation: WHERE clause filters records based on specified conditions in SQL queries.
Q19
What is database normalization?
  • A Reduce redundancy
  • B Increase storage
  • C Speed up queries
  • D Enhance security
Answer: Option A
Explanation: Normalization organizes data to reduce redundancy and improve data integrity in databases.
Q20
Which key can have NULL values?
  • A Foreign key
  • B Primary key
  • C Candidate key
  • D Super key
Answer: Option A
Explanation: Foreign keys can contain null values when there is no related record in the primary table.

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test