Which of the following statements would add a column job of type varchar 2 and size 20 to the already created Exhibition table? a. ALTER TABLE Exhibition add (job varchar2(20)); 1 b. ALTER TABLE...


Which of the following statements would add a column job of type varchar 2 and size 20 to the already created<br>Exhibition table?<br>a. ALTER TABLE Exhibition add (job varchar2(20));<br>1<br>b. ALTER TABLE Exhibition add column (job varchar2(20));<br>O c. ALTER TABLE Exhibition add job varchar2(20);<br>O d. ALTER TABLE Exhibition add column (job);<br>For a variable having value as str='BABY', what is the value of the function initcap(str) ?<br>а. ВАBY<br>b. Baby<br>O . BABY<br>O d. baby<br>For name='Daniel, what is the output of the function rpad(name,8,'$') ?<br>O a. Daniel<br>3<br>O b. $$Daniel<br>O c. $$$$$$$$<br>O d. Daniel$$<br>

Extracted text: Which of the following statements would add a column job of type varchar 2 and size 20 to the already created Exhibition table? a. ALTER TABLE Exhibition add (job varchar2(20)); 1 b. ALTER TABLE Exhibition add column (job varchar2(20)); O c. ALTER TABLE Exhibition add job varchar2(20); O d. ALTER TABLE Exhibition add column (job); For a variable having value as str='BABY', what is the value of the function initcap(str) ? а. ВАBY b. Baby O . BABY O d. baby For name='Daniel, what is the output of the function rpad(name,8,'$') ? O a. Daniel 3 O b. $$Daniel O c. $$$$$$$$ O d. Daniel$$

Jun 10, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here