Online Access Free A2090-545 Practice Test

In the function shown below:

Which statement can be used to invoke the function above?

• A.SELECT * FROM TABLE(fcn1('B01'))
• B.SELECT fcn1('B01') FROM SYSIBM.SYSDUMMY1
• C.SELECT * FROM fcn1('B01')
• D.SELECT TABLE(fcn1('B01')) FROM SYSIBM.SYSDUMMY1

Which of the following can be done while debugging a SQL procedure with IBM Data Studio?

• A.Edit the procedure and continue.
• B.Change the value of any variables used.
• C.Change the order of statements being executed.
• D.Re-execute the current statement.

Assuming EMP_ROW and NEW_HIRE have the same user-defined row data type, what is the best way to assign the elements of NEW_HIRE to EMP_ROW?

• A.emp_row.rowid = new_hire.rowid;
• B.emp_row.all = new_hire.all;
• C.SET emp_row.* = new_hire.*;
• D.SET emp_row = new_hire;

Which two statements are true? (Choose two.)

• A.SQL procedures can contain static and/or dynamic SQL statements.
• B.Static or dynamic SQL execution is not associated with a package.
• C.SQL procedures can have COMMIT or ROLLBACK within atomic compound statements.
• D.It is necessary for an end-user to have object level privileges if that user has execute privileges on an associated package and the SQL procedure.
• E.The SQL procedure is always associated with a package that contains access paths of SQL statements in the procedure.

Which of the following CURSOR declare statement is incorrect?

• A.DECLARE c1 INSENSITIVE CURSOR WITH RETURN TO CLIENT FOR SELECT * FROM tab1
• B.DECLARE c1 ASENSITIVE CURSOR WITH RETURN TO CLIENT FOR SELECT * FROM tab1
• C.DECLARE c1 CURSOR WITHOUT RETURN FOR SELECT * FROM tab1
• D.DECLARE c1 SENSITIVE CURSOR WITH RETURN TO CLIENT FOR SELECT * FROM tab1