WHAT OPERATOR PERFORMS PATTERN MATCHING?
Answers were Sorted based on User's Feedback
do views contain data ?
Difference between DELETE and TRUNCATE?
Find nth lowest salary or get nth lowest salary?
Where are magic tables stored ? Is it in the same database where it is created ?
What is the difference function and stored procedure?
What is live lock and deadlock? what is Lock escalation?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
What is mscorsvw.exe - process - microsoft .net framework ngen?
How will oyu test the stored procedure taking two parameters namely first name and last name returning full name?
What is the distinction amongst delete and truncate?
Where do we generally create INDEX?
1 Answers Ernst Young, Thomson Reuters,
How to tune a stored procedure?
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)