As a part of your job, what are the DBCC commands that you commonly use for database maintenance?
IBM,
1 4263What are the different ways of moving data or databases between servers and databases in SQL Server?
3 8509Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
1 5425What is database replicaion? What are the different types of replication you can set up in SQL Server?
1 4796Explain the difference between a hot backup and a cold backup and the benefits associated with each?
TCS,
7 21590You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?
3 11585Post New DB Administration Questions
how to restore files with rman?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
how can you record information about current session?
What are the different ways you can create databases in sql server? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
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
what do you understand by flashback feature of oracle?
What is a system database and what is a user database? : sql server DBA
what do you understand by fine-grained auditing?
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
How to start SQL Server in minimal configuration mode?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
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 do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?