As a part of your job, what are the DBCC commands that you commonly use for database maintenance?
IBM,
1 4271What are the different ways of moving data or databases between servers and databases in SQL Server?
3 8521Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
1 5430What is database replicaion? What are the different types of replication you can set up in SQL Server?
1 4803Explain the difference between a hot backup and a cold backup and the benefits associated with each?
TCS,
7 21606You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?
3 11591Post New DB Administration Questions
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What purpose does the model database server? : sql server DBA
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.
What the different topologies in which replication can be configured? : sql server DBA
Explain materialized views and how they are used.
What is the difference between the 2 operating modes of database mirroring? : 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 the importance of a recovery model? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
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 spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What is transparent data encryption? : sql server DBA
What is the difference between dropping a database and taking a database offline? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA