Define master database?
Answer / Tanu Tyagi
Master Database is a system database in Microsoft SQL Server that contains all system objects and data necessary for the management of other databases, such as login information, linked server definitions, and server configurations.
| Is This Answer Correct ? | 0 Yes | 0 No |
How to access the inserted record of an event?
How to insert and update data into a table with "insert" and "update" statements?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
What is a trigger?
Does sql server use t sql?
How to invoke a trigger on demand?
Do you know what is sql injection?
What is data compression? : sql server database administration
How will you go about resolving deadlocks?
What is optimistic concurrency?
What are views used for?
explain query execution plan
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)