成都笔试——PL/SQL准备

1. 英文邮件写作

先需要发一封邮件给客户，就一些需求的讨论确定一个会议时间，我们这边在周三下午和周五早上有空，讯问客户的空闲时间。

Dear all,

Good day!

Thank you for your last email!

We have got your general demand. And for deep understanding, we suggest to have a meeting together to discuss more details about it.

Wednesday afternoon and Friday morning this week are the available time for us. Would you please offer the feedback whether they are also convenient for you? If both not, please help offer your available time list. And we will try to book another time for this meeting and reply to you.

If any further questions, please feel free to contact us.

We are looking forward to your kind reply.

Thank you & Best regards!

Jay Cui

2. 测试题A

1) Other than Function, what other types of PL/SQL code blocks can be stored in the database?

Answers:

PROCEDURE 过程, PACKAGE 包

2) Define a LOOP statement that increments a variable “var_count” by 1 from 1 to 10.

Answers:

DECLARE
  var_i INT:=1;
  var_count INT:=0;
BEGIN
  LOOP
      var_count:=var_count+var_i;
      EXIT WHEN var_i=10;
      var_i:=var_i+1;---步