Thursday, February 12, 2015

MSc-II (2014-2015)



CCE Marks

NAME RNO CODE SEM MARKS
JAAGRATI ASATI 143351 552033 2 9
MEENA PAROHA 143352 552033 2 7
MONIKA YADAV 143353 552033 2 8
NIDHI AGRAWAL 143354 552033 2 8
RAGINI JAIN 143355 552033 2 8
RAJ KUMAR SINGH 143356 552033 2 9
SHUBHAM UPADHYAY 143360 552033 2 7
UTKARSH SHARMA 143358 552033 2
-------------------------------------------------------------------------------------
    1. Practical Program List
     1.    Write a program in C for generating a line using line function.
     2.    Write a program in C for generating   Rectangle using rectangle function;
     3.    Write a program in C for generating     a circle using circle function 
     4.    Write a program in C for generating Create a triangle
     5.    Write a program in C for generating  Ven Diagram;
     6.    Write a program in C for generatin g Five Triangle
     7.   Write a program in C for Implement DDA line drawing algorithm.
     8.  Write a program in C for for ploting a Thick line using DDA line algorithm.
     9.   Write a program in C for Drawing a Straight  line Using Bresenhams Algorithm.
   10.   Write a program in C for drawing a dashed straight line using Bresenhams Algorithm. .
   11.   Write a program in C for drawing a thick straight line using Bresenhams Algorithm. .
   12.   Write a program in C to draw a Circle using MID Circle Algorithm.
   13.   Write a program in C to draw a Dashed circle using MID circle Algorithm.



  2. Unit - 1 (Marks - 2.5)
  Topic Assigned for Presentation
     1. Jagrati      -  Applications of Computer Graphics
     2. Nidhi        -  Refresh Cathode Ray Tubes,
     3. Ragini      -  Raster Screen Display  and Random Screen Display
     4. Shubham  -  Flat Panel Displays,
     5. Rajkumar  - LCD.
     6. Monika  -   Input Devices and Hardcopy Devices
     7. Meena   -   Architecture of Raster Scan and Random Scan display systems
at No comments:
Labels:

Tuesday, February 10, 2015

BCA- IV (2014-15)

Unit - 1 ( Marks - 5)

Topic Assigned for Presentation
1. Java Program Structure       -       Vipin, Prashant, Vikas
2. Token and Structure            –      Sakshi, Saturan, Akansha
3. JVM( Java Virtual Machine)  –      Subhashree, Shubhi, Sonalika
4. Constant / Variable               –      Deepanjali, Roma, Rohini
5. Data Type                           -       Aishwarya, Sagar, Surya
6. Operators                           –        Nishu, Aman, Nishant,
7. Conditional Operation and Branching – Nikita, Prerna, Surbhi,
8. Scope of the  Variable          -         Poornima, Akansha, Veena
9. Java Java Virtual Machine     -         Preeti, Rubi, Shivani.
10. Type Casting                     -         Shrishti, Ayushi, Jisa
11. C++ Vs Java, Java Internet/www  -  Karan, Shubham, Mushraf
12. Looping Statement in Java    -   Shubhank, Mayank, Himanshu.


CCE (Unit - 1)
Group - 2: Token and Structure  
Akansha Tiwari:  3.5/5
Sakshi Pandey: 3/5
Seturan: 2.5/5
Question -1:What is label Statement? by Surya Garg
Answered by: Akansha (Satisfied).
Question - 2: What are literal? by Shivani
Answered by: Akansha, Sakshi (Satisfied).

Comments by Manish Tiwari ( Faculty)
1. Saturan did not prepared well even she does not answered any question.
2. Low confidence with all the three presenter.

Group - 3: JVM( Java Virtual Machine)
Subhshree Das: 3/5
Sonalika: 2.5/5
Shubhi: 3/5

Question -1:What is Difference between Compiler and Interpretor? by Manish Tiwari
Answered by:
Question - 2: When the interpreter executed: Run time or Compile time ? by 
Answered by: Wrong Answered.

Comments by Manish Tiwari ( Faculty):
1. Preparation not done before presentation.
2.  Subject not studied.

Group - 4: (Constant and Variable)
Deepanjali Patel: 3.5/5
Roma Khatton:  2.5/5
Rohani Prajapati: 2.5/5

Question -1: When to use Integer type and when to use real data?
Answered by: Not Answered
Question -2: What is application of static variable?
Answered by:NA
Question -3: Example of instance variable?
Question -4: Difference between instance variable/static variable?
Answered by: Deepanjali - Correct Answer.
Question -5: Example string Variable? Asked by Shrishti.
Answered by: Deepanjali.

Group - 5: JVM( Java Virtual Machine)
Sumit Deodhar:  1.75/5

Group - 6: (Type Casting)
Swechha: 3/5
Priyanshi: 2.5/5
Nisha: Absent - Taken Permission from Mala Madam.

