20151215 OCP 047 80-110

82.which three statements indicate the end of a transation?

a.after a commit is issued

b.after a rollback is issued

rollback transaction ,本transation全不会滚，回到本trasantion开始的地方，也就是上个transation结束的地方

d.after a create statement is issued

dll语句会隐式的提交该语句之前所有未提交的transation

85.the details of the order ID,order date,order total,and customer ID are obrained from the orders table.if the order value is more than 30000,the details have to be added to the large_orders table.the order ID,order date,and order total should be added to the ORDER_HISTORY table.abbnd order ID,AND TCUSTOMER id SHOULD BE ADDED TO THE CUST_ISTORY TABLE.WHICH MULTIABLE INSERT statement iwould you see?

c.conditional all insert 题目要求从orders表中提取的记录版短板order>30000,插入large_orders表，order ID,order date,and order total3列插入order_history表

要求有条件限制的将一条记录插入多个表，应该使用conditional all insert

93.the orders table belongs to the user OE,OE has granted the SELECT privilege on the ORDERS table to the user HR WHICH

statement would create a sysnonym ORD so that HR can execute the following query successfully ?

select * from ord;

d.create public sysnonym ord for oe.orders;this command is issued by the database administartot

ord是oe.order的同义词，要求hr能访问这个同义词，那么这必须是个Public的同义词，oublic同义词只有dba可以创建

101.which statement is true regarding synonyms?

c.a public synonym and a private synonym can exist with the same for the same qtable

a.同义词是任何表，视图，物化视图，序列，过程，函数，包的别名

b.同义词可以引用其他用户的表，也可以引用自己的表

c.公有同义词和私有同义词可以同名，调用时优先公有同义词

d.