Free Preparation Discussions
MENU
CompTIA Exam DS0-001 Topic 5 Question 25 Discussion
Topic #: 5
A database is configured to use undo management with temporary undo enabled. An UPDATE is run on the table.
Which of the following describes where the undo is stored?
The command that is part of DDL is CREATE. CREATE is a SQL command that belongs to the category of DDL, or Data Definition Language. DDL is a subset of SQL commands that are used to define or modify the structure or schema of a database, such as tables, columns, constraints, indexes, views, etc. CREATE is a DDL command that is used to create a new object in a database, such as a table, column, constraint, index, view, etc. For example, the following statement uses the CREATE command to create a new table called employee with four columns:
CREATE TABLE employee (
emp_id INT PRIMARY KEY,
emp_name VARCHAR(50) NOT NULL,
emp_dept VARCHAR(20),
emp_salary DECIMAL(10,2)
);
Copy
Shawnda
2 months agoTerrilyn
3 days agoKimberely
4 days agoXochitl
5 days agoDorthy
8 days agoJonelle
9 days agoJina
12 days agoKeneth
1 months agoMisty
2 months agoRosio
4 days agoAshlyn
10 days agoRonald
13 days agoWhitney
1 months agoSharmaine
2 months agoWilbert
2 months agoNelida
2 months agoLeota
1 months agoTerry
1 months agoLouvenia
1 months agoGwen
2 months agoEmmanuel
2 months agoWilbert
3 months ago