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-050





Question ID 1831

View the Exhibit for some of the current parameter settings.

A user logs in to the HR schema and issues the following commands:
SQL> CREATE TABLE emp
(empno NUMBER(3), enameVARCHAR2(20), sal NUMBER(8,2));
SQL> INSERT INTO emp(empno,ename) VALUES(1 /JAMES');
At this moment, a second user also logs in to the HR schema and issues the following command:
 
SQL> ALTER TABLE emp MODIFY sal NUMBER(10,2); What happens in the above scenario?
 

Option A

A.    A deadlock is created.
 

Option B

B.    The second user's command executes successfully.

 

Option C

C.    The second user's session immediately produces the resource busy error.
 

Option D

D.    The second user's session waits for a time period before producing the resource busy error.

Correct Answer D
Explanation


Question ID 1832

You upgraded Oracle Database 10g to Oracle Database 11 g. How would this affect the existing users' passwords?

Option A

A.    All passwords automatically become case-sensitive.
 

Option B

B.    All passwords remain non-case-sensitive till they are changed.

 

Option C

C.    All passwords remain non-case-sensitive and cannot be changed.
 

Option D

D.    All passwords remain non-case-sensitive until their password attribute in the profile is altered.

Correct Answer B
Explanation

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