What is the correct way to delete a user in Oracle when the user owns objects in their schema? To delete a user in Oracle when the user owns objec...
What is the correct way to delete a user in Oracle when the user owns objects in their schema?
To delete a user in Oracle when the user owns objects in their schema, we must use the DROP CASCADE command.
When using DROP CASCADE, the user can be deleted even if they are connected to the database.
If the user owns objects in their schema, we cannot delete them without using CASCADE.
The error ORA-01922 occurs when trying to delete a user who owns objects in their schema without using CASCADE.
a) I and III are correct.
b) II and IV are correct.
c) I and IV are correct.
d) II and III are correct.
To delete a user in Oracle when the user owns objects in their schema, we must use the DROP CASCADE command.
When using DROP CASCADE, the user can be deleted even if they are connected to the database.
If the user owns objects in their schema, we cannot delete them without using CASCADE.
The error ORA-01922 occurs when trying to delete a user who owns objects in their schema without using CASCADE.
a) I and III are correct.
b) II and IV are correct.
c) I and IV are correct.
d) II and III are correct.
💡 1 Resposta
Ed 
A alternativa correta é a letra C) I e IV estão corretas. Explicação: I - Para excluir um usuário no Oracle que possui objetos em seu esquema, é necessário usar o comando DROP CASCADE. IV - Se o usuário possuir objetos em seu esquema e tentarmos excluí-lo sem usar CASCADE, ocorrerá o erro ORA-01922.
✏️ Responder
Para escrever sua resposta aqui, entre ou crie uma conta
Outros materiais
Perguntas relacionadas
Compartilhar