Synonyms, Database Management System

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

 

Posted Date: 3/11/2013 2:33:00 AM | Location : United States







Related Discussions:- Synonyms, Assignment Help, Ask Question on Synonyms, Get Answer, Expert's Help, Synonyms Discussions

Write discussion on Synonyms
Your posts are moderated
Related Questions
What are data models? Explain it detail? Entity relationship model Rectangles Ellipse Diamonds Lines Relational model Relational model use a collection

Super keys of a relation can have extra attributes. Candidate keys are minimal super key, i.e. such a key have no extraneous attribute. An attribute is known as extraneous if even


Difference between LEFT OUTER JOIN and RIGHT OUTER JOIN In left outer join tuples from the left-hand-side relation which do not match any tuple in the right-hand-side relation

A collection of a same kind of entities is known as an Entity Set or entity type. Example: For the COLLEGE database defines earlier objects of concern are Students, Faculty,

What is candidate key? Candidate Key - A candidate key of an entity set is a minimal superkey, which uniquely identifies each row in the relation.

Probelm: (a) A distributed database (DDB) is a collection of multiple, logically interrelated databases which are physically distributed over a computer network" (i) Give a

Compare wait-die deadlock prevention scheme with wait-wound scheme   Ans:  Wait-Die Scheme  a) Based upon a nonpreemptive technique.  b) If Pi requests a resource present


What is a view in SQL? When can views be updated? A view is a virtual table which consists of columns from one or more tables. Through it is same to a table; it is stored in