Three Schema Architecture MCQ Quiz - Objective Question with Answer for Three Schema Architecture - Download Free PDF

Latest Three Schema Architecture MCQ Objective Questions

Three Schema Architecture Question 1:

A top-to-bottom relationship among the items in a database is established by a

1. Hierarchical schema
2. Network schema
3. Relational schema
4. All options are correct

Answer (Detailed Solution Below)

Three Schema Architecture Question 1 Detailed Solution

The correct option is (1)

Concept:-

Data is arranged into a tree-like form and kept as records that are linked to one another in a hierarchical database model. The structure enables the use of parent-child relationships to describe information.

Key Points

• The Relational to Hierarchical and Hierarchical to Relational Transformations both require a hierarchical schema.
• The intended hierarchy of the output data is defined by the schema. Multiple hierarchical schemas can be produced and kept in your project files.
• A database model called a "network model" is intended to be flexible in how it represents things and the connections among them.
• The network model's schema, which is regarded as a graph where relationship types are arcs and object types are nodes, is one of its distinctive features.
• A relational schema is a set of relational tables and associated items that are related to one another.
• One schema contains all of the base tables, views, indexes, domains, user roles, stored modules, and other components that a user develops to meet the data requirements of a certain business or collection of applications.

Three Schema Architecture Question 2:

Which of the following is/are true with reference to ‘view’ in DBMS? (a) A ‘view’ is a special stored procedure executed when certain event occurs. (b) A ‘view’ is a virtual table, which occurs after executing a pre-compiled query.

1. Only (a) is true
2. Only (b) is true
3. Both (a) and (b) are true
4. Neither (a) nor (b) are true
5. None of them are valid

Answer (Detailed Solution Below)

Three Schema Architecture Question 2 Detailed Solution

The correct answer is "option2".

CONCEPT:

A view is virtual table that is used to view or manipulate parts of the table.

A view can select rows on the basis of certain conditions & fields from one or more tables present in database is used to create view.

V iew i s not a special stored procedure but is a virtual table which occurs after executing a pre-compiled query.

Hence, View in DBMS is a virtual table.

Three Schema Architecture Question 3:

Which of the following is/are true with reference to ‘view’ in DBMS? (a) A ‘view’ is a special stored procedure executed when certain event occurs. (b) A ‘view’ is a virtual table, which occurs after executing a pre-compiled query.

1. Only (a) is true
2. Only (b) is true
3. Both (a) and (b) are true
4. Neither (a) nor (b) are true

Answer (Detailed Solution Below)

Three Schema Architecture Question 3 Detailed Solution

The correct answer is "option 2".

Key Points

• A view is a virtual table that is used to view or manipulate parts of the table.
• A view can select rows on the basis of certain conditions & fields from one or more tables present in the database is used to create a view.
• V iew i s not a special stored procedure but is a virtual table that occurs after executing a pre-compiled query. Hence, View in DBMS is a virtual table.

Three Schema Architecture Question 4:

1. Physical schema
2. External schema
3. Logical schema
4. Data model

Answer (Detailed Solution Below)

Three Schema Architecture Question 4 Detailed Solution

External schema provides facility of view. VIEW is logical representation of table but data are not actually stored in such format.

Three Schema Architecture Question 5:

1. Conceptual Schema to Logical Schema
2. Logical Schema to conceptual Schema
3. Logical Schema to internal Schema
4. Internal Schema to logical Schema

Answer (Detailed Solution Below)

Three Schema Architecture Question 5 Detailed Solution

The correct answer is Conceptual Schema to Logical Schema.

Concept:-

Data model: a collection of conceptual tools for describing data, and data relationships. A data model provides a way to describe the design of a database at the physical, logical, and view levels.

We have to convert the conceptual database design into the logical database schema(that is the reason we say the data model is mapping between conceptual schema to Logical schema).

Conceptual Schema: It describes what data is present in the database. This schema hides the information regarding physical storage.

