A.C

B.N

C.D

D.P

A.Elimination of the need for a database view

B.Automated client handling

C.Simplified syntax check

D.Simpler and stricter syntax

A.An alias can be assigned to the data sources and to the fields in the field list.

B.The data sources are linked using an ON clause.

C.The field list can include fields of the linked table without specifying the name of the corresponding data source.

D.They can expose an entire data source without listing individual fields.

A.field4

B.field3

C.field1

D.field2

A.CAST (field_f2 as N (8)) AS f_n8

B.CAST ('field_f1' as CHAR (8))) AS f_chars

C.CAST (field_f5 as DEC (15,2)) AS f_dec_15_2

D.CAST (29 as INT8) AS f_int8

E.CAST (34 as I) AS f_i34