ORACLE DATABASE INTERVIEW QUESTIONS
What is an RDBMS?
2. What are the key features of an RDBMS?
What is a primary key in an RDBMS?
How does an RDBMS enforce data integrity?
What is normalization in the context of an RDBMS?
How do transactions work in an RDBMS?
What are joins in an RDBMS, and why are they used?
How does indexing improve the performance of an RDBMS?
What is a foreign key, and how does it relate to referential integrity?
Explain the ACID properties of a transaction in an RDBMS with an example?
What is ACID in the context of RDBMS, and why is it important?
How does Oracle ensure Atomicity in transactions?
What does Consistency mean, and how is it achieved in Oracle?
How does Oracle implement Isolation between concurrent transactions?
What is Durability, and how does Oracle ensure it?
What is RDBMS, and how does Oracle handle security at the row and table level?
How is row-level security implemented in Oracle?
What is table-level security, and how is it enforced in Oracle?
How does Oracle ensure that security policies do not impact performance?
What are some best practices for implementing row-level and table-level security in Oracle?