SOLVED: What will be the result of the following embedded SQL statement? EXEC SQL ...

What will be the result of the following embedded SQL statement?

EXEC SQL
SELECT EMPID, EMPNAME FROM EMPLOYEE --WHERE EMPID=10000
END-EXEC.

The EMPID and EMPNAME of the employee with EMPID as '10000' are fetched from the table EMPLOYEE.

The EMPID and EMPNAME of all the employees are fetched from the table EMPLOYEE.

Gives a compilation error.

Gives a precompilation error.

Verified Answer

Correct Option - d

To get all Infosys Certified Mainframe COBOL-DB2 Programmer Exam questions Join Group https://bit.ly/infy_premium_group

We're passionate about offering best placement materials and courses!! A one stop place for Placement Materials. We daily post Offcampus updates and Placement Materials.

Important Links

Privacy Policy

Refund Policy

Terms & Conditions

About Us

Contact Us

What will be the result of the following embedded SQL statement? EXEC SQL SELECT EMPID, EMPNAME FROM EMPLOYEE --WHERE EMPID=10000 END-EXEC.

Important Links

What will be the result of the following embedded SQL statement?

EXEC SQL
SELECT EMPID, EMPNAME FROM EMPLOYEE --WHERE EMPID=10000
END-EXEC.