>>>>>>>>>>>>>BASIC SQL ASSIGNMENT >>>>>> 1) WHAT IS SEQUEL AND EXPLAIN HISTORY OF SEQUEL ? 2) EXPLAIN DATA WITH EXAMPLE 3) WHAT IS DATABASE AND EXPLAIN IT? 4) WHAT IS DBMS AND RDBMS EXPLAIN WITH DIFFERENCES ? 5) EXPLAIN THE RULES OF AN E.F CODD ? 6) WHAT IS DATATYPE AND EXPLAIN ALL THE DATATYPES WITH SYNTAX ? 7) DIFFERENCES BETWEEN CHAR AND VARCHAR ? 8) EXPLAIN CONSTRAINTS WITH SYNTAX FOR EACH CONSTRAINTS 7 9) DIFFERENCES BETWEEN PRIMARY KEY AND FOREIGN KEY 10) DIFFERENCES BETWEEN UNIQUE AND DISTINCT ? >>>>>>> QUERIES ON PROJECTION >>>>>>>>>> 11) WAQTD EMPLOYEES NAME FROM EMPLOYEES TABLE 7 12) WAQTD SAL AND EMPLOYEES NAME FROM EMPLOYEEE TABLE ? 13) WAQTD NAME AND DEPTNO AND JOBS THAT ARE PRESENT IN EMP TABLE ? 14) WAQTD HIREDATE AND DEPTNO FOR ALL THE EMPLOYEES ? 15) WAQTD MGR AND EMPNO FROM EMPLOYEE TABLE ? 16) WAQTD ALL THE DETAILS OF AN ALL THE EMPLOYEES 7 17) WAQTD DEPARTMENT NAME FROM DEPT TABLE ? 18) WAQTD LOC THAT ARE PRESENT IN DEPT TABLE 19) WAQTD DEPTNO AND LOC PRESENT IIN DEPT TABLE ? 20) WAQTD ALL THE OF DEPT TABLE ? 21) WAQTD DIFFERENT JOBS PRESENT IN EMPLOYEE TABLE ? 22) WAQTD ENAME AND SAL PRESENT IN EMP TABLE BUT THERE ‘SHOULD NOT BE ANY REPEATED RECORDS 7 23) WAQTD HIREDATE AND SAL OF AN EMPLOYEES BUT THERE SHOULD NOT BE ANY REPEATED RECORDS ? 24) WAQTD JOB SAL AND DEPTNO OF AN EMPLOYEES BUT THERE SHOULD NOT BE ANY REPEATED RECORDS ? 25) WAQTD ALL THE DETAILS OF AN EMPLOYEES BUT THERE SHOULD NOT BE ANY REPEATED RECORDS ? 26) WAQTD ANNUAL SALARY FOR ALL THE EMPLOYEES ? 27) WAQTD HALF TERM SALARY FOR ALL THE EMPLOYEES ? 28) WAQTD ENAME AND ANNUAL SALARY FOR ALL THE EMPLOYEES ? 29) WAQTD DEPTNO JOB AND SAL WITH 10% HIKE FOR ALL THE EMPLOYEE ? 30) WAQTD ALL THE DETAILS OF AN EMPLOYEES ALONG WITH ANNAUL SALARY 7 0 seamed vith one Seamer31) WAQTDALL THE DETAILS OF AN EMPLOYEES ALONG WITH 10% HIKE IN ANNUAL SALARY FOR ALL THE EMPLOYEE ? 32) WAQTD SAL ANNAUL SALARY HALF_TERM SALARY AND QUETER TERM SALARY FOR ALL THE EMPLOYEES ? 33) WAQTD ANNUAL SALARY WITH 20% DEDUCTION FOR ALL THE EMPLOYEES ? 34) WAQTD ALL THE DETAILS ALONG WITH 100 RS PENALTY FOR ALL THE EMPLOYEES ? 35) WAQTD TOTAL SALARY NEEDE TO PAY FOR EACH AND EVERY EMPLOYEE ? 36) WAQTD ANNAUL SALARY AND HALF_TERM SALARY WITH ALIAS NAME FOR ALL THE EMPLOYEES ? 37) WAQTD ALL THE DETAILS OF AN EMPLOYEES ALONG WITH 12% HIKE IN ANNUAL SALARY WITH ALIAS NAME FOR ALL THE EMPLOYEES 38) WAQTD JOB AS DESIGNATION HIREDATE AS JOINING DATE MGR AS REPRTING MANAGER NUMBER FOR ALL THE EMPLOYEES ? 39) WAQTD JOB WITH DEPTNO FOR ALL THE EMPLOYEES USING ALIAS AS DESIGNATION FOR THE JOB AND DNO FOR THE DEPTNO ? 40) WAQTD ALL THE DETAILS OF AN EMPLOYEES ALONG WITH 50 RS HIKE IN SAL USE ALIAS AS BONUS FOR ALL THE EMPLOYEE ? >>>>>>>>>>> QUERIES ON SELECTION >>>>>>>>>> 41) WAQTD ALL THE DETAILS OF THE EMPLOYEES WHOSE SALARY IS MORE THEN 1000 ? 42) WAQTD ENAME AND SALARY FOR THE EMPLOYEES WHOSE DEPTNO IS 20? 43) WAQTD JOB AND DEPTNO OF AN EMPLOYEES WHO ARE WORKING AS MANAGER ? 44) WAQTD ALL THE DETAILS OF ALL THE EMPLOYEES WHOSE NAME IS KING ? 45) WAQTD NAME AND HIREDATE OF ALL THE EMPLOYEES WHO HIRED ON ‘01-JAN-81 ? 46) WAQTD HIREDATE AND DEPTNO OF AN EMPLOYEES WHO HIRED AFTER THE 1981 7 47) WAQTD ALL THE DETAILS OF AN EMPLOYEES WHO HIRED BEFORE THE 1987 7 48) WAQTD ALL THE DETAILS ALONG WITH ANNUAL SALARY FOR ALL THE EMPLOYEES WHOSE SAL IS LESS THEN 5000 7 49) WAQTD ALL THE DETAILS OF AN EMPLOYEES WHOSE JOB IS MANAGER ? 50) WAQTD ENAME AND JOB AND DEPTNO OF ALL THE EMPLOYEES WHO ARE WORKING IN DEPTNO 30 ? 0 seamed vith one Seamer51) WAQTD ALL THE DETAILS OF AN EMPLOYEES WHOSE JOB IS NOT SALESMAN ? 52) WAQTD ENAME AND JOB OF ALL THE EMPLOYEES EXCEPT THE EMPLOYEES OF DEPTNO 20? 53) WAQTD JOB EPTNO AND SAL OF AN ALL THE EMPLOYEES EXCEPT THE EMPLOYEES WHO ARE WORKING AS SALESMAN ? 54) WAQTD DESIGNATION OF ALLL THE EMPLOYEES EXCEPT KING ? 55) WAQTD ALL THE DETAILS OF THE EMPLOYEES ALONG WITH THAT 20% HIKE OF IN THIER SALARY FOR THE EMPLOYEES WHO HIRED AFTER 85? 56) WAQTD ALL THE DETAILS OF THE EMPLOYEES ALONG WITH THAT 12% DEDUCTION OF IN THIER SALARY FOR THE EMPLOYEES WHO HIRED BEFORE 84? 57) WAQTD ALL THE DETAILS OF THE EMPLOYEES ALONG WITH THAT 2000 BONUS OF IN THIER SALARY FOR THE EMPLOYEES WHOSE EMPNO IS 7369 7 58) WAQTD ALL THE DETAILS OF THE EMPLOYEES WHO ARE NOT WORKING IN DEPTNO 10? 59) WAQTD ALL THE DETAILS OF THE EMPLOYEES ALONG WITH HALFTERM SALARY FOR ALL THE EMPLOYEE WHOSE ANNUAL SALARY IS MORE THEN 14000 ? 60) WAQTD ALL THE DETAILS OF THE EMPLOYEES ALONG WITH THAT 20% HIKE OF IN THIER HALFTERM SALARY FOR ALL THE EMPLOYEES WHOSE HALFTERM SALARY IS MORE THEN 7000 ? >>>>>>>>>>> ASSIGNMENT ON LOGICAL OPERATOR >>>>>>>>>>> 61) WAQTD ALL THE DETAILS OF THE EMPLOYEES WHO ARE WORKING IN DEPTNO 10 AND 207 62) WAQTD ALL THE DETAILS OF THE EMPLOYEES WHO ARE WORKING AS MANAGER AND SALESMAN ? 63) WAQTD ALL THE DETAILS OF THE EMPLOYEES WHOSE SAL IS MORE THEN 1000 AND LESS THEN 5000 ? 64) WAQTD ALL THE DETAILS OF THE EMPLOYEES WHOSE DEPTNOIS 20 AND WORKING AS MANAGER ? 65) WAQTD ALL THE EMPLOYEE NAME AND SALARY WHO HIRED AFTER 81 INTO DEPTNO 10? 66) WAQTD ALL THE DETAILS OF THE EMPLOYEES WHOSE NAME IS KING AND SCOTT ? 67) WAQTD ALL THE DETAILS OF THE EMPLOYEES WHOSE SAL IS 3000 AND 5000 7 68) WAQTD ALL THE DETAILS OF THE EMPLOYEES WHO ARE WORKING IN DEPTNO 10 AS MANAGER AND HIRED ON ‘17-DEC-82 ? 69) WAQTD ALL THE DETAILS OF THE EMPLOYEES WHO ARE WORKING AS 0 seamed vith one SeamerPRESIDENT IN DEPTNO 10 AND HAVING SALARY OF 5000 ? 70) WAQTD ALL THE DETAILS OF THE EMPLOYEES WORKING IN DEPTNO 10,20 AS MANAGER ? 71) WAQTD ALL THE EMPLOYEES NAME AND JOB FRO THE EMPLOYEES WHO HIRED AFTER 81 AND BEFORE 87 7 72) WAQTD ALL THE DETAILS OF THE EMPLOYEES WHOSE SALARY ARE MORE THEN 1000 AND LESS THEN 5000 IN DEPTNO 20? 73) WAQTD ALL THE DETAILS OF THE OF THE EMPLOYEES WHO ARE WORKING AS ‘MANAGER IN DEPTNO 20 AND 10AND EARNING COMMISIONS 400, 1600 ? 74) WAQTD ENAME AND ANNAUL SALARY WITH ALISAS NAME FOR THE E MPLOYEES WHOSE ANNUAL SALARY IS MORE THEN 800 IN DEPTNO 30 WORKING AS SALESMAN AND HIRED BEFORE THE 88 7 75) WAQTD ENAME AS A DEPTNO AS B AND JOB AS C FOR THE EMPLOYEES WHOSE COMM IS MORE THE 100 IN DEPTNO 10,20,30 ? 76) WAQTD ALL THE DETAILS FOR THE EMPLOYEEES WHOSE HIREDATE ARE "03-DEC-81’ AND “17DEC-81’ INTO DEPTNO 30 7 77) WAQTD JOB AND SALARY FOR THE EMPLOYEES WHOSE COMM IS LESS THEN 2000 AND SALARIES ARE MORE THEN 1000 IN DEPTNO 10, 20? 78) WAQTD ALL THE DEATILS FOR THE EMPLOYEES WHOSE NAMES ARE KING AND SMITH AND ALLEN ? 79) WAQTD ANNUAL SALARY HALF TERM SALARY WITH 25% DEDUCTION IN THE SALARY FOR THE EMPLOYEES WHOSE ANNUAL SALARY IS MORE THEN 6000 7 80) ALL THE DETAILS AND HALF TERM SALARY FOR SALESMAN AND MANAGER IN DEPTNO 10,30 ? >>>>>>>>>>> ASSIGNMENT ON SPECIAL OPERATOR >>>>>>>>>>> 81) WAQTD ALL THE DETAILS OF THE EMPLOYEES WHO ARE WORKING IN DEPTNO 10 AND 20? 82) WAQTD ALL THE DETAILS OF THE EMPLOYEES WHO ARE WORKING AS MANAGER AND SALESMAN 7 83) WAQTD ALL THE DETAILS OF THE EMPLOYEES WHOSE SAL IS MORE THEN 1000 AND LESS THEN 5000 ? 84) WAQTD ALL THE DETAILS OF THE EMPLOYEES WHOSE DEPTNO IS 20 AND WORKING AS MANAGER ? 85) WAQTD ALL THE EMPLOYEE NAME AND SALARY WHO HIRED AFTER 81 INTO DEPTNO 107 86) WAQTD ALL THE DETAILS OF THE EMPLOYEES WHOSE NAME IS KING AND SCOTT ? 87) WAQTD ALL THE DETAILS OF THE EMPLOYEES WHOSE SAL IS 3000 AND 5000 7 88) WAQTD ALL THE DETAILS OF THE EMPLOYEES WHO ARE WORKING IN DEPTNO 10 AS MANAGER AND HIRED ON ‘17-DEC-82 7 0 seamed vith one Seamer89) WAQTD ALL THE DETAILS OF THE EMPLOYEES WHO ARE WORKING AS PRESIDENT IN DEPTNO 10 AND HAVING SALARY OF 5000 ? 90) WAQTD ALL THE DETAILS OF THE EMPLOYEES WORKING IN DEPTNO 10,20 AS MANAGER ? 91) WAQTD ALL THE EMPLOYEES NAME AND JOB FRO THE EMPLOYEES WHO HIRED AFTER 81 AND BEFORE 87 ? 92) WAQTD ALL THE DETAILS OF THE EMPLOYEES WHOSE SALARY ARE MORE THEN 1000 AND LESS THEN 5000 IN DEPTNO 20 ? 93) WAQTD ALL THE DETAILS OF THE OF THE EMPLOYEES WHO ARE WORKING AS MANAGER IN DEPTNO 20 AND 10AND EARNING COMMISIONS 400,1600 ? 94) WAQTD ENAME AND ANNAUL SALARY WITH ALISAS NAME FOR THE EMPLOYEES WHOSE ANNUAL SALARY IS MORE THEN 800 IN DEPTNO 30 WORKING AS SALESMAN AND HIRED BEFORE THE 88 ? 95) WAQTD ENAME AS A DEPTNO AS B AND JOB AS C FOR THE EMPLOYEES WHOSE COMM IS MORE THE 100 IN DEPTNO 10,20,30 7 96) WAQTD ALL THE DETAILS FOR THE EMPLOYEEES WHOSE HIREDATE ARE '03-DEC-81’ AND “17DEC-81” INTO DEPTNO 30 7 97) WAQTD JOB AND SALARY FOR THE EMPLOYEES WHOSE COMM IS LESS THEN 2000 AND SALARIES ARE MORE THEN 1000 IN DEPTNO 10, 207 98) WAQTD ENAME FOR THE EMPLOYEES WHOSE NAMES ARE KING AND SMITH AND ALLEN 7 99) WAQTD ANNUAL SALARY HALF TERM SALARY WITH 25% DEDUCTION IN THE SALARY FOR THE EMPLOYEES WHOSE ANNUAL SALARY IS MORE THEN 6000 ? 100) ALL THE DETAILS AND HALF TERM SALARY FOR SALESMAN AND MANAGER IN DEPTNO 10,30 ? 101) ) WAQTD ALL THE DETAILS OF THE EMPLOYEES WHOSE HIRED BETWEEN 81 TO 89 INTO DEPTNO 207 102) WAQTD DETAILS FOR THE EMPLOYEES WHOSE SALARY IN THE RANGE OF 1000 TO 5000 IN DEPTNO 10,20? 103) WAQTD ENAME AND JOB FOR THE EMPLOYEES WHO ARE WORKING AS ANAGER AND EARNING COMMISION IN THE RANGE OF 100 TO 1000 7 104) WAQTD ALL THE DEATILS ALONG WITH 3 MONTHS SALARY FOR THE EMPLOYEES WHOSE SALARY IS NOT NULL AND DOESNT HAVING ANY REPORTING MANAGER ? 105) WAQTD ENAME AND SALARY AND JIB FOR THE EMPLOYEES WORKING AS SALESMAN IN DEPTNO 30 AND EARNING SALARY BUT NOT COMMISION AND HIRED BETWEEN 82 TO 887 106) WAQTD ALL THE DETAILS OF THE EMPLOYEE WHO ARE EARNING SALARY ? 107) WAQTD ANNAUL SALARY OF THE EMPLOYEE WHO ARE NOT EARNING COMMISSION ? 0 seamed vith one Seamer108) WAQTD ALL THE DETAILS WITH ANNAUL COMMISSION FOR THE EMPLOYEE WHO ARE WORKING IN DEPT 10 AND DONT JAVE ANY REPORTING MANAGER ? 109) WAQTD ALL THE DETAILS OF THE EMPLOYEE EXCEPT DEPTNO 10 AND WHO WHO HAVE REPORTING MAMAGER 7 110) WAQTD ENAME AND SALARY. AND COMMISSION OF THE EMPLOYEE WHO EARNING COMMISSION IN DEPT NO 30 AND WORKING AS SALESMAN ? 111) WAQTD ENAME OF THE EMPLOYEE WHOSE NAME START WITH S ? 112) WAQTD ALL THE DETAILS FOR THE EMPLOYEE WHOSE NAME ENDS WITH R? 113 ) WAQTD SALARY AND DEEPTNO AND NAME FOR THE EMPLOYEE WHOSE NAME HAVING A CHARACTER ? 114) WAQTD ALL THE DETAILS OF THE EMPLOYEE WHOSE HAVING 2 AIN THEIR NAME ? 115) WAQTD ALL THE DETAILS OF THE EMPLOYEE WHOSE NAME HAVING CONJUGATIVE A IN THEIR NAMES 7 116) WAQTD ALL THE DETAILS OF THE EMPLOYEE WHOSE NAME HAVING 2ND CHARACTER AS M ? 117) WAQTD ALL THE DETAILS OF THE EMPLOYEE WHOSE NAME HAVING LAST 2ND CHAPTER AS E? 118) WAQTD ALL THE DETAILS OF THE EMPLOYEE WHOSE NAME START WITH M HAVING 4TH CHARACTER L AND ENDS WITH R 7 119) WAQTD ALL THE DETAILS OF AN ALL THE EMPLOYEE WHO ARE EARNING 4 DOGIT OF SALARY AND NAMES STARTS WITH VOWELS ? 120) WAQTD ALL THE DETAILS OF THE EMPLOYEE WHOSE NAME STARTS WITH CONSONANTS. ? 121) WAQTD ENAME AND HIREDATE OF ALL THE EMPLOYEE WHO HIRED IN THE MONTH OF DEC ? 122) WAQTD ALL THE DETAILS FOR THE EMPLOYEE WHO HIRED DURING 1981 ? 123) WAQTD ALL THE DETAILS OF THE EMPLOYEE EXCEPT WHOSE NAME HAVING A ? 124) WAQTD SALARY AND NAMES FOR THE EMPLOYEE WHOSE NAME START WITH S EXCEPT THE EMPLOYEE WHOSE SALARY. STARTS WITH 1? 125) WAQTD ALL THE DETAILS OF THE EMPLOYEE WHOSE NAME HAVING 2 TIME CONSUGATIVE. A ? 126) WAQTD ALL THE DETAILS OF THE EMPLOYEE WHOSE NAME START WITH % 7 127) WAQTD ALL THE DETAILS OF THE EMPLOYEE WHOSE NAME ENDS WITH % ? 128) WAQTD ALL THE DETAILS OF THE EMPLOYEE WHOSE NAME START WITH % ENDS WITH _? 129) WAQTD ALL THE DETAILS OF THE EMPLOYEE WHOSE NAME HAVING % 7 0 seamed vith one Seamer130) WAQTD ALL THE DETAILS OF THE EMPLOYEE WHOSE NAME START WITH % HAVING 4TH CHARACTER _ AND ENDS WITH % ? 131) WAQTD MAX SALARY FROM THE EMPLOYEE TABLE ? 132) WAQTD MAX AND MIN COMM FROM EMPLOYEES TABLE ? 133) WAQTD TOTAL SALARY NEEDED TO PAY FOR THE SALESMAN ? 134) WAQTD NUMBER OF EMPLOYEES WORKING IN DEPTNO 30 ? 135) WAQTD NUMBER OF EMPLOYEES WORKING AS MANAGER IN DEPTNO 20? 136) WAQTD MAX SALARY NEEDED TO PAY FOR THE EMPLOYEES WHOSE NAME STARTS WITH A? 137) WAQTD AVG SALARY NEEDED TO PAY FOR THE EMPLOYEES OF DEPTNO 10? 138) WAQTD TOTAL SALARY AND AVG SALARY NEEDED TO PAY FOR THE EMPLOYEES WHO ARE HIRED IN THE RANGE OF 81 TO 87? 139) WAQTD NUMBER OF EMPLOYEES WORKING IN DEPTNO 40 ? 140) WAQTD TOTAL SALARY NEEDED TO PAY FOR THE EMPLOYEES WHO ARE REPORTING TO 7839 ? 141) WAQTD HOW MANY EMPLOYEES ARE WORKIN AS PRESIDENT IN DEPTNO 10 AND EARNING SALARY MORE THEN 4000 ? 142) WAQTD HOW MANY EMPLOYEES ARE WORKIN AS SALESMAN IN DEPTNO 30 AND EARNING SALARY LESS THEN 5000 ? 143) WAQTD HOW MANAY EMPLOYEES ARE HIRED ON 03-DEC- 81 iN DEPTNO 10, 20 144) WAQTD HOW MUCH TOTAL SALARY NEEDE TO PAY FOR THE EMPLOYEE WHOSE MAME HAVING A CHARACTER ? 145) WAQTD AVG SALARY NEEDED TO PAY FOR THE SALESMAN IN DEPTNO 30? 146). WAQTD NUMBER OF EMPLOYEES WORKING IN EACH DEPARTEMENT EXCEPT PRESIDENT. ? 147)WAQTD TOTAL SALARY NEEDED TO PAY ALL THE EMPLOYEES IN EACH JOB. ? 148) WAQTD NUMBER OF EMPLOYEEES WORKING AS MANAGER IN EACH DEPARTMENT. ? 0 seamed vith one Seamer149). WAQTD AVG SALARY NEEDED TO PAY ALL THE EMPLOYEES IN EACH DEPARTMENT EXCLUDING THE EMPLOYEES OF DEPTNO 20. ? 150). WAQTD NUMBER OF EMPLOYEES HAVING CHARACTER ‘4 EACH JOB. ? 151). WAQTD NUMBER OF EMPLOYEES AND AVG SALARY NEEDED TO PAY THE EMPLOYEES WHO SALARY IN GREATER THAN 2000 IN EACH DEPT. ? 152)WAQT D TOTAL SALARY NEEDED TO PAY AND NUMBER OF SALESMANS IN EACH DEPT. 7 153)WAQTD NUMBER OF EMPLOYEES WITH THEIR MAXIMUM SALARIES IN EACH JOB. ? 154) WAQTD MAXIMUM SALARIES GIVEN TO AN EMPLOYEE WORKING IN EACH DEPT. ? 155)WAQTD NUMBER OF TIMES THE SALARIES PRESENT IN EMPLOYEE TABLE. ? IN THEIR NAMES IN 156). WAQTD DNO AND NUMBER OF EMP WORKING IN EACH DEPT IF THERE ARE ATLEAST 2 CLERKS IN EACH DEPT ? 157)WAQTD DNO AND TOTAL SAALARYNEEDED TO PAY ALL EMP IN EACH DEPT IF THERE ARE ATLEAST 4 EMP IN EACH DEPT ? 158). WAQTD NUMBER OF EMP EARNING SAL MORE THAN 1200 IN EACH JOB AND THE TOTAL SAL NEEDED TO PAY EMP OF EACH JOB MUST EXCEES 3800 ? 159). WAQTD DEPTNO AND NUMBER OF EMP WORKING ONLY IF THERE ARE 2 EMP WORKING IN EACH DEPT AS MANAGER. ? 160) WAQTD JOB AND MAX SAL OF EMP IN EACH JOB IF THE MAX SAL EXCEEDS 2600 ? 161). WAQTD THE SALARIES WHICH ARE REPEATED IN EMP TABLE ? 162).WAQTD THE HIREDATE WHICH ARE DUPLICATED IN EMP TABLE ? 164) WAQTD AVG SALARY OF EACH DEPT IF AVG SAL IS LESS THAN 3000 7 164) WAQTD DEPTNO IF THERE ARE ATLEAST 3 EMP IN EACH DEPT WHOS NAME HAS CHAR ‘A’ OR 'S'? 0 seamed vith one Seamer165). WAQTD MIN AND MAX SALARIES OF EACH JOB IF MIN SAL IS MORE THAN 1000 AND MAX SAL IS LESS THAN 5000. 166). WAQTD NAME OF THE EMPLOYEES EARNING MORE THAN ADAMS ? 167). WAQTD NAME AND SALARY OF THE EMPLOYEES EARNING LESS THAN KING 168) WAQTD NAME AND DEPTNO OF THE EMPLOYEES IF THEY ARE WORKING IN THE SAME DEPT AS JONES 169) WAQTD NAME AND JOB OF ALL THE EMPLOYEES WORKING IN THE SAME DESIGNATION AS JAMES 170)WAQTD EMPNO AND ENAME ALONG WITH ANNUAL SALARY OF ALL THEEMPLOYEES IF THEIR ANNUAL SALARY IS GREATER THAN WARDS ANNUAL SALARY. 171) .WAQTD NAME AND HIREDATE OF THE EMPLOYEES IF THEY ARE HIRED BEFORE SCOTT 7.WAQTD NAME AND HIREDATE OF THE EMPLOYEES IF THEY ARE HIRED AFTER THE PRESIDENT 172) .WAQTD NAME AND SAL OF THE EMPLOYEE IF THEY ARE EARNING SAL LESS THAN THE EMPLOYEE WHOS EMPNO IS 7839 173).WAQTD ALL THE DETAILS OF THE EMPLOYEES IF THE EMPLOYEES ARE HIRED BEFORE MILLER 174) .WAQTD ENAME AND EMPNO OF THE EMPLOYEES IF EMPLOYEES ARE EARNING MORE THAN ALLEN 175). WAQTD ENAME AND SALARY OF ALL THE EMPLOYEES WHO ARE EARNING MORE THAN MILLER BUT LESS THAN ALLEN. 178).WAQTD ALL THE DETAILS OF THE EMPLOYEES WORKING IN DEPT 20 AND WORKING IN THE SAME DESIGNATION AS SMITH 0 seamed vith one Seamer179).WAQTD ALL THE DETAILS OF THE EMPLOYEES WORKING AS MANAGER IN THE SAME DEPT AS TURNER 180). WAQTD NAME AND HIREDATE OF THE EMPLOYEES HIRED AFTER 1980 AND BEFORE KING 15. WAQTD NAME AND SAL ALONG WITH ANNUAL SAL FOR ALL EMPLOYEES WHOS SAL IS LESS THAN BLAKE AND MORE THAN 3500 181).WAQTD ALL THE DETAILS OF EMPLOYEES WHO EARN MORE THAN SCOTT BUT LESS THAN KING 182). WAQTD NAME OF THE EMPLOYEES WHOS NAME STARTS WITH ‘A' AND WORKS: IN THE SAME DEPT AS BLAKE 183). WAQTD NAME AND COMM IF EMPLOYEES EARN COMISSION AND WORK IN THE SAME DESIGNATION AS SMITH 184). WAQTD DETAILS OF ALL THE EMPLOYEES WORKING AS CLERK IN THE SAME DEPT AS TURNER. 185). WAQTD ENAME, SAL AND DESIGNATION OF THE EMPLOYEES WHOS ANNUAL SALARY IS MORE THAN SMITH AND LESS THAN KING. RTE 186).WAQTD DNAME OF THE EMPLOYEES WHOS NAME IS SMITH 187). WAQTD DNAME AND LOC OF THE EMPLOYEE WHOS ENAME IS KING 188). WAQTD LOC OF THE EMP WHOS EMPLOYEE NUMBER IS 7902 189) WAQTD DNAME AND LOC ALONG WITH DEPTNO OF THE EMPLOYEE WHOS NAME ENDS WITH 'R’. 190) .WAQTD DNAME OF THE EMPLOYEE WHOS DESIGNATION IS PRESIDENT 191) .WAQTD NAMES OF THE EMPLOYEES WORKING IN ACCOUNTING DEPARTMENT 0 seamed vith one Seamer192) .WAQTD ENAME AND SALARIES OF THE EMPLOYEES WHO ARE WORKING IN THE LOCATION CHICAGO 193). WAQTD DETAILS OF THE EMPLOYEES WORKING IN SALES 194) .WAQTD DETAILS OF THE EMP ALONG WITH ANNUAL SALARY IF EMPLOYEES ARE WORKING IN NEW YORK 195) .WAQTD NAMES OF EMPLOYEES WORKING IN OPERATIONS DEPARTMENT 195) .WAQTD NAMES OF THE EMPLOYEES EARNING MORE THAN SCOTT IN ACCOUNTING DEPT 196). WAQTD DETAILS OF THE EMPLOYEES WORKING AS MANAGER IN THE LOCATION CHICAGO 197) .WAQTD NAME AND SAL OF THE EMPLOYEES EARNING MORE THAN KING IN THE DEPT ACCOUNTING 198) .WAQTD DETAILS OF THE EMPLOYEES WORKING AS SALESMAN IN THE DEPARTEMENT SALES 199) .WAQTD NAME, SAL. JOB, HIREDATE OF THE EMPLOYEES WORKING IN OPERATIONS DEPARTMENT AND HIRED BEFORE KING 200) .DISPLAY ALL THE EMPLOYEES WHOSE DEPARTMET NAMES ENDING 201) .WAQTD DNAME OF THE EMPLOYEES WHOS NAMES HAS CHARACTER ‘A’ INIT. 202). WAQTD DNAME AND LOC OF THE EMPLOYEES WHOS SALARY IS RUPEES 800. 203) .WAQTD DNAME OF THE EMPLOYEES WHO EARN COMISSION 204) .WAQTD LOC OF THE EMPLOYEES IF THEY EARN COMISSION IN DEPT 40 0 seamed vith one Seamer205) .WAQTD NAME OF THE EMPLOYEES EARNING SALARY MORE THAN THE SALESMAN 206) WAQTD DETAILS OF THE EMPLOYEES HIRED AFTER ALL THE CLERKS 207) .WAQTD NAME AND SALARY FOR ALL THE EMPLOYEES IF THEY ARE EARNING LESS THAN ATLEST A MANAGER 208) WAQTD NAME AND HIREDATE OF EMPLOYEES HIRED BEFORE ALL THE MANAGERS 209) .WAQTD NAMES OF THE EMPLOYEES HIRED AFTER ALL THE MANAGERS AND EARNING SALARY MORE THAN ALL THE CLERKS 210) .WAQTD DETAILS OF THE EMPLOYEES WORKING AS CLERK AND HIRED BEFORE ATLEST A SALESMAN 211). WAQTD DETAILS OF EMPLOYEES WORKING IN ACCOUNTING OR SALES DEPT 212) WAQTD DEPARTMENT NAMES OF THE EMPOYEES WITH NAME SMITH, KING AND MILLER 213) .WAQTD DETAILS OF EMPLOYEES WORKING NEWYORK OR CHICAGO 214) WAQTD EMP NAMES IF EMPLOYEES ARE HIRED AFTER ALL THE EMPLOYEES OF DEPT 10 ESSER RT 61. WAQTD 2ND MINIMUM SALARY 62. WAQTD 5TH MAXIMUM SALARY 63. WAQTD NAME OF THE EMPLOYEE EARNING 3RD MAXIMUM SALARY 64.WAQTD EMPNO OF THE EMPLOYEE EARNING 2D MAXIMUM SALARY 65. WAQTD DEPARTMENT NAME OF AN EMPLOYEE GETTING 4TH MAX SAL 66. WAQTD DETAILS OF THE EMPLOYEE WHO WAS HIRED 2nd 67.WAQTD NAME OF 0 seamed vith one SeamerTHE EMPLOYEE HIRED BEFORE THE LAST EMPLOYEE 68. WAQTD LOC OF THE EMPLOYEE WHO WAS HIRED FIRST 69. WAQTD DETAILS OF THE EMPLOYEE EARNING 7TH MINIMUM SALARY 70. WAQTD DNAME OF EMPLOYEE GETTING 2ND MAXIMUM SALARY ASSIGNMENT ON EMP AND MANAGER RELATION . 71.WAQTD SMITHS REPORTING MANAGER'S NAME 72.WAQTD ADAMS MANAGER'S MANAGER NAME 73.WAQTD DNAME OF JONES MANAGER 74.WAQTD MILLER'S MANAGER'S SALARY 75.WAQTD LOC OF SMITH'S MANAGER'S MANAGER. 76.WAQTD NAME OF THE EMPLOYEES REPORTING TO BLAKE 77.WAQTD NUMBER OF EMPLPOYEES REPORTING TO KING 78.WAQTD DETAILS OF THE EMPLOYEES REPORTING TO JONES 79.WAQTD ENAMES OF THE EMPLOYEES REPORTING TO BLAKE'S MANAGER 80.WAQTD NUMBER OF EMPLOYEES REPORTING TO FORD'S MANAGER <<<>>>>> 121) WHAT IS JOINS LIST ALL THE TYPES OF JOINS ? 122) WHAT IS CROSS JOIN EXPLAIN WITH SYNTAX ? 123) WHAT IS INNER JOIN EXPLAIN WITH SYNTAX ? 124) DIFFERENCES BETWEEN CROSS JOIN AND INNER JOIN 7 125) EXPLAIN THE ADVANTAGES AND DISADVANTAGES OF INNER JOIN 7 126) EXPLAIN THE NATURAL JOIN WITH SYNTAX ? 0 seamed vith one Seamer127) WHAT IS OUTER JOIN EXPLAIN ALL OUTER JOIN WITH SYNTAX ? 129) DIFFERENCES BETWEEN LOJ AND ROJ? 129) WHAT IS SELF JOIN EXPLAIN WITH SYNTAX ? 130) WHAT IS THE USE USING SELF JOIN COMPARE TO SUB QUERY ? ASSIGNMENT ON INNER JOINS OR NATURAL JOIN 131) WAQTD ENAME AND DNAME FOR ALL THE EMPLOYEES ? 132) WAQTD NAME AND SAL FOR THE EMPLOYEES WHO ARE WORKING AS MANAGER ? 133) WAQTD SAL AND HIREDATE AND LOC FOR THE EMPLOYEES WHOSE NAME HAVING A CHARACTER IN THEIR NAME 7 134) WAQTD ALL THE DETAILS OF AN EMPLOYEE ALONG WITH LOC FOR AN EMPLOYEES WHOSE SAL IS MORE THEN 2000 IN ACCOUNTING DEPARTMENT ? 135) WAQTD DNAME AND SAL AND DEPTNO OF AN EMPLOYEES WHOSE JOB IS PRESIDENT IN DEPTNO 10? 136) WAQTD ENAME AND DEPTNO AND LOC FOR ALL THE EMPLOYEES WHOSE NAME ENDS WITH VOWELS 7 137) WAQTD HIREDATE AND DEPTNO FOR ALL THE EMPLOYEES WHO ARE WORKING IN NEW YORK AND HAVING COMM ? 138) WAQTD EMPLOYEE NAME AND DEPARTMENT NAME FOR ALL THE EMPLOYEE WHO ARE HIRED IN THE MONTH OF FEB INTO ACCOUNTING DEPARTMENT ? 0 seamed vith one Seamer139) WAQTD LOC AND EMPNO AND MGR NO FOR ALL THE EMPLOYEES WHOSE SAL LESS THEN 5000 IN BOSTON HIRED IN THE YEAR OF 87 ? 140) WAQTD DNAME AND LOC ALONG WITH 10% HIKE IN THE SALARY OF AN EMPLOYEE WHO ARE REPORTING TO ALLEN 7 141) WAQTD ANNAUL SALARY AND LOC OF AN EMPLOYEE WHOSE MANAGER NAME IS KING ? 142) WAQTD ALL TEH DETAILS OF AN EMPLOYEES AND THEIR DNAME AND LOC FOR THE EMPLOYEE WHOSE COMM IS NULL IN DEPTNO 10,20 ? 143) WAQTD DNAME AND ENAME FOR THE EMPLOYEE WHOSE SALARY ENDS WITH 50 IN DEPTNO 10,20,30 AND WORKING IN RESEARCH DEPARTMENT ? 144) WAQTD LOC DNAME AND ENAME OF AN EMPLOYEES WHO ARE HIRED BEFORE THE LAST TWO EMPLOYEES ? 145) WAQTD DNAME AND SALARY OF AN EMPLOYEE WHOSE NAME ENDS WITH CONSONANTS ? 146) WAQTD MGR SAL AND DEPTNO AND LOC OF AN EMPLOYEES WHOSE LOC ENDS WITH S? 147) WAQTD EMPNO AND LOC FOR THE EMPLOYEES WHOSE HIREDATE IS '01-JAN-81" IN DALLAS ? 148) WAQTD ENAME AND LOC AND SAL OF AN EMPLOYES WHOSE EMPNO ARE 7369,7488 7 149) WAQTD ENAME AND LOC FOR THE EMPLOYEES WHOSE SAL IS LESS THEN KING AND MORE THEN SMITH IN DEPTNO 30 AND WORKING IN SALES DEPARTMENT ? 150) WAQTD COMM AND LOC FOR THE EMPLOYEES WHOSE MGR IS 7902 WORKING IN ACCOUNTING AND RESEARCH DEPARTMENT ? >>>>>>>> ASSIGNMENT ON OTHER JOINS>>>>>>>>>> 151) WAQTD ENAME AND DNAME FOR ALL THE EMPLOYEES OF THE EMPLOYEES NOT WORKING IN ANY DEPARTMENT ? 0 seamed vith one Seamer152) WAQTDALL THE DETAILS OF AMPLOYEES AND THEIR DEPARTMENT DETAILS IF THE DEPARTMENT IN WHICH NO EMPLOYEES ARE WORKING ? 153) WAQTD ALL THE DETAILS OF AN EMPLOYEES AND HIER DEPARTMENT DETAILS IF THE EMPLOYEES NOT WORKING IN ANY DEPARTMENT AND THE DEPARTMENT IN WHICH THE NO EMPLOYEES ARE WORKING ? 154) WAQTD ENAME AND SAL AND DNAME FOR THE EMPLOYEES THOSE WHO ARE NOT WORKING IN ANY DEPARTMENT ? 155) WAQTD HIERDATE AND JOB INCLUDING DNAME AND LOC FORTHE DEPARTMENT IN WHICH NO EMPLOYEES ARE WORKING ? 156) WAQTD DNAME AND LOC AND JOB FOR THE EMPLOYEES WHO ARE NOT WORKING IN ANY DEPARTMENT AND THE DEPARTMENT NO EMPLOYEES ARE WORKING ? 157) WAQTD EMPLOYEES NAME AND DEPTNAME FOR ALL THE EMPLOYEES WHOSE SALARIES ARE MORE THEN 2000 ? 158) WAQTDMANAGER NAME AND THE EMPLOYEES SALARY FOR ALL THE EMPLOYEES THOSE WHO ARE WORKING IN DEPTNO 10,20 ? 159) WAQTD MANAGERS MANAGE NAME FOR ALL THE MANAGER WHOSE SALARIES ARE LESS THEN EMPLOYES ? 160) WAQTD EMPLOYEES NAME MANAGER SALARY AND MANAGER MANAGE (COMM FOR ALL THE MANAGER WHO HIRED BEFORE THE 87 AS SALESMAN AND EARNING SALARY MORE THEN MANAGERS MANAGER ? 161) WAQTD ENAME AND MANAGER HIREDATE AND JOB FOR ALL THE EMPLOYEES WHO ARE WORKING IN NEW YORK ? 162) WAQTD EMPLOYEES DNAME AND MANAGER LOC INCLUDING EMPLOYEES SALARY AND MANAGER DEPTNO FOR ALL THE EMPLOYEES WHO ARE HIRED BEFORE THE MANAGERS MANAGE ? 163) WAQTD MANAGERS MANAGER NAME FOR ALL THE EMPLOYEES WHO ARE WORKING IN MANAGERS LOCATION AND NOT WORKING IN MANAGESMANAGERS LOCATION ? 164) WAQTD MANAGER NAME FOR THE MANAGERS MANAGER WHO ARE WORKING IN DEPTNO 20 AS ACTUAL MANAGER AND EARNING SALARY MORE THEN THE EMPLOYEES ? 165) WAQTD MANAGERS DNAME AND MANAGERS MANAGER LOC FOR THE EMPLOYEES WHO ARE WORKING IN BOSTON ? 166) WAQTD EMPLOYEES DNAME FOR THE MANAGERS MANAGER WHOSE SAL ARE MORE THEN MANAGER AND LESS THEN EMPLOYEES ? 167) WAQTD EMPLOYEES LOC AND MANAGERS MANAGERS LOC FOR THE MANAGER WHO ARE HIRED BEFORE THE EMPLOYEE AND EARNING SALARY MORE THEN THE EMPLOYEES ? 168) WAQTD MANAGERS MANAGERS MANAGER NAME FOR THE EMPLOYEES WHO ARE WORKING IN MANAGERS MANAGERS MANAGERS LOC AND EARNING SALARY LESS THE MANAGERS HIRED BEFORE MANAGERS MANAGERS MANAGER ? 169) WAQTD DNAME FOR THE EMPLOYEES WHO HIRED BEFORE THE MANAGERS INTO ACCOUNTING DEPARTMENT IN THE MONTH OF DEC ? 170) WAQTD MANAGERS MANAGERS MANAGERS MANAGER NAME IF THEY ARE HIRED AFTER THE MANAGERS INTO DALLAS ? >>>> ASSIGNMENT ON DDL DML TCL DCL >>>>>>>>> 171) WAQT CREATE ANY ONE TABLE WITHOUT ANY PRIMARY KEY WITH 5 COLUMNS 7 172) WAQT RENAME THE EMP TABLE NAME TO EMPLOYEES ? 173) WAQT TRUNCATE THE SALGRADE TABLE ? 174) WAQT DROP THE EMP ANY ONE TABLE FROM DATABASE AND GET IT BACK ? 175) WAQT PURGE THE ANY ONE TABLE ? 176) WAQT CREATE TWO TABLES AND AMKE THE CONNECTION BETWEENTHISE TWO TABLES ? 177) WAQT ADD THE ONE COLUMN INTO EMPLOYEES TABLE ? 178) WAQT ADD TWO COLUMN INTO DEPT TABLE ? 179) WAQT DROP THE RECENTLY ADDED COLUMN FROM THE EMP TABLE ? 180) WAQT RENAME THE COLUMN FROM EMP AND DEPT TABLE FORGN KEY AS DNO? 181) WAQT INSERT 5 RECORDS INTO EMP TABLE ? 182) WAQT DELETE THE EMPLOYEES RECORD WHOSE NAME IS KING ? 183) WAQT UPDATE THE SALARY OF SMITH AS 5000 7 184) WAQT UPDATE THE JOB OF ALLL THE EMPLOYEES AS MANAGER WHO ARE GETTING SAL <1600 7 185) WAQT DELETE THE EMPLOYEES RECORD WHO ARE WORKING IN NEW YORK ? 186) WAQT DELETE THE EMPLOYEES RECORDS WHO ARE EARNING SALARY MORE THEN SMITH AND HIRED BEFORE SCOTT ? 187) WAQT UPDATE THE COMM FOR ALL THE EMPLOYEES WHO ARE REPORTING TO KING AS 10007 188) WAQT UPDATE THE JOB AS BOSS AND SALARY AS 90000 FOR THE EMPLOYEES WHOSE DNAME HAVING EXACTLY ONE A ? 189) WAQT TAKE PERMISSION FROM THE SCOTT AND DELETE THE RECORDS WHOSE SALARY IS 3000 IN HR DATABASE ? 190) WAQT RETAKE THE PERMISSION FROM HR AND TRY TO DELETE THE RECORDS WHOSE SAL IS MORE THEN 2000 7 22>>> THEORY STATEMENT QUESTIONS >>>>>> 191) WHAT ARE THE DIFFERENCE BETWEEN DELETE AND TRUNCATE ? 192) DIFFERENCE BETWEEN DELETE DROP AND TRUNCATE ? 193) DIFFERENCE BETWEEN ALTER AND UPDATE ? 194) SYNTAX FOR CREATE TABLE WITH PRIMARY KEY AND FOREIGN KEY ? 195) SYNTAX FOR GRANT AND REVOKE ? 196) SYNTAX FOR DML ? 197) SYNTAX FOR ALL THE STATEMENT OF DDL ?198) SYNTAX FOR CHECK THE CONSTRAINTS ? 199) SYNTAX FOR TO CHECK THE TABLE LIST FROM RECYCLE BIN ? 20) SYNTAX FOR TO CHECK THE PERMISSION LIST ? 201) SYNTAX FOR TCL STATEMENTS ? 202) SYNTAX FOR SELECTION AND PROJECTION ? 203) DIFFERENCE BETWEEN PROJECTION AND SELECTION ? 204) DIFFERENCE BETWEEN DDL AND DML ? 205) SYNTAX FOR TO CREATE THE INDEX ? 206) SYNTAX FOR TO CHECK THE STRUCTURE OF TABLE ? 207) SYNTAX FOR TO ADD THE COLUMN INTO TABLE ? 208) SYNTAX FOR TO DROP THE COLUMN FROM THE TABLE ? 209) SYNTAX FOR TO CHANGE THE DATATYPES ? 210) SYNTAX FOR TO CHANGE FROM NULL TO NOT NULL OR VISE VERSA ? SRF QUESTIONS / ASSIGNMENT 211) WAQTD THE NO OF CHARACTERS PRESENT IN YOUR NAME ? 212) WAQTD THE DEATILS OF THE EMPLOYEES WHOSE NAME HAVING 4 CHARACTERS ? 213) WAQTD ENAME AND LOC OF ALL THE EMPLOYEES WHO ARE EARNING 4 DIGIT OF SALARY ? 214) WAQT GET THE REMINDER VALUES OF 10/5 7 215) WAQTD THE DEATILS OF EMPLOYEES WHOSE NAME ENDS WITH VOWELS ? 216) WAQTD ALL THE DEATILS OF THE EMPLOYEES WHO AHEV MORE THEN 513 MONTHS OF EXPERIANCE ?217) WAQT REPLACE THE 3RD A FROM THE MALAYALAM ? 218) WAQTD THE FIRST HALF NAME OF EMPLOYEES SAME AND 2ND HALF NAME OF EMPLOYEES IN REVERSE MANNAER ? 219) WAQT REPLACE THE FIRST 6 NUMBER AS (*) FROM 9900199001 ? 220) WSQTD OF THE EMPLOYEES WHOSE NAME HAVING EXACTLY 2A IN THEIR NAMES ? 221) WAQTD DNAME AND SAL OF ALL THE EMPLOYEES WHOSE NAMES ARE PALYDROM IN NATURE ? 222) WAQTD DNAME AND ENAME OF ALL THE EMPLOYEES WHOSE 2ND HALF NAME PALYDROM IN NATURE ? 223) WAQTD THE TOTAL SALARY NEEDED TO PAY FOR EACH AND EVERY EMPLOYEES ?(NVL) 224) WAQTD THE DETAILS OF THE EMPLOYEES WHO ARE EARNING 3RD MAX SALARY FROM EMP TABLE ? 225) WAQTD THE 2ND MAX SALARY FROM EACH AND EVERY JOB ? 226) WAQTD THE EMPLOYEES NAME AND THEIR DNAME IN INITCAP FORMAT AND ALSO DISPLAY THEIR JOB IN LOWER CASE FORMAT ? 227) WAQT GET THE NO OF MONTHS BETWEEN YOUR DATE OF BIRTH TO TODAYS DATE ? 228) WAQT GET THE YOUR CURRENT AGE IN YEAR FORMAT UPTO THE DATE ? 229) WAQT CONCAT ENAME WITH THEIR HALF DNAME OF ALL THE EMPLOYEES ? 230) WAQT GET THE DEATILS OF THE EMPLOYEES IF THEIR NAME HAVING % AS LAST LETTER ? 231) WAQTD THE DETAILS OF AN EMPLOYEES IF THEIR SALARIES ARE PALYDROM IN NATURE ? 232) WAQTD ALL THE EMPLOYEES IF THEIR NAME AND DNAME STARST WITH SAME LETTER ?233) WAQTD ALL THE EMPLOYEES IF THEIR NAME AND DNAME STARST AND ENDS WITH SAME LETTER ? 234) WAQTD THE LOC AND DNAME AND JOB OF ALL THE EMPLOYEES IF THEIR NAME MIDDLE LETTERS ARE VOWELS ? 235) WAQT GET EXACTLY THE MIDDLE NAME FROM “VIRAT ANUSKHA KHOLI" ? 236) WAQT PRINT THE DEATILS IN GIVEN FLOW “HI SMITH GOOD MORNING YOUR DESIGNATION IS CLERK AND SALARY IS 800 YOUR DEPTNO IS 20" SAME FORMAT FOR ALL THE EMPLOYEES ? 237) WAQTD ALL THE DETAILS OF THE EMPLOYEES WHO ARE HIRED ON WENSEDAY ? 238) WAQTD ALL THE DEATILF OF EMPLOYEES AND THEIR DEPARTMENT IF THEY ARE HIRED IN THE MONTH OF DEC, JAN , FEB ? 239) WAQTD ALL THE EMPLOYEES IF THEY ARE HIRED IN THE YEAR OF 81, 87, 82? 240) WAQT GET THE YOUR CURRENT AGE WITH DAY OF BORN ?DIFFERENCES QUESTIONS IN SQL 241) DIFFERENCES BETWEEN DMBS AND RDBMS ? 242) DIFFERENCES BETWEEN CHAR AND VARCHAR ? 243) DIFFERENCES BETWEEN SQL AND NO SQL ? 244) DIFFERENCES BETWEEN PROJECTION AND SELECTION ? 245) DIFFERENCES BETWEEN WHERE CLAUSE AND HAVING CLAUSE ? 246) DIFFERENCES BETWEEN ALIAS AND DISTINCT ? 247) DIFFERENCES BETWEEN DISTINCT AND UNIQUE ? 248) DIFFERENCES BETWEEN PRIMARY KEY AND FOREIGN KEY ? 249) DIFFERENCES BETWEEN PRIMARY KEY AND UNIQUE ? 250)DIFFERENCES BETWEEN NULL AND NOT NULL ? 251)DIFFERENCES BETWEEN EXPRESSION AND ALIAS ? 252)DIFFERENCES BETWEEN FUNCTIONS AND OPERATORS ? 253)DIFFERENCES BETWEEN USER DEFINED FUNCTION AND BUILT IN FUNCTIONS ? 254)DIFFERENCES BETWEEN SRF AND MRF ? 255)DIFFERENCES BETWEEN SQSR AND MRSQ ? 256)DIFFERENCES BETWEEN SUB QUERY AND JOINS ? 257)DIFFERENCES BETWEEN ALL AND ANY OPERATORS ? 258)DIFFERENCES BETWEEN INNER JOIN TO CARETESIAN JOIN 7 259)DIFFERENCES BETWEEN NATURAL TO INNER JOIN 7 260)DIFFERENCES BETWEEN OUTER JOIN TO INNER JOIN ? 261)DIFFERENCES BETWEEN DELETE AND TRUNCATE ? 262)DIFFERENCES BETWEEN DROP AND DELETE ? 263)DIFFERENCES BETWEEN FLASHBACK AND ROLLBACK ? 264)DIFFERENCES BETWEEN ALTER AND UPDATE ? 265)DIFFERENCES BETWEEN TABLES AND VIEWS ?© semned ith nt Seamer