1Z0-001考题回忆 12.17

ect text from user_views
　　where view_name='EMP_HIST_V';
　　d. some wrong select statement
　　
　　13.U've created an index like
　　create index emp_deptid_fk_idx on emp(deptid);
　　there are two tables emp and dept and emp table contain a FK deptid which reference the dept tables deptid.
　　Know u've created the index what is achieved ?
　　
　　a.index is stored in emp table
　　b.it reduces I/O using SELECT statement
　　c.performs full table scan
　　d.increases performance of u'r insert statements
　　
　　14.a question about TO_CHAR function using 'RR' format
　　15.know what ALL_COL_PRIVS_RECD datadictionary view
　　16.Evaluate this block
　　IF v_val>100 THEN
　　v_new_val:=2*v_val;
　　ELSIF v_val > 200 THEN
　　v_new_val :=4* v_val;
　　ELSIF v_val <300 THEN
　　v_new_val:=6*v_val;
　　END IF;
　　What is the value of v_new_val if v_val =250?
　　a. 1000
　　b.500
　　c.1500
　　d.error
　　
　　17.know how to run a script file in SQL*PLUS environment(START )
　　18. Evaluate this block
　　DECLARE
　　CURSOR some cursor definition ....
　　BEGIN
　　FOR cur_rec in curs LOOP
　　--some processing given here ....
　　END LOOP;
　　CLOSE curs;
　　END;
　　Why this statement will fail?
　　A.no explicit closing of the cursor
　　
　　19. u've given the following update statement ...
　　-- some update statement given ...
　　u want to know whether next fetch returned rows are not what will u do?
　　Ans: use SQL%FOUND attribute (this's the only valid thing given)
　　

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