Oracle Installation Interview Questions and Answers - 3

Question: 11

How will you determine which segment belongs to which database instances?

You can use the ipcs – m command.

Question: 12

How do you kill a process in UNIX?

You can use the kill command to kill a process in UNIX.

Question: 13

How can you execute UNIX commands from SQL plus?

You can use the host command to execute the UNIX commands from SQL plus.

Question: 14

Which command would you use to check how many memory segments are acquired by Oracle instances?

You can use the ipcs –m UNIX command to check the memory segments that are acquired by Oracle instances.

Question: 15

What is Optional Flexible Architecture (OFA)?

The OFA standard is a set of configuration guidelines created to ensure fast and reliable Oracle databases that require little maintenance. It is designed to enable the following:

Organize large amounts of complicated software and data on disk, to avoid device bottlenecks and poor performance.

Facilitate routine administrative tasks, such as software and data backup, which are often vulnerable to data corruption.

Facilitate switching between multiple Oracle databases

Adequately manage and administer database growth

Help eliminate fragmentation of free space in the data dictionary, isolate other fragmentation, and minimize resource contention.

 

Related Questions