Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. Write the output of the following SQL command: (i) selectconcat(Lcase('To be'),trtm(traillng '.' From 'continued ... ')); (ii) select round(15.193,1) + truncate(2.24,1); (iii) selectlen(trim('Ajay#Jain###')) (#
1. Write the output of the following SQL command:
(i) selectconcat(Lcase('To be'),trtm(traillng '.' From 'continued ... '));
(ii) select round(15.193,1) + truncate(2.24,1);
(iii) selectlen(trim('Ajay#Jain###')) (# means blank space)
(iv) select mid(trim('#lnformatics Practices##'),6,6); (# means blank space)
2. There is a table Tl with combination of columns Cl, C2, and C3 as its primary key? Is it possible to enter:
a. NULL values in any of these columns?
b. Duplicate values in any of these columns?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started