4. In which way does a DBMS ensure data integrity?

B) By enforcing constraints like primary and foreign keys

1. What is a Database Management System (DBMS)?

B) A software used to manage and manipulate databases

8. What is the main advantage of using a DBMS over a traditional file system?

C) It provides structured data management and minimizes redundancy

9. What is the role of concurrency control in DBMS?

B) To ensure multiple users can access data without conflicts

studbud

DBMS DAy-1

10 termsStudBud Administration52 plays

Day-1

Flashcards10 cardsFPractice quizPHost liveL

Questions 10

Answers

1
10. Which type of DBMS stores data as objects similar to object-oriented programming?
D) Relational DBMS
A) Hierarchical DBMS
C) Network DBMS
B) Object-Oriented DBMS
2
3. Which language is primarily used to interact with relational databases?
A) Python
D) NoSQL
B) Java
C) SQL
3
4. In which way does a DBMS ensure data integrity?
B) By enforcing constraints like primary and foreign keys
D) By storing data only in text files
C) By preventing user access
A) By allowing redundant data
4
1. What is a Database Management System (DBMS)?
C) A programming language for creating applications
A) A hardware component for storing data
D) A file management system like Windows Explorer
B) A software used to manage and manipulate databases
5
7. Which of the following is a NoSQL database?
C) PostgreSQL
A) Microsoft SQL Server
D) SQLite
B) Cassandra
6
5. What type of DBMS organizes data in a tree-like structure with parent-child relationships?
D) Object-Oriented DBMS
B) Relational DBMS
C) Network DBMS
A) Hierarchical DBMS
7
8. What is the main advantage of using a DBMS over a traditional file system?
D) It does not need backups
A) It requires no storage
C) It provides structured data management and minimizes redundancy
B) It is cheaper to implement
8
9. What is the role of concurrency control in DBMS?
B) To ensure multiple users can access data without conflicts
D) To allow only one transaction at a time
C) To slow down data retrieval for security reasons
A) To restrict multiple users from accessing the database
9
6. Which property ensures data consistency in DBMS?
A) CAP theorem
D) CRUD operations
C) BASE properties
B) ACID properties
10
2. Which of the following is NOT an example of a relational DBMS?
B) Oracle
C) MongoDB
D) PostgreSQL
A) MySQL

DBMS DAy-1 Flashcards | StudBud