AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z0-001





Question ID 8079

Scott forgot his password while on location. Which command must be executed to set a password for scott?

Option A

Scott must execute the command. ALTER USER scott PASSOWRD BY lion

Option B

The DBA must execute the command. ALTER USER scott IDENTIFIED BY lion

Option C

Scott must execute the command ALTER USER scott IDENTIFIED BY lion

Option D

The scott must execute the command CHANGE password to lion WHERE "user=scott";

Option E

The DBA must execute the command CHANGE password to lion WHERE "user=scott";

Correct Answer B
Explanation Explanation/Reference: Explanation: Answer B is correct because of only DBA (not user himself) can change password for account if user forgot his password. Incorrect Answers: A: Clause 'PASSWORD BY' is wrong for 'ALTER USER' command. C: User needs to be connected to change his password, but he cannot connect if he forgot password. D: Command CHANGE is incorrect to change password and user cannot connect himself to change password because he forgot it. E: Command CHANGE is incorrect to change password. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 182 Chapter 4: Creating Other Database Objects in Oracle


Question ID 8080

You are updating the employee table. Jane has been granted the same privileges as you on the employee table. You ask Jane to logon to the database to check your work before you issue the commit command. What can Jane do to the employee table?

Option A

Jane can access the table and verify your changes.

Option B

Jane cannot access the table.

Option C

Jane can access the table but she cannot see your changes, she can make the changes for you.

Option D

Jane can access the table but she cannot see your changes and cannot make the changes to the roles that you are changing.

Correct Answer D
Explanation Explanation/Reference: Explanation: Answer D is correct because before you committed changes in the employee table nobody can see changed data. Incorrect Answers: A: Jane can access table but she cannot verify changes because she does not see them before you commit data changes. B: Jane can access table because she has been granted the same privileges as you on the employee table. C: Jane cannot commit herself changes you did to the data. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 484-485 Chapter 10: Managing Database Use

Send email to admin@getfreedumps for new dumps request!!!