1Z0-001考题回忆 12.17

>　　20.u're proceesing a cursor and in the middle fetched some rows..
　　what will be the next step in the processing of a cursor?
　　a.OPEN
　　b.Test whether fetch return rows
　　c.CLOSE
　　d. ....
　　
　　21.u've created this
　　CREATE SYNONYM emp FOR Ed.Employee;
　　what will be achieved?
　　a.Need to qualify the table with schema name is removed for the user Ed
　　b..Need to qualify the table with schema name is removed for u only
　　c..Need to qualify the table with schema name is removed for all users of the database
　　d..Need to qualify the table with schema name is removed for the users who can access emp table
　　
　　22.a ques about sequence i only remember answer
　　CREATE SEQUENCE patient_id_seq
　　START WITH 10000
　　MAXVALUE 999999999
　　NOCYCLE;
　　
　　23.a ques about the uses of WHERE clause(u've to pick 3)
　　
　　24. In a PLSQL block which of these will generate an exception? (Pick 2)
　　
　　a.select will return a single row (when used with INTO)
　　b.select will return multiple rows (when used with INTO)
　　c.a select statement with group by

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