Last updated on August 29th, 2020 at 09:55 amTransaction: A transaction is a collection of operations that performs a single
Month: April 2016
Briefly describe the two-tier and three-tier architecture. DBMS
Last updated on August 29th, 2020 at 09:55 amTwo-tier Architecture: In the two-tier architecture, the application is partitioned into a
Describe the components of the query processor. DBMS
Last updated on August 29th, 2020 at 09:56 amQuery Processor: As query is very much necessary to find out only
Describe the data structures implemented by the storage manager.
Last updated on August 29th, 2020 at 09:56 amData Structures Implemented by the Storage Manager: The storage manager implements several
What is storage manager? Describe the components of storage manager. DBMS
Last updated on August 29th, 2020 at 09:57 amStorage Manager: A storage manager is a program module which is responsible
In how many ways can database constraints be tested/evaluated? Describe briefly. DBMS
Last updated on August 29th, 2020 at 09:57 amDatabase Constraints: Database constraints are like conditions given to the manipulation of
Describe Data Definition Language (DDL). DBMS
Last updated on August 29th, 2020 at 09:57 amData Definition Language (DDL): The specific language used to express the database
What are database languages? Describe DML (DBMS)
Last updated on August 29th, 2020 at 09:58 amDatabase Language: As whatever we want to be manipulated by computer has
What is data model? Describe various data models. DBMS
Last updated on August 29th, 2020 at 09:58 amData Model: Data model is the structure of the database, which is
What are instances and schema? DBMS
Last updated on August 29th, 2020 at 09:58 amInstances: A database is generally used by many users where insertion and