What is db stored procedure?
No Answer is Posted For this Question
Be the First to Post Answer
What is clustered primary key?
What is difference between views and tables?
What is data integrity? Explain constraints?
If there is failure during updation of certain rows, what will be the state?
Are null values the same as that of zero or a blank space?
How to use the inserted and deleted pseudo tables?
What kind of problems occurs if we do not implement proper locking strategy?
How we can refresh the view?
What is data compression? : sql server database administration
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.
When would you use a before or after trigger?
Can a table be moved to different filegroup?
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)