1) What is Instance, how to recover instance . 2) Oracle logical/physical file system and processors . 3) SQL / PL/SQL Queries . 4) Unix Commands . 5) ITIL related questions . Ex- What is SLA, how many types of incidents etc .

Question

Accepted Answer

The interview questions cover topics such as Oracle instance recovery, file systems, SQL/PL/SQL queries, Unix commands, and ITIL concepts.

An instance in Oracle refers to the memory structures and background processes that manage a database.
Instance recovery is the process of bringing a database instance back to a consistent state after a failure.
Oracle has both logical and physical file systems. The logical file system includes tablespaces, data files, and control files, while the physical file system consists of actual files on disk.
SQL and PL/SQL queries are used to retrieve and manipulate data in Oracle databases.
Unix commands are used for managing files, processes, and system configurations in a Unix-based operating system.
ITIL (Information Technology Infrastructure Library) is a framework for managing IT services. SLA (Service Level Agreement) is a commitment between a service provider and a customer regarding the quality and availability of services. Incidents in ITIL refer to any event that disrupts or reduces the quality of a service.
Example of a Unix command: 'ls' is used to list files and directories in a Unix-based system.
Example of an SQL query: 'SELECT * FROM employees WHERE department = 'IT'' retrieves all employees from the 'employees' table who belong to the 'IT' department.