The DESCRIBE DEPT statement displays the structure of the DEPT table.
The ROLLBACK statement frees the storage space occupies by the DEPT table.
The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.
The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.
You cannot roll back this statement.
All pending transactions are committed
All views based on the DEPT table are deleted
All data in the table is deleted, and the table structure is also deleted
All data in the table is deleted, but the structure of the table is retained.
. NUMBER and FLOAT can be a maximum of 38 bytes.
The DATE datatype stores date values with a timestamp
CHAR and VARCHAR2 default to 1 byte if no length is defined.
Both VARCHAR2 and CHAR can exceed 2,000 bytes.
VARCHAR2 can be a maximum size of 4,000 bytes; CHAR, 2,000 bytes
None of the above
No error will be returned.
Yes. The table name TEST is invalid.
Yes. All columns but the date column must have declared sizes.
Yes. The length of the VARCHAR2 variable must be defined.
Yes. The CHAR column must have a declared size.
INSERT INTO TEST VALUES(10000.234);
INSERT INTO TEST VALUES(1000.2345);
INSERT INTO TEST VALUES(10000.2345);
INSERT INTO TEST VALUES(100000.2345);
INSERT INTO TEST VALUES(100000.24);
DML commands execute an implicit rollback.
DML commands require an explicit COMMIT to be rolled back.
DDL commands can be undone.
DDL commands change data in tables.
None of the above.
INSERT INTO TEST(ID) VALUES(1);
INSERT INTO TEST VALUES(2, 'This is a string');
INSERT INTO TEST(ID, STR) VALUES(3, 'This is another string');
INSERT INTO TEST(STR) VALUES('This is another string still');
INSERT INTO TEST(ID) VALUES('This is yet another string');
TRUNCATE TABLE TEST;
DELETE FROM TEST WHERE ID = 1;
TRUNCATE TABLE TEST WHERE ID = 1;
REMOVE TABLE TEST;
DELETE FROM TEST;