ARA-C01 Question #74: Real Exam Question with Answer & Explanation

Question

A table, EMP_ TBL has three records as shown: The following variables are set for the session: Which SELECT statements will retrieve all three records? (Select TWO).

Options

• ASelect * FROM Stbl_ref WHERE Scol_ref IN ('Name1','Nam2','Name3');
• BSELECT * FROM EMP_TBL WHERE identifier(Scol_ref) IN ('Namel','Name2', 'Name3');
• CSELECT * FROM identifier<Stbl_ref> WHERE NAME IN ($var1, $var2, $var3);
• DSELECT * FROM identifier($tbl_ref) WHERE ID IN Cvarl','var2','var3');
• ESELECT * FROM $tb1_ref WHERE $col_ref IN ($var1, Svar2, Svar3);