Oracle SQL Interview Questions and Answers
Practice one question at a time. Read the question, answer aloud, then compare your explanation with the answer.
← Back to the complete interview hub
Q1. What is Oracle Database?
Easy
Answer: Oracle Database is a powerful relational database management system (RDBMS) developed by Oracle Corporation. It is used to store, manage, retrieve, and secure large volumes of structured data. Oracle is widely used in enterprise applications because of its high performance, scalability, reliability, security, and advanced database features.
Interview tip: Use a short example and connect the answer to real project work.
Q2. What are the main features of Oracle Database?
Easy
Answer: Oracle Database provides high availability, scalability, security, transaction management, backup and recovery, partitioning, indexing, PL/SQL support, RAC (Real Application Clusters), Data Guard, Flashback technology, and advanced performance optimization features.
Interview tip: Use a short example and connect the answer to real project work.
Q3. What is SQL?
Easy
Answer: SQL (Structured Query Language) is the standard language used to create, retrieve, update, delete, and manage data in relational databases. It is also used to define database structures, control access, and manage transactions.
Interview tip: Use a short example and connect the answer to real project work.
Q4. What are the different types of SQL statements?
Medium
Answer: SQL statements are classified into five categories: DDL (CREATE, ALTER, DROP, TRUNCATE, RENAME), DML (INSERT, UPDATE, DELETE, MERGE), DQL (SELECT), DCL (GRANT, REVOKE), and TCL (COMMIT, ROLLBACK, SAVEPOINT).
Interview tip: Use a short example and connect the answer to real project work.
Q5. What is the difference between DELETE, TRUNCATE, and DROP?
Medium
Answer: DELETE removes selected rows and can be rolled back before commit. TRUNCATE removes all rows by deallocating data pages, is faster than DELETE, and cannot be rolled back after execution in Oracle because it performs an implicit commit. DROP permanently removes the entire database object, including its structure and data.
Interview tip: Use a short example and connect the answer to real project work.
Q6. What is a table in Oracle?
Easy
Answer: A table is the primary database object used to store related data in rows and columns. Each row represents a record, and each column represents an attribute with a specific data type.
Interview tip: Use a short example and connect the answer to real project work.
Q7. What are Oracle data types?
Medium
Answer: Oracle supports data types such as NUMBER, VARCHAR2, CHAR, DATE, TIMESTAMP, CLOB, BLOB, RAW, LONG, INTERVAL, and XMLTYPE. Choosing the correct data type improves storage efficiency and query performance.
Interview tip: Use a short example and connect the answer to real project work.
Q8. What is the difference between CHAR and VARCHAR2?
Medium
Answer: CHAR is a fixed-length character data type that pads unused space with blanks. VARCHAR2 is a variable-length character data type that stores only the actual characters entered, making it more storage-efficient for most applications.
Interview tip: Use a short example and connect the answer to real project work.
Q9. What is the difference between NUMBER and INTEGER in Oracle?
Medium
Answer: NUMBER is Oracle's primary numeric data type and supports integers as well as decimal values with configurable precision and scale. INTEGER is a subtype of NUMBER with a scale of zero and is used for whole numbers only.
Interview tip: Use a short example and connect the answer to real project work.
Q10. What is the difference between Oracle Database and MySQL?
Hard
Answer: Oracle Database is an enterprise-grade commercial RDBMS offering advanced features such as RAC, Data Guard, Flashback, partitioning, advanced security, and sophisticated performance tuning. MySQL is an open-source relational database that is easier to deploy and commonly used for web applications but has fewer enterprise features than Oracle.
Interview tip: Use a short example and connect the answer to real project work.
Q11. What are constraints in Oracle?
Easy
Answer: Constraints are rules applied to table columns to maintain data integrity and accuracy. They prevent invalid data from being inserted or updated. Common Oracle constraints include PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK, and NOT NULL.
Interview tip: Use a short example and connect the answer to real project work.
Q12. What is a Primary Key?
Easy
Answer: A Primary Key is a constraint that uniquely identifies each row in a table. A primary key column cannot contain NULL values or duplicate values. Each table can have only one primary key, which may consist of one or multiple columns.
Interview tip: Use a short example and connect the answer to real project work.
Q13. What is a Foreign Key?
Easy
Answer: A Foreign Key is a constraint that establishes a relationship between two tables. It references the Primary Key or Unique Key of another table and helps maintain referential integrity by preventing invalid references.
Interview tip: Use a short example and connect the answer to real project work.
Q14. What is the difference between a Primary Key and a Unique Key?
Easy
Answer: A Primary Key uniquely identifies each row and does not allow NULL values. A Unique Key also enforces uniqueness but allows NULL values (subject to Oracle's uniqueness rules). A table can have only one Primary Key but multiple Unique Keys.
Interview tip: Use a short example and connect the answer to real project work.
Q15. What is a CHECK constraint?
Easy
Answer: A CHECK constraint restricts the values that can be stored in a column by enforcing a logical condition. For example, it can ensure that a salary is greater than zero or an age is between 18 and 60.
Interview tip: Use a short example and connect the answer to real project work.
Q16. What is a NOT NULL constraint?
Easy
Answer: The NOT NULL constraint ensures that a column always contains a value. It prevents NULL values from being inserted or updated in that column.
Interview tip: Use a short example and connect the answer to real project work.
Q17. What is an INNER JOIN?
Medium
Answer: An INNER JOIN returns only the rows that have matching values in both tables based on the specified join condition. Rows without matching values are excluded from the result.
Interview tip: Use a short example and connect the answer to real project work.
Q18. What are the different types of OUTER JOINs in Oracle?
Medium
Answer: Oracle supports LEFT OUTER JOIN, RIGHT OUTER JOIN, and FULL OUTER JOIN. A LEFT OUTER JOIN returns all rows from the left table and matching rows from the right table. A RIGHT OUTER JOIN returns all rows from the right table and matching rows from the left table. A FULL OUTER JOIN returns all matching and non-matching rows from both tables.
Interview tip: Use a short example and connect the answer to real project work.
Q19. What is a SELF JOIN?
Medium
Answer: A SELF JOIN is a join where a table is joined with itself. It is commonly used to represent hierarchical relationships such as employees and managers stored in the same table.
Interview tip: Use a short example and connect the answer to real project work.
Q20. What is a CROSS JOIN?
Medium
Answer: A CROSS JOIN returns the Cartesian product of two tables, meaning every row from the first table is combined with every row from the second table. If one table contains 100 rows and another contains 50 rows, the result will contain 5,000 rows.
Interview tip: Use a short example and connect the answer to real project work.
Q21. What are Single Row Functions in Oracle?
Medium
Answer: Single Row Functions operate on one row at a time and return one result for each row processed. They are commonly used for character, numeric, date, conversion, and general-purpose operations.
Interview tip: Use a short example and connect the answer to real project work.
Q22. What are Aggregate Functions in Oracle?
Medium
Answer: Aggregate Functions perform calculations on multiple rows and return a single result. Common aggregate functions include COUNT(), SUM(), AVG(), MIN(), MAX(), and LISTAGG(). They are frequently used with the GROUP BY clause.
Interview tip: Use a short example and connect the answer to real project work.
Q23. What is the GROUP BY clause?
Medium
Answer: The GROUP BY clause groups rows that have the same values in specified columns so that aggregate functions can be applied to each group. It is commonly used for reports and summary calculations.
Interview tip: Use a short example and connect the answer to real project work.
Q24. What is the HAVING clause?
Medium
Answer: The HAVING clause filters grouped data after the GROUP BY operation has been performed. Unlike the WHERE clause, HAVING is used with aggregate functions to filter groups based on calculated values.
Interview tip: Use a short example and connect the answer to real project work.
Q25. What is the difference between WHERE and HAVING?
Medium
Answer: The WHERE clause filters individual rows before grouping occurs and cannot use aggregate functions directly. The HAVING clause filters grouped results after the GROUP BY operation and is commonly used with aggregate functions such as COUNT(), SUM(), and AVG().
Interview tip: Use a short example and connect the answer to real project work.
Q26. What is a subquery in Oracle?
Hard
Answer: A subquery is a query written inside another SQL statement. It can be used in SELECT, INSERT, UPDATE, DELETE, or WHERE clauses to provide values or filter results. Subqueries may return a single value, multiple rows, or multiple columns.
Interview tip: Use a short example and connect the answer to real project work.
Q27. What is a correlated subquery?
Hard
Answer: A correlated subquery is a subquery that references columns from the outer query. It is executed once for every row processed by the outer query, making it more flexible but often slower than a regular subquery.
Interview tip: Use a short example and connect the answer to real project work.
Q28. What is the EXISTS operator in Oracle?
Hard
Answer: The EXISTS operator checks whether a subquery returns at least one row. If the subquery returns any record, EXISTS evaluates to TRUE. It is commonly used for efficient existence checks and correlated subqueries.
Interview tip: Use a short example and connect the answer to real project work.
Q29. What is the difference between IN and EXISTS?
Hard
Answer: The IN operator compares a value against a list of values returned by a subquery and is suitable for smaller result sets. EXISTS checks only whether matching rows exist and often performs better for large datasets because it stops searching after finding the first matching row.
Interview tip: Use a short example and connect the answer to real project work.
Q30. What are the set operators in Oracle?
Hard
Answer: Oracle provides four set operators: UNION combines results and removes duplicates, UNION ALL combines results without removing duplicates, INTERSECT returns only common rows, and MINUS returns rows from the first query that are not present in the second query. The participating queries must return the same number of columns with compatible data types.
Interview tip: Use a short example and connect the answer to real project work.
Q31. What is a View in Oracle?
Medium
Answer: A View is a virtual table created from the result of one or more SQL queries. It does not store data itself but displays data from underlying tables. Views improve security, simplify complex queries, and provide logical data abstraction.
Interview tip: Use a short example and connect the answer to real project work.
Q32. What is a Materialized View?
Hard
Answer: A Materialized View stores the query result physically in the database. Unlike a regular view, it improves query performance by avoiding repeated execution of complex queries. Materialized views can be refreshed manually, on demand, or automatically.
Interview tip: Use a short example and connect the answer to real project work.
Q33. What is an Index in Oracle?
Medium
Answer: An Index is a database object that improves query performance by providing faster access to rows. Oracle uses indexes to reduce the amount of data scanned during query execution. However, indexes require additional storage and can slightly slow INSERT, UPDATE, and DELETE operations.
Interview tip: Use a short example and connect the answer to real project work.
Q34. What is the difference between Unique, Composite, and Function-Based Indexes?
Hard
Answer: A Unique Index prevents duplicate values in indexed columns. A Composite Index is created on two or more columns to optimize queries using those columns together. A Function-Based Index stores the result of an expression or function, allowing Oracle to efficiently execute queries that use functions in the WHERE clause.
Interview tip: Use a short example and connect the answer to real project work.
Q35. What is a Sequence in Oracle?
Medium
Answer: A Sequence is a database object that automatically generates unique numeric values. It is commonly used to generate primary key values and supports options such as START WITH, INCREMENT BY, CACHE, NOCACHE, CYCLE, and NOCYCLE.
Interview tip: Use a short example and connect the answer to real project work.
Q36. What is a Synonym in Oracle?
Medium
Answer: A Synonym is an alias for a database object such as a table, view, sequence, or procedure. Synonyms simplify object access, hide object ownership, and make applications easier to maintain.
Interview tip: Use a short example and connect the answer to real project work.
Q37. What is ROWID in Oracle?
Hard
Answer: ROWID is a unique pseudo-column that identifies the physical storage location of a row in a table. Oracle can use ROWID for very fast row retrieval, and it is often used internally for query optimization and troubleshooting.
Interview tip: Use a short example and connect the answer to real project work.
Q38. What is ROWNUM in Oracle?
Medium
Answer: ROWNUM is a pseudo-column that assigns a sequential number to rows as they are returned by a query. It is commonly used to limit query results or retrieve the top N rows. Since numbering occurs before ORDER BY, nested queries are often required when sorting results first.
Interview tip: Use a short example and connect the answer to real project work.
Q39. What is the difference between ROWNUM and ROW_NUMBER()?
Hard
Answer: ROWNUM is assigned before ORDER BY and simply numbers rows as they are retrieved. ROW_NUMBER() is an analytic function that assigns row numbers after sorting based on the ORDER BY clause within the OVER() function, making it more suitable for ranking and pagination.
Interview tip: Use a short example and connect the answer to real project work.
Q40. How is pagination implemented in Oracle?
Hard
Answer: In Oracle 12c and later, pagination is implemented using the OFFSET ... FETCH NEXT ... ROWS ONLY clause. In earlier versions, pagination is commonly implemented using ROW_NUMBER() with a subquery or ROWNUM in nested queries.
Interview tip: Use a short example and connect the answer to real project work.
Q41. What is PL/SQL?
Easy
Answer: PL/SQL (Procedural Language/SQL) is Oracle's procedural extension of SQL. It combines SQL with procedural programming features such as variables, loops, conditions, cursors, exception handling, procedures, functions, and packages, enabling developers to write powerful database programs.
Interview tip: Use a short example and connect the answer to real project work.
Q42. What is an Anonymous Block in PL/SQL?
Easy
Answer: An Anonymous Block is a PL/SQL block that does not have a name and is not stored in the database. It is executed only once and is commonly used for testing, scripting, and performing one-time tasks.
Interview tip: Use a short example and connect the answer to real project work.
Q43. What are the sections of a PL/SQL block?
Medium
Answer: A PL/SQL block consists of four sections: DECLARE (optional, used for variables and cursors), BEGIN (mandatory, contains executable statements), EXCEPTION (optional, handles runtime errors), and END (mandatory, marks the end of the block).
Interview tip: Use a short example and connect the answer to real project work.
Q44. What are variables and constants in PL/SQL?
Medium
Answer: Variables are named memory locations used to store values that can change during program execution. Constants store fixed values and are declared using the CONSTANT keyword. Variables and constants improve code readability and maintainability.
Interview tip: Use a short example and connect the answer to real project work.
Q45. What control statements are available in PL/SQL?
Medium
Answer: PL/SQL supports conditional statements such as IF, IF-ELSE, CASE, and looping statements including LOOP, WHILE LOOP, FOR LOOP, EXIT, CONTINUE, and GOTO (rarely used). These statements control the program's execution flow.
Interview tip: Use a short example and connect the answer to real project work.
Q46. What is a Cursor in PL/SQL?
Hard
Answer: A Cursor is a pointer to the result set returned by a SQL statement. It enables PL/SQL to process query results one row at a time. Oracle automatically creates implicit cursors for DML and single-row SELECT statements, while developers create explicit cursors for queries returning multiple rows.
Interview tip: Use a short example and connect the answer to real project work.
Q47. What is the difference between Explicit and Implicit Cursors?
Hard
Answer: Implicit cursors are automatically created by Oracle for SQL statements such as INSERT, UPDATE, DELETE, and SELECT INTO. Explicit cursors are defined and controlled by the programmer to process multiple rows manually using OPEN, FETCH, and CLOSE statements.
Interview tip: Use a short example and connect the answer to real project work.
Q48. What is a Stored Procedure?
Medium
Answer: A Stored Procedure is a named PL/SQL program stored in the database. It performs one or more tasks and can accept input parameters, return output values through OUT parameters, and be executed repeatedly by applications or other database objects.
Interview tip: Use a short example and connect the answer to real project work.
Q49. What is a Function in PL/SQL?
Medium
Answer: A Function is a named PL/SQL program that performs a specific task and must return exactly one value using the RETURN statement. Functions are commonly used in SQL queries and reusable business logic.
Interview tip: Use a short example and connect the answer to real project work.
Q50. What is the difference between Procedures, Functions, and Packages in Oracle?
Hard
Answer: A Procedure performs operations and may return values through OUT or IN OUT parameters but does not require a RETURN value. A Function must return exactly one value using RETURN and can often be called from SQL statements. A Package is a collection of related procedures, functions, variables, cursors, and types grouped together, improving modularity, performance, security, and code organization.
Interview tip: Use a short example and connect the answer to real project work.
Q51. What is a Trigger in Oracle?
Medium
Answer: A Trigger is a stored PL/SQL program that automatically executes when a specified database event occurs, such as INSERT, UPDATE, DELETE, CREATE, ALTER, or LOGON. Triggers are commonly used for auditing, enforcing business rules, maintaining data integrity, and logging changes.
Interview tip: Use a short example and connect the answer to real project work.
Q52. What is the difference between BEFORE and AFTER Triggers?
Medium
Answer: A BEFORE Trigger executes before the triggering event occurs and is typically used for validation or modifying data before it is stored. An AFTER Trigger executes after the event has completed successfully and is commonly used for auditing, logging, or updating related tables.
Interview tip: Use a short example and connect the answer to real project work.
Q53. What is the difference between Row-Level and Statement-Level Triggers?
Hard
Answer: A Row-Level Trigger executes once for each affected row and can reference :NEW and :OLD values. A Statement-Level Trigger executes only once for the entire SQL statement, regardless of how many rows are affected, and cannot directly access :NEW or :OLD values.
Interview tip: Use a short example and connect the answer to real project work.
Q54. How is exception handling performed in PL/SQL?
Medium
Answer: PL/SQL handles runtime errors using the EXCEPTION block. Oracle provides predefined exceptions such as NO_DATA_FOUND, TOO_MANY_ROWS, ZERO_DIVIDE, and DUP_VAL_ON_INDEX. Developers can also define custom exceptions for application-specific error handling.
Interview tip: Use a short example and connect the answer to real project work.
Q55. What are user-defined exceptions in PL/SQL?
Hard
Answer: User-defined exceptions are custom exceptions declared by the programmer using the EXCEPTION keyword. They are raised explicitly with the RAISE statement or RAISE_APPLICATION_ERROR to handle business-specific validation and error conditions.
Interview tip: Use a short example and connect the answer to real project work.
Q56. What is a RECORD in PL/SQL?
Medium
Answer: A RECORD is a composite data type that groups multiple related fields into a single variable. It is useful for storing an entire database row or logically related values and can be created using %ROWTYPE or custom record types.
Interview tip: Use a short example and connect the answer to real project work.
Q57. What are Collections in PL/SQL?
Hard
Answer: Collections are data structures that store multiple elements of the same data type. Oracle supports three collection types: Associative Arrays (Index-by Tables), Nested Tables, and VARRAYs. They are widely used for bulk processing and in-memory data manipulation.
Interview tip: Use a short example and connect the answer to real project work.
Q58. What are BULK COLLECT and FORALL in PL/SQL?
Hard
Answer: BULK COLLECT retrieves multiple rows into a collection in a single operation, reducing context switches between SQL and PL/SQL engines. FORALL performs bulk INSERT, UPDATE, or DELETE operations on collection elements, significantly improving performance when processing large datasets.
Interview tip: Use a short example and connect the answer to real project work.
Q59. What is Dynamic SQL in Oracle?
Hard
Answer: Dynamic SQL allows SQL statements to be constructed and executed at runtime. It is useful when table names, column names, or conditions are not known until execution. Oracle provides EXECUTE IMMEDIATE for simple dynamic SQL and DBMS_SQL for more complex scenarios.
Interview tip: Use a short example and connect the answer to real project work.
Q60. What are the advantages of using BULK COLLECT, FORALL, and Dynamic SQL?
Hard
Answer: BULK COLLECT and FORALL improve performance by minimizing context switches between SQL and PL/SQL during bulk data processing. Dynamic SQL provides flexibility by allowing SQL statements to be generated at runtime. Together, these features help build scalable, efficient, and reusable Oracle applications.
Interview tip: Use a short example and connect the answer to real project work.
Q61. What is Query Optimization in Oracle?
Hard
Answer: Query optimization is the process of improving SQL statement performance by minimizing resource usage and execution time. It involves writing efficient SQL, using appropriate indexes, avoiding unnecessary full table scans, minimizing context switches, and allowing the optimizer to choose the most efficient execution plan.
Interview tip: Use a short example and connect the answer to real project work.
Q62. What is an Explain Plan?
Hard
Answer: An Explain Plan shows how Oracle intends to execute a SQL statement. It displays execution steps such as table access methods, join operations, index usage, sorting, estimated cost, and cardinality. Developers use it to identify performance bottlenecks and optimize queries.
Interview tip: Use a short example and connect the answer to real project work.
Q63. What is the Cost-Based Optimizer (CBO)?
Hard
Answer: The Cost-Based Optimizer (CBO) is Oracle's query optimizer that selects the most efficient execution plan based on table statistics, indexes, data distribution, and estimated resource costs. Keeping optimizer statistics up to date is essential for accurate execution plans.
Interview tip: Use a short example and connect the answer to real project work.
Q64. How can indexes improve SQL performance?
Hard
Answer: Indexes reduce the number of data blocks Oracle must scan to locate rows, significantly improving SELECT query performance. However, excessive or unnecessary indexes increase storage requirements and can slow INSERT, UPDATE, and DELETE operations because indexes must also be maintained.
Interview tip: Use a short example and connect the answer to real project work.
Q65. What are Oracle Optimizer Hints?
Hard
Answer: Hints are special instructions placed inside SQL comments to influence the optimizer's execution plan. Common hints include INDEX, FULL, USE_NL, USE_HASH, LEADING, PARALLEL, and FIRST_ROWS. Hints should be used only when necessary after proper performance analysis.
Interview tip: Use a short example and connect the answer to real project work.
Q66. What is Partitioning in Oracle?
Hard
Answer: Partitioning divides large tables or indexes into smaller, manageable pieces called partitions. Oracle supports Range, List, Hash, Interval, and Composite partitioning. Partitioning improves query performance, simplifies maintenance, and enables efficient data management for very large tables.
Interview tip: Use a short example and connect the answer to real project work.
Q67. How are Materialized Views refreshed?
Hard
Answer: Materialized Views can be refreshed using Complete Refresh, Fast Refresh, Force Refresh, or On Commit Refresh. The appropriate refresh method depends on business requirements, available materialized view logs, and data freshness requirements.
Interview tip: Use a short example and connect the answer to real project work.
Q68. What are SQL Trace and TKPROF?
Hard
Answer: SQL Trace records detailed execution statistics for SQL statements, including parse, execute, fetch, CPU usage, elapsed time, logical reads, and physical reads. TKPROF formats SQL Trace output into a readable performance report, making it easier to analyze slow SQL statements.
Interview tip: Use a short example and connect the answer to real project work.
Q69. What are AWR and ASH reports?
Hard
Answer: AWR (Automatic Workload Repository) collects historical database performance statistics for analysis and tuning. ASH (Active Session History) captures sampled information about active sessions, helping identify performance bottlenecks, blocking sessions, and high-resource SQL statements.
Interview tip: Use a short example and connect the answer to real project work.
Q70. What are the best practices for Oracle SQL performance tuning?
Hard
Answer: Write efficient SQL statements, use appropriate indexes, avoid SELECT *, analyze execution plans, keep optimizer statistics updated, use bind variables, avoid unnecessary commits inside loops, use BULK COLLECT and FORALL for bulk operations, partition large tables when appropriate, monitor database performance regularly, and optimize only after identifying actual bottlenecks through profiling and analysis.
Interview tip: Use a short example and connect the answer to real project work.
Q71. What is a transaction in Oracle?
Hard
Answer: A transaction is a logical unit of work consisting of one or more SQL statements. A transaction begins with the first executable SQL statement and ends with a COMMIT or ROLLBACK statement. Oracle guarantees the ACID (Atomicity, Consistency, Isolation, Durability) properties to ensure reliable transaction processing.
Interview tip: Use a short example and connect the answer to real project work.
Q72. What is the difference between COMMIT, ROLLBACK, and SAVEPOINT?
Medium
Answer: COMMIT permanently saves all changes made during the current transaction. ROLLBACK undoes uncommitted changes and restores the database to its previous state. SAVEPOINT creates a checkpoint within a transaction, allowing a partial rollback to a specific point instead of rolling back the entire transaction.
Interview tip: Use a short example and connect the answer to real project work.
Q73. What are locks in Oracle?
Hard
Answer: Locks are mechanisms used by Oracle to control concurrent access to data and maintain consistency. Oracle automatically applies row-level and table-level locks during DML operations to prevent conflicting changes while allowing maximum concurrency.
Interview tip: Use a short example and connect the answer to real project work.
Q74. What is a deadlock in Oracle?
Hard
Answer: A deadlock occurs when two or more sessions wait indefinitely for resources locked by each other. Oracle automatically detects deadlocks, rolls back one of the conflicting transactions, and returns the ORA-00060 error to resolve the situation.
Interview tip: Use a short example and connect the answer to real project work.
Q75. What are Oracle transaction isolation levels?
Hard
Answer: Oracle primarily provides the READ COMMITTED isolation level by default, which prevents dirty reads while allowing non-repeatable reads. Oracle also supports SERIALIZABLE and READ ONLY transaction modes for stronger consistency when required.
Interview tip: Use a short example and connect the answer to real project work.
Q76. What is Oracle Real Application Clusters (RAC)?
Hard
Answer: Oracle Real Application Clusters (RAC) allows multiple database servers to access the same database simultaneously. RAC provides high availability, scalability, load balancing, and fault tolerance by distributing workloads across multiple nodes.
Interview tip: Use a short example and connect the answer to real project work.
Q77. What is Oracle Data Guard?
Hard
Answer: Oracle Data Guard is a disaster recovery and high availability solution that maintains one or more synchronized standby databases. If the primary database fails, a standby database can quickly take over, minimizing downtime and data loss.
Interview tip: Use a short example and connect the answer to real project work.
Q78. What is Flashback Technology in Oracle?
Hard
Answer: Flashback Technology allows administrators to recover data or view previous database states without restoring backups. Oracle provides features such as Flashback Query, Flashback Table, Flashback Drop, Flashback Database, and Flashback Transaction Query to simplify recovery from logical errors.
Interview tip: Use a short example and connect the answer to real project work.
Q79. What are the basic backup and recovery options in Oracle?
Hard
Answer: Oracle supports logical backups using Data Pump (EXPDP/IMPDP) and physical backups using Recovery Manager (RMAN). RMAN provides full, incremental, archived log, and point-in-time recovery while ensuring efficient backup management and disaster recovery.
Interview tip: Use a short example and connect the answer to real project work.
Q80. What are Oracle database best practices?
Hard
Answer: Follow proper database normalization, use appropriate indexes, write optimized SQL, use bind variables, keep optimizer statistics updated, implement regular backups, monitor AWR and ASH reports, use partitioning for large tables, secure database access with least-privilege principles, avoid unnecessary commits inside loops, optimize PL/SQL using BULK COLLECT and FORALL where appropriate, and regularly review performance and security configurations.
Interview tip: Use a short example and connect the answer to real project work.
Quick revision checklist
- Explain the answer without reading.
- Write one small example.
- Review platform or version differences in official documentation.
No comments:
Post a Comment
Please do not enter any spam link in the comment box.