Question -1: Example of type casting? Asked by Poornima
Answered by: Deepanjali.
Question - 2:  What is use application of type casting? Asked Akansha Gupta.


Group - 7: Looping Statement in Java
Shubhank: 2/5
Himanshu: 2/5
Mayank: Absent - Medical Reason.

 Group - 8: Operators                        
Nishant:  Absent
Nishu:   Absent
Aman Jain: 2/5

Question -1: What is precedence sequence  arithmetic operator ?
Answered: Wrong Answer.
Question - 2: What is precedence sequence of relational operator?
Answered: Wrong Answer.

Group - 9: Java Program Structure
Prashant: 3/5
Vipin:     Absent
Vikas:     Absent

 Group - 10: Data Types
Aishwarya: 2.5
Sagar:    2.5
Surya:  3.5

Question - 1:Explain the real time application of Boolan Data Type?
Answered: Surya Garg

Group - 11: JVM ( Java Virtual Machine)
Rubi: Absent ( Taken permission)
Shivani: 3/5
Preethi: 2.5/5

Question - 1:  What is difference between compiler and JVM?
Answer: Shivani.
Question - 2:  Advantage of JVM? Any Four?
Answer: Not Answered.
Question - 3:  Why Java is platform Independent?
Answer: Not Answered.

Group - 12: Type Casting
Sister Jisha: 4.5/5
Ayushi: 4.5/5
Shrishti: 3.75/5

 Question -1: Example of Implicit Type casting? by Shivam.
Question -2: Application of Type Casting? by Aman jain.


Group - 13: C++ Vs Java, Java Internet/www  
Saharyar Mushraf : 2.75/5
karan Dirdhar:  New Topic will be given
Shubham Yadav: Absent( Medical Reason)

Question -1: What is used for replacement of Multilevel inheritance in Java?


Group - 14:  Conditional Operation and Branching 
Nikita: 4/5
Prerna: 4.25/5
Surbhi: 4.25/5
Question -1:Difference between break and Continue
Question -2:what is difference  conditional and if

Group - 15: Scope of Variable
Poornima:  2/5
Akansha:   2/5
Veena:  2/5
-----------------------------------------------------------------------------------------------------------------------

Final CCE Marks
SlNo Name Number JAVA
(20)
1 AAKANKSHA GUPTA 3137201 14
2 AISHWARY DUBEY 3137206 15
3 AKANKSHA TIWARI 3137207 18
4 AMAN JAIN 3137208 13
5 AYUSHI KHANDELWAL 3137213 19
6 CHOUDHARI M. SHAHERYER 3137214 14
7 DEEPANJALI PATEL 3137215 17
8 GAURAV SHARMA 3137217 14
9 HIMANSHU SAGGAR 3137219 15
10 JISHA CHACKO 3137221 18
11 KARAN GIRDHAR 3137222 15
12 MAYANK MEHTA 3137224 15
13 NIKITA RAJPUT 3137226 17
14 NISHA TOPPO 3137227 15
15 NISHANT KUMAR SINGH 3137228 17
16 NISHU KUSHWAHA 3137229 16
17 POORNIMA SHARMA 3137231 14
18 PRASHANT CHAUHAN 3137233 15
19 PRATEEK PATEL 3137235
20 PREETI SHRESHTH 3137236 16
21 PRERNA CHATURVEDI 3137237 17
22 PRIYANSHI RAI 3137238 16
23 ROHINI PRAJAPATI 3137240 16
24 ROMA KHATOON 3137241 17
25 RUBI KUMARI 3137242 16
26 SAGAR PATHAK 3137269 14
27 SAKSHAM LODHI 3137243
28 SAKSHI PANDEY 3137244 16
29 SETURAN GUPTA 3137247 16
30 SHIVANI SIRSATH 3137250 16
31 SHRISHTI CHOUKSEY 3137251 17
32 SHUBHAM YADAV 3137254 16
33 SHUBHANK GULATI 3137255 15
34 SHUBHI DWIVEDI 3137256 15
35 SONALIKA SINHA 3137258 16
36 SUBHASHREE DAS 3137259 14
37 SUMIT DEODHAR 3137261 14
38 SURABHI KOSTA 3137262 17
39 SURYA GARG 3137263 16
40 SWECHHA PATEL 3137264 17
41 VEENA PILLAI 3137266 14
42 VIPIN KUMAR SHUKLA 127347 11
43 VIKAS PAL 127346 0
44 SWAPNIL RAI



at No comments:
Labels:

Tuesday, January 13, 2015

BSc-IV(2014-15)

        

