Scribd Logo
Upload

Welcome to Scribd!

  • 33 views

    Interview Qsns Dba

    Uploaded by

    Nainika Kedarisetti
    The document contains 55 Oracle DBA interview questions covering a wide range of topics related to an Oracle DBA's responsibilities and tasks. Some of the key areas addressed include the roles and common tasks of a DBA, Oracle database objects, database administration tools, database security management, database backup and recovery processes using RMAN, database performance tuning, and the physical structure and architecture of Oracle databases.

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd

    Interview Qsns Dba

    Uploaded by

    Nainika Kedarisetti
    33 views2 pages
    The document contains 55 Oracle DBA interview questions covering a wide range of topics related to an Oracle DBA's responsibilities and tasks. Some of the key areas addressed include the roles and common tasks of a DBA, Oracle database objects, database administration tools, database security management, database backup and recovery processes using RMAN, database performance tuning, and the physical structure and architecture of Oracle databases.

    Original Title

    Interview qsns dba

    Copyright

    © © All Rights Reserved

    Available Formats

    TXT, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains 55 Oracle DBA interview questions covering a wide range of topics related to an Oracle DBA's responsibilities and tasks. Some of the key areas addressed include the roles and common tasks of a DBA, Oracle database objects, database administration tools, database security management, database backup and recovery processes using RMAN, database performance tuning, and the physical structure and architecture of Oracle databases.

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd
    Download as txt, pdf, or txt
    33 views2 pages

    Interview Qsns Dba

    Uploaded by

    Nainika Kedarisetti
    The document contains 55 Oracle DBA interview questions covering a wide range of topics related to an Oracle DBA's responsibilities and tasks. Some of the key areas addressed include the roles and common tasks of a DBA, Oracle database objects, database administration tools, database security management, database backup and recovery processes using RMAN, database performance tuning, and the physical structure and architecture of Oracle databases.

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd
    Download as txt, pdf, or txt
    You are on page 1of 2

    Oracle DBA interview questions

    1. What are the responsibilities of the database administrator’s tasks?


    2. Differentiate between Oracle DBA and Oracle Developer?
    3. You want to find out how many users are defined in the password file and what
    privileges those users have. How would you accomplish this?
    4. What are the roles of DBA?
    5. What are the common Oracle DBA tasks?
    6. Name the various Oracle database objects?
    7. What are the contents of the control file?
    8. List out the tools for administering the database?
    9. What are the dictionary tables used to monitor a database space?
    10. What are the differences between EBU and RMAN?
    11. What is the logical structure of the disk resources?
    12. How do you find the total database size in the database?
    13. What are the different levels of auditing?
    14. Why is performance tuning a menacing area for DBA's?
    15. What are the dynamic performance views? Who has the access to these views?
    16. What is an ASM instance?
    17. What is an ASM Disk Group?
    18. Explain the procedure of restoring RMAN for the recovery if all the instances
    are down.
    19. What is instance recovery?
    20. Which files must be backed up?
    21. What is a backup set?
    22. What are the architectural components of RMAN?
    23. What does RMAN backup consist of?
    24. What do you mean by recovery catalog?
    25. What are the uses of a database Resource Manager?
    26. What is a Resource Plan?
    27. Which components of your database environment can be protected by an “Oracle
    Restart” configuration?
    28. Which tools can you use to start up an Oracle database?
    29. What are the main aspects of oracle database security management?
    30. How can you improve the performance of Sql*loader?
    31. What Is Oracle Database?
    32. Explain Oracle Grid Architecture?
    33. What Is The Difference Between Large Dedicated Server And Oracle Grid?
    34. What Are The Computing Components Of Oracle Grid?
    35. What Is Recoverer Process?
    36. What Are Job Queue Processes?
    37. What Are Archiver Processes?
    38. What Is Rollback Segment ?
    39. What Is A Segment?
    40. What Is A Synonyms?
    41. What Is Server Virtualization?
    42. What Is Storage Virtualization?
    43. What Is Grid Management Feature?
    44. What Is An Extent?
    45. What Are Data Blocks?
    46. When Oracle Allocates An Sga?
    47. What Is An Oracle Instance?
    48. What Are The Several Tools For Interacting With The Oracle Database Using Sql?
    49. How Views Are Used?
    50. How Oracle Works?
    51. What Contains Oracle Physical Database Structure?
    52. What Is A Tablespace?
    53. What Is A Dimension?
    54. Explain Sequence Generator In Oracle?
    55. What Is A Control File?
    56.What Is An Index?
    57. Explain Briefly Shared Server Architecture?

    You might also like