What is database replicaion? What are the different types
of replication you can set up in SQL Server?
Answer / kishor
move/copy of the data from one server to another server is
call replication
types of replication
1.snapshot
2.merge
3.transactional
4.transactional with up-datable subscription(newly added in
sql server2005)
Is This Answer Correct ? | 2 Yes | 0 No |
by issuing "alter tablespace begin backup;" what happens to tablespace?
What is RAID and what are different types of RAID configurations?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
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.
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
Is it possible to update the multiple field values in a single query? If possible then write the actual query.
what is difference between user managed backup and rman backup?
how can you find out if a table can be redefined?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What is dbcc? : sql server DBA
now one user in online.now i want drop him..how do u drop him?