IT認証試験問題集
毎月、ITshikenは1500人以上の受験者が試験準備を助けて、試験に合格するために受験者にご協力します
 ホームページ / 1Z0-144 問題集  / 1Z0-144 問題練習

Oracle 1Z0-144 問題練習

Oracle Database 11g: Program with PL/SQL 試験

最新更新時間: 2019/05/15,合計183問。

平成から令和へ:1Z0-144 最新真題を買う時、日本語版と英語版両方を同時に獲得できます。

実際の問題集を練習し、試験のポイントを了解し、テストに申し込むするかどうかを決めることができます。

さらに試験準備時間の35%を節約するには、1Z0-144 問題集を使用してください。

 / 13

Question No : 1
View the Exhibit and examine the structure of the customer table.



You create the following trigger to ensure that customers belonging to category "A" or "B" in the customer table can have a credit limit of more than 8000.



What is the outcome?

正解:

Question No : 2
View the exhibit and examine the structure of the EMPLOYEE table. EMPLOYEE_SEQ is an existing sequence. Examine the following block of code:



Which statement is true about the above block of code?

正解:

Question No : 3
Which three statements are true about anonymous blocks and subprograms? (Choose three.)

正解:

Question No : 4
View the Exhibit and examine the structure of the AUDIR_CUST table.
Exhibit Missing CUST_ID and CUST_LIMIT are existing columns in the CUSTOMER table. Examine the following trigger code:



Which statement is true about the above trigger?

正解:

Question No : 5
View the Exhibit to examine the PL/SQL code.



SERVEROUTPUT is on for the session.
Which statement is true about the execution of the code?

正解:

Question No : 6
View the exhibit to examine the PL/SQL code.



Which statement is true about the exception handlers in the PL/SQL code?

正解:

Question No : 7
View the Exhibit and examine the structure of the customer table.
You need to create a trigger to ensure that customers in category “A” and “B” have a credit limit of more than 8000. Examine the following trigger.



Which statement is correct about the outcome of this trigger?

正解:

Question No : 8
View the Exhibit to examine the PL/SQL code.



The record for the employee with employee__id 100 in the employees table is as follows;



Identify the correct output for the code.

正解:

Question No : 9
Which two statements are true about database triggers? (Choose two.)

正解:
Explanation:http://www.dba-oracle.com/m_trigger.htm

Question No : 10
Which two statements are true about the exit statement encountered in loop? (Choose two)

正解:
Explanation:http://docs.oracle.com/cd/B10501_01/appdev.920/a96624/04_struc.htm

Question No : 11
View the Exhibit and examine the package code created by SCOTT. The execute privilege on this package is granted to green.



Examine the following sequence of commands issued by SCOTT:



What is the outcome?

正解:

Question No : 12
Examine the following PL/SQL code:



Which statement is true about the execution of the PL/SQL code?

正解:
Explanation:http://docs.oracle.com/cd/B19306_01/appdev.102/b14261/errors.htm

Question No : 13
Examine the following PL/SQL code; The execution of the code produces errors. Identify the error in the code.



正解:

Question No : 14
Which statements correctly describe the features of functions and procedures? (Choose all that apply.)

正解:
Explanation:http://docs.oracle.com/cd/B19306_01/appdev.102/b14261/subprograms.htm(using the return statement)

Question No : 15
Examine the following DECLARE section of PL/SQL block: Which line in the above declaration would generate an error?



正解:

 / 13