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

  • Delete
  • Remove
  • Truncate
  • Both [A] and [B]
Answer: Truncate
1375 students attemted this question.

Explanation

No Explanation Available.

Share this question with friends

Similar Questions

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

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

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

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

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

  6. Which one of the following command is used to delete the existing row in a table?

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

  8. In existing table, ALTER TABLE statement is used to

  9. Which is the correct query to delete the rows of employees whose exp is less than 10.

  10. Which of these rows absolutely CANNOT be the primary key?

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

  12. Intersection of rows and columns is called ..........

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

  14. How will a data analyst retrieve a list of all employees' first_name, last_name and hire_date from the employees table?

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

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

  17. This is an authorization command of SQL

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

  19. Correct syntax query syntax to drop a column from a table is

  20. How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?

Comments

Add Your Review

Your email address will not be published.

Subscribe to Newsletter!

Subscribe to get latest updates and information.