MCQs
Total Questions : 109
| Page 3 of 11 pages
Answer: Option D. -> MAX
Answer: Option B. -> AVG
Answer: Option B. -> A view is a virtual table which results of executing a pre-compiled query. A view is not part of the physical database schema, while the regular tables are.
Answer: Option C. -> SELECT
Answer: Option B. -> UPDATE
Answer: Option D. -> DELETE
Answer: Option C. -> ORDER BY
Answer: Option B. -> 2345
Answer: B. 2345
Explanation: The INSTR() function is used to find the first occurrence of a substring in a string. The syntax for INSTR() is INSTR(string, substring). In this question, the INSTR() function is used to find the first occurrence of the substring 'b' in the string 'abcabcabc'. The INSTR() function returns the position of the first occurrence of the substring, which is 2.
The SUBSTR() function is used to extract a substring from a given string. The syntax for SUBSTR() is SUBSTR(string, start_position, [length]). In this question, the SUBSTR() function is used to extract a substring from the string '123456789' starting at the position 2 and with a length of 4. Therefore, the output of the query is '2345'.
Answer: B. 2345
Explanation: The INSTR() function is used to find the first occurrence of a substring in a string. The syntax for INSTR() is INSTR(string, substring). In this question, the INSTR() function is used to find the first occurrence of the substring 'b' in the string 'abcabcabc'. The INSTR() function returns the position of the first occurrence of the substring, which is 2.
The SUBSTR() function is used to extract a substring from a given string. The syntax for SUBSTR() is SUBSTR(string, start_position, [length]). In this question, the SUBSTR() function is used to extract a substring from the string '123456789' starting at the position 2 and with a length of 4. Therefore, the output of the query is '2345'.
Answer: Option D. -> All of the above
Answer: Option B. -> 9