DATABASE FUNDAMENTALS
WHAT IS DATABASE MANAGEMENT
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Structural independence is promoted using independent tables
|
|
|
Tabular view improves conceptual simplicity
|
|
|
Ad hoc query capability is based on SQL
|
|
|
Isolates the end user from physical-level details
|
|
|
Improves implementation and management simplicity
|
Detailed explanation-1: -The primary benefit of the relational database approach is the ability to create meaningful information by joining the tables. Joining tables allows you to understand the relations between the data, or how the tables connect. SQL includes the ability to count, add, group, and also combine queries.
Detailed explanation-2: -One of the major benefits of using a Relational Database is that this type of Database allows the user to simply classify the data into different categories and store them efficiently. This arrangement can be further fetched using queries and filters.
Detailed explanation-3: -Advantages of Relational Data Models Scalable: Relational Data Model in RDBMS greatly supports scalability making it possible to enhance the usability of the Database. Query Capability: Users can use SQL language to access data and even easily write complex queries and avoid complex Database navigation.
Detailed explanation-4: -Which of the following is an advantage of using a relational database management system? Data can be accessed or reassembled from the database in many different ways without having to reorganize the database tables.