What is Locking in Sybase? What are its types?
Latest Answer: Lock: controling access to page In sybase, locking is done at page level (whereas in Oracle, it is at row level).So, suppose if we have a lock (shared lock, write lock) on a page, than we can not access any rows in that page. ...
Explain What is Update Statistics?
Latest Answer: ASE uses two system tables for maintaining stats on tables for obtimized query and data retrival.systabstats is used on table level and is maintained dynamically while sysstatistics maintains information on columns and is not maintained.Update statistcis ...
Latest Answer: Procedure cache is the memory area where compiled query tree run e.g, procedure, batch query. Data Cache is the memory area where data that is required for the current querys running is bought from Disk on to memory for building result ...
Latest Answer: @@errorlog will display the path of log file ...
Latest Answer: Dump tran with truncate_only if it is not cleared the go for select lct_admin("abort", {process_id [, database_id]}) ...
How to find out the maximum sales of an item for each sales man.The table consists sales_man, item, sales columns, each sales man will have the different sales values for different items.here I have to find out for every sales man, which item he sold maximum
Latest Answer: Autosys is a product from Platinum, it is a job scheduling software. Most basic job scheduling is done using unix - Cron (or windows - AT), which is time based", it will fire the job based on the clock. However, in real business, you need to fire ...
View page [1] 2 3 4 5 6 Next >>
Go Top
