This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: a Yes b No 6.Which is not part of the Data Definiton Language ? a CREATE b ALTER c ALTER SESSION 7. The Data Manipulation Language statements are a INSERT b UPDATE c SELECT d All of the above 8.EMPNO ENAME SAL A822 RAMASWAMY 3500 A812 NARAYAN 5000 A973 UMESH A500 BALAJI 5750 Using the above data Select count(sal) from Emp will retrieve a 1 b 0 c 3 d None of the above 9.Which of the following statements contains an error? a.. SELECT * FROM emp WHERE empid = 493945; b. SELECT empid FROM emp WHERE empid= 493945; c. SELECT empid FROM emp; d. SELECT empid WHERE empid = 56949 AND lastname = 'SMITH'; 10.Which of the following is not a group function? a. avg( ) b. sqrt ( ) c. sum ( ) d. max ( )...
View Full Document
This note was uploaded on 10/25/2010 for the course CMPN SEM4 taught by Professor Thakur during the Spring '07 term at University of Mumbai.
- Spring '07