| CARVIEW |
- Courses
- Tutorials
- Practice
- Jobs
Quiz on Database Management System Basics
Quiz about database management system basics.
Question 1
Which of the following is NOT an advantage of DBMS over traditional file system?
Reduced data redundancy and improved consistency
Faster storage for small data
Easy to query to data
Scalability
Question 2
Which type of DBMS is best suited for handling unstructured or semi-structured data like JSON documents?
Relational DBMS (RDBMS)
Object-Oriented DBMS (OODBMS)
NoSQL DBMS
Hierarchical DBMS
Question 3
Which DCL command is used to grant specific database access permissions to a user?
COMMIT
GRANT
SELECT
UPDATE
Question 4
In the database approach, data is stored in a
Text File
Spreadsheet
Database specific format
Word processor
Question 5
Which of the following is NOT a characteristic of the database approach?
Self-describing nature of a database
Insulation between programs and data
Multiple views of data
Increased data redundancy
Question 6
What is data independence?
Data not accessible to anyone
Data can be used without backup
Changes in data do not affect application programs
Data is dependent on one user
Question 7
Which of the following is an advantage of using a DBMS?
Increased redundancy
Better data integration
More complex programming
Less security
Question 8
Which one of the following is disadvantage of DBMS?
Improved data consistency
Data sharing
High initial cost
Reduced redundancy
Question 9
In a DBMS, multiple users can access data at the same time. This requires a DBMS to support?
Single-user mode
Concurrency control
Multi-mode access
Parallel retrieval
Question 10
Which of the following is a component of a DBMS?
Compiler
Query Processor
Spreadsheet
Web Browser
There are 10 questions to complete.
