Oracle 1Z0-149 試験概要:
Oracle 1Z0-149 認定試験の出題範囲:
| トピック | 出題範囲 |
|---|
| トピック 1 | - Overload package subprograms and use forward declarations
- Initialize collections and records
|
| トピック 2 | - Create triggers on DDL statements
- Create a procedure with parameterrs
- Bind PL
- SQL types in SQL statements
|
| トピック 3 | - Lock rows with the FOR UPDATE clause and reference the current row with the WHERE CURRENT OF clause
- Recognize unhandled exceptions
|
| トピック 4 | - Describe when implicit conversions take place and when explicit conversions have to be dealt with
- Create user-defined PL
- SQL records
|
| トピック 5 | - Describe different types of triggers and their uses
- Describe the execution flow of SQL statements
|
| トピック 6 | - Use built-in SQL functions in PL
- SQL and sequences in PL
- SQL expressions
- Creating Procedures and Using Parameters
|
| トピック 7 | - Use the PL
- SQL compiler initialization parameters
- Working with Composite Data Types
|
| トピック 8 | - Use ACCESSIBLE BY to restrict access to package subprograms
- Create a record with the %ROWTYPE attribute
|
| トピック 9 | - Identify the uses and types of control structures
- Make use of the INTO clause to hold the values returned by a SQL statement
|
| トピック 10 | - Use bulk binding and the RETURNING clause with DML
- Create PL
- SQL executable blocks using DML and transaction control statements
|
| トピック 11 | - Describe the differences among records, collections, and collections of records
- Declaring PL
- SQL Variables
|
| トピック 12 | - Identify the benefits and the components of packages
- List and describe various data types using the %TYPE and %ROWTYPE attributes
|
| トピック 13 | - Handle exceptions in procedures and display a procedure's information
- Recognize valid and invalid identifiers
|
| トピック 14 | - Control the run-time privileges of a subprogram
- List the uses of variables, declare and initialize variables, use bind variables
|
| トピック 15 | - Whitelist code access with the ACCESSIBLE BY clause
- Create an INDEX BY table and INDEX BY table of records
|
参照:https://education.oracle.com/oracle-database-19c-program-with-pl-sql/pexam_1Z0-149