Synonyms, Database Management System

Assignment Help:

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

 


Related Discussions:- Synonyms

Explain the shadow paging recovery technique, Explain the shadow paging rec...

Explain the shadow paging recovery technique.  Ans: Shadow paging is a method used to acquire atomic and durable transactions, and provides the capability to manipulate pages i

Define single value and multivalued attribute, Define Single Value and Mult...

Define Single Value and Multivalued attribute Single value attribute comprise a single atomic value for an entity and multivalued attribute may have much more than one value f

Transactions t1 and t2 are in a deadlock, Evaluate: a.When transactions...

Evaluate: a.When transactions T1 and T2 are in a deadlock, one of the transactions will eventually implement to completion and let the other one continue implementation. b.

Normalise data to third normal form, A software contract and consultancy fi...

A software contract and consultancy firm maintains details of all the various projects in which its employees are currently involved. These details comprise: Employee Numbe

Purchase orber , Run the following queries. For each query show 1) What yo...

Run the following queries. For each query show 1) What you expect the output to be based upon the data 2) the SQL code and 3) the output running the query in Oracle. 1. Show all c

HRM, is Chipo carrying his baby

is Chipo carrying his baby

Define 3nf normal form, 3NF Normal Form A relation schema R is in 3NF ...

3NF Normal Form A relation schema R is in 3NF if it is in 2NF and for each FD X A either of the following is true X is a Super-key of R. A is a prime attribute of R

Locking, define locking in simple language and decribed it

define locking in simple language and decribed it

Hashing.., various techniques of hashing?

various techniques of hashing?

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

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!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd