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