Find us on Google+ Google+

October 22, 2012

Oracle DBA Interview Questions/FAQs Part4

Oracle DBA Interview Questions/FAQs Part4

61. What is the use of root.sh & oraInstRoot.sh?
Ans:
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?
Ans:
RMAN

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?
Ans:
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?
Ans:
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 ?
Ans:
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?


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