Choose the correct options. __________ command is used to delete the records and _________ command is used to delete the db objects?Select one:Drop ,TruncateDelete , TruncateTruncate , DropTruncate , DeleteClear my choice
Question
Choose the correct options. __________ command is used to delete the records and _________ command is used to delete the db objects?Select one:Drop ,TruncateDelete , TruncateTruncate , DropTruncate , DeleteClear my choice
Solution
The correct option is: Drop , Truncate. The 'Drop' command is used to delete the records and the 'Truncate' command is used to delete the db objects.
Similar Questions
Which SQL command is used to delete data from a table?Select one:a. DELETEb. ERASEc. TRUNCATEd. REMOVE
Which SQL statement is used to delete all records from a table?OptionsDELETE ALLREMOVEDROPTRUNCATE
In SQL, which command is used to remove a table's data but keep the structure?OptionsDELETEDROPREMOVETRUNCATE
Which of the following commands is used to delete all rows and free up space from a table?TRUNCATEDROPDELETEALTER
Select the correct answerWhich of the following commands is used to delete all rows and free up space from a table?OptionsDELETEDROPTRUNCATEALTER
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.