What is the difference between delete and truncate command in dbms?
No Answer is Posted For this Question
Be the First to Post Answer
What is database normalization? Explain types of it.
what is datapump? Difference between exp and expdp?
2 Answers Capital IQ, TCS, WNS,
Explain what is an Exception ?
Does the Database trigger will fire when the table is TRUNCATED ?
What are the benefits of modeling?
What are indexes? Mention the differences between the clustered and non-clustered index?
Describe concurrency control.
Differentiate between ‘delete’, ‘truncate’ and ‘drop’ commands.
What is database partitioning?
What will be the maximum size of an extent of a segment if the tablepac's default storage values are specified as (initial 8K next 16k minextent 4 pctincrease 100).Explain.
Why do we need database normalization?
How many records can a database hold?
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)