Which schema architecture level describes how the data is physically stored on disk storage media? MCQ with Answer and Explanation

Question

Share Report Error

Which schema architecture level describes how the data is physically stored on disk storage media?

A. External Level

B. Internal Level

C. Logical Level

D. Conceptual Level

Answer: Option B

Solution (By JKSSB Mock Tests)

The Internal (or Physical) level of the three-schema architecture describes the physical storage structure and access paths of the database.

This question belongs to: Computer Database Management System (DBMS)

Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1

What is a database lock?

A. A backup file

B. A type of index

C. A user account

D. A mechanism to prevent simultaneous access to the same data causing inconsistency

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Locking is a concurrency control mechanism that ensures data integrity during simultaneous transactions.

This question belongs to: Computer Database Management System (DBMS)

Question #2

What is the result of the SQL query: SELECT * FROM employees;?

A. Only the primary key column

B. Only the first row

C. An empty result

D. All rows and all columns from the employees table

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
SELECT * retrieves all columns and rows from the specified table.

This question belongs to: Computer Database Management System (DBMS)

Question #3

An attribute whose value is computed dynamically from another attribute (such as calculating Age from Date_of_Birth) is called a what?

A. Derived Attribute

B. Multi-valued Attribute

C. Stored Attribute

D. Base Attribute

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A Derived Attribute is an attribute whose values are not stored physically in the database but are calculated at runtime from other stored attributes.

This question belongs to: Computer Database Management System (DBMS)

Explore All Database Management System (DBMS) MCQs