DATABASE FUNDAMENTALS
DATABASE CONCEPTS AND STRUCTURES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Distinction
|
|
|
Initial Database State
|
|
|
Valid State
|
|
|
Database Schema
|
Detailed explanation-1: -Valid State: – A state that satisfies the structure and constraints of the database. Schema is also called intension.
Detailed explanation-2: -A database is always in one specific state. For example, these states include ONLINE, OFFLINE, or SUSPECT. To verify the current state of a database, select the state desc column in the sys. databases catalog view or the Status property in the DATABASEPROPERTYEX function.
Detailed explanation-3: -Database State: Refers to the content of a database at a moment in time. Valid State: A state that satisfies the structure and constraints of the database.
Detailed explanation-4: -In computer programming, a schema (pronounced SKEE-mah) is the organization or structure for a database, while in artificial intelligence (AI) a schema is a formal expression of an inference rule. For the former, the activity of data modeling leads to a schema.