What types of replication are supported in sql server? : sql server DBA
how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.
what is the use of recording information about current session?
Datapump backup steps?
I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?
how can you get actual data change values from previous transactions in oracle?
What is the difference between clustered and non-clustered index? : sql server DBA
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.
Explain the difference between a data block, an extent and a segment.
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.
what is logical system in sap basis
why we use cursors