CLOUD COMPUTING
DATABASE MANAGEMENT
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Delete
|
|
|
Drop
|
|
|
Remove
|
|
|
All of the above
|
Detailed explanation-1: -Therefore the “drop” command is used to delete a relation form a database instead of using the “delete” command.
Detailed explanation-2: -The correct answer is Drop. DROP-It is a Data Definition Language(DDL) Command which is used to delete, tables, views, triggers, etc from a database. A DROP statement in SQL removes a component from a relational database management system (RDBMS).
Detailed explanation-3: -Use the D line command on the Select Relationships panel to delete the relationship.
Detailed explanation-4: -The DROP DATABASE command is used to delete an existing SQL database.
Detailed explanation-5: -In SQL Server Data Tools, click the Table menu, and then click Manage Relationships. In the Manage Relationships dialog box, select one or more relationships from the list. Click Delete Relationship. More items •09-Dec-2022