Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

is it mandatory to select all the column in a view then what
columns should be selected

Question Posted / arpitha2206

Answers were Sorted based on User's Feedback



is it mandatory to select all the column in a view then what columns should be selected..

Answer / guest

No, Its not mandatory.

Is This Answer Correct ?    3 Yes 0 No

is it mandatory to select all the column in a view then what columns should be selected..

Answer / sundeep

no.view is nothing but virtual table.a view is like a instance variable for a query.if the query length is long and it used for more than twice then we go for views. In these views we will select the columns which are to be used in a table.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

1. what is the exact use of hint in sql. 2. How we can avoid index scan in sql even though index is there in the table.

1 Answers   Polaris,

What is error ora-01000: maximum open cursors exceeded

0 Answers  

Which software is used for pl sql programming?

0 Answers  

What is normalization? dec 2009

3 Answers   Cognizant,

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

0 Answers  

How to fetch records from a partitioned table?

2 Answers   HSBC,

What is benefit of creating memory optimized table?

0 Answers  

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

0 Answers  

What is the life of an sql statement?

0 Answers  

select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator how many values accpect ?

2 Answers  

What is faster join or subquery?

0 Answers  

Can we join same table in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories