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!
When are two schedules said to be view equivalent?
Ans: Two schedules that is denoted as S and S' are said to be view equivalent if the subsequent three conditions are met
1) For every data item Q, if a transaction Ti reads the initial value of Q in schedule S, after that transaction Ti should in schedule S' also read the initial value of Q.
2) For every data item Q, if a transaction Ti executes read(Q) in schedule S and that value was generated by Tj (if any) , then transaction Ti must in schedule S' as well read the value of Q generated by Tj.
3) For every data item Q, if a transaction if any that carries out the final write(Q) in schedule S should perform the final write(Q) in schedule S'.
Explain Object oriented Model ? Object Oriented Model - This model is based on the object-oriented programming language paradigm. It involves the features of OOP such as inhe
List the requirements needed to design a trigger. The requirements are:- Specifying when a trigger is to be implemented. State the actions to be taken when the trigger im
What is known as heap file organization? In the heap file organization, any record can be placed anywhere in the file where there is space for the record. There is no ordering
What are the reasons for having variable length records? What are the various ways to store variable length records? Variable-length records arise in a database in various wa
List the drawbacks of relational database system A) Repetition of data B) Inability to s certain information.
What is average response time? The average response time is that the average time for a transaction to be done after it has been submitted.
Order by clause By using this rows can be sorted It is used in the last portion of select statement By default it gets ascending order DESC: is used
how many hourse have been spent on a certain project
Equi Join: A join in which the joining condition is based on equality among values in the common columns. Common columns show (redundantly) in the result table. Let us Consider th
The entity type STUDENT has the following attributes: Student Name, Address, Phone, Age, Activity, and No of Years. Activity represents some campus-based student activity, and No o
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