 Related Questions Latest Answer : Yes a view can be based on another view. For example data dictionary views can be used to create another view in order to improve better access. ... The primary functional difference between logical and physical standby database setups is that logical standby permits you to add additional objects (tables, indexes, etc) to the database, while physical Latest Answer : A physical or logical standby database is a database replica created from a backup of a primary database. A physical standby database is physically identical to the primary database on a block-for-block basis. It's maintained in managed ... This is extract from Oracle10g Advanced Replication Book. How Materialized Views Work with Object Types and CollectionsOracle object types are user-defined datatypes that make it possible to model complex Thhere are 3 different ways :-1) SELECT name, value FROM v$parameter WHERE name = 'spfile'; //This query will return NULL if you are using PFILE2) SHOW PARAMETER spfile // This query will returns Latest Answer : select * from v$parameter where name='spfile'; ... Virtual Indexes are another undocumented feature used by Oracle. Virtual indexes, as the name suggests are pseudo-indexes that will not behave the same way that normal indexes behave, and are meant for View Question | Asked by : David What is the difference between Cost Based Optimizer and Rule Based Optimizer?(CBO is the default optimizer) Latest Answer : In brief the rule-based method means that when executing a query the database must follow certain predefined rules and matter what data is stored in affected database tables. The cost-based method means the database must decide which query execution plan ... I have applied the following commands:Shutdown abortstartupNow what will happen, will the database will give an error / it will work. Latest Answer : Yes, Given no other factors, the database will start up without issue. You killed all sessions, killed all transactions, and didn't write from the buffers. Note that instance recovery will take place during startup. ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0 
1