Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
| Question 679 |
____ is logical design of a database, while____is snapshot of data in the database at a point in time.
| Database schema, database instance | |
| Database relation,attribute | |
| Attribute domain, attribute value | |
| Database schema, attribute domain |
Question 679 Explanation:
→A database schema is the skeleton structure that represents the logical view of the entire database. It defines how the data is organized and how the relations among them are associated. It formulates all the constraints that are to be applied on the data.
→The environment of database is said to be instance. A database instance or an ‘instance’ is made up of the background processes needed by the database software. These processes usually include a process monitor, session monitor, lock monitor, etc.
→A database instance (Server) is a set of memory structure and background processes that access a set of database files.
→The environment of database is said to be instance. A database instance or an ‘instance’ is made up of the background processes needed by the database software. These processes usually include a process monitor, session monitor, lock monitor, etc.
→A database instance (Server) is a set of memory structure and background processes that access a set of database files.
Correct Answer: A
Question 679 Explanation:
→A database schema is the skeleton structure that represents the logical view of the entire database. It defines how the data is organized and how the relations among them are associated. It formulates all the constraints that are to be applied on the data.
→The environment of database is said to be instance. A database instance or an ‘instance’ is made up of the background processes needed by the database software. These processes usually include a process monitor, session monitor, lock monitor, etc.
→A database instance (Server) is a set of memory structure and background processes that access a set of database files.
→The environment of database is said to be instance. A database instance or an ‘instance’ is made up of the background processes needed by the database software. These processes usually include a process monitor, session monitor, lock monitor, etc.
→A database instance (Server) is a set of memory structure and background processes that access a set of database files.