Question

which of the following commands must be supported in the same way by the commercial database management system to comply with ansi standards? a.) drop table b.) alter table c.) update d.) drop index

Answer 1

To comply with ANSI standards, a commercial database management system must support the 'Drop Table,' 'Alter Table,' and 'Update' commands in the same way. Therefore, the correct options are a.) Drop Table, b.) Alter Table, and c.) Update.

Step-by-step explanation:

In order to comply with ANSI standards, a commercial database management system must support the following commands in the same way:

1. Drop Table: This command is used to permanently remove a table and its data from the database.
2. Alter Table: This command is used to modify the structure of a table, such as adding or deleting columns.
3. Update: This command is used to modify existing data in a table.

Therefore, the correct options are a.) Drop Table, b.) Alter Table, and c.) Update.