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!
Synonyms It allows short names or alternative names for objects.
Example:
CREATE SYNONYM D30
FOR EMPD30;
Now if we give command:
SELECT * FROM D30;
NAME
MINSAL
MAXSAL
AVGSAL
---------------------
------------
-------------
--------------
ACCOUNTING
1300
5000
2916.6667
RESEARCH
800
3000
2175
SALES
950
2850
1566.6667
To eliminate duplicate rows (distinct operator) Example: SELECT DISTINCT DEPTNO FROM EMP;
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
What is theta join explain? Theta Join - The theta join operation is an extension to the natural-join operation which permits us to merge selection and a Cartesian
Higher Normal Forms Is there more normal forms beyond BCNF? Yes, though, these normal forms are not based on the concept of functional dependence. More normalisation is needed if
Name the three major set of files on disk that compose a database in Oracle. There are three main sets of files on disk that compose a database. All the files are binary. These
What is Outer join? They can be employed while we want to keep all the tuples in R, or all those in S or all those in both relations in the result of the JOIN in spite of of w
What do you mean through integrity constraints? Integrity Constraints -An integrity constraint is a condition specified on a database schema and restricts the data in which
Implementation of association as an object Implement as a separate association object, independent of either class, as in Figure. An association object is a group of pairs
Explain the term- Query. Queries are used to repossess and show specific records in a table. They can also be used to show specific fields of specific records, which meet the co
When is UPDATE_STATISTICS command used? - When processing of large data is done, this command is used. - Whenever large number of modification, deletions or copy takes place
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