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

  • delete
  • drop
  • remove
  • none of these
Answer: drop
733 students attemted this question.

Explanation

No Explanation Available.

Share this question with friends

Similar Questions

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

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

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

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

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

  6. Which command is used to remove all rows from a table ?

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

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

  9. This is an authorization command of SQL

  10. All DBMS systems use SQL as a command language.

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

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

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

  14. The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.

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

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

  17. If every non-key attribute is functionally dependent on the primary key, then the relation will be in :

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

  19. 12) What is the relation calculus?

  20. The statement in SQL which allows to change the definition of a table is

Comments

Add Your Review

Your email address will not be published.

Subscribe to Newsletter!

Subscribe to get latest updates and information.