COMPUTER APPLICATIONS
DATABASE MANAGEMENT SYSTEMS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Delete
|
|
|
Drop
|
|
|
Remove
|
|
|
All of the above
|
Detailed explanation-1: -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-2: -The DROP DATABASE command is used to delete an existing SQL database.
Detailed explanation-3: -DELETE command: The DELETE command is used to delete existing records in a table.
Detailed explanation-4: -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. In the Manage Relationships dialog box, click Close. 09-Dec-2022