SQL Course completion Exam Online Test

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?






















































Description:

This Exam assess your readiness to start working on SQL. Test to be taken after the completion of course and practice.

Discussion

Premium

Overview: vc 22350 i(https://california-business-lawyer-corporate-lawyer.com/california-laws/vehicle-code-vc-22350/)

There was a triable issue as to whether, in the absence of the allegedly false advertising,See more

379 days 2 hours 50 minutes ago

Poppy Cohn

what it feels when all the questions you prepared for exam can appear in real exam.
I know it's the best feeling. yes I'm talking about https://www.dumpslocator.com/oracle-exams.html

504 days 2 hours 17 minutes ago

Hjwese9898

Do You know what? I used Oracle Exam Dumps dumps from ExamforSure site and didn't even opened my notes and no other books at all because their provided study guide was really really helpful if you dont have much time to prepare for your exam. You should give it a try. It won't let you down..

https://www.examforsure.com/oracle-exam-dumps.html

844 days 19 hours 24 minutes ago

Michael

Hi,

Our company has a quite a few interns. Does the test also apply to people, who do not have a prior understanding of the subject?

Best regards,
Michael from https://moneylender.dk/kvikl%C3%A5n

1148 days 2 hours 22 minutes ago

Michael

Hi,

Our company has a quite a few interns. Does the test also apply to people, who do not have a prior understanding of the subject?

Best regards,
Peter from https://moneylender.dk/kvikl%C3%A5n

1148 days 2 hours 22 minutes ago

Padmaja

answer is wrong. Last_day always return last day of month.

1503 days 6 hours 51 minutes ago

Lasse Poulsen

Is it possible to have the exam assignment sent to me, so I can use it for course of training?

Regards,
Lasse from https://moneybanker.dk/

1521 days 1 hours 21 minutes ago

Pradeep

For Q5 the ans is 505

2174 days 12 hours 42 minutes ago

Paul Romias

No, question no 5 correct answer is D. the last_day command always return the last day of the year.

3039 days 10 hours 19 minutes ago

Ishu Sharma

question no 5 correct answer is b.

3059 days 2 hours 37 minutes ago

DTecH IT Education
DTecH IT Education-Your mentor for a better Career
User
42 Followers

Your Facebook Friends on WizIQ

More Tests By Author

1Z0-051: Oracle 11g SQL Exam
25 Questions | 17485 Attempts

Oracle Interview Questions - Frequently Asked
10 Questions | 7044 Attempts

Oracle SQL, PL/SQL Quiz
10 Questions | 52124 Attempts