Database Management
Accenture PrimermediumDatabase Management06 Function-Scalar & Aggregate

Select the suitable option for fetching the output of the following query. select substr("Oracle World",1,6) from dual;

Answer options

A
Oracle
B
World
C
Oracle W
D
racle W

Correct answer: Oracle

Explanation

SUBSTR('Oracle World', 1, 6) starts at position 1 and takes 6 characters = 'Oracle'.

Related Accenture Database Management questions

Tom has designed a payroll software for XYZ technology.The sofware will store the salary details into the database and l…In SQL is a case sensitive language and the data stored inside the table are case in-sensitive. Say true or false?Which of the following is not a valid relational database?Database is a shared collection of logically unrelated data, designed to meet the needs of an organization. State True o…Which of the following represents the degree of the relation?A table consists of ______ primary keys.

Practice more Accenture Database Management questions

PrimerDumps has 1400+ primer questions, 2026 mocks and coding hands-on — all free.

Database Management question bankAll subjects