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 |
how can you connect from 10g user to 11g user??
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
When a user process fails, what background process cleans up after it?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
How do you add a data file to a tablespace?
Name a tablespace automatically created when you create a database.
Describe what redo logs are.
Compare and contrast TRUNCATE and DELETE for a table.
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.
how can you generate profile of pl/sql applications to identify performance bottlenecks?
what is meant by gateway