How do you Implement SSIS Packages in your Project?
64
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
93
Oracle client is not able to connect to Oracle server
although tnsnames.ora file has
valid enteries. Oracle error message is “ cannot resolve
net service name”.
Mention any three reasons.
274
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.
2
From the database level, how can you tell under which time
zone a database is operating?
21
What is log shipping? Can we do logshipping with SQL Server
7.0 - Logshipping is a new feature of SQL Server 2000. We
should have two SQL Server - Enterprise Editions. From
Enterprise Manager we can configure the logshipping. In
logshipping the transactional log file from one server is
automatically updated into the backup database on the other
server. If one server fails, the other server will have the
same db and we can use this as the DR (disaster recovery) plan.
255
if i write the procedure.. and other person make the
changes in that code then where i find who is changing my
procedure
91
You have modified 100 store procedures and want to
replicate these changes from development to prodution, and
production can have users using the Server/DB, how would
you replicate without causing issues?