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 3551
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?1 5551
What is blocking and how would you troubleshoot it?1 5208
Explain CREATE DATABASE syntax?2 5953
How to start SQL Server in minimal configuration mode?1 6210
What are the different ways of moving data or databases between servers and databases in SQL Server?3 5947
Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?1 3907
What is database replicaion? What are the different types of replication you can set up in SQL Server?1 3028
How to determine the service pack currently installed on SQL Server?1 2847
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 9073
What the different types of replication and why are they used? : sql server DBA
what are the types of connection load-balancing?
How do you open a cluster administrator? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
which background process invoke at the time of upgradation tell me???
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
Where do you find the default index fill factor and how to change it? : sql server DBA
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
What are the different types of indexes available in sql server? : sql server DBA
what is logical system in sap basis
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.