Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
No Answer is Posted For this Question
Be the First to Post Answer
What are the advantages of stored procedure in sql server?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output
What are the different types of locks in the database?
What are the steps need to be take improve the speed of a SQLDATA Server?
What are the disadvantages of using querystrings to send data from one page to another?
How do I create a stored procedure in sql server?
What are the types of database recovery models?
What are the events recorded in a transaction log?
What do you know about system database? : SQL Server Architecture
Can we rollback records deleted by a truncate statement?
3 Answers CarrizalSoft Technologies, United Healthcare,
Why do you need a sql server?
Oracle (3259)
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)