The SQL statement SELECT SUBSTR('abcdefghij', INSTR('123321234', '2', – McqOptions

MCQOPTIONS

1.	The SQL statement SELECT SUBSTR('abcdefghij', INSTR('123321234', '2', 3, 2), 2) FROM DUAL;prints
A.	gh
B.	23
C.	bc
D.	ab
Answer» B. 23

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