CCE Marks CS- Physics
NAME RNO CODE SEM JAVA SQL MARKS
AADITYA RAJ SINGH CHAUHAN 131156 214132 4 5 5 10
ABHAY KUMAR 131158 214132 4 5 6 11
ABHAY PANDEY 131159 214132 4 5 4 9
ABHAY VICKRAM SINGH TOMAR 131160 214132 4 5 4 9
ABHISHEK PATEL 131161 214132 4 5 4 9
AJAY SINGH RAGHUWANSHI 131165 214132 4 5 4 9
AKANKSHA NAMDEO 131166 214132 4 5 6 11
AKANSHA NAKRA 131167 214132 4 6 7 13
ALIFIA SHAHANAZ 131170 214132 4 #######
ALKA SINGH 121207 214132 4 5 4 9
ALOK KUMAR HARDAHA 131171 214132 4 6 6 12
AMIT SINGH 121211 214132 4 5 7 12
ANJALI DIXIT 131177 214132 4 6 5 11
ANKIT FOUJDAR 131179 214132 4 5 4 9
ANKIT KUMAR PANDEY 121216 214132 4 5 4 9
ANKUR UPADHYAY 131182 214132 4 5 6 11
ARCHANA RAJPOOT 131184 214132 4 5 6 11
ARTI KURMI 131186 214132 4 5 4 9
ASHA SHARMA 131187 214132 4 6 4 10
ASHWATI NAIR 131188 214132 4 7 6 13
ATUL STHAPAK 131190 214132 4 5 5 10
AYUSH MISHRA 131191 214132 4 5 4 9
AYUSHI KANKANE 131192 214132 4 7 6 13
AYUSHI SARAOGI 131193 214132 4 7 6 13
DARSHNA CHOURASIA 131195 214132 4 5 6 11
DEEPAK SHUKLA 131196 214132 4 5 6 11
DEVANTI MARKAM 131199 214132 4 5 4 9
DIVYANSHA PATEL 131201 214132 4 5 5
EVON PETER 131202 214132 4 5 5 10
HARSHA GUSAIN 131205 214132 4 5 5 10
HARSHIT SHRIVASTAVA 131206 214132 4 5 4 9
HARSHITA GADEKAR 131207 214132 4 5 6 11
HARSHITA PATEL 131208 214132 4 6 6 12
HEMANTRAJ YADAV 121240 214132 4 5 4 9
HIMANSHU GARG 131209 214132 4 5 5 10
IRAM KHAN 131212 214132 4 5 4 9
JAYANTI RAGHUWANSHI 131214 214132 4 4 4
JITENDRA SINGH PARIHAR 131215 214132 4 5 4 9
JYOTI PATEL 131218 214132 4 7 5 12
KANCHAN CHOUKSEY 131219 214132 4 5 4 9
KARUNA SINGOUR 131221 214132 4 5 6 11
KEVAL UPADHYAY 131222 214132 4 5 4 9
KRITIKA JHA 131223 214132 4 6 6 12
KUMARI DIVYA JHARIYA 131224 214132 4 6 6 12
LALIT KUMAR SINGH 131225 214132 4 5 6 11
LALIT SINGOUR 131226 214132 4 5 4 9
MALA RAJAK 131227 214132 4 7 6 13
MAYANK RAJAN CHHIRA 131230 214132 4 7 4 11
MOHAMMAD SAQIB 121260 214132 4 5 4 9
MOHIT KUMAR CHOURASIYA 131232 214132 4 5 6 11
MONIKA SHARMA 131234 214132 4 7 4 11
NARMETA SINGH 131238 214132 4 5 6 11
NAZNEEN ANJUM MANSOORI 131239 214132 4 7 6 13
NEHA SEN 131240 214132 4 6 5 11
NEHA SINGH 121266 214132 4 5 4 9
NIDHESH PATEL 131241 214132 4 7 7 14
NIRMAL KAUR MANN 131246 214132 4 5 7 12
NISHA BARMAN 131247 214132 4 6 4 10
NISHA PATEL 131248 214132 4 7 4 11
PARUL SONI 131250 214132 4 7 7 14
POOJA  VISHWAKARMA 131251 214132 4 5 6 11
POOJA KACHHI 131252 214132 4 5 6 11
POOJA PATEL 131253 214132 4 6 6 12
POOJA  VISHWAKARMA 131254 214132 4 4 4
POORNITA PATEL 131255 214132 4 5 6 11
PRACHI MARAVI 131256 214132 4 4 4
PRAVEEN KUMAR PATHAK 131258 214132 4 5 5 10
PRAVEEN KUMAR TRIPATHI 131259 214132 4 4 4 8
PRAYAG PATHAK 131260 214132 4 5 4 9
PRINSHEE RAI 131262 214132 4 5 4 9
PRIYA DWIVEDI 131263 214132 4 6 6 12
PRIYA KACHHI 131264 214132 4 5 4 9
PRIYA TIWARI 131265 214132 4 6 6 12
PRIYANKA KANHOUA 131267 214132 4 6 4 10
PRIYANKA SAHU 131268 214132 4 6 5 11
PRIYANSHI CHOURASIA 131269 214132 4 6 4 10
PRIYANSHU CHOURASIA 131270 214132 4 5 4 9
RAJSHREE NAIDU 131274 214132 4 5 6 11
RAVENDRA KUMAR YADAV 131275 214132 4 #######
RAVI KUMAR YADAV 131276 214132 4 5 4 9
RISHIVA SONI 131278 214132 4 4 4
RIYA CHOURASIYA 131279 214132 4 5 6 11
RUCHI SINGH 131280 214132 4 5 4 9
SACHIN UIKEY 131281 214132 4 5 4 9
SAKSHI SINGH 131285 214132 4 5 5 10
SAKSHI THAKUR 131286 214132 4 5 5 10
SARIKA TIWARI 131288 214132 4 5 6 11
SARITA SHRIPAL 131289 214132 4 5 4 9
SHAHRUKH KHAN 131291 214132 4 6 4 10
SHEEBA BANO 131294 214132 4 5 5 10
SHIKHA SINGH TOMAR 131295 214132 4 6 4 10
SHIVANGI YADAV 131298 214132 4 5 4 9
SHIVANI BAIN 131299 214132 4 5 5 10
SHIVANI CHOUDHARI 131300 214132 4 5 5 10
SHIVANI PATEL 131301 214132 4 5 4 9
SHIVKUMAR PATEL 131303 214132 4 5 5 10
SHRUTI JAIN 131304 214132 4 5 4 9
SHUBHAM BHIRANI 131305 214132 4 5 5 10
SHUBHAM DAHIYA 131306 214132 4 5 4 9
SHUBHAM KUMAR KURMI 131308 214132 4 4 4
SHUBHANK PAROHA 131310 214132 4 5 5 10
SHWETA BHARTI 131312 214132 4 7 7 14
SONALI JAIN 131313 214132 4 5 4 9
SOUMYA UPADHYAY 131314 214132 4 5 4 9
SOURBH SAHU 121320 214132 4 5 4 9
SUBHAM MARATHA 121337 214132 4 5 4 9
SUDHEER BHANWARE 131315 214132 4 5 6 11
SUMAN GUSAIN 131316 214132 4 5 5 10
SUNIL GUPTA 121344 214132 4 5 4 9
SWATI BHATT 131318 214132 4 6 6 12
SWATI KANOJIYA 131319 214132 4 5 4 9
SWECHHA CHOURASIA 131321 214132 4 5 6 11
TANUSHREE CHATTERJEE 131322 214132 4 7 6 13
UPASNA SINGH RAJPOOT 131324 214132 4 7 7 14
VAISHALI PARAS 131325 214132 4 5 4 9
VIKAS MISHRA 131326 214132 4 7 6 13
VIMLESH DUBEY 131327 214132 4 5 3 8
VINEET KUMAR SINGH 121356 214132 4 4 4
WILLIAM MARTIN 121360 214132 4 5 4 9
YAMINI SINGH 131330 214132 4 #######

