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

Are stored procedures faster than dynamic sql?

0 Answers  

Types of optimization?

6 Answers   Microsoft,

What is clustered index sql?

0 Answers  

Is pl sql and postgresql same?

0 Answers  

How do you create a db file?

0 Answers  




how to achieve this problem?i am having table with two colums like empno,gender. in gender column, i am having records male,female like that .my final output will be male female 5 6

4 Answers   Hexaware,

what is global temporary tables and how use that tables in pl/sql packages

1 Answers   Cap Gemini,

Does normalization improve performance?

0 Answers  

How many types of sql are there?

0 Answers  

What is execute immediate?

0 Answers  

What is pessimistic concurrency control? : Transact sql

0 Answers  

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories