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 |
. 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 see how much space is used and free in a tablespace
What is the difference between online backup & offline backup?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
Give two examples of how you might determine the structure of the table DEPT.
by issuing "alter tablespace begin backup;" what happens to tablespace?
what is ora 600?
What type of index should you use on a fact table?
Where do you find the default index fill factor and how to change it? : sql server DBA
What is the recommended interval at which to run statspack snapshots, and why?
How can you control the amount of free space in your index pages? : sql server DBA
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)