Thursday, November 12, 2020

C++ question set (Balagurusamy) set -1

 CHAPTER 3


1. Dynamic Initialization of variables.

2. Reference variables.

3. Scope reslolution operator.

4. New and Delete operator.

java theory question set 12 ( Balagurusamy )

 1. what is thread

2. what is multithreading

3. different type of thread creation 

4. start() and run()

5. stopping and blocking a thread

6. life cycle of a thread

7. thread priority

8. thread exceptions

9. thread synchronization.




java theory question set 11 ( Balagurusamy )

 1. benefit of packages.

2. 


3. hierarchical representation of package

4. creation and access package

5. importing a class from other packages

6. access protection in package

7. hiding class in package




java theory question set 10 ( Balagurusamy )

 1. interface

2. extending interface

3. implementing interface

4.


5. accessing interface variable.

java theory question set 9 ( Balagurusamy )

 1. different type of array creation

2. how array is initialized?

3. 2d array creation and initialization.

4. variable size array.

5. mutable and immutable.

6. string and stringBuffer comparison

7. 


8. common stringBuffer method

9. wrapper class

10. autoboxing and unboxing

11. enumerated datatype.








java theory question set 8 ( Balagurusamy )

 1. method overloading

2. use of super.

3. static memebr

4.static function.

5. variable arguments

6.access specifier

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

Tuesday, November 10, 2020

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 এর কাজ।