|
| 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 : in 10g there is a option to lock an acount we can lock system user through this correct me if i am wrong ... Read Answers (2) | Asked by : reddy What is the differences between DBMS & RDBMS? What is the differences between Oracle & MS Access? Read Answers (3) | Asked by : k.rajkumar 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 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 ... 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 : ofcourse Ascending ... 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 Can we read Control file? If yes, then how? Latest Answer : Yes, We can read control filefirst we have to transfer it to text file.sql> alter database backup controlfile to trace,we can view the controlfile from user_dump_test. ... 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 ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
