What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Oracle DBA (Database Administration) Interview Questions

Tell me about standby database? What are some of the configurations of it?

0 Answers  


Are database administrators in demand?

0 Answers  


What happens when the default and temp tablespace clauses are left out from create user statements?

0 Answers  


What are the five main functions of a database administrator?

0 Answers  


How should a many-to-many relationship be handled?

0 Answers  






What is the difference between truncate and delete? Why is one faster?

0 Answers  


Users are not being allowed on the system. The following message is received: ora-00257 archiver is stuck. Connect internal only, until freed. What is the problem?

0 Answers  


How can you find your id on a system?

0 Answers  


What are the goals of dba?

0 Answers  


What command is used to type files to the screen?

0 Answers  


Is oracle dba in demand?

0 Answers  


Which database is best to learn?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)