1Z1-144無料問題集「Oracle Database 11g: Program with PL/SQL」

質問 1

View Exhibit 1 and examine the structure of the EMP and dept tables.

View Exhibit2 and examine the trigger code that is defined on the dept table to enforce the update and delete restrict referential actions on the primary key of the dept table.

What is the outcome on compilation?

（A）It gives an error on compilation because it is not a row-level trigger.

（B）It compiles and executes successfully.

（C）It gives an error on compilation because the exception section Is used in the trigger.

（D）It compiles successfully but gives an error on execution because it is not a row-level trigger.

正解：A 解答を投票する

質問 2

Which system events can be used to create triggers that fire both at database and schema levels? (Choose all that apply)

（A）AFTER SERVERERROR

（B）AFTER STARTUP

（C）AFTER LOGON

（D）BEFORE SHUTDOWN

正解：A、C 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 3

You execute the following block of code:

Which statement is true about the outcome?

（A）Both Output statements show different values.

（B）It gives an error because the V_CUSTOMER variable have different types in the nested blocks

（C）Both output statements show exactly the same values.

（D）It gives an error because the nested blocks are not labeled.

正解：A 解答を投票する

質問 4

Which statement is true about transactions in PL/SQL?

（A）The END keyword signals the end of a PL/SQL block and automatically commits the transaction in the block.

（B）A block can contain only a single transaction.

（C）SERVERPOINTS cannot be created in a PL/SQL block.

（D）A transaction can span multiple blocks.

正解：D 解答を投票する

質問 5

Examine the following PL/SQL code:

Which statement is true about the fetch statements in the PL/SQL code?

（A）They produce an error because you must close and reopen the cursor before each fetch -statement.

（B）Each fetch retrieves the next consecutive row and assigns values to the target variables.

（C）Only the first fetch retrieves the first row and assigns values to the target variables- the second produces an error.

（D）Each fetch retrieves the first row and assigns values to the target variables.

正解：B 解答を投票する

質問 6

View Exhibit1 and examine the structure of the employees table.

User SCOTT needs to generate a text report that contains the names of all employees and their salaries.
Examine the following commands issued by the DBA: SQL_CREATE DICTORY my_dir AS '/temp/my_files* ; SQL_GRANT WRITE ON DIRECTORY my_dir TO SCOTT;
View Exhibit2 and examine the procedure code. You issue the following command: You issue the following command:

SQL_EXEC sal_5tatus ('MY_DIR', 'EMPREPORT.TXT')
What is the outcome?

（A）It executes successfully and creates the report.

（B）It executes but no data is written to the text file because the FFLUSH subprogram is not used to write all the data buffered in memory to a file.

（C）It gives an error because the text file should be opened in append mode.

（D）It gives an error because the "no data found" condition is not handled to come out of the loop.

（E）It gives an error because user SCOTT should be granted both read and write privileges to the directory alias.

正解：A 解答を投票する

質問 7

Examine the following partial declare section from a block of PL/SQL code

Which line(s) in the above code are NOT valid? (Choose all that apply.)

（A）line 3

（B）line 4

（C）line 5

（D）line 2

正解：A、C 解答を投票する

質問 8

You want to create a trigger that fires whenever rows are deleted from the customer table and that displays the number of rows remaining in the table.
Which two statements are correct about the trigger to be created for the above requirement? (Choose two.)

（A）It should be an after trigger.

（B）It can be a before or an after trigger.

（C）It should be a before trigger.

（D）It should be a row-level trigger.

（E）It should be a statement-level trigger.

正解：A、D 解答を投票する

1Z1-144 無料問題集「Oracle Database 11g: Program with PL/SQL」

弊社を連絡する

関連リンク

トップ試験