Oracle 11g DBA Interview Questions and Answers - 1

Question: 1

What privileges are available on a UNIX directory?

Following privileges are available on the UNIX directory or file:

Read – Allows you to view and list the directory or file contents.

Write – Allows you to create, edit and delete files and subdirectories in the directory.

Execute – Gives you the previous read or write permissions. It also allows you to change into the directory and execute programs or shells from the directory.

Question: 2

Give two UNIX kernel parameters that affect installation or oracle?

The SHMMAX & SHMMNI UNIX kernel parameters affect the installation of Oracle.

Question: 3

How do you execute a UNIX command in the background?

A UNIX command can be executed in the background by ending the command with the & (ampersand) character.

Question: 4

List the major steps in installation of Oracle software on UNIX in brief?

Following are the steps in installation of Oracle software on UNIX:

Set up disk

Set up kernel parameters

Run the orainst command

Question: 5

What is vmstat?

The vmstat command in UNIX can be used to get the reports on resource usage, such as virtual memory, disks, and CPU activities.