Question : Which of the following is a key advantage of three-schema architecture?
Solution :
Correct Answer : Provides data independence
Description -
Question : What is the role of mapping in three-schema architecture?
Solution :
Correct Answer : To transform requests between different schema levels
Description -
Question : Which of the following correctly describes the conceptual level?
Solution :
Correct Answer : It describes the entire database structure logically
Description -
Question : Which level of the three-schema architecture deals with the physical storage structure of the database?
Solution :
Correct Answer : Internal Level
Description -
Question : What is the main objective of the three-schema architecture in DBMS?
Solution :
Correct Answer : To separate user view from physical database
Description -
Question : Which statement best explains the purpose of DBMS architecture?
Solution :
Correct Answer : To define how users interact with the database system
Description -
Question : Which of the following is a major advantage of multi-tier DBMS architecture?
Solution :
Correct Answer : Independence between layers
Description -
Question : In 3-Tier Architecture, which layer acts as an intermediary between client and database server?
Solution :
Correct Answer : Application Server
Description -
Question : Which component in 2-Tier Architecture is responsible for query processing and transaction management?
Solution :
Correct Answer : Server
Description -
Question : Which of the following correctly describes 1-Tier DBMS Architecture?
Solution :
Correct Answer : User directly interacts with the database system
Description -
Question : Which of the following correctly compares recovery mechanisms in DBMS and file systems?
Solution :
Correct Answer : DBMS provides recovery, file system does not
Description -
Question : What is the main reason for data inconsistency in file systems?
Solution :
Correct Answer : Data duplication across multiple files
Description -
Question : Which of the following features is NOT supported by file systems but supported by DBMS?
Solution :
Correct Answer : Query language (SQL)
Description -
Question : In a traditional file system, data is typically stored using which approach?
Solution :
Correct Answer : Decentralized approach
Description -
Question : Which of the following is a major advantage of DBMS over file system?
Solution :
Correct Answer : Data independence
Description -
Question : Why is RDBMS considered more suitable for large-scale applications?
Solution :
Correct Answer : It handles large data and supports multiple users
Description -
Question : Which of the following properties is associated with RDBMS but not DBMS?
Solution :
Correct Answer : ACID properties
Description -
Question : Which statement correctly describes the relationship handling in DBMS and RDBMS?
Solution :
Correct Answer : DBMS has no relationships, RDBMS maintains relationships using keys
Description -
Question : Which feature is supported in RDBMS but not in DBMS?
Solution :
Correct Answer : Normalization
Description -
Question : Which of the following is the primary difference between DBMS and RDBMS in terms of data storage?
Solution :
Correct Answer : DBMS stores data as files, RDBMS in tabular form
Description -