Home > Oracle > Quizzes > Oracle Database Fundamentals Test
Oracle Database Fundamentals Test
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 7% • Most missed: “There are 2 classifications of an index:”
Oracle Database Fundamentals Test
Time left 00:00
25 Questions

1. In an Oracle RAC environment - a physical standby database will be registered with the clusterware. When creating the clusterware resource for the standby database - which of the following commands do you use to perform this registration?
2. What will the shortcut 'Ctrl + F11' do?
3. SQL stands for:
4. Which of the following SQL functions can operate on any datatype?
5. Which of these is not a real Oracle suite option?
6. Regarding Oracle - what does DES most commonly mean?
7. The Oracle Certification Program contains three levels. Which of these is not one of them?
8. In Oracle 'view' consists of:
9. In business - what is the most common definition for CRM?
10. Oracle default optimization follows:
11. The source code of procedure - function and package bodies can be queried from which data dictionary?
12. Which of the following are system privileges?
13. Which of the following statements are true about deleting or updating a statement?
14. Which of the following statements is true about rebuilding indexes?
15. Which of these is not a language element of SQL?
16. Order the following entities from the smallest to the largest:
17. How would you display a listing of the sums of employee salaries for those employees not making a commission - for each job type - including only those sums greater than 2500?
18. A rollback segment can be specified as either PUBLIC or PRIVATE. The value of PCTINCREASE of a rollback segment is always set to:
19. Which function is not in DBMS_OUTPUT?
20. You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which statement accomplishes this task?
21. The 'materialized view' in Oracle stores:
22. What is the purpose of the Rollback command?
23. What is the definition of data buffer cache?
24. What clause follows 'group by' in SQL?
25. What happens if the command ALTER TABLE DEALLOCATE UNUSED is used without the KEEP clause?

⚡ Recently practiced quizzes in this topic
Live quiz activity
Oracle Database 11 G Administration Oracle Certification Questions Oracle SQL Oracle PL - SQL Oracle Data Warehousing 11g Essentials Oracle 11g
 
❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

🌈  Our mission is to help improve your scores in any subject and exam withonline quizzes, practice tests, study guides, & advice for students. Since 2018.
About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | OSHA Basics Quiz | What Should We Know?
Privacy | Terms |
Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.