Best Oracle SQL Questions and Answers (Q&A) - ProProfs Discuss

Most Read

How would you add a foreign key constraint on the dept_no column in the EMP table, referring to the ID column in the DEPT table?

C. Hughes, Musician
Answered: Sep 25, 2020

You can refer to the ID column in the DEPT table to add a foreign key constraint on the dept_no column in the EMP table by using the command of an altar table with the added clause on the emp...Read More

5 Answers

6648 views

What happens when a DROP TABLE command is executed on a table?

Jessica Rhodes, Economic advisor
Answered: Sep 21, 2020

The DROP TABLE command may be implemented on a table in which there are imminent deals. • The DROP TABLE command is utilized in the database management system called Oracle...Read More

12 Answers

5218 views

Which single SQL command would you use to permanently remove all the data from the student table, and you need the table structure in the future?

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

2045 views