CCE Marks CA

NAME RNO CODE SEM Java SQL MARKS
AKASH PANDEY 131376 214142 4 4 4
ANCHAL MISHRA 131378 214142 4 5 4 9
ANJALI KHARE 131379 214142 4 5 4 9
ANJALI SONI 131380 214142 4 7 5 12
ANKITA PATHAK 131381 214142 4 6 4 10
BARKHA BHARTI 131382 214142 4 7 5 12
DEEKSHA UPADHYAY 131383 214142 4 5 6 11
DEEPAK THAKUR 131384 214142 4 5 6 11
MONIKA JAIN 131390 214142 4 5 4 9
PAWAN KUMAR  PATEL 121433 214142 4 ########
PRAGYA NEMA 131391 214142 4 5 4 9
PRAMOD KUMAR VISHWAKARMA 131392 214142 4 5 4 9
PRIYANKA VISHWAKARMA 131393 214142 4 5 5 10
RAVI KUMAR GUPTA 121436 214142 4 5 4 9
SANDEEP KUMAR PARASTE 131394 214142 4 5 4 9
SHEETAL JHARIYA 131396 214142 4 5 4 9
SHOBHIT PATEL 111208 214142 4 ########
SHUBHAM RAI 131398 214142 4 5 4 9
SIDDHARTH CHOUKSEY 131401 214142 4 5 4 9
VAISHALI MISHRA 131403 214142 4 5 5 10

