Your browser does not support JavaScript!

Choose the letter of the correct answer based on the table EMPLOYEES as shown below.Table 1.0 EMPLOYEESBased on the given SELECT statement below what would be the possible output?SELECT (LASTNAME||FIRSTNAME), JOB_IDFROM EMPLOYEESWHERE SUBSTR (JOB_ID,4)'REP';

  • ABELELLEN                  SA_REPTALORJONATHAN       SA_REPGRANTKIMBERLY       SA_REPFAYPAT                          MK_REP Correct
  • ABELELLEN                  SA_REPTALORJONATHAN       SA_REPGRANTKIMBERLY       SA_REP
  • ABELELLEN                  SA_REPGRANTKIMBERLY           SA_REPFAYPAT                       MK_REP
  • TALORJONATHAN       SA_REPGRANTKIMBERLY       SA_REPFAYPAT                       MK_REP
Similar IT-6202 questions