← Database Management System 🟑 Medium πŸ“‹ Sanfoundry

Evaluate the following SQL statements in the given order: DROP TABLE dept; CREATE TABLE dept (deptno…

Question #1625 of 749+ in Database Management System

πŸ“ Question #1625

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;

⌨️ Press A B C D to select
βœ“

All Options & Correct Answer

A It recovers only the first DEPT table Correct
B It recovers only the second DEPT table
C It does not recover any of the tables because FLASHBACK is not possible in this case
D It recovers both the tables but the names would be changed to the ones assigned in the RECYCLEBIN

πŸ“‹ Question Details

πŸ“š
Subject
Database Management System
🎯
Difficulty
Medium
πŸ“…
Year
β€”
πŸ“‹
Source
Sanfoundry

πŸ“€ Share This MCQ

πŸ“š Want More?

Practice Database Management System MCQs

749+ questions with detailed answers