CCE Marks ECO
NAME RNO CODE SEM Java SQL MARKS
ADARSH CHOURASIA 131338 214132 4 4 4
AIJAZ AHMED 121401 214132 4 5 5 10
ALLWYN YESUDAS 131340 214132 4 5 4 9
ANUSHRI DUBEY 131342 214132 4 6 5 11
DARSHIKA AGRAWAL 131343 214132 4 5 4 9
KIRTI SINGH LODHI 131345 214132 4 5 6 11
KRATI PALIWAL 121431 214132 4 ########
MADHUBALA NAGDEO 131346 214132 4 5 5 10
MAYANK NARAYAN  TIWARI 131347 214132 4 5 5 10
NAMRATA PAUL 131349 214132 4 7 6 13
NIKITA PAUL 131350 214132 4 7 6 13
OM PRAKASH MARKO 131351 214132 4 6 5 11
PRAGYA SHARMA 131354 214132 4 7 6 13
RAGINI SHARMA 131356 214132 4 5 6 11
RAJDEEP YADAV 131357 214132 4 4 4
RINKEE 131359 214132 4 5 4 9
RIYA RAJPUT 131361 214132 4 5 5 10
SAMIKSHA KUSHWAHA 131362 214132 4 7 4 11
SANGEETA 131363 214132 4 5 4 9
SHRADDHA KORI 131364 214132 4 5 4 9
SHREYA DUBEY 131365 214132 4 7 4 11
SHUBHAM CHAURASIYA 131366 214132 4 5 4 9
SIDDHARTH SINGHAI 121414 214132 4 5 6 11
SOURABH RAI 131369 214132 4 6 4 10
UTKARSH KACHHWAH 131371 214132 4 5 4 9
VIJAY KUMAR PATEL 131372 214132 4 ########
VIPIN RATHIYA 131373 214132 4 5 4 9







--------------------------------------------------


Assignment 

Note:      Write all the   question 3 times in your copy.

1-      Explain Join and Its Types?
2-      Explain the Normalization and All normalization 1NF, 2NF, 3NF, 4NF and 5 NF.
3-      Explain the Cursor and Its attribute.

4-      Write about Trigger and Its type.
-------------------------------------------------------------------------------------------------------------------------
Link: Practical Exam Batch List

 BSc(CS PHY) Practical 15.4.15
