Multiple choice technology databases

Please see the below query: create table employee (emp_id number(6) primary key, emp_name varchar2(20)); rollback; What will the result of the below query: desc employee;

  1. It will describe the table.

  2. It will return ar error:'Table or view does not exist'

  3. The query is not correct.

  4. None of the above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In Oracle and most relational databases, DDL statements like CREATE TABLE commit automatically and implicitly. Because of this implicit commit, a subsequent ROLLBACK command has no effect on the table's existence. Therefore, the DESC command will successfully describe the table structure.

Keep practicing — related questions