 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 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 are the necessary steps to be take when server gets down? How can we increase size of a database? Latest Answer : 1.Bring up the server. 2.Run the profile of the database 3.Bring up the database. 4.In server prompt, check ps- ef | grep pmon - This is used to check whether the database is up or not. 5.Bring up the listener. 6.Check whether the tablespace ... How will you check the database status from os level in a unix env ?consider that some of the instances are in mount state; hence checking the pmon os process will be vain..? Need a unix os command to
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
