As a part of your job, what are the DBCC commands that you commonly use for database maintenance?
IBM,
1 3233What are the different ways of moving data or databases between servers and databases in SQL Server?
3 7013Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
1 4495What is database replicaion? What are the different types of replication you can set up in SQL Server?
1 3780Explain the difference between a hot backup and a cold backup and the benefits associated with each?
TCS,
7 19164You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?
3 10130Post New DB Administration Questions
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
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
What are the steps you will take to improve performance of a poor performing query?
what is grd?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
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 authentication modes in sql server and how can you change authentication mode? : sql server DBA
what are the differences of where and if in SAS?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What is replication? : sql server DBA
What happens on checkpoint? : sql server DBA
how can you connect from 10g user to 11g user??
Query processing is slow(eg select query)how will u solve that