Oracle資格とは
Other Oracle Certification 認証
の1Z0-242テストは、IT技術者育成カリキュラムと人材評価ツールである資格とのあわせて、 インターネット技術者の育成とともにその力を総合的に証明できる世界共通の国際IT資格です。
Oracle評議会による厳正な管理の下、米国IT業の標準に準拠して開発された唯一のIT資格で、世界的なインターネット技術者の組織団体であるOracle認証を推奨しています。
killtestの実践試験1Z0-242問題集
は最も標準的な技術を正確的に書き入れ、認証した専門家と作者の出版した新製品だけを使います。
1Z0-242
1. Evaluate this PeopleCode snippet.Local Array of Number &MyArray;
Local Any &Len, &Result;
&MyArray = CreateArray(3);
&MyArray[1] = 100;
&MyArray[2] = 200;
&MyArray[3] = 300;
&Result = &MyArray.POP();
&Len = &MyArray.LEN;
&End = &MyArray[&Len];
What are the correct values for &Result and &End?
A. &Result is 300
&End is 200
B. &Result is 300
&End is Null
C. &Result is 300
&End is 300
D. &Result is Null
&End is 300
E. &Result is 100
&End is 300
Answer: A
2. Here is a snippet of PeopleCode that uses the Fetch method of the SQL class.
&SQL = CreateSQL("Select EFFORT_AMT from PS_PSU_TASK_EFFORT where TASK= :1",
PSU_TASK_TBL.TASK);
&Var1 = &SQL.Fetch(&Var2);
Select the two correct statements. (Choose two.)
A. &Var2 specifies which row to fetch.
B. &Var2 specifies which field to fetch.
C. &Var1 is populated with TRUE if a row is fetched.
D. &Var1 is populated with the number of rows returned.
E. &Var2 is populated with EFFORT_AMT from the row fetched.
F. &Var1 is populated with EFFORT_AMT from the row fetched.
G. &Var1 is populated with EFFORT_AMT from the first row returned.
Answer: CE