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).

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).

Peter Shillingford · Accepted Answer

SELECT * FROM EMP_TBL WHERE identifier(Scol_ref) IN ('Namel','Name2', 'Name3');

Peter Shillingford · Accepted Answer

SELECT * FROM $tb1_ref WHERE $col_ref IN ($var1, Svar2, Svar3);

Peter Shillingford · Answer

Select * FROM Stbl_ref WHERE Scol_ref IN ('Name1','Nam2','Name3');

Peter Shillingford · Answer

SELECT * FROM identifier<Stbl_ref> WHERE NAME IN ($var1, $var2, $var3);

Peter Shillingford · Answer

SELECT * FROM identifier($tbl_ref) WHERE ID IN Cvarl','var2','var3');

Question list

List of questions

Question 1

(0)

Question 2

(0)

Question 3

(0)

Question 4

(0)

Question 5

(0)

Question 6

(0)

Question 7

(0)

Question 8

(0)

Question 9

(0)

Question 10

(0)

Related questions

Question 102 - ARA-C01 discussion

Suggested answer: B, E

0 comments