 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 : While cloning a database we also copy the oracle home to the target node whereas in case of refresh we don't need to copy the Oracle home. ... Read Answers (3) | 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 : Sql>alter database begin backup;The above query is used to freeze the header of all datafiles belongs to tablespace in that particular database.Freeze means lock i.e during backup no data's will be get in the datafiles.To release the headers from ... Read Answers (4) | 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
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
