Topics
Products
Follow Us:

Oracle SQL Questions and Answers (Q&A)

Matz Lewis Clark, College student
Answered: Jul 18, 2019
There are two correct answers to this question, which are B. The table structure and its deleted data cannot be rolled back and restored once the DROP TABLE command is executed, and C. The DROP...Read More

6 Answers

1722 views
Karthicksugadev
Answered: Mar 30, 2020
Use the ALTER TABLE command with the ADD clause on the EMP table.

1 Answer

1296 views
John Adney
Answered: Oct 09, 2017

You have decided to permanently remove all the data from the STUDENT table and you need the table structure in the future. Which single command performs this?

2 Answers

992 views
Karthicksugadev
Answered: Mar 30, 2020
SELECT e.ename FROM emp e WHERE e.empno NOT IN (SELECT m.mgr FROM emp m WHERE m.mgr IS NOT NULL);

1 Answer

689 views
Bruno miguel redondo
Answered: Mar 30, 2020
PGA

The PGA holds session variables and arrays.

1 Answer

218 views

Related Topics Of Oracle SQL

Loading, please wait...

Email Sent
We have sent an email to your address "" with instructions to reset your password.