MCA DCA8142 OPEN SOURCE DB SYSTEMS

Description

SESSION	MAY 2023
PROGRAM	Master of COMPUTER APPLICATIONS (MCA)
SEMESTER	3
course CODE & NAME	DCA8142- OPEN-SOURCE DB system
CREDITS	4

 

Set – I

1. What do you mean by Concurrency Control? Explain different concurrency control problems.

Ans: Concurrency control refers to the techniques and mechanisms used to manage and coordinate concurrent access to shared resources in a multi-user or multi-threaded environment. It ensures that multiple transactions or threads can execute concurrently without interfering with each other Its Half solved only

Buy Complete from our online store

 

https://smuassignment.in/online-store/

 

MUJ Fully solved assignment available for session March  2023.

 

Lowest price guarantee with quality.

Charges INR 200 only per assignment. For more information you can get via mail or Whats app also

Mail id is aapkieducation@gmail.com

 

Our website www.smuassignment.in

After mail, we will reply you instant or maximum

1 hour.

Otherwise you can also contact on our

whatsapp no 8791490301.

 

aWhat are the different strategies of OSS licensing?

Ans: Open-source software (OSS) licensing offers various strategies that govern the usage, modification, distribution, and sharing of open-source software. These strategies define the rights and obligations for both the software creators and users.

Here are some of the different strategies of OSS licensing: 

Permissive

 

3. Explain the features and data types of Postgre SQL.

Ans: PostgreSQL, often referred to as Postgres, is a powerful open-source relational database management system (RDBMS) known for its robustness, scalability, and extensibility.

Here’s an overview of its features and data types: 

Features of PostgreSQL:  ACID Compliance: PostgreSQL ensures ACID (Atomicity, Consistency, Isolation,

 

 

Set – II

1. Explain the PHP control structures.

Ans: PHP provides various control structures that allow developers to control the flow of execution in their programs. These control structures determine how blocks of code are executed based on conditions and loops.

Here’s an explanation of the main

 

 

2. Write a note on transactions and cursors.

Ans: Transactions:  In the context of databases, a transaction refers to a logical unit of work that consists of one or more database operations. These operations can include reading, writing, or modifying data.

Transactions ensure data consistency and integrity by following the ACID (Atomicity, Consistency, Isolation, and Durability) properties.

Here’s an

 

 

3. Explain about Data management in InnoDB.

Ans: InnoDB is a popular storage engine used in the MySQL and Maria DB relational database management systems. It provides advanced features for data management, storage, and transactional processing.

Here’s an overview of data management in InnoDB: 

Data Storage:  InnoDB uses a storage model based on clustered indexes, where data is physically stored in a