Home » Oracle » Oracle Quiz

Oracle Quiz

Leave a Comment / By /
Oracle Quiz

This Online Oracle quiz test check the understanding on various topics on Oracle sql like Delete ,truncate, constraints, drop ,select,insert, Joins, outer join, Natural join ,indexes , profiles,Dictionary views, many more

The below test is randomized Oracle Quiz and select 15 questions from the set of many questions,so each time you try to attempt it, you will get different questions in different order and option would also be in different order, So it will be fun practicing with this tool. You can try as many times as you want till you feel comfortable about it. I will keep updating the set of questions to make you feel competitive and comfortable with Oracle

Instructions for online test

1.This quiz consists of 15 questions .It is recommended to complete the test in 30 min
2. It consists both single choice and more than  one choice questions to test your knowledge
3. You can press the submit button at the end of your test and get the final score
4.You will also get the know the correct choice after you finished the test.

1. Which data dictionary view contains the definition of a view?

Question 1 of 15

2. Which of the following is a valid table name?

Question 2 of 15

3. Evaluate the SQL statement
DROP TABLE DEPT;
Which four statements are true of the SQL statement?

Question 3 of 15

See also  What is Oracle PLSQL Variable

4. What is the purpose of a referential integrity constraint?

Question 4 of 15

5. What is another name for a simple join or an inner join?

Question 5 of 15

6. A NATURAL JOIN is based on

Question 6 of 15

7. You create the emp table with the following command:

CREATE TABLE emp
(emp_no NUMBER(8)
CONSTRAINT emp-no-pk PRIMARY KEY,
emp_name NUMBER(8)
CONSTRAINT emp-name-nk NOT NULL);
Which index or indexes are created for the emp table?

Question 7 of 15

8. What function would you use to convert a numeric value into a VARCHAR2?

Question 8 of 15

9. What are the purposes of the SQLCODE and SQLERRM functions?

Question 9 of 15

See also  Top Oracle Enterprise Manager 13c Features

10. Which SQL statement defines a FOREIGN KEY constraint on the DEPTNO column of the EMP table?

Question 10 of 15

11. Which command would you use to remove all the rows from the EMP table and you dont have option to rollback?

Question 11 of 15

12. For which two constraints does the Oracle Server implicitly create a unique index?

Question 12 of 15

13. What is the purpose of the SUBSTR string function?

Question 13 of 15

14. Select the constraint used to validate that values in the given column meet the specific criteria?

See also  How to purge SYS.AUD$ table in Oracle

Question 14 of 15

15. Which statement about a self join is true?

Question 15 of 15


 

I hope you like this Oracle MCQ quiz and it helps in your examination preparation. Best of Luck for the Oracle certification Examination. Please do provide feedback on it. We will also be adding more quizzes and questions in future.

Happy Learning!!!!

Related Articles
Oracle Architecture MCQ :This is a Oracle Architecture MCQ to check your understanding on Oracle database Architecture concepts like Oracle background processes, memory elements
Oracle sql online test :Check out this Oracle sql online test for interview preparation & certification. This will help in checking your understanding on Oracle SQL
Oracle DBA quiz : this is a oracle dba quiz to check your understanding on DBA concepts.This will help in Passing oracle certification examination and the interview also
Oracle Performance & Tuning Quiz :Check out this Oracle performance online test for interview preparation & certification. This will help in checking your understanding on Oracle SQL
https://en.wikipedia.org/wiki/Oracle_Database

Related Posts

WFLOAD command

Oracle, Oracle Ebuisness Suite

INTRODUCTION TO WFLOAD COMMAND The WFLOAD command/ loader (workflow definitions loader) is a utility that moves workflow data between a file and a database. It…

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top