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 |
what is incremental checkpoint?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Is it possible to update the multiple field values in a single query? If possible then write the actual query.
what is logical system in sap basis
what are the types of connection load-balancing?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
Hot backup procedure?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
What questions might be they ask in managerial round in capgemini.
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
what is the use of ocr?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
Oracle (3253)
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)