1Z0-001考题回忆 12.17

8.Jane has been granted the same privileges as u got on u'r emp table.u're updating the emp table and u
　　
　　asked Jane to log to the database and check the emp table;
　　
　　Which tasks can the Jane be allowed to do?
　　
　　a.Jane can access the emp table but cannot see the changes and not be able to make the same changes.
　　b.Jane will not be allowed to access the emp table;
　　c.Jane will be allowed to access the emp table and can see teh changes made by u.
　　
　　9.Which of these is a system level security?
　　a.DROP ANY TABLE
　　b.ALTER
　　c.INDEX
　　d.EXECUTE
　　
　　10.Evaluate the following PLSQL block
　　DECLARE
　　CURSOR cust_cursor (p_empno NUMBER, p_ename VARCHAR2) IS
　　SELECT * FROM emp
　　WHERE empno=p_empno
　　AND ename = p_ename;
　　Which statement will correctly open this cursor?
　　a.OPEN cust_cursor;
　　b.OPEN cust_cursor('ALLEN',20);
　　c.OPEN cust_cursor(10,'SCOTT');
　　d. ...
　　
　　11. Consider the following statements ..
　　CREATE ROLE clerk;
　　CREATE ROLE hrmanager;
　　CREATE ROLE inventory;
　　CREATE USER scott IDENTIFIED BY tiger;
　　GRANT inventory to clerk;
　　GRANT hrmanager TO clerk;
　　GRANT inventory TO SCOTT;
　　How many roles has been granted to user SCOTT?
　　a. 0
　　b.1
　　c.2
　　d.None
　　
　　12. u've created one view on emp as emp_hist_v and u want to see what are all the columns that are retrieved
　　
　　by the view(view definition) what will u do?
　　a. describe emp
　　b.describe emp_hist_v
　　c.sel

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