In the CUSTOMERS table, the CUST_CITY column contains the value ‘Paris’ for the
CUST_FIRST_NAME ‘ABIGAIL’. Evaluate the following query: What would be the outcome?
A.
Abigail PA
B.
Abigail Pa
C.
Abigail IS
D.
an error message
What would be the outcome?
In the CUSTOMERS table, the CUST_CITY column contains the value ‘Paris’ for the
CUST_FIRST_NAME ‘ABIGAIL’. Evaluate the following query: What would be the outcome?
The right answer is A
select initcap(‘ABIGAIL’) || ‘ ‘ ||
UPPER(SUBSTR(‘Paris’,-LENGTH(‘Paris’),2))
from dual;
Abigail PA
B is correct. Example is using INITCAP on all words (check parenthesis). Your example is using INITCAP only on “Abigail”.
Try this:
select initcap((‘ABIGAIL’) || ‘ ‘ ||
UPPER(SUBSTR(‘Paris’,-LENGTH(‘Paris’),2)))
from dual;
Downlaod new Maddn 17 Coin Glitch and Generator game!
Best Madden NFL 17 Coin Glitch and Generator for unlimied Cash and Coins!
DOWNLOAD LINK : Madden NFL 17 Coin Glich and Generator
Cleared Oracle Database 11g 1Z0-051 exam last weekend!
Scored 90%! (The passing score is 60%)
There were 64 questions in my actual 1Z0-051 test.
Many questions on SQL statements (Examine, Evaluate…etc.), Manipulating Data (Insert, Update, Delete), Using DDL Statements to Create and Manage Tables.
Also, please pay close attention to questions on Reporting Aggregated Data Using the Group Functions, Using Subqueries to Solve Queries, Creating Schema Objects, a little difficult!
I mainly learned the PassLeader 1Z0-051 dumps (http://www.passleader.com/1z0-051.html) (303q VCE and PDF), all questions were from it, and many wrong answers have been corrected in it, the most valid 1Z0-051 dumps! DO RECOMMEND!!
By the way, part of that 303q 1Z0-051 dumps are available here:
http://www.oraclebraindump.com/?s=1z0-051
(
p.s. More 1Z0-051 exam questions on Google Drive: drive.google.com/open?id=0B-ob6L_QjGLpWXpBUEhyRnVXVlE
)
Good Luck!!!
Downlaod new Madden 17 Coin Glitch and Generator game!
Best Madden NFL 17 Coin Glitch and Generator for unlimied Cash and Coins!
DOWNLOAD LINK : Madden NFL 17 Coin Glich and Generator