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. |
संबंधित प्रश्न
State any one method of removing data from a cell in a spreadsheet.
Give the full form of SQL.
State the significance of the following in DBMS :
(i) Forms
(ii) Reports
What is the difference between .importing and exporting of a database?
State the main advantages of an Action Query.
__________ is a collection of related data.
Define database
What is the acronym of DBMS?
What symbol is used for the SELECT statement?
What is the difference between the Select and Project commands?
Which language is used to request information from a Database?
The ______ diagram gives a logical structure of the database graphically?
List few disadvantages of the file processing system.
What are the ACID properties?
Explain on Evolution of DBMS.
How is a top to bottom relationship among the items in a database established?
List the components of storage manager.
What is the full form of DBMS?
Limitations of a file system can be resolved by ______.
What is not a DBMS?
The interface between the database and end users or application programs is referred to as ______.
What do you call the database catalogue where DBMS stores database schema along with various constraints?
State or snapshot of a database at any instance is known as ______.
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.
Entity Integrity
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'.
Give the shortcut that is used to select a row in Excel.
Why is database testing important?
