A VIEWS takes memory in the database.
If yes, how can u proove it?
is there any way to display the size of views?



A VIEWS takes memory in the database. If yes, how can u proove it? is there any way to display the..

Answer / kriish

Views do no take memory in database they are just window through data is shown to user from table

Is This Answer Correct ?    17 Yes 2 No

Post New Answer

More Oracle General Interview Questions

What is tns service name?

0 Answers  


What are the types of partitions in oracle?

0 Answers  


Difference between pre-select and pre-query

0 Answers  


What is a proxy object?

0 Answers  


What is forall Statement ?

2 Answers   Thermotech,






what is the difference between functional dependecy and multilevel dependency?

0 Answers   Oracle,


Explain an extent?

0 Answers  


The join defined by the default data link is an outer join yes or no ?

1 Answers   Oracle,


can you write commit in triggers?

4 Answers  


What are the factors that affect OPTIMIZER in choosing an Optimization approach ?

2 Answers  


Is it possible to disable the parameter from while running the report ?

1 Answers   Honeywell, Oracle,


In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?

4 Answers   Cap Gemini,


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)