DDL-Constarints

Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

• Data Definition Language(DDL)

• Data Manipulation Language(DML)

• DML and DDL

• None of the Mentioned

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

• ALTER TABLE

• MODIFY TABLE

• CHANGE TABLE

• All of the Mentioned

In SQL, which of the following is not a data definition language commands?

• RENAME

• REVOKE

• GRANT

• UPDATE

___________ defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity.

• Column

• Constraint

• Index

• Trigger

Which command defines its columns, integrity constraint in create table:

• Create command

• Drop table command

• Alter table command

• All of the Mentioned