Knowee
Questions
Features
Study Tools

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

🧐 Not the exact question you are looking for?Go ask a question

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

1/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.