As a part of your job, what are the DBCC commands that you commonly use for database maintenance?
IBM,
1 4374What are the different ways of moving data or databases between servers and databases in SQL Server?
3 8668Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
1 5528What is database replicaion? What are the different types of replication you can set up in SQL Server?
1 4893Explain the difference between a hot backup and a cold backup and the benefits associated with each?
TCS,
7 21881You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?
3 11739Post New DB Administration Questions
What is transparent data encryption? : sql server DBA
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
Which autogrowth database setting is good? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
What is replication? : sql server DBA
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
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.
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
how can you enable flashback feature?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
What is the default fill factor value? : sql server DBA
How do you troubleshoot errors in a sql server agent job? : sql server DBA
how does an oracle clusterware manage crs resources?