As a part of your job, what are the DBCC commands that you commonly use for database maintenance?
What is RAID and what are different types of RAID configurations?1 2039
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?1 4109
What is blocking and how would you troubleshoot it?1 3668
Explain CREATE DATABASE syntax?2 4250
How to start SQL Server in minimal configuration mode?1 4117
What are the different ways of moving data or databases between servers and databases in SQL Server?3 3532
Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?1 2652
What is database replicaion? What are the different types of replication you can set up in SQL Server?1 1727
How to determine the service pack currently installed on SQL Server?1 1693
Explain the difference between a hot backup and a cold backup and the benefits associated with each?
You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?3 6385
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
Why does Oracle not permit the use of PCTUSED with indexes?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
How would you best determine why your MVIEW couldn't FAST REFRESH?
What are the steps you will take to improve performance of a poor performing query?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
what is the role of dip user in our database?
what is logical system in sap basis
Query processing is slow(eg select query)how will u solve that
how can you connect from 10g user to 11g user??
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :email@example.com
what are the differences of where and if in SAS?