Examine the structure of the two tables.
Which two queries execute successfully? (Choose two.)
A.
B.
C.
D.
E.
|
Download Printable PDF. VALID exam to help you PASS. |
 |
Examine the structure of the two tables.
Which two queries execute successfully? (Choose two.)
A.
B.
C.
D.
E.
|
Download Printable PDF. VALID exam to help you PASS. |
|
AB TESTED
ABD
A… COLUMNS NUMBER AND DATATYPE SAME
B…COLUMNS NUMBER AND DATATYPE SAME
D….COLUMNS NUMBER AND DATATYPE SAME
not true d doesn’t have matching datatypes
Answer is AB.
If D says SELECT ‘100’ with the single quote around, then the query will work. It becomes char instead of a number type.
I executed all them, and only AB executed successfully.
AB
AB is correct
D incorrect because invalid data type (the first query is CHAR data type, the second query is NUMBER data type)
AD
ABD
BC….