View the exhibit and examine the description for the SALES and CHANNELS tables.
You issued the following SQL statement to insert a row in the SALES table:
INSERT INTO sales VALUES
(23, 2300, SYSDATE, (SELECT channel_id
FROM channels
WHERE channel_desc=’Direct Sales’), 12, 1, 500);
Which statement is true regarding the execution of the above statement?
A.
The statement will execute and the new row will be inserted in the SALES table.
B.
The statement will fail because subquery cannot be used in the VALUES clause.
C.
The statement will fail because the VALUES clause is not required with subquery.
D.
The statement will fail because subquery in the VALUES clause is not enclosed with in single quotation marks .
INSERT STATEMENT INSERTS 7 VALUES AND THE TABLE ONLY HAVE 6 COLUMNS SO HOW THE FIRST OPTION IS CORRECT
It’s crazy
It looks like it is mistake in the statement. It should be one number less but you can use subquery in the caluse Values like in the above example.
B,C,D are wrong so A is correct but printing mismake(one extra number)
So ‘A’ is correct
If the subquery would return 2 or more ID’s how is A corect?
“single-row subquery returns more than one row”
Sub query is returning Channel ID which is PK. It means returning only one row(value)
Simply, the questions has asked that sub-query is acceptable in INSERT column VALUES. So, answer ‘A’ is correct. Assume table sales has 7 column and sub-query will give one singe value.
A.
The statement will execute and the new row will be inserted in the SALES table.
This question has apparently two errors: First, as mentinoned before, the theoretical correct answer has 7 attributes values and the table SALES has 6; second, there is a possibility in which this subquery to return more than 1 result. This question must be reviewed.
Thanks , I’ve recently been looking for info approximately this topic for a while and yours is the best I’ve found out so far. However, what about the conclusion? Are you sure about the source?|
cheap team soccer jerseys knock off hockey jerseys
Ninguna es la respuesta correcta, porque se trata de insertar en una tabla con 6 columnas, 7 valores. Esas pruebas están muy mal hechas.