What is the outcome the following query?

View the Exhibit and examine the structure of the EMPLOYEES table.
Examine the data in the ENAME and HIREDATE columns of the EMPLOYEES table:
ENAME HIREDATE
SMITH 17-DEC-80
ALLEN 20-FEB-81
WARD 22-FEB-81
You want to generate a list of user IDs as follows:
USERID
Smi17DEC80
All20FEB81
War22FEB81
You issue the following query:
SQL>SELECT CONCAT(SUBSTR(INITCAP(ename),1,3), REPLACE(hiredate,’-‘)) "USERID"
FROM employees;
What is the outcome?

View the Exhibit and examine the structure of the EMPLOYEES table.

Examine the data in the ENAME and HIREDATE columns of the EMPLOYEES table:
ENAME HIREDATE
SMITH 17-DEC-80
ALLEN 20-FEB-81
WARD 22-FEB-81

You want to generate a list of user IDs as follows:
USERID
Smi17DEC80
All20FEB81
War22FEB81

You issue the following query:
SQL>SELECT CONCAT(SUBSTR(INITCAP(ename),1,3), REPLACE(hiredate,’-‘)) “USERID”
FROM employees;

What is the outcome?

A.
It executes successfully and gives the correct output.

B.
It executes successfully but does not give the correct output.

C.
It generates an error because the REPLACE function is not valid.

D.
It generates an error because the SUBSTR function cannot be nested in the CONCAT function.



Leave a Reply 23

Your email address will not be published. Required fields are marked *


Google

Google

Usually posts some very interesting stuff like this. If you are new to this site.

CPA Medicaid Experience

CPA Medicaid Experience

Here are a few of the web pages we recommend for our visitors

military soldier blog

military soldier blog

we came across a cool web site that you might appreciate. Take a appear for those who want

tech

tech

that could be the end of this write-up. Right here youll come across some sites that we assume you will enjoy, just click the hyperlinks over

mentor

mentor

usually posts some incredibly interesting stuff like this. If you are new to this site

Convert your video files here

Convert your video files here

that would be the end of this report. Here you will come across some internet sites that we consider youll appreciate, just click the hyperlinks over

Free Games online

Free Games online

we came across a cool web-site that you simply might delight in. Take a search in case you want

create an app

create an app

although websites we backlink to beneath are considerably not associated to ours, we really feel they may be really worth a go as a result of, so have a look

satta matka

satta matka

Wonderful story, reckoned we could combine a couple of unrelated information, nevertheless genuinely really worth taking a search, whoa did one particular master about Mid East has got additional problerms also

Hawaiian Lava Veneers

Hawaiian Lava Veneers

Here are several of the internet sites we recommend for our visitors

app creator

app creator

one of our guests a short while ago encouraged the following website

Visit Website

Visit Website

here are some hyperlinks to web-sites that we link to mainly because we feel they may be really worth visiting

プラセンタ

プラセンタ

The info mentioned in the post are a number of the most beneficial available

インフルエンザ

インフルエンザ

just beneath, are numerous totally not associated sites to ours, even so, they may be surely worth going over

personalised shot glasses uk

personalised shot glasses uk

Sites of interest we’ve a link to

20ft shipping container homes cost

20ft shipping container homes cost

please stop by the sites we comply with, such as this 1, as it represents our picks from the web

buy youtube views

buy youtube views

one of our visitors not too long ago advised the following website

anal vibrator

anal vibrator

below you will come across the link to some web pages that we think you must visit

Diy Home Energy System Review

Diy Home Energy System Review

check below, are some entirely unrelated sites to ours, having said that, they may be most trustworthy sources that we use

fetish sex

fetish sex

please take a look at the web sites we follow, which includes this 1, as it represents our picks through the web

malay sex stories

malay sex stories

please visit the web sites we follow, such as this 1, as it represents our picks through the web