Oracle SQL, PL/SQL Quiz Online Test

Can you commit inside a Trigger?

Maximum characters allowed in dbms_out.put_line()

Can you delete a column in table with data in Oracle?

Maximum number of columns in a table or view in Oracle 9i?

What is the Datatype of NULL in Oracle?

Maximum length of all Oracle Objects in 9i:

How to check the version of Oracle?

Maximum levels of subqueries in the WHERE clause of an SQL statement?

How to Kill a Session in Oracle?

Oracle UTL_FILE Package is used :


Oracle SQL, PL/SQL Quiz made up from lots of real interview questions.


aleena mark providing you with exam questions & confirmed answers that imitate the actual exam. These important questions & answers offer you with the knowledge of taking the actual test. These basis exams are not only questions & answers. Certification Specialists, who have a solid, confirmed & certified background & high technical skill, have compiled these detailed and information exams foundation. It’s guaranteed you will pass your any exam in the first attempt. We are giving you money back guarantee. Our company status is very high in the market and we don’t want to lose it. If you need to ask any question regarding your PDF exams so, now you can ask freely.

19 days 12 hours 5 minutes ago


This is a wrong answer. NULL doesn't have a data type. NULL is never equal to any value.

33 days 5 hours 1 minutes ago


I think the answer for this question is yes, but not always.
For example assume we have a primary key column (let it be col1) for a table (let be table1),and a column (col2) in other table (let be table 2) is a foreign key to table 1 col1.
If we try to delete/drop col1, then we will get a "cannot drop parent key column" error.

33 days 5 hours 2 minutes ago

Aliza John

Oracle Corporation reserves the right to take action against any candidate involved in fraudulent activities, including, but not limited to, fraudulent use of vouchers, promotional codes, reselling exam discounts and vouchers, cheating on an exam, alteration of score reports, alteration of completion certificates, violation of exam retake policies or other activities deemed fraudulent by Oracle.

113 days 22 hours 19 minutes ago


thnz, i'll learn more from it.

259 days 22 hours 59 minutes ago


good test and very basic questions.

272 days 22 hours 37 minutes ago

Ihead Go

Found a site ( that offers tons of practice exams for multiple subjects. They offer practice exams for almost anything possible. Check it out.
Checking out this site and looks interesting...a lot of different Exams TI.

749 days 13 hours 36 minutes ago



810 days 11 hours 21 minutes ago


Yes Good Test.Very basic and important Questions

968 days 11 hours 57 minutes ago


So STUPID test!!!
Who need to REMEMBER those numbers?!?!
Statister, not a developer would answer such!

1007 days 8 hours 37 minutes ago

DTecH IT Education
DTecH IT Education-Your mentor for a better Career

Your Facebook Friends on WizIQ

More Tests By Author

SQL Course completion Exam
10 Questions | 730 Attempts

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

Oracle Interview Questions - Frequently Asked
10 Questions | 6630 Attempts