Searching for ":"

Q:

You responsible for maintaining an application that was written by a former colleague at XYZ.

 

The application reads from and writes to log files located on the local network. The original author included the following debugging code to facilitate maintenance:

try {
Debug.WriteLine(“Inside Try”);
throw(new IOException());}
catch (IOException e) {
Debug.WriteLine (“IOException Caught”);}
catch (Exception e) {
Debug.WriteLine(“Exception Caught”);}.
finally {
Debug.WriteLine (“Inside Finally”);}
Debug.WriteLine (“After End Try”);

 

Which output is produced by thus code?

A) Inside Try Exception Caught IOException Caught Inside Finally After End Try B) Inside Try Exception Caught Inside Finally After End Try
C) Inside Try IOException Caught Inside Finally After End Try D) Inside Try IOException Caught Inside Finally
 
Answer & Explanation Answer: C) Inside Try IOException Caught Inside Finally After End Try

Explanation:

First the try code runs. Then one single exception, the IOException occurs, not two exceptions.Then the Finally code segments executes. After Finally code bas been executed normal application resumes at the next line after the line that called the error. In this case, the After End Try code runs.

Report Error

View Answer Report Error Discuss

Q:

You develop a Windows-based application that enables to enter product sales. You add a subroutine named XYZ.

 

You discover that XYZ sometimes raises an IOException during execution. To address this problem you create two additional subroutines named LogError and CleanUp. These subroutines are governed by the following rules:

• LogError must be called only when XYZ raises an exception.
• CleanUp must be called whenever XYZ is complete.

 

 You must ensure that your application adheres to these rules. Which code segment should you use?

A) try { XYZ(); LogError(); } catch (Exception e) { CleanUp(e); } B) try { XYZ(); } catch (Exception e) { LogError(e); CleanUp(); }
C) try { XYZ(); } catch (Exception e) { LogError(e); } finally { CleanUp(); } D) try { XYZ(); } catch (Exception e) { CleanUp(e); } finally { LogError(); }
 
Answer & Explanation Answer: C) try { XYZ(); } catch (Exception e) { LogError(e); } finally { CleanUp(); }

Explanation:

We must use a try…catch…finally construct. First we run the Comapany() code in the try block.Then we use the LogError() subroutine in the catch statement since all exceptions are handled here. Lastly we put the CleanUp() subroutine in the finally statement since this code will be executed regardless of whether an exception is thrown or not.

Report Error

View Answer Report Error Discuss

Q:

The DBA can set the registry variable DB2_HASH_JOIN on or off because:

A) hash joins may require more resources to run. B) hash joins are not used unless outer joins are requested.
C) If hash joins are enabled, no other join method can be used. D) Hash joins are only needed when the tables are portioned using hash keys.
 
Answer & Explanation Answer: A) hash joins may require more resources to run.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification

Q:

Explain Given the following SQL statement: GRANT REFERENCES ON TABLE tab1 TO USER usera.Which of the following describes what USERA is allowed to do?

A) Create a read?only view using TAB1. B) Alter TAB1 to add a check constraint.
C) Define a primary key or unique constraint on TAB1. D) Define a dependent table where TAB1 is the parent.
 
Answer & Explanation Answer: D) Define a dependent table where TAB1 is the parent.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: IBM Certification

Q:

How do we decide on the Characteristics to be included in a Dimension?

A. When the fields (InfoObjects) have 1: m relationship.

B. When the fields (InfoObjects) have m: 1 relationship.

C. When the fields (InfoObjects) have m: n relationship.

Answer

Answer : C

Report Error

View answer Workspace Report Error Discuss

Subject: SAP BW

Q:

Which of the following is primary wage type ?

A. User Wage Type

B. Dialog Wage Type

C. Technical Wage Type

D. Statement Wage Type

Answer

Answer : B

Report Error

View answer Workspace Report Error Discuss

Subject: SAP HR

Q:

Wage type in SAP HR System consists of three value fields:

A. RTE, RIO and NUM.

B. RTE, NUM and AMT.

C. RIO, NUM and PAY.

D. RTE, NUM and PAY.

Answer

Answer : B

Report Error

View answer Workspace Report Error Discuss

Subject: SAP HR

Q:

The personnel control record performs the following functions in payroll:[Choose one or more correct answers]

A. Defines the payroll past for retroactive accounting recognition.

B. Defines the earliest possible retroactive accounting date for each payroll area.

C. Locks master data and time data so no changes can be made during the payroll process.

D. Defines the latest possible retroactive accounting date for each payroll area.

E. Locks vendor data so no changes can be made during the payroll process.

Answer

Answer : A , B , C , D

Report Error

View answer Workspace Report Error Discuss

Subject: SAP HR