What is difference between delete & truncate commands?
No Answer is Posted For this Question
Be the First to Post Answer
how many no of arguments can be passed in procedures and functions
What is transaction server explicit transaction?
WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN SQL SERVER?
What is create command?
What is referential integrity and how is it achieved?
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
How we can refresh the view?
Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?
How do you know which index a table is using?
Why do we use sql limitations? Which constraints can we use while making a database in sql?
Explain the truncate command?
What is the difference between a fill factor of 100 and 0?
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)