You have a database table that contains the following columns:
You must insert the following record into the table: Which two Structured Query Language (SQL)
statements can you use? (Choose two.)
A.
Option A
B.
Option B
C.
Option C
D.
Option D
The correct answer :
B.
Option B
C.
Option C
4
0
B 100% and the second one probably c
0
0
Correct Answers are B and C. Answer B specifies the columns to populate and answer C only passes the values without identifying the columns. That is fine as long as the data is in the same order and same number of fields.
0
0
B & C is correct ansewer
1
0
B & C
0
0
“A” contains the values in the first line rather than rather than the destination fieldnames, definitely “B”. “C” has the values in the order the data that the fields are currently being stored so this would also work in this example.
0
0
B and C is correct.
A = wrong syntax
D = wrong parameter
0
0