# CTE Resource Center - Verso - Database Design and Management (Oracle) Task 1685818586

CTE Resource Center - Verso

Virginia’s CTE Resource Center

Write SQL code to manipulate column definitions, using DROP, RENAME, and TRUNCATE commands.

Definition

Writing code should include using the following DDL commands:

  • DROP—deletes the entire table including the structure and data
  • TRUNCATE—deletes the data content entered into the table, but leaves the structure of the table intact
  • RENAME—changes the name of a table, view, sequence, or synonym

Related Standards of Learning

Mathematics

COM.1

The student will design and apply computer programs to solve practical problems in mathematics arising from business and applications in mathematics.

COM.3

The student will write program specifications that define the constraints of a given problem.

Other Related Standards

NBEA Achievement Standards for Information Technology

Enter data and edit fields and records.