MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

SQL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

Which of the following model describes HOW the system will be implemented using a specific DBMS system?

A	Physical
B	Conceptual
C	Logical
D	UML

Explanation:

Detailed explanation-1: -Physical Data Model: This Data Model describes HOW the system will be implemented using a specific DBMS system. This model is typically created by DBA and developers.

Detailed explanation-2: -Definition: An implementation of a given data model is a physical realization on a real machine of the components of the abstract machine that together constitute that model.

Detailed explanation-3: -A physical data model is a database-specific model that represents relational data objects (for example, tables, columns, primary and foreign keys) and their relationships. A physical data model can be used to generate DDL statements which can then be deployed to a database server.

Detailed explanation-4: -Hierarchical database model. Relational model. Network model. Object-oriented database model.

Detailed explanation-5: -ER model, Relational model, and Object-oriented model are among the most popular data models in DBMS.

There is 1 question to complete.