A) It is usually slower than DELETE command
B) There is no comparison between DELETE & TRUNCATE
C) It is usually faster than DELETE command
D) None of these
The correct answer to the question “Which of the following is true for TRUNCATE in SQL” is option ©. It is usually faster than the DELETE command. And all the other options are incorrect for TRUNCATE in SQL. Wish to learn and master SQL? Enroll in Intellipaat’s SQL certification course, which offers you an industry-grade course to help you enhance your practical experience and skillsets. Also, look at the following YouTube video on SQL for Beginners and get started.
Certification in Digital Marketing |
Certification in Big Data Analytics |
Certification in Cloud & Devops |
Certification in Full Stack Web Development
Big Data and Data Science Master’s Course |
Data Science Architect Master’s Program |
Cloud and DevOps Architect Master’s Course |
Artificial Intelligence Engineer Master’s Course |
Microsoft Azure Certification Master’s Training
Data Science Course Online |
Big Data Hadoop Certification Training |
Machine Learning Course Online |
Artificial Intelligence Course and Training |
Salesforce Certification Training: Administrator and App Builder |
Tableau Training and Certification Course |
Python Data Science Course & Training |
Ethical Hacking Course |
Business Analyst Course |
Courses in Cyber Security
© COPYRIGHT 2011-2021 INTELLIPAAT.COM. ALL RIGHTS RESERVED.
Download Salary Trends Now !
Learn how professionals like you got up to 100% Salary Hike.