Log shipping enables high availability of database. It the process of shipping the transaction log to another server. It copies the replica of the database. Both the databases are in synch. In case of failure of primary server or database, the secondary server can be used. In this process, another server called as monitor that tracks the history and status of backup and restore operations.
Explain triggers?
Describe triggers features and limitations?
Explain Syntax for viewing, dropping and disabling triggers?
Determine how to use the inserted and deleted pseudo tables?
How to apply cascading referential integrity in place of triggers?
Explain trigger classes i.e. instead of and after trigger?
What are the instances when triggers are appropriate?
What is Stored Procedures?
What is extended Stored Procedures?
What are the purposes and advantages stored procedure?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
