Cancel
TopicsDown
Products Down
Follow Us:
FacebookTwitter
Advertisement

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

3356 views
Karthicksugadev
Answered: Sep 18, 2020
Use the ALTER TABLE command with the ADD clause on the EMP table.

1 Answer

2637 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

1597 views
Karthicksugadev
Answered: Sep 18, 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

1521 views
Bruno miguel redondo
Answered: Sep 18, 2020
PGA

The PGA holds session variables and arrays.

1 Answer

307 views

Related Topics Of Oracle SQL

Advertisement
Advertisement
Loading, please wait...

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