goo blog サービス終了のお知らせ 

killtestのIT問題集ブログ

killtestの最新試験参考書を提供し、合格することが保証できます!

Oracle資格認証を紹介 killtestはOracle資格の 1Z0-501

2010-05-19 11:11:55 | 日記
Oracle Other Oracle Certification 1Z0-501試験は今も掲載のOracle認定試験模擬問題?演習問題を、試験別?範囲別に一覧することができます。解答?解説とともに受験前の直前対策、苦手分野の克服などにご活用下さい。試験番号は1Z0-501はkilltest全部提供いたします。気楽に試験を通すように助けます、ご使用になってください!

1Z0-501
1 .Given:
1. public class test (
2. public static void main (String args[]) {
3. int i = 0xFFFFFFF1;
4. int j = ~i;
5.
6. }
7. )
What is the decimal value of j at line 5?
A. 0
B. 1
C. 14
D. -15
E. An error at line 3 causes compilation to fail.
F. An error at line 4 causes compilation to fail.
Answer: C
2 .Given:
Integer i = new Integer (42);
Long 1 = new Long (42);
Double d = new Double (42.0);
Which two expressions evaluate to True? (Choose Two)
A. (i ==1)
B. (i == d)
C. (d == 1)
D. (i.equals (d))
E. (d.equals (i))
F. (i.equals (42))
Answer: D,E
3 .Exhibit:
1. public class test (
2. private static int j = 0;
3.
4. private static boolean methodB(int k) (
5. j += k;
6. return true;
6. )
7.
8. public static void methodA(int i) {
9. boolean b:
10. b = i <10 | methodB (4); 13.
14. public static void main (String args[] } (
15. methodA (0);
16. system.out.printIn(j);
17. )
18. )
What is the result?
A. The program prints "0"
B. The program prints "4"
C. The program prints "8"
D. The program prints "12"
E. The code does not complete.
Answer: B
4 CORRECT TEXT
Given
1. Public class test (
2. Public static void main (String args[]) (
3. System.out.printIn (6 ^ 3);
4. )
5. )
What is the output?
Answer: 5
5 .Given:
1. public class Foo {
2. public static void main (String [] args) {
3. StringBuffer a = new StringBuffer ("A");
4. StringBuffer b = new StringBuffer ("B");
5. operate (a,b);
6. system.out.printIn{a + "," +b};
7. )
8. static void operate (StringBuffer x, StringBuffer y) {
9. x.append {y};
10. y = x;
11. )
12. }
What is the result?
A. The code compiles and prints "A,B".
B. The code compiles and prints "A,A".
C. The code compiles and prints "B,B".
D. The code compiles and prints "AB,B".
E. The code compiles and prints "AB,AB".
F. The code does not compile because "+" cannot be overloaded for StringBuffer.
Answer: D
6 CORRECT TEXT
Exhibit:
1. Public class test (
2. Public static void stringReplace (String text) (
3. Text = text.replace ('j' , 'i');
4. )
5.
6. public static void bufferReplace (StringBuffer text) (
7. text = text.append ("C")
8. )
9.
10. public static void main (String args[]} (
11. String textString = new String ("java");
12. StringBuffer text BufferString = new StringBuffer ("java");
13.
14. stringReplace (textString);
15. BufferReplace (textBuffer);
16.
17. System.out.printIn (textString + textBuffer);
18. }
19. )
What is the output?
Answer: JAVAJAVA

Oracle 1Z0-223 killtest問題集 一発合格する!

2010-05-18 11:30:56 | 日記
Oracle Other Oracle Certification 1Z0-225
killtesは1Z0-225問題集を提供しております、killtesの製品Oracle Other Oracle Certification 1Z0-225を使った後、お客様が認定合格にただ一歩の距離があります.まだ確信させませんか?今すぐkilltesの練習試験を試してみましょう。しかし、全部の解答を暗記によって、順調に合格することができると思います。
1Z0-225には、我々はお客様が成功に試験合格のために、一生懸命に努力してお客様に完全で均衡な公式を提供します、killtesのOracle認証の質問と練習試験の製品は試す認定1Z0-225試験に自信を持ってお客様の能力を高めます. 一発合格することが保証できます。

1Z0-225
1. Which two are supply sources for Supplier and Production inventory replenishment? (Choose two.)
A. Discrete job
B. Intransit order
C. External sales order
D. Replenishment move order
E. Internal purchase requisition
F. External purchase requisition
Answer: AF
2. What is the purpose of the profile options INV: CCEOI Commit Point and INV: CCEOI Workers?
A. to provide a baseline for generating cycle count tags
B. to set default values for the frequency of automatic cycle count requests
C. to set default values for the Import Cycle Count Entries from Open Interface concurrent program
D. to limit the actions permitted when reviewing cycle counts imported from an external system using the
Cycle Count Entries Open Interface
Answer: C
3. Your client wants to ensure that backflush operations can continue even if the inventory level is driven
below zero. At the same time, they want typical inventory transactions to be prevented from driving
inventory levels below zero.
Which configuration meets this requirement?
A. Org Profile option to Allow Negative Balances = No; Profile option for INV: Override Neg for Backflush
= No.
B. Org Profile option to Allow Negative Balances = No; Profile option for INV: Override Neg for Backflush
= Yes.
C. Org Profile option to Allow Negative Balances = Yes; Profile option for INV: Override Neg for Backflush
= No.
D. Org Profile option to Allow Negative Balances = Yes; Profile option for INV: Override Neg for Backflush
= Yes.
Answer: B
4. You define a UOM Class for VolumE.
Which grouping represents the Volume class?
A. Liter, gallon, milliliter, pint
B. Kilometer, meter, mile, yard
C. Liter, milliliter, kilometer, meter
D. Liter, gallon, milliliter, centimeter
E. Kilometer, meter, cubic yard, cubic meter
F. Kilometer, meter, centimeter, cubic centimeter
Answer: A
5. XYZ is a metal fabrication company. It wants to classify all metals and plastics into two major groups.
There are many subgroups in metals and plastics. All the subgroups are linked to their major group.
This group classification is extensively used in all the reports in the organization.
Which Oracle functionality can meet the above requirement?
A. Catalogs
B. Categories
C. Catalog and Categories
D. Category Set and Categories
E. Group key flexfield enabled in the reports
F. Group descriptive flexfield enabled in the reports
Answer: D
6. ABC company uses serial numbers for the following transactions:
1. Purchase order receipt
2. Miscellaneous receipt
3. Account alias receipt
The company wants to reuse the same serial numbers for work order completion transactions. Which
setup would allow it to reuse the same serial numbers?
A. INV: Validate Returned Serial: No
B. INV: Validate Returned Serial: Yes
C. INV: Restrict Receipt of Serials: No
D. INV: Restrict Receipt of Serials: Yes
E. INV: Validate Returned Lot: Yes and INV: Validate Returned Serial: No
F. INV: Restrict Receipt of Serials: Yes and INV: Validate Returned Serial: No
G. INV: Restrict Receipt of Serials: Yes and INV: Validate Returned Serial: Yes
Answer: C
7. You want Oracle Inventory to automatically create move orders while performing min-max planninG. To
enable that functionality, you would need to define the ____.
A. subinventory supply source type at the pull level
B. Move Order Timeout Action to a value greater than zero
C. Move Order Timeout Period to a value greater than zero
D. subinventory supply source type at the subinventory or item level
Answer: D
8. Which three statements are true about the Move Order process? (Choose threE. )
A. Requisition and pick release orders are preapproveD.
B. Replenishment and pick wave move orders are preapproveD.
C. Requisition and pick release orders are preapproved and require inspection.
D. If no planner is specified for the item, the requisition line is automatically approveD.
E. If no approvals are required in your organization, set the inventory organization parameters Timeout
Period to 0 and the Timeout Action to Approve Automatically.
Answer: BDE

1Z0-147テスト 一発合格を保証Oracle認証

2010-05-17 09:53:37 | 日記
killtestはOracle認証の最新問題集を提供いたします、最も標準的な技術を正確的に書き入れ、認証した専門家と作者の出版した新製品だけを使います、Oracle認証の1Z0-147問題集は世界のどこでも人気があるんですよ、killtestでその問題集を購入するのは明確の選択でございます。
9i Internet Application Developer認証試験について1Z0-147問題集 を 研究し続けています。100%気楽に試験を通すように保証できます。

1Z0-147
1.What can you do with the DBMS_LOB package?
A.Use the DBMS_LOB.WRITE procedure to write data to a BFILE.
B.Use the DBMS_LOB.BFILENAME function to locate an external BFILE.
C.Use the DBMS_LOB.FILEEXISTS function to find the location of a BFILE.
D.Use the DBMS_LOB.FILECLOSE procedure to close the file being accessed.
Correct:D

2.Examine this procedure: CREATE OR REPLACE PROCEDURE ADD_PLAYER (V_ID IN NUMBER,
V_LAST_NAME VARCHAR2) IS BEGIN INSERT INTO PLAYER (ID,LAST_NAME) VALUES (V_ID,
V_LAST_NAME); COMMIT; END; This procedure must invoke the UPD_BAT_STAT procedure and
pass a parameter. Which statement, when added to the above procedure, will successfully invoke
the UPD_BAT_STAT procedure?
A.EXECUTE UPD_BAT_STAT(V_ID);
B.UPD_BAT_STAT(V_ID);
C.RUN UPD_BAT_STAT(V_ID);
D.START UPD_BAT_STAT(V_ID);
Correct:B

3.Which three describe a stored procedure? (Choose three.)
A.A stored procedure is typically written in SQL.
B.By default, a stored procedure executes with the privileges of its owner.
C.A stored procedure has three parts: the specification, the body, and the exception handler part .
D.A stored procedure is stored in the database and can be shared by a number of programs.
E.A stored procedure offers some advantages over a standalone SQL statement, such as programmable
functionality and compiled code.
Correct:B D E

4.Examine this package: CREATE OR REPLACE PACKAGE pack_cur IS CURSOR c1 IS SELECT
prodid FROM product ORDER BY prodid DESC; PROCEDURE proc1; PROCEDURE proc2; END
pack_cur; / CREATE OR REPLACE PACKAGE BODY pack_cur IS v_prodid NUMBER;
PROCEDURE proc1 IS BEGIN OPEN c1; LOOP FETCH c1 INTO v_prodid;
DBMS_OUTPUT.PUT_LINE('Row is: ' || c1%ROWCOUNT); EXIT WHEN c1%ROWCOUNT >= 3; END
LOOP; END proc1; PROCEDURE proc2 IS BEGIN LOOP FETCH c1 INTO v_prodid;
DBMS_OUTPUT.PUT_LINE('Row is: ' ||c1%ROWCOUNT); EXIT WHEN c1%ROWCOUNT >= 6; END
LOOP; CLOSE c1; END proc2; END pack_cur; / The product table has more than 1000 rows. The
SQL*Plus SERVEROUTPUT setting is turned on in your session. The product table has more than
1000 rows. The SQL*Plus SERVEROUTPUT setting is turned on in your session. The product table
has more than 1000 rows. The SQL*Plus SERVEROUTPUT setting is turned on in your session.
You execute the procedure PROC1 from SQL*Plus with the command: The product table has more
than 1000 rows. The SQL*Plus SERVEROUTPUT setting is turned on in your session. You execute
the procedure PROC1 from SQL*Plus with the command: EXECUTE pack_cur.proc1 You execute
the procedure PROC1 from SQL*Plus with the command: EXECUTE pack_cur.proc1 You execute
the procedure PROC1 from SQL*Plus with the command: EXECUTE pack_cur.proc1 What is the
output in your session? EXECUTE pack_cur.proc1 What is the output in your session? What is the
output in your session? A. ERROR at line 1: What is the output in your session? A. ERROR at line
1: A. ERROR at line 1: B. Row is:
A.ERROR at line 1:
B.Row is:
C.Row is:
D.Row is: Row is:
E.Row is: 1 Row is:
F.Row is: 1 Row is: 2
G.Row is: 1 Row is: 2 Row is: 3
H.Row is: 1 Row is: 2 Row is: 3 Row is: 2 Row is: 3
I.Row is: 4
J.Row is: 4 Row is: 5
K.Row is: 4 Row is: 5 Row is: 6 Row is: 5 Row is: 6
Correct:E F G H

5.Examine this procedure: CREATE OR REPLACE PROCEDURE INSERT_TEAM (V_ID in NUMBER,
V_CITY in VARCHAR2 DEFAULT 'AUSTIN', V_NAME in VARCHAR2) IS BEGIN INSERT INTO TEAM
(id, city, name) VALUES (v_id, v_city, v_name); COMMIT; END; Which two statements will
successfully invoke this procedure in SQL*Plus? (Choose two.)
A.EXECUTE INSERT_TEAM;
B.EXECUTE INSERT_TEAM(3, V_NAME=>'LONGHORNS', V_CITY=>'AUSTIN');
C.EXECUTE INSERT_TEAM(3,'AUSTIN','LONGHORNS');
D.EXECUTE INSERT_TEAM (V_ID := 3, V_NAME := 'LONGHORNS', V_CITY := 'AUSTIN');
E.EXECUTE INSERT_TEAM (3,'LONGHORNS');
Correct:B C

6.You need to create a DML trigger. Which five pieces need to be identified? (Choose five.)
A.table
B.DML event
C.trigger body
D.package body
E.package name
F.trigger name
G.system event
H.trigger timing
Correct:A B C F H

7.This statement fails when executed: CREATE OR REPLACE TRIGGER CALC_TEAM_AVG AFTER
INSERT ON PLAYER BEGIN INSERT INTO PLAYER_BAT_STAT (PLAYER_ID,
SEASON_YEAR,AT_BATS,HITS) VALUES (:NEW.ID, 1997, 0,0); END; To which type must you
convert the trigger to correct the error?
A.row
B.statement
C.ORACLE FORM trigger
D.before
Correct:A

8.Examine this package:
A.The value of DISCOUNT_RATE always remains 0.00 in a session.
B.The value of DISCOUNT_RATE is set to 0.10 each time the package is invoked in a session.
C.The value of DISCOUNT_RATE is set to 1.00 each time the procedure DISPLAY_PRICE is invoked.
D.The value of DISCOUNT_RATE is set to 0.10 when the package is invoked for the first time in a
session.
Correct:D



Oracle 11g 1Z0-052 killtestは試験問題集を提供 合格へ

2010-05-15 10:14:31 | 日記
Oracle 11g 1Z0-052試験番号: 1Z0-052
試験の名称: Oracle Database 11g: Administrator I :
Version:V8.02
問題と解答:188 Q&As
価格(日本円): \ 9900.00 JPY
更新:2010-04-22

killtestはIT資格試験の模擬問題をWebベースで学習できる、IT自分戦略研究所の新サービス「IT資格攻略」では、Oracle関連の資格をテーマとして取り上げています。11g基礎 11gも近日中に追加予定です。
killtestの問題集は世界中権威的な専門家が作りあがった作品でございます、100%気楽に合格することが保証いたします。

1Z0-052
1. View the Exhibit and examine the attributes of an undo tablespace.
In an OLTP system, the user SCOTT has started a query on a large table in the peak transactional hour
that performs bulk inserts. The query runs for more than 15 minutes and then SCOTT receives the
following error:
ORA-01555: snapshot too old
What could be the reason for this error?
A.The query is unable to get a read-consistent image.
B.There is not enough space in Flash Recovery Area.
C.There is not enough free space in the flashback archive.
D.The query is unable to place data blocks in undo tablespace
Answer: A

2. Which two statements are true about the Automatic Workload Repository (AWR)? (Choose two.)
A.All AWR tables belong to the SYSTEM schema.
B.The AWR contains systemwide tracing and logging information.
C.The snapshots collected by the AWR are accessible through data dictionary views.
D.The snapshots collected by the AWR are used by self-tuning components in the database.
Answer: CD

3. While observing the index statistics, you find that an index is highly fragmented, thereby resulting in
poor database performance. Which option would you use to reduce fragmentation without affecting the
users who are currently using the index?
A.Validate the index structure using the ANALYZE...INDEX command.
B.Rebuild the index using the ALTER INDEX..REBUILD ONLINE command.
C.Change the block space utilization parameters using the ALTER INDEX command.
D.Deallocate the unused space in the index using the ALTER INDEX..DEALLOCATE UNUSED command.
Answer: B

4. Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type of
backups that can be performed on the database?
A.You can perform online whole database backups.
B.You can perform offline whole database backups.
C.You cannot perform schema-level export/import operations.
D.You can perform the backup of only the SYSTEM tablespace when the database is open.
Answer: B

5. The database instance is currently using SPFILE. View the Exhibit and examine the error that you
received while running the DB Structure Integrity check.
Given below are the steps to recover from the error in random order:
1: Shut down the instance, if not already done.
2: Copy one of the remaining control files to a new location.
3: Change the value of the CONTROL_FILES initialization parameter to correspond to the new location of
the control files.
4: Start up the database instance to the NOMOUNT stage.
5: Recover the database to the point of failure of the control file.
6: Open the database.
Identify the correct sequence of steps?
A.1, 2, 4, 3, 5, 6
B.2, 4, 3, 5, 6; 1 not required
C.4, 5, 6, 2, 3; 1 not required
D.5, 2, 3, 4; 1 and 6 not required
Answer: A

6. Note the following points describing various utilities in Oracle Database 11g:
1: It enables the high-speed transfer of data from one database to another.
2: It provides a complete solution for the backup, restoration, and recovery needs of the entire database.
3: It enables the loading of data from an external file into an Oracle database.
4: It provides a tape backup management for the Oracle ecosystem.
Which point describes Oracle Secure Backup?
A.1
B.2
C.3
D.4
E.1, 2, and 4
F.1, 2, 3, and 4
Answer: D

7. You have issued a SHUTDOWN ABORT command to bring down your database instance. Consider
the steps that will be performed later when you open the database:
1: SGA is allocated.
2: Control file is read.
3: Redo log files are read.
4: Instance recovery is started.
5: Background processes are started.
6: Data files are checked for consistency.
7: Server parameter file or the initialization parameter file is read.
Which option has the correct order in which these steps occur?
A.7, 1, 5, 2, 3, 6, 4
B.1, 2, 3,7, 5, 6, 4
C.7, 1, 4, 5, 2, 3, 6
D.1, 7, 5, 4, 2, 3, 6
Answer: A

10g DBA資格の取得 killtestは1Z0-211試験の最新試験問題集を提供

2010-05-14 10:01:41 | 日記
killtestは11i資格の最も最新試験問題集を提供し、11i資格を取りたいだったら、三科目を受けなければならないんです。

1Z0-211 Oracle 11i general ledgerfundamentals

受験者のために、すべての11iのテストを勉強しなければなりません。killtestを選んで絶好なチャンスだと思います!killtestの問題集は世界中権威的な専門家が作りあがった作品でございます、100%気楽に合格することが保証いたします。
弊社は一年以内無料更新版のサービスを提供いたします、弊社の問題集は本格テストとすごく近いし、合格率は100%でございます。

1Z0-211
1.Which two statements would be true when helping a customer make implementation decisions
for General Ledger? (Choose two)
A.Integration issues can be minimized.
B.Cost of upgrades would not be affected.
C.Patching cannot be done on a customized implementation.
D.Training can be standardized when Oracle is implemented without customization.
E.All Oracle subledger journals go directly to General Ledger to overcome interface problems.
Correct:A D
2.Revenue accounts can be viewed only by the head of the Finance team, who has a GL Superuser
responsibility. She has successfully created a standard Profit and Loss statement for the
company. Another member of the department with a General Ledger Supervisor responsibility has
been asked to run the standard Profit and Loss statement for Feb-06. The report shows only the
expenses accounts. Which two steps should she perform so that the Profit and Loss statement
will run successfully? (Choose two.)
A.Recreate the Profit and Loss under her own responsibility.
B.Ask to have security removed from her responsibility.
C.Perform an on-line inquiry to get the revenue balances.
D.Ask to have the profile option FSG: Enforce Segment Value Security changed to No.
Correct:B D
3.In creating a report, what is true about the column set? (Choose two.)
A.Formats can be set for each column.
B.Accounts cannot be assigned to a column set.
C.Calculations can be performed using columns.
D.Seeded column sets provided by Oracle must be used.
Correct:A C
4.Select the two minimum set up steps for intercompany accounting. (Choose two.)
A.Define a clearing company for all many-to-many intercompany journals.
B.Include an Intercompany segment in the chart of accounts structure.
C.Enable the Intercompany Qualifier for the Intercompany segment.
D.Enable Balance Intercompany Journal when defining the set of books.
E.Set up intercompany accounts for every journal source and journal category for intercompany
transactions.
F.Set up intercompany accounts for journal source and journal category of Other.
G.Define a value set for the Company and Intercompany segments.
H.Define a journal source and a journal category for Intercompany.
Correct:D F
5.Select the three true statements about mapping rules. (Choose three.)
A.A rollup rule tells General Ledger what detail level of information to transfer and how to roll that
information up to the parent.
B.There are only three rollup rules: 1. Transfer Level Detail - Using Detail Ranges; 2. Transfer Level Detail
- Using Parent; 3. Transfer Level Summary - Using Parent
C.You can define a combination of segment values and account rules.
D.There are only two mapping rule actions: 1. Copy Value from; 2. Assign Value from
E.Mapping sets enable you transfer data from multiple subsidiaries simultaneously.
Correct:A C E
6.XYZ Corporation has two sets of books and six inventory organizations. What is the minimum
number of times that XYZ needs to run the general ledger interface in order to close the inventory
at the end of each accounting cycle?
A.2
B.4
C.6
D.8
E.10
F.12
Correct:C
7.XYZ Company has many Financial Statement Generator reports created to produce Profit &
Loss statements and Balance Sheet reports. Occasionally XYZ has a need to run a report that is
slightly different than the standard ones that are already created. Which two types of changes
could XYZ make using the Row Order feature? (Choose two.)
A.add a new calculation
B.sort based on column values
C.display segment values and descriptions
D.change how rounding options are performed
Correct:B C
8.XYZ Enterprise has two diverse business operations in retail stores and services. It has five
legal entities in Canada and five in the United States for both operations. The fiscal year end is the
same for all the legal entities with 12 monthly periods. However, XYZ wants to use a 4-5-4
accounting calendar for its retail operations and a calendar-month accounting calendar for the
services operations. XYZ also wants to use a single chart of accounts structure. Which five items
must XYZ define to meet the minimum setup steps that are required for the sets of books for all
legal entities? (Choose five.)
A.two sets of books
B.four sets of books
C.three sets of books
D.account combinations
E.one accounting calendar
F.two accounting calendars
G.chart of accounts structure
H.period types or use seeded ones
I.enable seeded CAD and USD currencies
Correct:B F G H I