Latest Answer : In addition to the above mentioned cases we can also include some more like:1. If sort component is used and the sort keys are same for the next sort component which follows after 2 or 3 components, then instead of using sort component again it is preferable ...
Latest Answer : Rollup summarises the group of data records based on key eg you want the income of a particular city from a set of records , you can use the rollup component.example dml is customer ,city name and amount (here the key ...
Latest Answer : while creating table you can implement tat by addingforeign key references p.tab_name(p.Col_name)heree p refers primary table andd this statement to be written beside col you want make as refrential integrity for the table..................... ...
Latest Answer : 1. It is used to increases the performance of the application. Because when
we create Store procedure, they are compiled and stored in database. Later when
applications call them, they are generally executed faster than the uncompiled
SQL statements ...
Latest Answer : The below SQL Query can solve the purpose:select username from V$SESSION; ...
Latest Answer : explain plan can be reviewed to check the execution plan of the query. This would guide if the expected indexes are used or not. ...
Latest Answer : By checking the execution plan of the query after doing each modification and determining the cost of the query. ...
Describe where you would use each of the following index types in relation to query type and/or data set: Hashed, Sorted, Bitmapped (Ranked), Clustered
In a process which reads 15,000 rows from one table and either updates or inserts them into another table and given the scenario where the process may abnormally terminate, describe how you track progress within the data to ensure the process could be restarted without repeating any processing.
In the scenario outlined in #18 and given that the output table(s) will be accessed by concurrent readers describe how your SQL code would be structured to minimize lock contention.
