java theory question set 7 ( Balagurusamy )

 1. use of unconditional branching.

2. difference between entry controlled loop and exit controlled loop.

3. enhanced for loop

java theory question set 6 ( Balagurusamy )

 1. fall through

2. which is faster ??? ifelse or switch

3. use of ternary operator.

java theory question set 5 ( Balagurusamy )

 

1. What is mixed mode arithmatic?

2. Difference between >> and >>>.

3. generic type casting.

4.implicit ,explicit type casting.

5. operator priority and precedance

SQL - STEP BY STEP

 1.  SQL1 dept create table without primary key.

2. SQL2 data insertion into two ways.

3. SQL3 display dept table.

4. SQL4 display column in a table.

5. SQL5.USE OF WHERE IN A TABLE.

6. SQL6 display data where location=mumbai. 

7. SQL7 WHAT IS MAIN PROBLEM IF WE NOT USE ANY PRIMARY KEY IN A TABLE.

8. SQL8 DELETE THE TABLE DEPT.

9. SQL9 PRIMARY KEY CREATION IN TABLE.

10.  SQL10 ADVANTAGES OF PRIMARY KEY IN A TABLE.

11. SQL11 USE OF DESC IN SQL .

12.  SQL12 USE OF DEFAULT VALUE IN SQL TABLE.

13. SQL13 HOW FOREIGN KEY IS CREATED??

14. SQL14 WHY FOREIGN KEY IS USED??

15. SQL15 USE OF BETWEEN KEYWORD IN SQL.

16. SQL16 USE OF NOT BETWEEN IN SQL.

17. SQL17 CURRENT DATE USING SYSDATE IN SQL.

18. SQL18 DUAL TABLE IN SQL.

19.SQL19 ARITHMETIC OPERATION IN SQL USING DUAL TABLE. 

20.SQL20 COLUMN RENAME USING AS IN SQL.

21. SQL21 STRING PATTERN MATCHING. 

22. SQL22 ENDING WITH A LETTER. STRING PATTERN MATCHING. 

23.  SQL23 SATRTING WITH TWO LETTER।

24. SQL24 ENDING WITH TWO LETTER।

25. SQL25 STARTING AND ENDING WITH LETTER.

26. SQL26 SECOND LETTER MATCHING।

27. SQL27 3RD LETTER MATCHING। 

28. SQL28 4 LENTH NAME OR 4 LENGTH STRING।

 

29. SQL29 SECOND LETTER AND 4TH LETTER CHECKING. 

30. SQL30 a letter in ANY POSITION. 

31. SQL31 matches a SUBSTRING

32. SQL32 4 LENGTH BUT STARTING WITH A.

33. SQL33 4LENTH AND ENDING WITH A.

34. SQL34 NAME WITH TWO AA

35.  SQL35 FUNCTION OF COUNT() , COUNT() এর কাজ।

36. SQL36 FUNCTION OF MAX(), MAX() এর কাজ।

37. SQL37 FUNCTION OF MIN(), MIN () এর কাজ।

38.SQL38 FUNCTION OF SUM(), SUM() এর কাজ।

39. SQL39 FUNCTION OF AVG(), AVG()এর কাজ।

40. SQL40 USE OF IN, IN এর কাজ।

41. SQL41 FUNCTION OF NOT IN, NOT IN এর কাজ।

42.SQL42 FUNCTION OF GROUP BY. GROUP BY এর কাজ।

 

APPLY FAMILY IN R LANGUAGE: 3.SAPPLY () IN R LANGUAGE:

 APPLY FAMILY IN R LANGUAGE:

3.SAPPLY () IN R LANGUAGE:

1. MATRIX CREATION IN R LANGUAGE , ADDITION OF TWO MATRICES IN R LANGUAGE , SUBTRACTION OF TWO MATRICES IN R LANGUAGE, MULTIPLICATION OF TWO MATRICES IN R LANGUAGE, DIVISION OF TWO MATRICES IN R LANGUAGE -

 1. MATRIX CREATION IN R LANGUAGE , ADDITION OF TWO MATRICES IN R LANGUAGE , SUBTRACTION OF TWO MATRICES IN R LANGUAGE, MULTIPLICATION OF TWO MATRICES IN R LANGUAGE, DIVISION OF TWO MATRICES IN R LANGUAGE -

APPLY FAMILY IN R LANGUAGE: 1.APPLY() IN R LANGUAGE:

 APPLY FAMILY IN R LANGUAGE:

1.APPLY() IN R LANGUAGE: 

APPLY FAMILY IN R LANGUAGE: 2.LAPPLY() IN R LANGUAGE:

 APPLY FAMILY IN R LANGUAGE:

2.LAPPLY() IN R LANGUAGE:

MERGE SORT IN R LANGUAGE

 MERGE SORT IN R LANGUAGE -

MERGE SORT THEORY 

VECTOR USING RANDOM VALUES -

 VECTOR USING RANDOM VALUES - 

