Choose the correct options. __________ command is used to delete the records and _________ command is used to delete the db objects?Select one:Drop ,TruncateTruncate , DeleteTruncate , DropDelete , Truncate
Question
Choose the correct options. __________ command is used to delete the records and _________ command is used to delete the db objects?Select one:Drop ,TruncateTruncate , DeleteTruncate , DropDelete , Truncate
Solution
The correct option is: Drop , Truncate
Similar Questions
Which SQL statement is used to delete all records from a table?OptionsDELETE ALLREMOVEDROPTRUNCATE
Which SQL command is used to delete data from a table?Select one:a. DELETEb. ERASEc. TRUNCATEd. REMOVE
Select the correct answerWhich of the following commands is used to delete all rows and free up space from a table?OptionsDELETEDROPTRUNCATEALTER
In SQL, which command is used to remove a table's data but keep the structure?OptionsDELETEDROPREMOVETRUNCATE
Which of the following statements correctly describe the DELETE operation?1) DROP database [database_name], delete a specific database2) DELETE from [table_name], delete all record from a specific table3) DELETE from [table_name] where [condition], delete a record that meets the condition from a specific table4) DROP table [table_name], delete a specific tableQuestion 9Select one:a.4,3,1b.1,2,3,4c.2,3,4d.1,2,3
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.