|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions Latest Answer : Lookup tables are like constraints which hold a value. The content in the lookup tables dosen't change often, hence refered as lookup (reference). Example : Countries table Countries are not added on regular bases hence one can consider the table ... Latest Answer : hi,create role in database with proper permission. then assign that role to the user. This is the simplest method to implement secuirty in database. ... Latest Answer : Log shipping transfers database dumps and logs from the primary server to the secondary server. As with any warm standby solution, failure detection and failover processing is not automated. When log shipping is employed, the standby database cannot be ... Read Answers (2) | Asked by : t.madhusudhanreddy Tags : Replication Latest Answer : A Transaction is a logical unit of work that comprised one or more sql statements. where as scn is system change number, When a transaction commits a scn will be generated. ... Read Answers (2) | Asked by : SUMIT Latest Answer : Generally a database refresh is done on the same server. A database refresh is just like defragmentation in windows so that the space can be utilized more efficiently and performance also improves since the data of a segment is brought into a single extent.Generally ... Read Answers (2) | Asked by : krishna How to recover the DB if we lost controlfile and we are not having backup also and the database is down...? Tags : Backup Latest Answer : hi,You can put the entire database in read only mode.startup mountalter database open read only; ... 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 Tags : Restore 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 ... Read Answers (1) | Asked by : Iran Latest Answer : In simple terminology, combination of S/w(Operating system et all) and hardware(Disk Drives) on which these S/W(OS) are loaded, are vital for smooth runing of system. Failure of any of these tools make a system to crash.now if any software(OS) ... Read Answers (4) | Asked by : Arthur
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