SQL & JAVA
Time-8.15 AM 
FIRST BATCH FOR PRACTICAL 
SN NAME SN NAME
1 AADITYA RAJ SINGH CHAUHAN 37 HARSHIT SHRIVASTAVA
2 ABHAY KUMAR 38 HARSHITA GADEKAR
3 ABHAY PANDEY 39 HARSHITA PATEL
4 ABHAY VICKRAM SINGH TOMAR 40 HEMANTRAJ YADAV
5 ABHISHEK PATEL 41 HIMANSHU GARG
6 ABHISHEK TIWARI 42 INDU YADAV
7 AJAY SINGH RAGHUWANSHI 43 IRAM KHAN
8 AKANKSHA NAMDEO 44 JAYANT SAHU
9 AKANSHA NAKRA 45 JAYANTI RAGHUWANSHI
10 ALIFIA SHAHANAZ 46 JITENDRA SINGH PARIHAR
11 ALKA SINGH 47 JYOTI PATEL
12 ALOK KUMAR HARDAHA 48 KANCHAN CHOUKSEY
13 AMIT BOHRE 49 KARUNA SINGOUR
14 AMIT KOSHTA 50 KEVAL UPADHYAY
15 AMIT SINGH 51 KRITIKA JHA
16 ANJALI DIXIT 52 KUMARI DIVYA JHARIYA
17 ANKIT FOUJDAR 53 LALIT KUMAR SINGH
18 ANKIT KUMAR PANDEY 54 LALIT SINGOUR
19 ANKUR KESHARWANI 55 MALA RAJAK
20 ANKUR UPADHYAY 56 MAYANK RAJAN CHHIRA
21 ARCHANA RAJPOOT 57 MEGHA SHUKLA
22 ARTI KURMI 58 MOHAMMAD SAQIB
23 ASHA SHARMA 59 MOHIT KUMAR CHOURASIYA
24 ASHWATI NAIR 60 MONIKA SHARMA
25 ATUL STHAPAK 61 NARMETA SINGH
26 AYUSH MISHRA 62 NAZNEEN ANJUM MANSOORI
27 AYUSHI KANKANE 63 NEHA SEN
28 AYUSHI SARAOGI 64 NEHA SINGH
29 DARSHNA CHOURASIA 65 NIDHESH PATEL
30 DEEPAK SHUKLA 66 NIRMAL KAUR MANN
31 DEEPIKA PANDEY 67 NISHA BARMAN
32 DEVANTI MARKAM 68 NISHA PATEL
33 DHARMENDRA PATEL 69 PANKAJ BEDUA
34 DIVYANSHA PATEL 70 PARUL SONI
35 EVON PETER
36 HARSHA GUSAIN
BSc(CS PHY) Practical 15.4.15
SQL & JAVA
Time-12.00 PM 
SECOND BATCH FOR PRACTICAL 
SN NAME SN NAME
71 POOJA  VISHWAKARMA 108 SHIVANGI YADAV
72 POOJA KACHHI 109 SHIVANI BAIN
73 POOJA PATEL 110 SHIVANI CHOUDHARI
74 POOJA VISHWAKARMA 111 SHIVANI PATEL
75 POORNITA PATEL 112 SHIVANI SINGH
76 PRACHI MARAVI 113 SHIVKUMAR PATEL
77 PRAVEEN KUMAR PATHAK 114 SHRUTI JAIN
78 PRAVEEN KUMAR TRIPATHI 115 SHUBHAM BHIRANI
79 PRAYAG PATHAK 116 SHUBHAM DAHIYA
80 PRINSHEE RAI 117 SHUBHAM KUMAR KURMI
81 PRIYA DWIVEDI 118 SHUBHANK PAROHA
82 PRIYA KACHHI 119 SHULABH  CHATURVEDI
83 PRIYA TIWARI 120 SHWETA BHARTI
84 PRIYANK MUKHERJEE 121 SONALI JAIN
85 PRIYANKA KANHOUA 122 SOUMYA UPADHYAY
86 PRIYANKA SAHU 123 SUBHAM MARATHA
87 PRIYANSHI CHOURASIA 124 SUDHEER BHANWARE
88 PRIYANSHU CHOURASIA 125 SUMAN GUSAIN
89 PRIYESH GUPTA 126 SUNIL GUPTA
90 RAGHVENDRA SINGH THAKUR 127 SWATI BHATT
91 RAJSHREE NAIDU 128 SWATI KANOJIYA
92 RAVENDRA KUMAR YADAV 129 SWATI PILLAI
93 RAVI KUMAR YADAV 130 SWECHHA CHOURASIA
94 RISHIVA SONI 131 TANUSHREE CHATTERJEE
95 RIYA CHOURASIYA 132 UPASNA SINGH RAJPOOT
96 RUCHI SINGH 133 VAISHALI PARAS
97 SACHIN UIKEY 134 VIKAS MISHRA
98 SAHIL KHAN 135 VIMLESH DUBEY
99 SAKSHI HARDAHA 136 VINEET KUMAR SINGH
100 SAKSHI SINGH 137 WILLIAM MARTIN
101 SAKSHI THAKUR 138 YAMINI SINGH
102 SARIKA TIWARI 139 YOUNAS KISPOTTA
103 SARITA SHRIPAL
104 SHAHRUKH KHAN
105 SHEEBA BANO
106 SHIKHA SINGH TOMAR
107 SHIVAM TIWARI
BSc(CA/CA) Practical 15.4.15
SQL & JAVA
Time-1.15 AM 
THIRD BATCH FOR PRACTICAL 
CA ECO
SN NAME SN NAME
140 AKASH PANDEY 159 ADARSH CHOURASIA
141 ANCHAL MISHRA 160 AIJAZ AHMED
142 ANJALI KHARE 161 ALLWYN YESUDAS
143 ANJALI SONI 162 ANUSHRI DUBEY
144 ANKITA PATHAK 163 DARSHIKA AGRAWAL
145 ARPIT SHRIVASTAVA 164 KIRTI SINGH LODHI
146 BARKHA BHARTI 165 MADHUBALA NAGDEO
147 DEEKSHA UPADHYAY 166 MAYANK NARAYAN  TIWARI
148 DEEPAK THAKUR 167 NAMRATA PAUL
149 MONIKA JAIN 168 NIKITA PAUL
150 PRAGYA NEMA 169 OM PRAKASH MARKO
151 PRAMOD KUMAR VISHWAKARMA 170 POORVI PATEL
152 PRIYANKA VISHWAKARMA 171 PRAGYA SHARMA
153 RAVI KUMAR GUPTA 172 RAGINI SHARMA
154 SANDEEP KUMAR PARASTE 173 RAJDEEP YADAV
155 SHEETAL JHARIYA 174 RINKEE
156 SHUBHAM RAI 175 RIYA RAJPUT
157 SIDDHARTH CHOUKSEY 176 SAMIKSHA KUSHWAHA
158 VAISHALI MISHRA 177 SANGEETA
178 SHRADDHA KORI
179 SHREYA DUBEY
180 SHUBHAM CHAURASIYA
181 SHUBHAM DUBEY
182 SIDDHARTH SINGHAI
183 SOURABH RAI
184 UTKARSH KACHHWAH
185 VIJAY KUMAR PATEL
186 VIPIN RATHIYA
----------------------------------------------------------------------------------------------------------------------------------

Viva and CCE for Remaing  students will be Conducted on 

 10/Apr/2015
At 12: O'clock Noon
---------------------------------------------------------------------------------------------------------------------------------
1. Logical Operator/  Relational Operator/ Pattern Matching/ Range Searching Query
 1. SELECT ENAME, SAL FROM EMP
WHERE  sal < 3000;
2. SELECT ENAME, SAL FROM EMP
WHERE  sal > 3000;
3. SELECT ENAME, SAL FROM EMP
WHERE  sal = 3000;
4. SELECT ENAME, SAL FROM EMP
WHERE  sal <> 3000;
5. SELECT ENAME, SAL FROM EMP
WHERE  sal  <= 3000;
6. SELECT ENAME, SAL FROM EMP
WHERE  sal  >= 3000;
7. SELECT ENAME, SAL FROM EMP
WHERE  sal  > 3000
     AND  sal  < 4000;
