Oracle DBA (DataBase Admin) Interview Questions with Answers Part4
61. What is the use of root.sh & oraInstRoot.sh?
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)?
Answer :
63. How can you transport tablespaces (TTS) across platforms with different endian formats?
Answer :
RMAN
64. What is XTSS (cross platform transportable tablespace)?
Answer :
65. What is the difference between restore point & guaranteed restore point?
Answer :
67. What are the components of Grid control (OEM)?
Answer :
OMS (Oracle Management Server)
OMR (Oracle Management Repository)
OEM Agent
68. What were the new features of 12c Cloud control?
Answer :
69. How to find if your Oracle database is 32 bit or 64 bit?
Answer :
execute the command "file $ORACLE_HOME/bin/oracle", for 64 bit oracle, you should see output like
69. How to find if your Oracle database is 32 bit or 64 bit?
Answer :
execute the command "file $ORACLE_HOME/bin/oracle", for 64 bit oracle, you should see output like
/u01/db/bin/oracle: ELF 64-bit MSB executable SPARCV9 Version 1
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?
Answer :
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?
Answer :
72. How many types of histograms are there in Oracle 11g & in Oracle 12c?
Answer :
73. What is Oracle Transparent Data Encryption (TDE)?
Answer :
74. What is Data Redaction and how it will protect data?
Answer :
75. What is the difference between instance recovery and crash recovery ?
Answer :
Crash recovery is done automatically by SMON, in case of abnormal 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 ORA-04031 and ORA-04030 and what is the 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
77. What were the new features in Oracle 12c (release 2)?
Answer :
78. What were the new features in Oracle 18c?
Answer :
79. What were the new features in Oracle 19c?
Answer :
80. What were the new features in Oracle 21c?
Answer :
Hi Satya
ReplyDeleteIn 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
e.g
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,
Radhey