The main important aspect is physical data model is created after logical data model. For designing a logical data model one need not have through knowledge in any specific RDBMS like oracle, Informix and so on. This is because logical data model is created after having through study of the business entities which would be involved in the application. The same can be represented by using E-R diagram...

satyam_Ora

 Profile Answers by satyam_Ora Questions by satyam_Ora

• Jul 10th, 2007

Logical vs Physical Data ModelingLogical Data ModelPhysical Data ModelRepresents business information and defines business rulesRepresents the physical implementation of the model in a database.Entity...

Answer Question  Select Best Answer

Truncate command will delete all records and the most important thing to make note of truncate command is since truncate command cannot be rolled back one must make sure to take proper backup of table data before performing the truncate command. Truncate command is thus used to remove all rows from either a table or a cluster. If one wants to use the truncate command in a cluster they can use it only...

gvvskumaran

 Profile Answers by gvvskumaran Questions by gvvskumaran

• Jan 15th, 2007

* Used to Delete all the datas in a table .* Cannot be rollbacked.

Answer Question  Select Best Answer

The programmer may like the database o take some action when a database event occurs. In order to achieve the above purpose triggers are defined. The trigger body refers to the code written within the trigger which gets fired and executed when the related database event associated with the trigger occurs. On this situation one may have the question what is the event on the happening of which triggers...

gvvskumaran

 Profile Answers by gvvskumaran Questions by gvvskumaran

• Jan 15th, 2007

 trigger stored in the database can include SQL and PL/SQL or Java statements to run as a unit and can invoke stored procedures.Triggers are implicitly fired by Oracle when a triggering event occ...

Answer Question  Select Best Answer

matvin

• Apr 20th, 2007

Pre-query trigger fires before the query excutes and fires once while you try to query. With the help of this trigger you can modify the where clause part dynamically. Post-query fires after query exc...

Answer Question  Select Best Answer

SNirmala

 Profile Answers by SNirmala Questions by SNirmala

• Jun 10th, 2007

You can definitely load the data in to the warehouse for more than one time. And that is what a warehouse is for. To implement that, we should maintain a time dimension in the warehouse to differentiate the data loaded on various runs. To know more, jus send me a mail...

Answer Question  Select Best Answer

subasini sahu

• Nov 17th, 2006

Basic diff between data block and normal block is alwayes data block is based on one table and control block or normal block is without database table relationship.Diff bet call_form,new_form,open_for...

Answer Question  Select Best Answer

taraldesai

 Profile Answers by taraldesai Questions by taraldesai

• Jun 23rd, 2007

For difference refer oracle manual.You want to migrate or upgrade.1.ORACLE_HOME/rdbms/admin/utlu102i.sql2.Stop all cron3.PGA_AGGREGATE_TARGET initialization parameter is set to at least 24 MB.AQ_TM_PR...

Answer Question  Select Best Answer

geetha24

 Profile Answers by geetha24 Questions by geetha24

• Feb 13th, 2007

New Features of 10g1. Regular Expressions2. Flashback dropped table3. Can send mail using UTL_MAIL4. Datapump utility instead of export and import5. Comparision of nested table6. Sql Tuning advisor9....

Answer Question  Select Best Answer

srikanth

• Nov 14th, 2006

You can try merge statement option and give commit for a set range from 1000

Answer Question  Select Best Answer

Sudeep Biswas

• Nov 16th, 2006

In order to understand wht is a clustered index in oracle it is imp. to know what is a cluster. A cluster is a method to store data for more than 1 table in the same block.This can be compared to...

Answer Question  Select Best Answer

seema

• Feb 8th, 2007

Both commands are same but each is executed at different situations.When we directly want database should come in mount stage we give startup mount and when we want to do some modifications at nomount stage then first we nomount the database then give alter database mount command

Answer Question  Select Best Answer

satishorre

 Profile Answers by satishorre Questions by satishorre

• May 27th, 2008

Connect  your database as sysdbawe  assume  that this script available in $ORACLE_HOME/rdbms/adminRun the script   at the SQL prompt@$ORACLE_HOME/rdbms/admin/otrcsvr.sqlLet me know any comment if  any

Answer Question  Select Best Answer

prasads_delight1

 Profile Answers by prasads_delight1 Questions by prasads_delight1

• Sep 28th, 2007

 The way the data maintained in the collection of tables can be explained by the data structure. The structure of database will show on which conditions the database will be maintained with out inconsistancy.

Answer Question  Select Best Answer

Ashok Nayak

• Dec 19th, 2006

The problem arises because of the input date. You must not be having the timestamp in your input. So when you retrieve it into the date format "DD_MON_YYYY hh:mm:ss", what happens is that a typec...

Answer Question  Select Best Answer

taraldesai

 Profile Answers by taraldesai Questions by taraldesai

• Jun 23rd, 2007

1. cold backup2. hot backup3. import/export4. RMANRead oracle manual

Answer Question  Select Best Answer

romeopeay

 Profile Answers by romeopeay Questions by romeopeay

• Dec 31st, 2006

Row Cache is also known as the Dictionary Cache in the Shared Pool.

Answer Question  Select Best Answer

ranjeetapegu

 Profile Answers by ranjeetapegu Questions by ranjeetapegu

• Jan 11th, 2007

A temporary table is a table where data is stored temporarily during execution of a session and it is deleted as soon as session is over or commit is done. For example a create global temporary table ...

Answer Question  Select Best Answer

Praveen reddy.P

• Jan 31st, 2007

HiTo improve the performance of a Query, The following are the steps to be followed.1) First Check the Elapsced time of the Query2) Then see the optimization mode 3) Run the query in different optimiz...

Answer Question  Select Best Answer

ranjeetapegu

 Profile Answers by ranjeetapegu Questions by ranjeetapegu

• Jan 11th, 2007

The content canvas is the base canvas , it will always be there in the window. To hide the stack canvas you can use  HIDE_VIEW('name_stack_canvas'); SHOW_VIEW('name_content_canvas');--optional

Answer Question  Select Best Answer

suresh

• Mar 7th, 2007

you can create a a plan_table, by searching in the oracle folder of c drive in ur computer. look for the file utlxplan which usually resides in c:oracleora92rdbmsadmin. where u can get the script and ...

Answer Question  Select Best Answer