Answer / vj

Join:It is the combining of two rows from different tables
based on the comparative values in selected columns.

Types of Join : Cross Join, Inner Join or equi join and
Outer Join which comprises of Left join and Right join.

Inner Join : It is used to select certain fields from both
tables and only correct rows will be joined together.
Sytax:SELECT <column_name> FROM <Table1>, <Table2> WHERE
(Table1.column = Table2.column)

Outer Join:
Left join: It returns all the data's from the table
present in left of the join and only those data's from the
right tabel which matches the condition.
Syntax:SELECT <column_name> FROM <Table1> LEFT JOIN
<Table2> ON Table1.column = Table2.column (Conditions like
WHERE and USING)

Right join: It returns all the data's from the table
present in right of the join and only those data's from the
left tabel which matches the condition.
Syntax:SELECT <column_name> FROM <Table1> LEFT JOIN
<Table2> ON Table1.column = Table2.column (Conditions like
WHERE and USING)

write a program that inputs two real numbers then exchanges their values.

7 Answers   Infosys,

---

Financial: credit card number validation) Credit card numbers follow certain patterns. A credit card number must have between 13 and 16 digits. It must start with: &#9632; 4 for Visa cards &#9632; 5 for Master cards &#9632; 37 for American Express cards &#9632; 6 for Discover cards In 1954, Hans Luhn of IBM proposed an algorithm for validating credit card numbers. The algorithm is useful to determine whether a card number is entered correctly or whether a credit card is scanned correctly by a scanner. All credit card numbers are generated following this validity check, commonly known as the Luhn check or the Mod 10 check, which can be described as follows (for illustration, consider the card number 4388576018402626): 1. Double every second digit from right to left. If doubling of a digit results in a two-digit number, add up the two digits to get a single-digit number. 2 * 2 = 4 2 * 2 = 4 4 * 2 = 8 1 * 2 = 2 6 * 2 = 12 (1 + 2 = 3) 5 * 2 = 10 (1 + 0 = 1) 8 * 2 = 16 (1 + 6 = 7) 4 * 2 = 8 2. Now add all single-digit numbers from Step 1. 4 + 4 + 8 + 2 + 3 + 1 + 7 + 8 = 37 3. Add all digits in the odd places from right to left in the card number. 6 + 6 + 0 + 8 + 0 + 7 + 8 + 3 = 38 4. Sum the results from Step 2 and Step 3. 37 + 38 = 75 5. If the result from Step 4 is divisible by 10, the card number is valid; otherwise, it is invalid. For example, the number 4388576018402626 is invalid, but the number 4388576018410707 is valid. Write a program that prompts the user to enter a credit card number as a long integer. Display whether the number is valid or invalid. Design your program to use the following methods: /** Return true if the card number is valid */ public static boolean isValid(long number) /** Get the result from Step 2 */ public static int sumOfDoubleEvenPlace(long number) /** Return this number if it is a single digit, otherwise, return * the sum of the two digits */ public static int getDigit(int number) /** Return sum of odd place digits in number */ public static int sumOfOddPlace(long number) /** Return true if the digit d is a prefix for number */ public static boolean prefixMatched(long number, int d) /** Return the number of digits in d */ public static int getSize(long d) /** Return the first k number of digits from number. If the * number of digits in number is less than k, return

0 Answers  

---

Write a java program to display multiplication table in a Frame.

1 Answers  

---

write a java program to create a Frame with three scrolls, change the back ground color of the frame using functions with values of scrolls.

0 Answers  

---

Program to print map of India in java.

2 Answers  

---

Bubble Sort. java thereafter the user will be asked to inpout the size of the list,sort the list in ascending order and display the sorted list in a horizontal manner???

0 Answers  

---

does anyone know the code to display a triangle using a applet?

1 Answers  

---

write a c program which takes 20 numbers in an array as input from user and rearrange them in two different array defining even or odd

0 Answers  

---

A game that has five levels of play has the score for each level stored in an array. You are to write a program that goes through that array and finds: a) the minimum score, and the level at which it occurred b) the maximum score, and the level at which it occurred c)the average score for all five levels The score data you must use for this program are as follows: Game Level Score 1 450 2 316 3 148 Stack implementations is mandatory.

0 Answers  

---

Why we r using String args[] in main() even though v r not passing any arguments in command line?

2 Answers  

---

1+(2*3)+(4*5*6)+(7*8*9*10)+... specified input value

1 Answers   MAQ,

---

how to store and retrive a set of values without using an array

8 Answers   FCS, HCL, Maximus,

---