Subjects
PRICING
COURSES
SIGN IN
Start Free Trial
Ragini G.
Performance Engineer at Cognizant, India for 18 months; M.S @ University of West Florida;
Tutor Satisfaction Guarantee
SQL Programming
TutorMe
Question:

$$How to retrieve details about the tutor name might be "Gummadi" from the TUTORME table ? $$

Ragini G.
Answer:

Select * from TUTORME where tutor_name like '%Gummadi%'; Like - will help to search words that are similar to your given condition. Now, If I don't use '%' then I will not receive accurate details. For example, there are two people with Gummadi names such as Gummadi_S and S_Gummadi. If my condition was "tutor_name like 'Gummadi' " - it gives me Gummadi_S so I gave "tutor_name like '%Gummadi%' "to retrieve all the rows for that condition.

Java Programming
TutorMe
Question:

$$ How to swap two values using just two variables?$$

Ragini G.
Answer:

$$ Usually, one would think of using temporary variable for swapping two variable. $$ $$ But I will show how we can swap by using just two variables to swap two values. $$ $$int a =10, b = 50; a = a + b; // was a - 10 and b - 50 -> now a - 60 & b - 50 b = a - b; // was a - 60 & b - 50 - > now a - 60 & b - 10 a = a - b; // was a - 60 & b - 10 -> now a - 50 & b - 10 $$ There are other possibilities as well. ping me to know.

Databases
TutorMe
Question:

$$ When is it advisable to denormalize the data? $$

Ragini G.
Answer:

$$When you need better performance of your database, you can do it. Else, it is advisable to not denormalize. For example, Let us take the transactional environment, in which, you should not provide all the details of the transaction, few columns or sensitive data needs to be locked up that time you need to put them in other tables to maintain integrity though the performance might affect. $$

Send a message explaining your
needs and Ragini will reply soon.
Contact Ragini
Ready now? Request a lesson.
Start Session
FAQs
What is a lesson?
A lesson is virtual lesson space on our platform where you and a tutor can communicate. You'll have the option to communicate using video/audio as well as text chat. You can also upload documents, edit papers in real time and use our cutting-edge virtual whiteboard.
How do I begin a lesson?
If the tutor is currently online, you can click the "Start Session" button above. If they are offline, you can always send them a message to schedule a lesson.
Who are TutorMe tutors?
Many of our tutors are current college students or recent graduates of top-tier universities like MIT, Harvard and USC. TutorMe has thousands of top-quality tutors available to work with you.