Oracle Database Program with PL/SQL 試験対策問題集

模擬試験モードの設定

上記は本サイトの模擬試験モードの設定値です。実際の試験の出題数・制限時間・合格基準は、各認定プログラムの公式サイトでご確認ください。

出題分野

• Declaring Variables and Executable Statements（宣言部と実行部）（出題比率 13%）
• Design Considerations and Database Triggers（設計方針とトリガー）（出題比率 14%）
• Using the PL/SQL Compiler and Managing Code（コンパイラとコード管理）（出題比率 13%）
• Writing SQL in PL/SQL and Control Structures（SQL と制御構造）（出題比率 9%）
• Working with Composite Data Types（レコードとコレクション）（出題比率 9%）
• Using Explicit Cursors（明示カーソル）（出題比率 6%）
• Handling Exceptions（例外処理）（出題比率 6%）
• PL/SQL Subprograms and Creating Functions（サブプログラムと関数）（出題比率 9%）
• Creating Procedures and Using Parameters（プロシージャと引数）（出題比率 6%）
• Creating and Working with Packages（パッケージ）（出題比率 9%）
• Using Dynamic SQL and Managing Dependencies（動的 SQL と依存性）（出題比率 6%）

フリー問題

1. A block assigns a sequence value to a local variable, and a later statement in t…
2. An outer block declares a variable and an inner block declares another variable …
3. A variable is declared with the %TYPE attribute against a column of a table, and…
4. A procedure updates a few thousand rows with one bulk statement over a collectio…
5. A function reads a configuration table and also reads a value that is set for ea…
6. A reviewer sees three different clauses on three functions of one package and as…
7. A build script sets the flags that control conditional compilation, and a review…
8. A stored procedure compiles with a message that does not prevent the compilation…
9. A block has to place the salary of one employee into a local variable and the de…
10. A block inserts several rows and the developer places a COMMIT statement in the …
11. A block needs a variable that holds a customer name, a credit limit, and a date,…
12. A block declares a variable of a nested table type and immediately assigns a val…
13. A block has to walk through the rows of a query one row at a time and the develo…
14. A stored procedure detects that an amount breaks a rule of the business and has …
15. A query has to show a computed value beside each row, and a batch has to receive…
16. A query has to call a function of the schema inside its select list. Which descr…
17. A procedure fails to compile and the developer wants to see the reported problem…
18. A team has twelve related subprograms and several shared constants and types. Th…
19. A vendor creates the specification of a package in a customer database and leave…
20. A procedure has to build a query whose table name comes from a parameter, and an…