sac.blogspot.in

Wednesday, March 4, 2015

Research Paper

1. Comparative study image compression technique STW and SPIHT for black and white Image.
2. A Survey: Awareness about Cyber Security Issues AmongStudents and Teaching staff of St. Aloysius’ College Jabalpur
3.National Conference on Gau Samvardhan and Sanrakshan in Madhya Pradesh

Tuesday, March 3, 2015

BSc - II Sem (CA and C++)

1. 2015 - Computer Architecture and Programming in C++

MSc -II

1. MSc II Computer Graphics and MultiMedia

B.Com - V

BCA - IV
5. BCA -IV Java Previous Year Paper

1. B.Sc. - IV CCE Exam - 2014-15 DBMS and Java

2. Advance Java Previous Year Question Paper Previous Year

3. BSc IV -
2015 DBMS AND JAVA B
2015 DBMS AND JAVA A
2014 DBMS and Java - Previous Year
2013 DBMS AND JAVA

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

Sunday, March 1, 2015

Java Script

1. Introduction
2. History
3. Features of Java Script
4. Client Side Web Development Layer

5. Coding Editors for JS
6. Script Tag and HTML
8. Script Tag: Internal Script Tag OR calling External JS File.
7. Operator

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

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

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

NAME

AADITYA RAJ SINGH CHAUHAN

HARSHIT SHRIVASTAVA

ABHAY KUMAR

HARSHITA GADEKAR

ABHAY PANDEY

HARSHITA PATEL

ABHAY VICKRAM SINGH TOMAR

HEMANTRAJ YADAV

ABHISHEK PATEL

HIMANSHU GARG

ABHISHEK TIWARI

INDU YADAV

AJAY SINGH RAGHUWANSHI

IRAM KHAN

AKANKSHA NAMDEO

JAYANT SAHU

AKANSHA NAKRA

JAYANTI RAGHUWANSHI

ALIFIA SHAHANAZ

JITENDRA SINGH PARIHAR

ALKA SINGH

JYOTI PATEL

ALOK KUMAR HARDAHA

KANCHAN CHOUKSEY

AMIT BOHRE

KARUNA SINGOUR

AMIT KOSHTA

KEVAL UPADHYAY

AMIT SINGH

KRITIKA JHA

ANJALI DIXIT

KUMARI DIVYA JHARIYA

ANKIT FOUJDAR

LALIT KUMAR SINGH

ANKIT KUMAR PANDEY

LALIT SINGOUR

ANKUR KESHARWANI

MALA RAJAK

ANKUR UPADHYAY

MAYANK RAJAN CHHIRA

ARCHANA RAJPOOT

MEGHA SHUKLA

ARTI KURMI

MOHAMMAD SAQIB

ASHA SHARMA

MOHIT KUMAR CHOURASIYA

ASHWATI NAIR

MONIKA SHARMA

ATUL STHAPAK

NARMETA SINGH

AYUSH MISHRA

NAZNEEN ANJUM MANSOORI

AYUSHI KANKANE

NEHA SEN

AYUSHI SARAOGI

NEHA SINGH

DARSHNA CHOURASIA

NIDHESH PATEL

DEEPAK SHUKLA

NIRMAL KAUR MANN

DEEPIKA PANDEY

NISHA BARMAN

DEVANTI MARKAM

NISHA PATEL

DHARMENDRA PATEL

PANKAJ BEDUA

DIVYANSHA PATEL

PARUL SONI

EVON PETER

HARSHA GUSAIN

BSc(CS PHY) Practical 15.4.15

SQL & JAVA

Time-12.00 PM

SECOND BATCH FOR PRACTICAL

NAME

POOJA VISHWAKARMA

108

SHIVANGI YADAV

POOJA KACHHI

109

SHIVANI BAIN

POOJA PATEL

110

SHIVANI CHOUDHARI

POOJA VISHWAKARMA

111

SHIVANI PATEL

POORNITA PATEL

112

SHIVANI SINGH

PRACHI MARAVI

113

SHIVKUMAR PATEL

PRAVEEN KUMAR PATHAK

114

SHRUTI JAIN

PRAVEEN KUMAR TRIPATHI

115

SHUBHAM BHIRANI

PRAYAG PATHAK

116

SHUBHAM DAHIYA

PRINSHEE RAI

117

SHUBHAM KUMAR KURMI

PRIYA DWIVEDI

118

SHUBHANK PAROHA

PRIYA KACHHI

119

SHULABH CHATURVEDI

PRIYA TIWARI

120

SHWETA BHARTI

PRIYANK MUKHERJEE

121

SONALI JAIN

PRIYANKA KANHOUA

122

SOUMYA UPADHYAY

PRIYANKA SAHU

123

SUBHAM MARATHA

PRIYANSHI CHOURASIA

124

SUDHEER BHANWARE

PRIYANSHU CHOURASIA

125

SUMAN GUSAIN

PRIYESH GUPTA

126

SUNIL GUPTA

RAGHVENDRA SINGH THAKUR

127

SWATI BHATT

RAJSHREE NAIDU

128

SWATI KANOJIYA

RAVENDRA KUMAR YADAV

129

SWATI PILLAI

RAVI KUMAR YADAV

130

SWECHHA CHOURASIA

RISHIVA SONI

131

TANUSHREE CHATTERJEE

RIYA CHOURASIYA

132

UPASNA SINGH RAJPOOT

RUCHI SINGH

133

VAISHALI PARAS

SACHIN UIKEY

134

VIKAS MISHRA

SAHIL KHAN

135

VIMLESH DUBEY

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

ECO

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

List

Wednesday, March 4, 2015

Research Paper

Tuesday, March 3, 2015

Question Paper

Sunday, March 1, 2015

Java Script

Thursday, February 12, 2015

MSc-II (2014-2015)

Tuesday, February 10, 2015

BCA- IV (2014-15)

Tuesday, January 13, 2015

BSc-IV(2014-15)

Financial Year Oracle PLSQL Program

Instagram

Followers