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 and rs
500/semester only.
if urgent then call us
on 08791490301, 08273413412
Mca5033
Winter
2015
1 Explain different
concurrency control problems
Answer: Concurrency
control problems
The Lost Update Problem
This problem occurs when two transactions that access the
same database items have their operations interleaved in a way that makes the
value of some database item incorrect. Suppose that transactions and are
submitted at approximately the same time, and suppose that their operations are
interleaved; then the final
2 What is Copyleft
licenses? Explain its various categories.
Answer: Copyleft
licenses: Copyleft license refers to the license that tries to assure that
the public keeps the rights to use, transform and/or reallocate a creative work
and all other works based on it, instead
3 Write short note on:
a) Relational database
b) Domain
c) Attributes
d) Tuples
e) Relations
Answer: A relational database allows the
definition of data structures, storage and retrieval operations and integrity
constraints. In such a database the data and relations between them are
organized in tables. A table is a collection of records and each record in a
table contains the same fields. In the table,
4 What is a Trigger?
Describe trigger creation in detail.
Answer: SQL trigger is a
set of SQL statements stored in the database catalog and is executed or fired
whenever an event (insert, update or delete) that is associated with a table
occurs. This is a special type of stored
5 Describe the advance
features of SQL.
Answer: Advance
features of SQL
VIEWS
View is a virtual table. It is a subset of the table. We can
create a view Emp_view as selecting frequently used columns from the employee
table. This will improve the speed of processing data. We can create a view
over the query. The general syntax to create a view is given below:
CREATE VIEW
6 Describe briefly about
the experimental evaluation. Write the significance of generic benchmarks.
Answer: The performance of a database system
can be evaluated with bench marks. Probably the most popular and widely
accepted is TPC-C (it is a benchmark tool by TPC (Transaction processing
Performance
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 and rs
500/semester only.
if urgent then call us
on 08791490301, 08273413412
No comments:
Post a Comment