When I delete any data from a table, does the sql server reduce the size of that table?
No Answer is Posted For this Question
Be the First to Post Answer
Explain the different types of joins?
what is index seek and index scan?
Explain about temporary stored procedure?
Diffrent types of function
If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?
What kind of problems occurs if we do not implement proper locking strategy?
What happens if null values are involved in string operations?
What is Deadlock?
Define Foreign Key?
3 Answers ADP, College School Exams Tests,
What are different types of table joins?
What is dbcc updateusage?
How to copy the tables, schema and views from one sql server to another?
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)