• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General
Home » Oracle » Oracle Database » oracle dba quiz

oracle dba quiz

June 4, 2021 by techgoeasy Leave a Comment

I am presenting here the Oracle DBA quiz. I hope you like it

oracle dba quiz

This Oracle DBA online test check the understanding on various topics like RMAN, Oracle Structures,Backup & recovery , Oracle Memory structure, Background processes, Dictionary views , alert logs ,oracle tablespace ,indexes , profiles and many more

The below test is randomized Oracle DBA quiz and select 40 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

Instructions for online test

1.This quiz consists of 40 questions .It is recommended to complete the test in 60 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
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • Show paginator
  • Hide paginator

1. The best choice for decreasing size requirements for tables that need only be accessed via the primary key in oracle is which of the following?

Question 1 of 40

2. When choosing a character set and national character set, which of the following factors should not enter into consideration?

Question 2 of 40

3. When we issue the commit statement in the session, which of the following things will not occur?

Question 3 of 40

4. You are about to drop a tablespace. Which of the following statements can be used for dropping tablespaces that contain parent tables in foreign key relationships?

Question 4 of 40

5. Which of the following clauses in a create user statement restricts the number of tables a user can add to a tablespace?

Question 5 of 40

6. The DBA issues the following statement:
CREATE USER APPLDBA
IDENTIFIED BY APPLDBA;
What profile will user APPLDBA have?

Question 6 of 40

7. You need to identify the remaining free space in a tablespace. From which of the following views would you get this information most easily?

Question 7 of 40

8. You attempt to issue the alter tablespace rename datafile command in the Oracle database. Which of the following choices indicates a step that must take place after this command is issued?

Question 8 of 40

9. As the DBA, you are attempting to limit user's misuse of Oracle's ability to use host machine resources. Which of the following features of the Oracle database is useful for this purpose?

Question 9 of 40

10. If you wished to make it so that every user in Oracle could have only one connection to the database at a time, which of the following choices identifies how you would do it?

Question 10 of 40

11. You are implementing control file multiplexing. Which of the following choices identifies how Oracle knows the locations of the control files it is supposed to maintain?

Question 11 of 40

12. During regular database operation, which background process will take smaller blocks of free space in a dictionary-managed tablespace and move things around to make bigger pieces of free space?

Question 12 of 40

13. Which of the following choices identifies a constraint on performing alter tablespace resize operation if the intended size of the tablespace is larger than the tablespace’ s current size?

Question 13 of 40

14. You have assigned 10 tables to the keep pool. How should you determine the appropriate size for your keep pool?

Question 14 of 40

15. Your Oracle EMP table contains many unique values in the FIRST_NAME column. You want to index that column to take advantage of this fact in query access. Which of the following indexes might you use?

Question 15 of 40

16. Which of the following operations do not require Oracle to store information in an undo segment as part of the transaction?

Question 16 of 40

17. Which one of the following statements is incorrect with respect to RMAN's CROSSCHECK command?

Question 17 of 40

18. Which of the following is the init.ora parameter that indicates the size of each buffer in the buffer cache?

Question 18 of 40

19. You are working in an organization which is situated in many countries. You maintain databases in multiple countries in multiple languages. To determine the date conventions for a database in a particular country, you might use which of the following database views?

Question 19 of 40

20. User JOHN has create any table privilege with administrative abilities on that privilege. Which of the following statements show how to revoke the administrative component from JOHN without limiting her overall ability to create tables?

Question 20 of 40

21. Which one of the following statements is true while taking tablespace backups using RMAN?

Question 21 of 40

22. On an Oracle server installation, which of the following reorganizations of your indexes would be appropriate in order to improve performance of queries on tables containing all words in the dictionary starting with the letter 'S'?

Question 22 of 40

23. The user is selecting data from the Oracle database. Which of the following processes handles obtaining data from Oracle for that user?

Question 23 of 40

24. Records from the data dictionary information are stored in which of the following database memory areas?

Question 24 of 40

25. After creating a new user for your Oracle database, a user still complains he or she cannot log in because of insufficient privileges errors. Which of the following actions should you take?

Question 25 of 40

26. You need to remove a column from the database. Which of the following choices best identifies how to do so if your objective is to quickly execute the task without necessarily freeing up space in your tablespace?

Question 26 of 40

27. You want to find out the names and locations of all control files in your database. Which two of the following performance views would you query?

Question 27 of 40

28. You issue the following statement from SQL*Plus: startup mount. Where does Oracle obtain values for starting the instance?

Question 28 of 40

29. You are performing the steps that will create your Oracle data dictionary. The objects in the Oracle data dictionary are part of which of the following schemas?

Question 29 of 40

30. Which one of the following RMAN views must you query to view the code of an existing stored script in the recovery catalog?

Question 30 of 40

31. Information in the buffer cache is saved back to disk in each of the following situations except one. In which situation does this not occur?

Question 31 of 40

32. Which of the following choices lists an alter user option that can be executed by the user herself or himself?

Question 32 of 40

33. Session information when dedicated servers are being used is stored where in the Oracle database?

Question 33 of 40

34. You are attempting to locate your control files on an Oracle database called TEST. In which of the following files might you look for this information?

Question 34 of 40

35. The location of indexes in a database and the size of those indexes is information that can be found in which of the following dictionary views?

Question 35 of 40

36. Which two of the following items are required for killing a user session?

Question 36 of 40

37. You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?

Question 37 of 40

38. You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas?

Question 38 of 40

39. You want to perform some maintenance and You issue the shutdown command at 9 p.m. on a Saturday. One hours later, the database is still in the process of shutting down. Which of the following options did you most likely use in order to shut down the database?

Question 39 of 40

40. You alter a tablespace’ s default storage settings in the Oracle database to increase the size of initial extents. Which of the following choices identifies when the change will take effect for tables that already exist in that tablespace?

Question 40 of 40

Loading... Loading...

 

I hope you like this Oracle DBA online 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
How to prepare for OCI Associate Certified Examination : This post covers on how to prepare for Oracle cloud infrastructure Associate Architect examination (1Z0 932 /1072)
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
Tips for Passing OCI examination : Here is Oracle provided tips to clear OCI certification
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
Oracle Database Quiz : This is a Oracle Database Quiz to check your understanding on Oracle concepts. This will be helpful for interview and certification examination
oracle quiz :  This is a online Oracle Quiz to check your understanding on Oracle stuff like Truncate,delete, drop ,constraints, select query,distinct and many more

Filed Under: Oracle, Oracle Database Tagged With: 100 Basics oracle dba interview questions, 100 Basics Questions on Oracle DBA, Oracle DBA interview questions, oracle dba questions and answers

Reader Interactions

Leave a Reply Cancel reply

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

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • How to generate sql monitor report in Oracle
  • How to find the long running (longops session) in Oracle
  • How to find concurrent request id from Sid or spid
  • how to check recycle bin in oracle: Purge, enable/disable
  • how to check fra size in oracle: Location, usage, change size

Copyright © 2023 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us