What are the different ways of moving data or databases
between servers and databases in SQL Server?
Answer Posted / monal
BCP (BULK COPY PROGRAM)
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are the operating modes in which database mirroring runs? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
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 the use of ocr?
what are the differences of where and if in SAS?
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
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.
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
when does an alert gets signaled?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
What are the different types of database compression introduced in sql server 2008? : sql server DBA
what functionality does oracle provide to secure sensitive information?
what is logical system in sap basis
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What is a correlated sub-query? : sql server DBA