Amazon Oracle Database Administrator Interview Questions and Answers

Q1. What are stored procedures?
Ans. 
Stored procedures are precompiled database objects that can be called by applications to perform a specific task.
• Stored procedures are written in SQL or PL/SQL

• They can accept input parameters and return output parameters

• They can be used to encapsulate business logic and improve performance

• Examples include procedures for inserting, updating, and deleting data

• They can also be used for complex data manipulation and report
Answered by AI
Add your answer
Q2. Why is indexing required
Ans. 
Indexing is required to improve the performance of database queries.
• Indexing helps in faster retrieval of data from the database.

• It reduces the number of disk I/O operations required to fetch data.

• Indexes are created on columns that are frequently used in WHERE clauses or JOIN conditions.

• Examples of indexes include B-tree, bitmap, and hash indexes.
Answered by AI
Add your answer

Define schema for a simple book store