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!
What are the types of reference?explain it with suitable examples?
Object oriented language given the ability to refer the object attribute of the type can be referred to the specified type. We can describe the type dept with a field name and a field head which is reference to the type person and a table dept of the type dept as followed
Create type dept(
Name varchar(20),
Head ref(person)scope people
)
Create table dept of dept
The table definition must state that the reverence is derived and must still state a self referential attribute name. When interesting a tuple for dept we can then use
Insert into dept
Values('CS','john')
What is the use of rename operation? Rename operation is used to rename both relations and an attributes. It uses the as clause, taking the form: Old-name as new-name.
what characterizes the levels in RAID technology
Differance between Unordered and ordered file ? Unordered file do no has any sequence although ordered file has arranged in a few sequence and data are assigned in ordered form
Explain Candidate key? Candidate Key - A candidate key is a minimal superkey, that can be used to uniquely identify a tuple in the relation.
Distributed And Client Server Databases Introduction This unit tells the distributed database systems which are primarily relational and one important execution model: the
Explain pipelining. Ans: In order to describe pipelining in simple terms, think of it as breaking down processor functions into smaller and smaller parts. For instance,
Atomicity : Either all functions are laid out or none are. Users could not have to think about the effect of incomplete operations. DBMS ensures this by undoing the functions
Which model is record based logical model? Network Modelis basically known as record based logical model.
Using SQL create a view RS for the relations R and S. The view consists of the columns A and D renamed as X and Y in that order. Insert a tuple into it. Show the contents of t
What are the benefits of document scanning? Document scanning, in addition to being cost-efficient, also enhances productivity. This service enhances security as you set the pa
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