8. SELECT ENAME, SAL FROM EMP
WHERE  sal  > 3000  OR sal  < 4000;
9. SELECT ENAME, SAL FROM EMP
WHERE  SAL BETWEEN 1000 AND 3500;
10. SELECT ENAME, SAL FROM EMP
WHERE  SAL  IN(1000,3500,1100,1500);
11. SELECT ENAME, SAL FROM   EMP
WHERE ename LIKE   '%E%';  
12. SELECT ENAME, SAL FROM   EMP
WHERE ename LIKE   'M%';  
13. SELECT ENAME, SAL FROM   EMP
WHERE ename LIKE   '%M';
14. SELECT ENAME, SAL FROM   EMP
WHERE ename LIKE   'A%M';
15. SELECT ENAME, SAL FROM   EMP
WHERE ename LIKE   '__A%';
16. SELECT ENAME, SAL FROM EMP
WHERE  SAL  NOT BETWEEN 1000 AND 3500;
17. SELECT ENAME, SAL FROM EMP
WHERE  SAL NOT  IN(1000,3500,1100,1500);
18. SELECT ENAME, SAL FROM EMP
WHERE  SAL NOT  IN(1000,3500,1100,1500)
ORDER BY ENAME, SAL ASC;
19. SELECT ENAME, SAL FROM EMP
WHERE  SAL NOT  IN(1000,3500,1100,1500)
ORDER BY ENAME DESC;

2. String Function
1. SELECT  NAME
               ,LOWER(NAME)
               ,UPPER(NAME)
               ,INITCAP(NAME)
               ,ASCII(NAME)
               ,LENGTH(NAME)
               , CONCAT(LOWER(NAME),UPPER(NAME))
               ,LPAD(NAME,20,'*')
               ,RPAD(NAME,20,'*')
               ,LTRIM(NAME,'A')
               ,RTRIM(NAME,'E')
               ,REPLACE(NAME,'EE','I')
               ,SUBSTR(NAME,1,3)
               ,SUBSTR(NAME,2,5)
               ,SUBSTR(NAME,2,2)
FROM emp;

2. SELECT    CHR(34)  FROM DUAL;

3. Number Function
1. SELECT ABS(-56) FROM DUAL;
2. SELECT ABS(+56) FROM DUAL;
3. SELECT MOD(56,6) FROM DUAL;
4. SELECT MOD(17,4) FROM DUAL;
5. SELECT MOD(23,2) FROM DUAL;
6. SELECT POWER(2,2) FROM DUAL;
7. SELECT POWER(5,3) FROM DUAL;
8. SELECT POWER(8,8) FROM DUAL;
9. SELECT SQRT(64) FROM DUAL;
10. SELECT SQRT(8) FROM DUAL;
11. SELECT SQRT(23) FROM DUAL;
12. SELECT SIGN(-98) FROM DUAL;
13. SELECT SIGN(98) FROM DUAL;
14. SELECT CEIL(86.50) FROM DUAL;
15. SELECT CEIL(86.23) FROM DUAL;
16. SELECT CEIL(86.75) FROM DUAL;
17. SELECT FLOOR(86.50)FROM DUAL;
18. SELECT FLOOR(86.23) FROM DUAL;
19. SELECT FLOOR(86.75) FROM DUAL;
20. SELECT ROUND(86.50)FROM DUAL;
21. SELECT ROUND(86.23) FROM DUAL;
22. SELECT ROUND(86.75) FROM DUAL;
23. SELECT TRUNC(86.50) FROM DUAL;
24. SELECT TRUNC(86.23) FROM DUAL;
25. SELECT TRUNC(86.75) FROM DUAL;

4. Date Function
1. SELECT SYSDATE FROM DUAL.;
2. SELECT TO_CHAR(SYSDATE  ,'DD:MON:YY HH:MI:SS' )  FROM DUAL.;
3. SELECT TO_CHAR(SYSDATE ,'DD/MON/YY HH:MI:SS' )  FROM DUAL.;
4. SELECT TO_CHAR(SYSDATE,'DD/MM/YY HH:MI:SS') FROM DUAL.;
5. SELECT TO_CHAR(SYSDATE ,'DD/MONTH/YYYY' ) FROM DUAL.;
6. SELECT TO_CHAR(SYSDATE  ,'MONTH' ) FROM DUAL.;
7. SELECT TO_CHAR(SYSDATE ,'YYYY' ) FROM DUAL.;
8. SELECT TO_CHAR(SYSDATE  ,'DD' ) FROM DUAL.;
9. SELECT TO_CHAR(SYSDATE,'Day') FROM DUAL.;
10. SELECT TO_CHAR(SYSDATE ,'DAY') FROM DUAL.;
11. SELECT TO_CHAR(SYSDATE ,'DAY MONTH YEAR') FROM DUAL.;
11. SELECT
    TO_CHAR(SYSDATE ,'DAY MONTH YEAR')
     FROM DUAL.;
