Oracle数据库，这几道题做的不知道对不对。第七题有点疑惑

img

img

img

  1. You develop a PL/SQL block containing a complex series of data changes. A user then executes your PL/SQL block At what point will the data changes made be committed to the database?
    A. When the PL/SQL block finishes
    B. After each individual update
    C. Whenever the commit command is issued
    D. When you, the creator of the PL/SQL block, disconnect from your session

开发包含一系列复杂数据更改的PL/SQL块。然后，用户在什么时候执行PL/SQL块，所做的数据更改将提交给数据库？
A.当PL/SQL块完成时
B每次更新后
C每当发出commit命令时
D当您（PL/SQL块的创建者）断开与会话的连接时

  1. User SNOW executes the following statement: select from EMP. This statement executes successfully, and SNOW can see the output Table EMP is owned by user REED.
    What object would be required in order for this scenario to happen?
    A . User SNOW would need the role to view table EMP
    B. User SNOW would need the privileges to view table EMP.
    C. User SNOW would need a synonym for table EMP.
    D. User SNOW would need the password for table EMP

用户SNOW执行以下语句：select from EMP。此语句执行成功，并且SNOW可以看到输出表EMP属于用户REED。
为了实现这个场景，需要什么对象？
A.用户SNOW需要角色来查看表EMP
B用户SNOW需要查看表EMP的权限。
C用户SNOW需要表EMP的同义词。
D用户SNOW需要表EMP的密码

  1. You are coding a complex PL/SQL block where several procedures call other procedures You have one outermost procedure that calls all other procedures. If you only wanted to prevent the procedure from failing due to a situation where a select into statement received two or more records, you would include which of the following exceptions?
    您正在编写一个复杂的PL/SQL块，其中多个过程调用其他过程您有一个最外层的过程调用所有其他过程。如果您只想防止由于select into语句接收到两个或多个记录而导致过程失败，那么应该包括以下哪种异常？

A. too many rows
B. others
C. zero divid
D .no data found
A.行太多
B其他
C零分区ID
D.未找到数据

  1. Evaluate this PL/SQL block（计算此PL/SQL块）
declare
  v_result  boolean;
begin
  delete from sale where salesperson_id in(25,35,45);
  v_result :=sql%isopen;
  commit;  
end;

A.0
B.3
C. TRUE
D NULL
E. FALSE

  1. You are the DBA of ABC Corp. You need to retrieve the employee names and salaries from the employment tables, and to make the results assorted by salary, NOT in ascending order. Just in case, if two names match for a salary are found, the two names should be shown in alphabetical order. How do you do this?
    您是ABC公司的DBA。您需要从就业表中检索员工姓名和工资，并将结果按工资分类，而不是按升序排序。以防万一，如果找到两个与薪水匹配的名字，这两个名字应该按字母顺序显示。你是怎么做到的？

A .ORDER BY sal NON-ASC, ename;
B .ORDER BY ename, sal;
C. ORDER BY sal DESC, ename;
D .ORDERED BY sal, ename
E .SORT BY sal DESC, ORDER BY ename

10.
Which clause will cause an error ?
哪个子句会导致错误？

select group_id,isotop,avg(atomic_weight)
from char_n
where avg(action_weight) >89.00
group by group_id,isotope
order by avg(atomic_weight);

A.SELECT group_id,isotope,AVG(atomic_weight)
B.WHERE AVG(atomic_weight)>89.00
C.GROUP BY group_id,isotope
D.ORDER BY AVG(atomic_weight);

第五题 C
第六题 B
第七题 A
第八题 E
第九题 C
第十题 D