Advertisements
Advertisements
प्रश्न
Differentiate between Database state and database schema.
उत्तर १
- Database State/Instance: The data stored in the database at a particular moment time of time i.e. the state of the database at a particular instance of time, is called an instance of the database.
- Database Schema: The logical structure and design of a database are called the database schema. It is the blueprint or skeleton structure of a database.
उत्तर २
| Database Schema | Database State | |
| 1. | It is the overall description of the database. | It is the collection of information stored in a database at a particular moment. |
| 2. | The schema is same for the whole database. | Data in instances can be changed using addition, deletion, and updation. |
| 3. | Does not change Frequently. | Changes Frequently. |
| 4. | Defines the basic structure of the database i.e. how the data will be stored in the database. | It is the set of Information stored at a particular time. |
संबंधित प्रश्न
What is meant by cell address?
State any one method of removing data from a cell in a spreadsheet.
What is the use of legends in a chart?
State the main advantages of an Action Query.
Queries are used to ____________ information from database.
Define database
What is the acronym of DBMS?
What symbol is used for the SELECT statement?
A tuple is also known as ______
What is the difference between the Select and Project commands?
Which language is used to request information from a Database?
List few disadvantages of the file processing system.
Explain on Evolution of DBMS.
How is a top to bottom relationship among the items in a database established?
What is meant by Database Partitioning?
List the components of storage manager.
Limitations of a file system can be resolved by ______.
What is not a DBMS?
A database ______ certain details about how data is actually stored and maintained.
The interface between the database and end users or application programs is referred to as ______.
Which of the following is not a real-life application of database?
What do you call the database catalogue where DBMS stores database schema along with various constraints?
Constraints are used to ______.
State or snapshot of a database at any instance is known as ______.
Which is not a limitation of database?
Give the term for the following:
DBMS creates a file that contains a description of the data stored in the database.
State the following rules of DBMS.
Referential Integrity
State any two requirements that should be considered before making an investing decision to choose between 'Server database' or 'Desktop database'.
Mention the symbol which specifies the fixed columns or rows in a formula.
List any two types of storage devices in DBMS.
What is meant by date-transfer rate?
