Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
A. SELECT 'The first_name is " || first_name || " FROM (select 'user' first_name from dual); --O/P = ORA-00923: FROM keyword not found where expected
B. SELECT 'The first_name is ''' || first_name || '''' FROM (select 'user' first_name from dual); --O/P = The first_name is 'user'
C. SELECT 'The first_name is ''' || first_name || ''' FROM (select 'user' first_name from dual); --O/P = ORA-00923: FROM keyword not found where expected
D. SELECT 'The first_name is ' || first_name || '' FROM (select 'user' first_name from dual); --O/P = The first_name is user
E. SELECT 'The first_name is \" || first_name || '\" FROM (select 'user' first_name from dual); --O/P = ORA-24450: Cannot pre-process OCI statement
it depends on quotation mark, since we can not copy from this question normally you have to guess where are double qoutes and where are single ones, but if it like that:
SELECT 'The first_name is ' " || first_name || ' ' " FROM temp; (column name || first_name || ' ' )
SELECT 'The first_name is ' " || first_name || ' " FROM temp; (column name || first_name || ' )
SELECT 'The first_name is ' || first_name || ' ' FROM temp; ( The first_name is Jhon )
then 3 answers are right: BCD
Why its BD ? explain the reason logically & don't tell me I tested it.
In the exam there will be no tool to test anything if something changed so we need to understand the logic please.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
archit4321
3 weeks agoyaya32
4 months agolucemqy
6 months agoSushmasri
9 months, 3 weeks agojelenadinere_1
9 months, 4 weeks agozouve
11 months agoCyberP
11 months, 3 weeks agokuff
1 year agopmeyer
1 year agoMooonLight
1 year agoPoke90
1 year, 2 months agoOrakol
1 year, 2 months agojfc1
1 year, 3 months agodexdinh91
1 year, 4 months agocadcadley
1 year, 4 months agoViviana3184
1 year, 4 months agoabdullah_barham
1 year, 5 months ago