What would be the possible outcome of following SQL statement?
DELETE EMPNO FROM EMP; -- (HINT: TABLE EMP CONTAINS 100 RECORDS)
What is the error in following query?
SELECT DEPARTMENT_ID, LAST_NAME, SALARY
FROM EMPLOYEES
WHERE DEPARTMENT_ID = 30
ORDER BY DEPARTMENT_ID
INTERSECT
SELECT DEPARTMENT_ID, FIRST_NAME, SALARY
FROM EMPLOYEES
ORDER BY 1;
What would be the possible outcome of following SQL statement?
SELECT TRUNC (TO_NUMBER(TRIM (' 505 .99 '))) FROM DUAL;
How many records are there in EMP after running the following SQL statements? (Current records: 14)
INSERT INTO EMP (EMPNO) VALUES (1050);
SAVEPOINT X;
SAVEPOINT A;
SAVEPOINT B;
INSERT INTO EMP (EMPNO) VALUES (1051);
SAVEPOINT B;
UPDATE EMP SET SAL=100;
SAVEPOINT X;
DELETE FROM EMP;
ROLLBACK TO SAVEPOINT X;
SAVEPOINT X;
What would be the possible outcome of following SQL statement? --Assume SYSDATE= 15-Aug-2011
SELECT LAST_DAY (SYSDATE) FROM DUAL;
What would be the possible outcome of following SQL statement?
SELECT MOD (1500, 0) FROM DUAL;
What would be the possible outcome of following SQL statement?
SELECT COMMISSION_PCT, MAX(SALARY)
FROM EMPLOYEES
GROUP BY DEPARTMENT_ID;
What would be the possible outcome of following SQL statement?
UPDATE EMP SET (DEPTNO, SAL) = (10, 2000)
WHERE SAL>500 AND JOB=’CLERK’;
What would be the possible outcome of following SQL statement?
SELECT DEPTNO, COUNT (SAL)
FROM EMP
WHERE AVG(SAL) > 5000
GROUP BY DEPTNO;
Select the correct query to add a unique constraint on column "email" in EMP table?