Get fully
solved assignment. Buy online from website
online store
or
plz drop a mail
with your sub code
we will revert
you within 2-3 hour or immediate
Charges rs 125/subject
if urgent then call us on 08791490301, 08273413412
PROGRAM
MCA(REVISED
FALL 2012)
SEMESTER
V
SUBJECT
CODE & NAME
MCA5033-OPEN
SOURCE DB SYSTEMS
1 Explain
ACID properties in transaction management.
Answer: ACID properties are an important
concept for databases. The acronym stands for Atomicity, Consistency,
Isolation, and Durability.
The ACID properties of a DBMS allow safe sharing of data.
Without these ACID properties, everyday occurrences such
2 What are the different
strategies of OSS licensing? Explain briefly.
Answer: OSS licensing strategies which are
given below:
Ø Expansion
strategy: It is an open
source demonstration of the “law of conservation of modularity”
3 Explain the SELECT and PROJECT
operations.
Answer: Relational Algebra Operators are
mathematical functions used to retrieve queries by describing a sequence
operations on tables or even databases(schema) involved.[1] With relational
algebra operators, a
4 Explain MySQL
Administration
First check if your MySQL server is running or not. You can
use the following command to check this:
ps -ef | grep mysqld
If your
5 Write short notes on:
a) Ingres
b) Postgres
c) Postgres95
d) PostgreSQL7
e) PostgreSQL8
Answer: Ingres
Ingres, a research project to create a relational database,
was a project in the early 1970s at the University of California, Berkeley. This
was the starting of the research and later many other databases
6 Describe Availability
with respect to InnoDB.
Answer: You have decided to change one or more
tables from MyISAM to InnoDB. That should be as simple as ALTER TABLE foo
ENGINE=InnoDB. But you have heard that there might be some subtle
Get fully
solved assignment. Buy online from website
online store
or
plz drop a mail
with your sub code
we will revert
you within 2-3 hour or immediate
Charges rs 125/subject
if urgent then call us on 08791490301, 08273413412
No comments:
Post a Comment