12. SELECT ENAME
                      ,HIREDATE
                      ,ADD_MONTHS(HIREDATE,3)
         FROM EMP;
13. SELECT ENAME
                      ,HIREDATE
                      ,ADD_MONTHS(HIREDATE,-3)
                      ,TO_CHAR(ADD_MONTHS(HIREDATE,-3)
                                          ,'Month')
         FROM EMP;
14. SELECT ENAME
                      ,HIREDATE
                      ,LAST_DAY(HIREDATE)
                      ,LAST_DAY('11-APR-2015')
         FROM EMP;
15. SELECT ENAME
                      ,HIREDATE
                      ,MONTHS_BETWEEN('11-APR-2015','31-SEP-2015')         FROM EMP;
16. SELECT  NEXT_DAY('31-JAN-2015','SATURDAY')
         FROM  DUAL
17. SELECT  NEXT_DAY('31-JAN-2015','SATURDAY') + 10
         FROM  DUAL
18. SELECT  SYSDATE - 5
         FROM  DUAL

5. Alter, Drop, Delete, Update, Commit, Rollback
1.  DELETE  FROM  player
     WHERE sal BETWEEN 1 AND 100;
2. DELETE  FROM  player
     WHERE sal IN(1000,2000);
3.  ROLLBACK;
4.  COMMIT;
5.  DROP TABLE    TEST_0
6.  ALTER TABLE test_0
     ADD   add_name  VARCHAR2(30);
7.  ALTER TABLE test_0
     MODIFY add_name  VARCHAR2(20);
8.  ALTER TABLE test_0
     DROP COLUMN  add_name ;
9.  RENAME TEST_0 TO new_Table
10. TRUNCATE TABLE test_0;
11. UPDATE test_0
      SET   add_name =  'Your Name'
      WHERE ROLLNO = 101;
12. UPDATE test_0
       SET   add_name =  'Your Name'

6. Group Functions, Group Clause, Having Clause:
1. SELECT COUNT(*) FROM emp;
2. SELECT COUNT(hiredate) FROM emp;
3. SELECT COUNT(2) FROM  emp;
4. SELECT SUM(sal) FROM  emp;
5. SELECT AVG(sal) FROM emp;
6. SELECT MIN(sal) FROM emp;
7. SELECT MAX(sal) FROM emp;
8. SELECT STDDEV(sal) FROM emp;
9. SELECT VARIANCE(sal) FROM emp;
10. SELECT COUNT(*) FROM emp
      WHERE SAL< 4000;
12. SELECT COUNT(*) FROM emp
      WHERE HIREDATE > '11-Apr-1990';
13. SELECT SUM(sal) FROM emp
      WHERE ename LIKE'%A%';
14. SELECT  MAX(AMOUNT) FROM  ORDER
      WHERE SNUM IN(1002,1007)


7. Sub Query
1. SELECT * FROM EMP
 WHERE DEPTNO  IN (SELECT DEPTNO
                                       FROM DEPT
                                    WHERE  DNAME LIKE  'A%')



2. SELECT * FROM DEPT
 WHERE DEPTNO  IN (SELECT DEPTNO
                                       FROM EMP
                                    WHERE  ENAME LIKE  '%E%')

8. UNION, MINUS, INTERSECTION

1. SELECT ename,sal,comm FROM emp
   where ename like 'A%'
   UNION
   SELECT ename,sal,comm FROM emp
   where ename like 'E%'
2. SELECT ename,sal,comm FROM emp
   where ename like 'A%'
   UNION ALL
   SELECT ename,sal,comm FROM emp
   where ename like 'A%'
3. SELECT ename,sal,comm FROM emp
   where ename like 'E%'
   MINUS
   SELECT ename,sal,comm FROM emp
   where ename like 'E%'
   AND Comm IS NULL
4. SELECT ename,sal,comm FROM emp
   where ename like 'A%'
   INTERSECTION
   SELECT ename,sal,comm FROM emp
   where ename like 'A%'
   and sal < 2000















at No comments:
Labels:
Subscribe to: Posts (Atom)

Financial Year Oracle PLSQL Program

 CREATE OR REPLACE function FINANCIAL_YEAR(p_date DATE) return varchar2 IS    v_first     varchar2(4);    v_second    varchar2(4);    v_year...

  • Top-Down vs. Bottom-Up In Data Warehousing
         Data warehouse systems have gained popularity as companies from the most varied industries realize how useful these systems can be...
  • Title For College Project
    List of Projects of Project for Computer Science and Application Students 1.       Railway Reservation & Inquiry System 2.      ...