Let the statementSELECT column1 FROM myTable;return 10 rows. The state – McqOptions

MCQOPTIONS

1.	Let the statementSELECT column1 FROM myTable;return 10 rows. The statementSELECT ALL column1 FROM myTable;will return
A.	less than 10 rows
B.	more than 10 rows
C.	exactly 10 rows
D.	None of these
Answer» D. None of these

Discussion

No Comment Found

Related MCQs

Which of the following command makes the updates performed by the transaction permanent in the database?
The SQL statement SELECT SUBSTR('abcdefghij', INSTR('123321234', '2', 3, 2), 2) FROM DUAL;prints
The SQL statementSELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL;
What does the following query find?(SELECT DISTINCT r.sidFROM boats b, reserves rWHERE b.bid = r.bidAND b.color = 'red')MINUS(SELECT DISTINCT r.sidFROM boats b, reserves rWHERE b.bid = r.bidAND b.color = 'g
The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL;Outputs
Let the statementSELECT column1 FROM myTable;return 10 rows. The statementSELECT ALL column1 FROM myTable;will return
Find all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 79