Which one of the following commands is used for removing (or deleting) a relation forms the SQL database? DBMS

  • Delete
  • Drop
  • Remove
  • All of the above
Answer: Drop
785 students attemted this question.

Explanation

No Explanation Available.

Share this question with friends

Similar Questions

  1. SQL Query to delete all rows in a table without deleting the table (structure, attributes, and indexes)

  2. To remove a relation from an SQL database, we use the ______ command.

  3. Which one of the following commands is used to restore the database to the last committed state?

  4. Which command is used for removing a table and all its data from the database:

  5. Which of the following commands is used to save any transaction permanently into the database?

  6. In the relation model, the relation are generally termed as ________

  7. A particular DBMS uses SQL for extracting data. The SQL command "WHERE" is usually followed by:

  8. Match SQL language with SQL commands1)DDL i)Revok, Grant2)DML ii)rename a table3)TCL iii)insert, update4)DCL iv)rollback , commit

  9. Which SQL statement would add a record to the database?

  10. In SQL, which command is used to SELECT only one copy of each set of duplicate rows

  11. Database admins are responsible for the design of the database and software.

  12. The database management system can be considered as the collection of ______ that enables us to create and maintain the database.

  13. In SQL, which command(s) is (are) used to change a table’s storage characteristics?

  14. In SQL, which command is used to add new rows to a table?

  15. Which one of the following refers to the total view of the database content?

  16. Which of the following is used in the application programs to request data from the database management system?

  17. Which of the following language is used to specify database Schema?

  18. Which of the following refers to the number of attributes in a relation?

  19. DELETE FROM r; where r is relation. This command performs which of the following action?

  20. ....................is a Application software which is used to manage database .

Comments

Add Your Review

Your email address will not be published.

Subscribe to Newsletter!

Subscribe to get latest updates and information.