 |  Intro to Database 20 Flashcards |  Start |
 | What is the primary purpose of a Database Management System (DBMS)? |  Card: 1 / 20 |
| DBMS manages data effectively.
| Card: 2 / 20 |
| Fill in the blanks: The components of a database system include data, hardware, software, and ___. | Card: 3 / 20 |
| Users | Card: 4 / 20 |
| True or False: A DBMS allows multiple users to access data simultaneously while maintaining data consistency. | Card: 5 / 20 |
| True | Card: 6 / 20 |
| What are the ACID properties that transactions in a DBMS must adhere to? | Card: 7 / 20 |
| Transactions must adhere to Atomicity, Consistency, Isolation, and Durability. | Card: 8 / 20 |
| Riddle: I am the heart of a database, ensuring no duplication. What am I? | Card: 9 / 20 |
| A DBMS | Card: 10 / 20 |
|  Unlock all Flashcards with EduRev Infinity Plan Starting from @ ₹99 only | |
| What is normalization in the context of databases? | Card: 11 / 20 |
| Normalization is a set of techniques used to organize tables in a database to reduce redundancy and avoid update anomalies. | Card: 12 / 20 |
| Fill in the blank: The ________ level of abstraction describes how data is actually stored on storage media. | Card: 13 / 20 |
| Physical | Card: 14 / 20 |
| Which component of a database includes user data and metadata? | Card: 15 / 20 |
| Data | Card: 16 / 20 |
| Multiple Choice: Which of the following is NOT a core service provided by a DBMS? A) Data definition B) Transaction management C) Data visualization D) Recovery and backup | Card: 17 / 20 |
| C) Data visualization | Card: 18 / 20 |
| What role do Database Administrators (DBAs) play in a database system? | Card: 19 / 20 |
| DBAs are responsible for installation, configuration, tuning, backup, recovery, and security of the database. | Card: 20 / 20 |
| Completed! Keep practicing to master all of them. |  Restart |
