Home » Oracle » Oracle Database » Oracle Database Quiz

Oracle Database Quiz

Leave a Comment / By /
Oracle Database Quiz

This Online Oracle Database quiz test check the understanding on various topics on Oracle like Delete ,cache, Natural join ,indexes , profiles,Dictionary views,Oracle sql tuning, Oracle background processes, insert statement and many more to help you in test

The below test is randomized Oracle Quiz and select 20 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 20 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.

This quiz is automatically created to help you get started. It will be created only once.

1. Which type of table is the best candidate to be cached?

Question 1 of 20

2. What is the main reason to create a reverse key index on a column?

Question 2 of 20

3. the ability to store predefined execution plans so that the optimizer knows in advance which execution plan is best is called

Question 3 of 20

See also  Oracle ASM Diskgroups : Create and Alter diskgroup

4. histograms are useful because they allow the optimizer to have a better idea of how the data in an indexed columns is

Question 4 of 20

5. Which three statements about rebuilding indexes are true?

Question 5 of 20

6. User John creates an index with this statement:

CREATE INDEX dept_indx On dept ( empno);
In which tablespace would the index be created?

Question 6 of 20

7. which of the following factors would not make a column a good candidate for b-tree index

Question 7 of 20

8. What  can you use the values in the GETS and GETMISSES columns of V$ROWCACHE to determine the hit ratio for?

Question 8 of 20

9. The cost- based optimizer can choose between a nested loops join and a sort merge join operation. All tables are analyzed and the OPTIMIZER_ MODE is set to FIRST_ ROWS. Which execution plan will be the result?

See also  approx_count_distinct : Oracle Database 12c

Question 9 of 20

10. Which statement about the amount of undo generated is  true?

Question 10 of 20

11. the optimizer mode can be set at which of the following levels

Question 11 of 20

12. What are two possible causes of lock contention?

Question 12 of 20

13. Which view would you query to monitor cumulative total waits for all events and all sessions?

Question 13 of 20

14. You pinned an object in the shared pool using the DBMS_ SHARED_ POOL package.Which command could you use to unpin this object, assuming you are in a SQL * Plus session?

Question 14 of 20

15. Which type of change to an application is most likely to improve performance of the library cache?

Question 15 of 20

16. What are  two benefits of using locally managed tablespaces with segment space management set to auto?

Question 16 of 20

See also  ORA-00054: resource busy and acquire with NOWAIT specified

17. finding a statement already cached in the library cache is referred as

Question 17 of 20

18. which of the following types of indexes stores the indexed columns values associated row id as binary string

Question 18 of 20

19. following an ANALYZE command, which of the following data dictionary views will contain statistics on the number of rows in a table

Question 19 of 20

20. Which action could result in less frequent checkpoints?

Question 20 of 20


 

I hope you like this Oracle Database 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
https://en.wikipedia.org/wiki/Oracle_Database
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

Related Posts

Leave a Comment

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

Scroll to Top