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!
Illustrate different types of Locks in SQL Server.
There are three kinds of locks in SQL Server
i.) Shared locks - These are used for operations which don't allow any update or change of data. For example SELECT.
ii.) Update locks - These are used when SQL Server wants to modify a page. Update page lock is then promoted to an exclusive page lock before actually making changes.
iii.) Exclusive locks - they are used for data modification operations. For example UPDATE, INSERT, or DELETE.
what is data link layer
explain three types of internet risks to the consummers whent he business system is data dependent. how can we minimise these risks
Explain the concept of deadlock Yes. It can direct to deadlock. Suppose that a batch of frames arrived correctly and were accepted. Then receiver will advance its window. Now s
What is banker's algorithm? Banker's algorithm is a deadlock avoidance algorithm that is applicable to a resource-allocation system with multiple instances of each resource ty
Describe the types of attributes? Types of attributes: An attribute's category determines the type of values that are permitted in the attribute. For instance, the value vers
What is the use of unique function? UNIQUE function: If UNIQUE is specified then only unique values are used to computed the mean.
Define and differentiate between ordered indexing and hashing. Ans: Ordered indexing: To gain fast random access to records in a file, we can make of an index structure. Every
Describe integrity constraints? Integrity Constraints - A database is just as excellent as the information stored in it, and a DBMS must therefore help avoid the entry of inc
What are the comparison operator in SQL? Comparison operator in SQL are =, LIKE and BETWEEN
explain normalization,and give the examples 1NF,2NF,3NF,BCNF.AND FUNCTIONAL DEPANDENACY AND DECOMPOSITION TECHNIQUES.
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