Find us on Google+ Google+

October 22, 2018

Oracle DBA Interview Questions and Answers Part4

Oracle DBA (DataBase Admin) Interview Questions with Answers Part4

61. What is the use of &
Answer :
Changes ownership & permissions of oraInventory
Creating oratab file in the /etc directory
In RAC, starts the clusterware stack

62. What is transportable tablespace (and across platforms)?

63. How can you transport tablespaces (TTS) across platforms with different endian formats?
Answer :

64. What is xtss (cross platform transportable tablespace)?

65. What is the difference between restore point & guaranteed restore point?

66. What is the difference between 10g/11g OEM Grid control and 12c Cloud control?

67. What are the components of Grid control?
Answer :
OMS (Oracle Management Server)
OMR (Oracle Management Repository)
OEM Agent

68. What are the new features of 12c Cloud control?

69. How to find if your Oracle database is 32 bit or 64 bit?
Answer :
execute the command "file $ORACLE_HOME/bin/oracle", you should see output like /u01/db/bin/oracle: ELF 64-bit MSB executable SPARCV9 Version 1

means you are on 64 bit oracle.

If your oracle is 32 bit you should see output like below
oracle: ELF 32-bit MSB executable SPARC Version 1

70. How to find opatch Version ?
Answer :
opatch is utility to apply database/RDBMS patch, in order to find opatch version execute"$ORACLE_HOME/OPatch/opatch version"

71. What are histograms?

72. How many types of histograms are there in Oracle 11g & in Oracle 12c?

73. What is Oracle Transparent Data Encryption (TDE)?

74. What is Data Redaction and how it will protect data?

75. What is the difference between instance recovery and crash recovery ?
Answer :
Crash recovery is done automatically by SMON, in case of abonormal shutdown such as shutdown abort or any such reason.

Instance recovery refers to the case where a surviving instance recovers a failed instance in an Oracle Real Application Clusters (RAC) database.

76. What is the difference between Local and Global Index ?

77. What is ORA-04031 and ORA-04030 and what is difference between ORA-04030 and ORA-04031 ?
Answer :
ORA-04031: unable to allocate nn bytes of shared memory
ORA-04030: out of process memory when trying to allocate nn bytes

Related Oracle Interview Articles: Oracle Database Admin Interview Questions/FAQs – Part1   Oracle DBA Interview Questions/FAQs – Part2    Oracle DBA Interview Questions/FAQs – Part3

1 comment:

  1. Hi Satya

    In debt to you for making my learning on the Oracle DBA Interview Questions and Answers Part4 area so hassle-free! I lay my faith on your writings

    I've the attached table structure & data.

    From which I have a list of screen Ids from tbl_screen, and would like to get a list of users assigned, their privilege & access
    Get the digits from the ID Student.mod.456.std in tbl_screen
    this digit is prefixed with @ and added in tbl_user field user_screen @456
    then get which rights is attached to this users (tbl_user & tbl_user_rights id)
    then get the action priviledge from tbl_user_access

    Any idea.. how to build the select statement pls?
    Very useful post !everyone should learn and use it during their learning path.

    Kind Regards,