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
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE? HAVING CLAUSE - HAVING CLAUSE is used only with SELECT statement. - It is normally used in a GROUP BY
Determine the method of Choosing Algorithms In general, most of operations are easy and have a satisfactory algorithm since description of what is to be done also shows how i
SET concept is used in which type of modelling? SET concept is used in Network Model.
Deletion Anomalies: Loss of important Information: In some cases, useful information may be lost when a tuple is deleted. For instance, if we delete the tuple corresponding to stu
What benefits can a company gain by managing its own information infrastructure and servicea
Natural Join : It is the similar like Equi join except one of the duplicate columns is removed in the result table. The natural join is the most usually used form of join operation
What is a candidate key? Minimal super keys are known as candidate keys.
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
Hi, Do you offer private tuition for DBMS?
The result of the UNION operation between R1 and R2 is a relation that includes? The result of the operation between R1 and R2 includes all the tuples of R1 and R2 which have c
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