Online tests assess the depth of your Oracle knowledge. Taking this Oracle
online practice test helps you judge your database proficiency. The Oracle quiz
here comprises of theoritical and practical questions on Oracle to find out
your current status and help you prepare for the job interviews, cerrtification
tests and other written tests. This is a set of 40 questions on Oracle with
some sample objective questions.
Online Practice
Test > Oracle test
More oracle online test
Oracle
online test part 2 (30 questions)
Oracle DBA online test (30 questions)
Oracle PLSQL online test (30 questions)
Oracle Replication online test (20 questions)
Oracle Architecture online test (20 questions)
Oracle Transaction online test (20 questions)
Here are few sample oracle test/quiz questions
Which of the following queries are legal?
SELECT deptno, count(deptno) FROM emp GROUP BY ename;
SELECT deptno, count(deptno), job FROM emp GROUP BY deptno;
SELECT deptno, avg(sal) FROM emp;
SELECT deptno, avg(sal) FROM emp GROUP BY deptno;
Which of the following SQL operations demands the use of wild cards
comparisons?
IN
BETWEEN
EXISTS
LIKE
Indicate whether this statement is true or false. A foreign key column must
contain unique values.
True
False
Click here to
start Oracle online quiz/test
More Links
Latest answer: There are four attributes of implicit cursor in
oracle: SQL%IsOPEN - Implicit cursor always returns FALSE as it gets closed
automatically...........
Latest answer: There are four attributes of explicit cursor in
oracle. %IsOPEN - This evaluates TRUE when cursor is open else
FALSE..........
|
