1Z0-001考题回忆 12.17

　　Hi there!
　　I've passed 1z0-001 today with a score of 50/57.I've used the SYBEX SQL-PLSQL Study guide,Exam cram
　　
　　SQL/PLSQL and a host of other resources including braindumps from a very good site.But i've not taken the full
　　
　　advantage of Dumps as i 've very less time when i got them.I,ve also used SelfTest Practice Software which is
　　
　　pretty good.
　　Don't miss to visit 'http:\\nxdy.to\ocpbraindump\' site if u're planning to take 1z0-001 exam.
　　
　　Here are my contributions,
　　
　　1.There was a table structure .. for PLAYER table
　　ID NUMBER;
　　FIRSTNAME VARCHAR@;
　　LASTNAME VARCHAR2;
　　MANAGER NUMBER;
　　
　　u've to selfjoin the table to obtain players and their managers the answer query is..
　　select p.id,p.firstname||p.lastname,m.firstname||m.lastname
　　from players p,players m
　　where p.id=m.manager; something like this cant remeber full options..
　　
　　2.which operator is not used in a non equijoin
　　a.in b.= c.between d.<>
　　
　　3.In which section of the PL/SQL block the user defined exception is raised.
　　a.heading b.declarative c.executive d.exception
　　
　　4.u need to store data of numbers u know that the scale value will always be 2 decimals,but not sure about how
　　
　　many digits in integer part.which datatype is most appropriate for this scenario.
　　a.number b.number(P) c.long d.raw
　　
　　5.Evaluate the following PL/SQL block
　　BEGIN
　　FOR i in 1..10 LOOP
　　IF i=4 OR i=6 THEN
　　null;
　　ELSE
　　insert

[1] [2] [3] [4] [5] 下一页