Scenario: A DBA is tasked with removing outdated records from a database table. Which SQL command should they utilize for this task?
- DELETE
- DROP
- TRUNCATE
- REMOVE
The correct option is 'DELETE'. This SQL command is used to remove one or more rows from a table based on the condition specified in the WHERE clause. It allows the DBA to selectively remove outdated records while retaining the structure of the table and other existing data.
Loading...
Related Quiz
- The VARIANCE() function in DB2 returns the ________ of the values in a column.
- The IMPORT utility in DB2 supports the ________ option, which allows for skipping header rows in the input file.
- Which component of a DB2 tag defines the name of the database object?
- Which data format is commonly used for representing hierarchical data structures in DB2?
- How are cardinality and ordinality represented in an ERD?