Home > Archive > Oracle certifications > February 2002 > Answer for this 1Z0-001 question?





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Answer for this 1Z0-001 question?
sid456

2002-02-07, 3:38 am

Please help with the following question:

1. John FORGOT HIS PASSWORD WHILE ON VACATION WHICH COMMAND MUST BE EXECUTED TO SET A PASSWORD FOR SCOTT

A. DBA MUST EXECUTE THE COMMAND. ALTER USER John IDENTIFIED BY LION
B. The command must be issed by John. Alter USER SCOTT identified by GREEN.

What is the answer?
sid456

2002-02-07, 3:41 am

The names in the question should be John
all the way. Scott should be John.
aneesh_bhatia

2002-02-07, 3:58 am

"A" sounds right...
Oracle_de

2002-02-07, 7:07 pm

hi sid456

This right answer

A. DBA MUST EXECUTE THE COMMAND. ALTER USER John IDENTIFIED BY LION

JOHN OR SCOTT CAN'T LOGIN TO DATABASE IF HE LOSE THE PASSWORD ???
siddharth_k

2002-02-09, 12:21 am

dear sid456 as far as i know .. answer a is right 'cause:
1. you cant login unless you have password.
2. you have to have admin privilage to set password except your own account.

so i think it has to be dba who can change the passwd by giving alter user command
siddharth_k

2002-02-09, 12:29 am

dear sid456 as far as i know .. answer a is right 'cause:
1. you cant login unless you have password.
2. you have to have admin privilage to set password except your own account.

so i think it has to be dba who can change the passwd by giving alter user command
sid456

2002-02-09, 5:30 am

Thanks for the reply.
Sponsored Links





Free Braindumps | MCSE braindumps software forum

Copyright 2003 - 2008 examnotes.net