 Related Questions Latest Answer : .dbc file basically helps abinitio coops to connect to database. It includes all the required database parameter and other default value respective to it. you can modify them.However .cfg is file is use set up some temporary environment for a particular ... Latest Answer : Hi,lookup_local funtion retrieves the first matching record from a partitioned multifile,which is partitioned on a particular key.consider a lookup file "emp_detail" which is having the fields emp_id,emp_name,dept and is partitioned on emp_id.use,lookup_local("emp_detail","456A"),then ... 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; ... Describe which database structural and physical elements you would review when optimizing query performance. Describe which system/process elements you would review when trouble-shooting general server slowness. Describe how you would ensure a T-SQL script ran on a particular database where there are multiple databases on a single server. What is the t-sql command element you would use to place a logical object (table or index) on a specific physical file (file group).
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
