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

what is the difference between granting and creating a view?

Question Posted / swapna

Answers were Sorted based on User's Feedback



what is the difference between granting and creating a view?..

Answer / prasuna

Granting view means giving access to the view that is
already created where as creating a view means creating a
new view
granting privileges to a view is a dcl command
where as creating a view is a ddl command

Is This Answer Correct ?    4 Yes 0 No

what is the difference between granting and creating a view?..

Answer / swapna

Granting depends upon the user, he may give permission for
others to manipulation on the table. But in case of views
others can only retrive the table.
granting is dcl command
creating is ddl command

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More SQL PLSQL Interview Questions

What is exception? What are the types of exceptions?

0 Answers  

How to write pl sql program in mysql command prompt?

0 Answers  

how can we optimize or increase the speed of a mysql select query? : Sql dba

0 Answers  

Name the different types of indexes in sql and define them.

0 Answers  

what is a trigger? : Sql dba

0 Answers  

How to start oracle sql developer?

0 Answers  

How many indexes can be created on a table in sql?

0 Answers  

What are Anti joins

1 Answers   IBM,

Why you are not able to create a table using select command,if it is having a LONG column? for eg:create table test as select * from test1 here test1 containg a column having LONG datatype...

1 Answers  

What are the return values of functions SQLCODE and SQLERRM ?

2 Answers   PreVator,

How to install oracle sql developer?

0 Answers  

what is the command for user data type?

2 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories