What are the different ways of moving data or databases
between servers and databases in SQL Server?
Answer Posted / santo
export/import...attach/detach...DTS....backup/restore!
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Where do you find the default index fill factor and how to change it? : 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
What is replication? : sql server DBA
Explain materialized views and how they are used.
How do you open a cluster administrator? : sql server DBA
What authentication modes does sql server support? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
what are the performance views in an oracle rac environment?
what is ora 24313?what is the procedure to exclude that error?
who owns the operating system files created by the utl_file package?
how can you record information about current session?
how can you generate profile of pl/sql applications to identify performance bottlenecks?