Vidyalelo
Computer Fundamentals · Q457

MS Access

Computer Related · Computer Fundamentals · question 457

Q457

the complete picture of data stored in database is known as

A.
Record
B.
Scheme
Answer
C.
System flowchart
D.
Dbms

Answer: Option B

Solution

Answer: Option B
Solution:
Option A: Record

This option is incorrect. A record in a database refers to a single row of data in a table, which represents a single instance of the entity described by the table. It is not the complete picture of the data stored in the database.

Option B: Scheme

This option is correct. A schema (often spelled "scheme" in some contexts) is the complete picture of data stored in a database. It includes the structure of the database, such as tables, relationships, constraints, and other elements that define how the data is organized and accessed.

Option C: System flowchart

This option is incorrect. A system flowchart is a graphical representation of the processes and flow of data within a system. It does not specifically refer to the complete picture of data stored in a database.

Option D: Dbms

This option is incorrect. A DBMS (Database Management System) is software that provides an interface to create, read, update, and delete data in a database. It is the tool used to manage the database, not the representation of the data itself.

Conclusion:

The complete picture of data stored in a database is known as the schema, making Option B: Scheme the correct answer.