Set - 10

Question 71 :

Can you create index on view ?

Answer :

No


Question 72 :

What is the difference between a view and a synonym ?

Answer :

Synonym is just a second name of table used for multiple link of database. View can be created with many tables, and with virtual columns and with conditions. But synonym can be on view.


Question 73 :

What is the difference between alias and synonym ?

Answer :

Alias is temporary and used with one query. Synonym is permanent and not used as alias.


Question 74 :

What is the effect of synonym and table name used in same Select statement ?

Answer :

Valid


Question 75 :

What's the length of SQL integer ?

Answer :

32 bit length