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!
For the relations answer the following queries in SQLStreet (name, location, city) House (number, street_name) Lives (name, house_number)(i) Obtain the names of persons who live in the street named ‘Mahatma Gandhi'.(ii) Obtain the house numbers street wise.(iii) Obtain the numbers of houses which are not occupied.
(i) Select lives.name from Street, House, Lives where Street.name = House.street_name and House. Number = Lives. House_number and street_name =‘Mahatma Gandhi'; (ii) Select number from House order by street_name; (iii) Select number from houseminusSelect house_number from lives;
Differentiate between horizontal & mixed horizontal fragmentation?
Dirty Reads: T10 reads a value which is updated by T9. This update has not been committed and T9 aborts. T9 T10 Value of x old value = 200
Define Two phase commit Two phase commit: To make sure atomicity, all the sites where a transaction is being executed must agree on the final outcome of the execution. The tran
What is NULL? Give an example to described testing for NULL in SQL? The NULL SQL keyword is used to represent either a missing value or a value which is not applicable in a re
What is nested relational model? The nested relational model is an extension of relational model in which domains might be either atomic or relation valued.
The Maximum no of key fields that can be used in a header is?? 50
Submit SQL INSERT Statements that will populate the database with sample data. You must insert at least 5 records into each table in your database.Submit your SQL INSERT Statement
Discuss deferred update technique of recovery. What are the advantages? Ans: The deferred update methods do not physically update the database on disk till after a transact
What are the different approaches for database design? There are two basic approaches for database design which are as follows: Attribute driven: It compiles a list of att
What is assertion? Mention the forms available. An assertion is a predicate expressing a condition that we wish the database always to satisfy. Domain integrity constraints.
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: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd