• 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 Architecture MCQ

Oracle Architecture MCQ

June 5, 2021 by techgoeasy Leave a Comment

Oracle Architecture MCQ

This Oracle Architecture MCQ test check the understanding on various topics like Recovery Manager (RMAN), Oracle Architecture concept like shared pool ,PGA, Library cache size,Backup & recovery , Oracle Memory structure, Background processes, Dictionary views , alert logs ,oracle tablespace ,indexes , profiles and many more

The below test is randomized Oracle Architecture MCQ 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. While performing an online backup, the database crashed due to a media failure. DBA kept several tablespaces in backup mode, and each tablespace had several data files. Which one of the following statements is most appropriate to use for taking the tablespaces out of backup mode?

Question 1 of 40

2. which of the following views contains information about overall system statistics, both previously and currently connected

Question 2 of 40

3. Prior to performing an incomplete database recovery, what is the most important task that you are supposed to perform as a DBA?

Question 3 of 40

4. Which one of the following views would you query to obtain information about data files that need recovery?

Question 4 of 40

5. which of the following components of SGA caches recently accessed data , index and rollback block

Question 5 of 40

6. which of the following background processes detects failed user process and roll backs

Question 6 of 40

7. Which one of the following statements enables the control file AUTOBACKUP feature?

Question 7 of 40

8. the alert log contains information on all but which of the following

Question 8 of 40

9. increasing the size of the system global area in order to improve performance is an example of which step in the oracle tuning methodology

Question 9 of 40

10. Which one of the following options would you use with RMAN to back up archive log files along with other files?

Question 10 of 40

11. To enable a database to have more than one service associated with it, the connect descriptor SID parameter in the tnsnames.ora file has been replaced by which two parameters?(Choose two)

Question 11 of 40

12. What is the most important action a DBA must perform after changing the database from NOARCHIVELOG TO ARCHIVELOG?

Question 12 of 40

13. Due to a media failure, all the members that are part of an online redo log group are lost. Under what conditions can you still recover the database without data loss?

Question 13 of 40

14. The buffers in the database buffer cache that are currently being accessed by a server process are referred to as?

Question 14 of 40

15. Which one of the following files contains records that are rejected by SQL*Loader due to invalid input format?

Question 15 of 40

16. response time is a measure of

Question 16 of 40

17. Which two statements are true when corrupted blocks are skipped?

Question 17 of 40

18. an oracle instance is made up of

Question 18 of 40

19. Which one of the following parameters when specified determines the maximum number of the files that can be stored in each backup set?

Question 19 of 40

20. What is the default value for the initialization parameter CONTROL_FILE_RECORD_KEEP_TIME?

Question 20 of 40

21. In which one of the following loading methods does SQL*Loader compete with the other processes to acquire buffer resources?

Question 21 of 40

22. Which one of the following commands must be issued to remove a stored script from the recovery catalog?

Question 22 of 40

23. throughput is a measure of

Question 23 of 40

24. An oracle database is made up of

Question 24 of 40

25. What can you see when querying V$LOGMNR_CONTENTS?

Question 25 of 40

26. Which one of the following configuration files can be used to implement the host naming method?

Question 26 of 40

27. Which three statements about fine-grained access control are true?

Question 27 of 40

28. Which Oracle process is responsible for archiving the online redo log files when the automatic archiving feature is enabled in ARCHIVELOG mode?

Question 28 of 40

29. When can you perform a database backup using RMAN if the database is in ARCHIVLOG mode?

Question 29 of 40

30. What must you do after the completion of copying the data files while performing online database backup?

Question 30 of 40

31. What is the result of issuing the following command? SQL> ALTER SYSTEM SET SHARED_SERVERS=0;

Question 31 of 40

32. Which one of the following Oracle components or products must be installed and configured to enable the secure communications between the client and the server over the network?

Question 32 of 40

33. Which one of the following statements about the tnsping utility is correct?

Question 33 of 40

34. Assume that you need to restore and recover a database that's operating in ARCHIVELOG mode. The archive log files available for recovery start from log sequence 21156 to 21190. If the archived log files with sequence number 21187, 21184, and 21180 are corrupted, then until which log sequence can you recover the database?

Question 34 of 40

35. if the init.ora optimizer mode is set to choose, but no statistics have been generated for the application’s tables and indexes, which optimizer mode will oracle user

Question 35 of 40

36. Which one of the following options of the export utility enables data to be directly transferred to the client without the intermediate evaluation buffer?

Question 36 of 40

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

Question 37 of 40

38. which of the following lock type is the most restrictive

Question 38 of 40

39. Which Oracle background process frees SGA resources that were allocated to a user process that failed?

Question 39 of 40

40. Which one of the following commands can you use to display whether or not the automatic archiving feature is enabled?

Question 40 of 40

Loading... Loading...

 

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

Filed Under: Oracle

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 compare statistics using history for a table in Oracle
  • How to create environment variables in Windows
  • How to transfer statistics between databases
  • How to import statistics
  • How to export statistics

Copyright © 2023 : TechGoEasy

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