MySQL Functions Sumita arora IP Solution || MySQL Functions Sumita arora IP Class 12 Solution || MySQL Functions IP || MySQL Functions Information Practices || MySQL Functions Sumita arora Information Practices Solution || MySQL Functions Sumita arora Information Practices Class 12 Solution || MySQL Functions Sumita arora Solution
Q1. Define a function.
Q2. What will be the output of following code?
mysql> SELECT CONCAT (CONCAT ('Inform', 'atics'), 'Practices');
Q3. What will be the output of following code?
mysql> SELECT LCASE ('INFORMATICS PRACTICES CLASS 11TH');
Q4. What will be the output of following code?
mysql> SELECT UCASE ('Computer studies');
Q5. What will be the output of following code?
mysql> SELECT CONCAT (LOWER ('Class'), UPPER ('xii'));
Q6. If Str = "INFORMATICS PRACTICES …." and Str1 = "... FOR CLASS XI"
Write commands to print the output as 'informatics practices for class xi'
Q7. Write commands to display the system date.
Q8. Write a command to display the name of current month.
Q9. Write SQL statement to display
Today, the date is <current date>
Q10. Write command to print the day of the week of your Birthday in the year 1999.
Q11. Write a command to display the current time.
Q12. Consider two fields B_date, which stores the birth date and J_date, which stores the joining date of an employee. Write commands to find out and display the approximate age of an employee as on today.
Q2. What will be the output of following code?
mysql> SELECT CONCAT (CONCAT ('Inform', 'atics'), 'Practices');
Q3. What will be the output of following code?
mysql> SELECT LCASE ('INFORMATICS PRACTICES CLASS 11TH');
Q4. What will be the output of following code?
mysql> SELECT UCASE ('Computer studies');
Q5. What will be the output of following code?
mysql> SELECT CONCAT (LOWER ('Class'), UPPER ('xii'));
Q6. If Str = "INFORMATICS PRACTICES …." and Str1 = "... FOR CLASS XI"
Write commands to print the output as 'informatics practices for class xi'
Q7. Write commands to display the system date.
Q8. Write a command to display the name of current month.
Q9. Write SQL statement to display
Today, the date is <current date>
Q10. Write command to print the day of the week of your Birthday in the year 1999.
Q11. Write a command to display the current time.
Q12. Consider two fields B_date, which stores the birth date and J_date, which stores the joining date of an employee. Write commands to find out and display the approximate age of an employee as on today.
are answers kahaan hai ? mujhe gussa ara h . eak toh hamare maam ji CS vallo ko IP ka syllabus padha rahI hAIN :(
ReplyDeleteClick on Question.
Deletekutta ji khush hue !! dosto bas question pe click karo aur answers pao
ReplyDelete: )
DeleteIt's 100% correct and reliable answer... Liked it.
ReplyDeleteThank you so much 🥰💘
DeleteThank you so so so much helped one day before preboards
ReplyDeleteWelcome 😊 and best of luck for your exams 👍👍
DeleteWelcome 😊😊
ReplyDeleteThanku sir
ReplyDeleteWelcome 😊😊😊
DeleteRespt sir you forgot to publish Question.10 nd Question.11 as per the textbook of Sumita Arora.
ReplyDeletePlease send me questions.
Deletewhere are rest of the questions?
ReplyDeletePlease tell me questions.
DeleteThank you so much Sir. Because of this website I have been able to self study IP. Many blessings from student community of 2022-2023.
ReplyDeleteWelcome 😊😊😊😊😊😊😊😊😊 All the best 👍👍👍👍👍👍👍👍
DeleteU're fantastic
ReplyDeletethank you :)
DeleteRest of questions ?
ReplyDeletePlease tell me question.
DeleteInclude this que as well : Anjali rights the following commands with respect to a table employee having fields empno, name, department,commission:
ReplyDeleteCommand1 : select count(*) from employee;
Command2 : select count (commission) from employee;
She gets the output as 4 for the first command but gets an output 3 for the second command explain the output with justification
That was que no. 10
DeleteQ)11 write the SQL function which will perform the following operations:
ReplyDelete1. To display the name of the month of the current date.
2. To remove spaces from the beginning and end of the string,"Panorama".
3. To display the name of the day example Friday or Sunday from your date of birth ,dob.
4. To display the starting position of your first name (fname) from your whole name (name).
5. To compute the remainder of division between two numbers , n1 and n2.
Post a Comment
You can help us by Clicking on ads. ^_^
Please do not send spam comment : )