Oracle PLSQL online test, online practice test, exam, quiz

Oracle PLSQL Online Test

The purpose of this online test is to help you evaluate your Oracle PLSQL knowledge yourself. These Multiple Choice Questions (MCQs) on Oracle PLSQL will prepare you for technical round of job interview, written test and many certification exams.

The test contains 30 questions and there is no time limit. You will get 1 point for each correct answer. You will get your online test score after finishing the complete test.

(Total 30 questions) (Time spent 0:0)

1. What is the meaning of + sign in a condition like where consumer.consumer _id = orders.consumer _id(+);

indicates that, if a consumer _id value in the consumer table does not exist in the orders table, all fields in the orders table will display as in the result set.

indicates that, if a consumer _id value in the consumer table exists in the orders table, all fields in the orders table will display as in the result set.

indicates that, if a consumer _id value in the consumer table does not exist in the orders table, all fields in the orders table will display as default value in the result set.

indicates that, if a consumer _id value in the consumer table exists in the orders table, all fields in the orders table will display as default value in the result set.

View Test Answer

Oracle PLSQL online test, online practice test, exam, quiz

Oracle PLSQL Online Test

Online Practice Test

Advertisement