Logical schema: It is nothing but the design of the database at its logical level. This logical level contains table names, attributes, and key constraints.

Top Three Schema Architecture MCQ Objective Questions

Three Schema Architecture Question 6

1. Hierarchical schema
2. Network schema
3. Relational schema
4. All options are correct

Answer (Detailed Solution Below)

Three Schema Architecture Question 6 Detailed Solution

The correct option is (1)

Concept:-

Data is arranged into a tree-like form and kept as records that are linked to one another in a hierarchical database model. The structure enables the use of parent-child relationships to describe information.

Key Points

• The Relational to Hierarchical and Hierarchical to Relational Transformations both require a hierarchical schema.
• The intended hierarchy of the output data is defined by the schema. Multiple hierarchical schemas can be produced and kept in your project files.
• A database model called a "network model" is intended to be flexible in how it represents things and the connections among them.
• The network model's schema, which is regarded as a graph where relationship types are arcs and object types are nodes, is one of its distinctive features.
• A relational schema is a set of relational tables and associated items that are related to one another.
• One schema contains all of the base tables, views, indexes, domains, user roles, stored modules, and other components that a user develops to meet the data requirements of a certain business or collection of applications.

Share on Whatsapp

Three Schema Architecture Question 7

Which of the following is/are true with reference to ‘view’ in DBMS? (a) A ‘view’ is a special stored procedure executed when certain event occurs. (b) A ‘view’ is a virtual table, which occurs after executing a pre-compiled query.

1. Only (a) is true
2. Only (b) is true
3. Both (a) and (b) are true
4. Neither (a) nor (b) are true

Answer (Detailed Solution Below)

Three Schema Architecture Question 7 Detailed Solution

The correct answer is "option 2".

Key Points

• A view is a virtual table that is used to view or manipulate parts of the table.
• A view can select rows on the basis of certain conditions & fields from one or more tables present in the database is used to create a view.
• V iew i s not a special stored procedure but is a virtual table that occurs after executing a pre-compiled query. Hence, View in DBMS is a virtual table.

Share on Whatsapp

Three Schema Architecture Question 8:

1. Physical schema
2. External schema
3. Logical schema
4. Data model

Answer (Detailed Solution Below)

Three Schema Architecture Question 8 Detailed Solution

External schema provides facility of view. VIEW is logical representation of table but data are not actually stored in such format.

Three Schema Architecture Question 9:

Which of the following is/are true with reference to ‘view’ in DBMS? (a) A ‘view’ is a special stored procedure executed when certain event occurs. (b) A ‘view’ is a virtual table, which occurs after executing a pre-compiled query.

1. Only (a) is true
2. Only (b) is true
3. Both (a) and (b) are true
4. Neither (a) nor (b) are true
5. None of them are valid

Answer (Detailed Solution Below)

Three Schema Architecture Question 9 Detailed Solution

The correct answer is "option2".

CONCEPT:

A view is virtual table that is used to view or manipulate parts of the table.

A view can select rows on the basis of certain conditions & fields from one or more tables present in database is used to create view.

V iew i s not a special stored procedure but is a virtual table which occurs after executing a pre-compiled query.

Hence, View in DBMS is a virtual table.

Three Schema Architecture Question 10:

1. Conceptual Schema to Logical Schema
2. Logical Schema to conceptual Schema
3. Logical Schema to internal Schema
4. Internal Schema to logical Schema

Answer (Detailed Solution Below)

Three Schema Architecture Question 10 Detailed Solution

The correct answer is Conceptual Schema to Logical Schema.

Concept:-

Data model: a collection of conceptual tools for describing data, and data relationships. A data model provides a way to describe the design of a database at the physical, logical, and view levels.

We have to convert the conceptual database design into the logical database schema(that is the reason we say the data model is mapping between conceptual schema to Logical schema).

Conceptual Schema: It describes what data is present in the database. This schema hides the information regarding physical storage.

Logical schema: It is nothing but the design of the database at its logical level. This logical level contains table names, attributes, and key constraints.