|
| 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 : 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 what is Referential Backup? Which case we use Referential Backup and which case we use Incremental backup? Tags : Backup Imagine that you joined a company as DBA and your first task is to create test and production database environments for application developers and users. How would you analyze requirements for a new DBMS? View Question | Asked by : aiman Tags : DBMS Latest Answer : In oracle 9i we have some limitation with reqard to Backing up entire dataabase in one go. First we will have to take the database in mount stage (not open) in order to take the back up, and that too, one tablespace at a time. like:-sql>alter ... Read Answers (2) | Asked by : support dba 8910 Tags : Backup What is mean by fractured block in terms of manual hot backup? Latest Answer : The concept of fractured block occrus when backup is under process.It means you are taking backup and some other session is updating it.Then backup process can not get the consistent image of the block and it will be inconsistent right thats why it is ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