SELECTION SORT IN R LANGUAGE -

 SELECTION SORT IN R LANGUAGE  -

SELECTION SORT THEORY - 

RANDOMIZED QUICK SORT IN R LANGUAGE -

  RANDOMIZED QUICK SORT IN R LANGUAGE  - 

QUICK SORT THEORY 

INSERTION SORT IN R LANGUAGE -

 INSERTION SORT IN R LANGUAGE  - 

INSERTION SORT THEORY:

BUBBLE SORT IN R LANGUAGE -

 BUBBLE SORT IN R LANGUAGE  -

BUBBLE SORT THEORY - 

BINARY SEARCH IN R LANGUAGE -

 BINARY SEARCH IN R LANGUAGE  - 

BINARY SEARCH THEORY :

LINEAR SEARCH IN R LANGUAGE -

 LINEAR SEARCH IN R LANGUAGE  -

THEORY OF LINEAR SEARCH :

SUM AND AVERAGE OF ELEMENTS INVECTOR IN R LANGUAGE

 SUM AND AVERAGE OF ELEMENTS INVECTOR  IN R LANGUAGE

LARGEST AND SMALLEST ELEMENT IN VECTOR IN R LANGUAGE

  LARGEST AND SMALLEST ELEMENT IN VECTOR IN R LANGUAGE

NAME	C	C++	JAVA	PYTHON	R	VB	SHELL	JAVA SCRIPT	PHP
UNIQUE NUMBER	C	C++	JAVA	PYTHON	R	VB	SHELL	JAVA SCRIPT	PHP
HAPPY NUMBER	C	C++	JAVA	PYTHON	R	VB	SHELL	JAVA SCRIPT	PHP
STRONG NUMBER	C	C++	JAVA	PYTHON	R	VB	SHELL	JAVA SCRIPT	PHP
ARMSTRONG NUMBER	C	C++	JAVA	PYTHON	R	VB	SHELL	JAVA SCRIPT	PHP
PRONIC NUMBER	C	C++	JAVA	PYTHON	R	VB	SHELL	JAVA SCRIPT	PHP
KAPREKAR NUMBER	C	C++	JAVA	PYTHON	R	VB	SHELL	JAVA SCRIPT	PHP
KRISHNAMURTY NUMBER	C	C++	JAVA	PYTHON	R	VB	SHELL	JAVA SCRIPT	PHP
DEFICIENT NUMBER	C	C++	JAVA	PYTHON	R	VB	SHELL	JAVA SCRIPT	PHP
ABUNDANT NUMBER	C	C++	JAVA	PYTHON	R	VB	SHELL	JAVA SCRIPT	PHP
DISARIUM NUMBER	C	C++	JAVA	PYTHON	R	VB	SHELL	JAVA SCRIPT	PHP
UGLY NUMBER	C	C++	JAVA	PYTHON	R	VB	SHELL	JAVA SCRIPT	PHP
PERFECT NUMBER	C	C++	JAVA	PYTHON	R	VB	SHELL	JAVA SCRIPT	PHP
CATALAN NUMBER	C	C++	JAVA	PYTHON	R	VB	SHELL	JAVA SCRIPT	PHP
AUTOMORPHIC NUMBER	C	C++	JAVA	PYTHON	R	VB	SHELL	JAVA SCRIPT	PHP
DUCK NUMBER	C	C++	JAVA	PYTHON	R	VB	SHELL	JAVA SCRIPT	PHP
AMICABLE NUMBER	C	C++	JAVA	PYTHON	R	VB	SHELL	JAVA SCRIPT	PHP
PRIME NUMBER	C	C++	JAVA	PYTHON	R	VB	SHELL	JAVA SCRIPT	PHP
CYCLIC NUMBER	C	C++	JAVA	PYTHON	R	VB	SHELL	JAVA SCRIPT	PHP
FERMAT NUMBER	C	C++	JAVA	PYTHON	R	VB	SHELL	JAVA SCRIPT	PHP
MERSENNE NUMBER	C	C++	JAVA	PYTHON	R	VB	SHELL	JAVA SCRIPT	PHP
KEITH NUMBER	C	C++	JAVA	PYTHON	R	VB	SHELL	JAVA SCRIPT	PHP
LUCKY NUMBER	C	C++	JAVA	PYTHON	R	VB	SHELL	JAVA SCRIPT	PHP

VECTOR CREATION, MODIFICATION,DELETION,BASIC OPERARTION OF TWO VECTORS ( R LANGUAGE )

 VECTOR CREATION, MODIFICATION,DELETION IN R LANGUAGE

INDEXING, INDEXING WITH LOGICAL VALUES, INDEXING WITH CHARECTER VALUES IN R LANGUAGE

ADDITION OF TWO VECTORS IN R LANGUAGE

SUBTRACTION OF TWO VECTORS IN R LANGUAGE

MULTIPLICATION OF TWO VECTORS IN R LANGUAGE

DIVISION OF TWO VECTORS IN R LANGUAGE