Oracle online test - oracle practice test - oracle quiz

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

Click here to start Oracle online quiz/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
Explain the attributes of implicit cursor

Latest answer: There are four attributes of implicit cursor in oracle: SQL%IsOPEN - Implicit cursor always returns FALSE as it gets closed automatically...........

Explain the attributes of explicit cursor.

Latest answer: There are four attributes of explicit cursor in oracle. %IsOPEN - This evaluates TRUE when cursor is open else FALSE.......... 



Write your comment - Share Knowledge and Experience

Discussion Board
Oracle Online Test - Oracle Practice Test - Oracle Quiz

What operator is used to prevent the error: ‘ORA-01427:single row sub query returns more than one row’ ?

Use the IN operator
Use the >= operator
Use the CAN EXIST operator
Use the = operator


Oracle Online Test 05-11-2012 07:58 AM

Oracle Online Test - Oracle Practice Test - Oracle Quiz

ll of the following can ONLY be used with numeric data types except:

AVG
COUNT
SUM
STDDEV


Oracle Online Test 05-11-2012 07:58 AM

Oracle Online Test - Oracle Practice Test - Oracle Quiz

Which of the following queries displays the sum of all employee salaries for those employees not making commission, for each job, including only those sums greater

than 2500?

select job, sum(sal) from emp where sum(sal) > 2500 and comm is null;
select job, sum(sal) from emp where comm is null group by job having sum(sal) > 2500;
select job, sum(sal) from emp where sum(sal) > 2500 and comm is null group by job;
select job, sum(sal) from emp group by job having sum(sal) > 2500 and comm is not null;


Oracle Online Test 05-11-2012 07:58 AM

Oracle Online Test - Oracle Practice Test - Oracle Quiz

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;


Oracle Online Test 05-11-2012 07:58 AM

More online test

Business object Test
OLAP Test
ReportNet Test
Microstrategy Test
Websphere Quiz
Solaris Quiz
SAS test
SQL server Quiz
Database Online Test
SQL Server DBA questions
Datawarehousing test
Biztalk Test
Networking Test
Iphone Test


Career 12-20-2011 04:51 AM

 


Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring