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 |
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
what do you understand by flashback feature of oracle?
Explain how you would restore a database using RMAN to Point in Time?
What are the operating modes in which database mirroring runs? : sql server DBA
How would you go about generating an EXPLAIN plan?
how can you find out if a table can be redefined?
How would you determine the time zone under which a database was operating?
i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???
Q. How to set ORACLE_HOME to my oracle software directory. Hi Friend I am installing oracle 10g Express Edition on Linux Fedora Core 6. Installation is success but when i run #sqlplus I getting command not found error. Then I have search sqlplus .i.e # find / -name sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/sqlplus These above output from find i have doubt which is correct path of sqlplus. So doubtfully i have set path 1st one.i.e # PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin Then I have run #sqlplus but still i have problem following Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory How overcome this please answer m???
how can a session indicate its interest in receiving alerts?
how can you get actual data change values from previous transactions in oracle?
what is a user-defined lock?
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)