Latest Answer: Due to DML commands, HWM will increase, which means for a query till the HWM all the blocks will be read whether blocks contain data or not (due to delete), because of this performance will go down. ...
Latest Answer: dedicated server will have only one userprocess for each server process but where as in shared server server process can be shared among the different user processes ...
what is Referential Backup? Which case we use Referential Backup and which case we use Incremental backup?
Latest Answer: alter table add constraint primary key ()DEFERRABLE initially immediate enable novalidate ...
Can RAC structures have different operating system nodes in cluster. e.g one node linux and other node is Windows. if not then why?
Latest Answer: DSS is desicion support system. This is mainly useful for tking appropriate decisions based on existing data. All the data is already available in the DB. And we have to get reports according to the need. OLTP - OnLine Transaction Processing is ...
When normalizing a table that can have a many to many relationship with another table, what steps should you take?
looking for a detailed answer if possible
During a full database restore, you have a power outage and the restore fails after running for 6 hours out of an estimated 7 hours to complete. What would you do when power is restored to recover the database in the most effective way? Re-write this query so it will use the index on the Datecreated column. (1) SELECT * FROM order_header WHERE DateDiff(hh,Datecreated,getdate()) < 2 SELECT * FROM order_header WHERE DateDiff < 2 Your clustered SQL Server 2000 production database
Latest Answer: hi,You can put the entire database in read only mode.startup mountalter database open read only; ...
Latest Answer: To see fragmentation:select sum(bytes)/1024 from dba_data_files where tablespace_name='';output: 10select sum(bytes)/1024 from dba_segments where tablespace_name='';ouput :7Select sum(bytes)/1024 from dba_free_space where ...
View page << Previous 1 2 3 [4] 5 6 7 Next >>
Go Top
