Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Write short notes on transaction state?
A transaction may not always complete its implementation successfully such a transaction is termed aborted
A transaction must be in one of the following states
Active
Partially committed
Failed
Aborted
Committed
What are composite objects? Objects that have other objects are known as complex objects or composite objects.
Differance between DDL and SDL? DDL and SDL - The data definition language (DDL) is used through DBA and database designers to describe internal schema, conceptual schema, and
Describe the functions and features of foreign key? Foreign Key : The primary key of one file or table that is implanted in another file or table to implement the relationships
What is the difference among a primary index and a secondary index? Primary Index: A primary index is an ordered file whose records are of fixed length along with two fields.
What is storage manager? A storage manager is a program module that gives the interface between the Low level data kept in a database and the application programs
PART MARKING: For this section, we will use part marking. This means we will supply model answers to all questions but we will only mark six questions. We will choose these randoml
Which is a valid SQL type? A valid SQL Should be in CHARACTER it is should be NUMERIC and FLOAT.
Saving Derived Attributes to Avoid Re-computation As discussed, "redundancy means duplication of exact data". But, if multiple copies of same data are present in the system,
Construct a generalization-specialization hierarchy for a motor-vehicle sales company. The company sells motorcycles that comprise an engine number and cost; cars that have a chass
How is Oracle used in PL/SQL? Define the features of process and how they are defined? PL/SQL - PL/SQL is Oracle's procedural language (PL) superset of the Structured
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd