Evaluate The Following Sql Statements In The Given Orderp Pre #50
Evaluate the following SQL statements in the given order:</p> <pre><code class="language-sql"> DROP TABLE dept; CREATE TABLE dept (deptno NUMBER(3) PRIMARY KEY, deptname VARCHAR2(10)); DROP TABLE dept; FLASHBACK TABLE dept TO BEFORE DROP; </code></pre> <p>Which statement is true regarding the above FLASHBACK operation?
This multiple choice question (MCQ) is related to the book/course gs gs117 Database Management System. It can also be found in gs gs117 Transactions - Implementation of Isolation Levels - Quiz No.1.
Evaluate the following SQL statements in the given order:
DROP TABLE dept; CREATE TABLE dept (deptno NUMBER(3) PRIMARY KEY, deptname VARCHAR2(10)); DROP TABLE dept; FLASHBACK TABLE dept TO BEFORE DROP;
Which statement is true regarding the above FLASHBACK operation?
It recovers only the first DEPT table
It recovers only the second DEPT table
It does not recover any of the tables because FLASHBACK is not possible in this case
It recovers both the tables but the names would be changed to the ones assigned in the RECYCLEBIN
Similar question(s) are as followings:
Online Quizzes of gs117 Database Management System
Indexing and Hashing - Bitmap Indices - Quiz No.1
gs gs117 Database Management System
Online Quizzes