Oracle dba interview question and answer

Do Command Rules Work Alone? When the operator selects the list icon, a list of available choices appears. The background processes are operating system processes and each process has a specific responsibility in the instance. All user processes concurrently connected to the instance share access to the database buffer cache.

Uploader: Zulkirg
Date Added: 2 January 2012
File Size: 16.16 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 97032
Price: Free* [*Free Regsitration Required]

Oracle Database must have at least one control file. When confine mode is on, an object cannot be dbz outside its parent in the layout.

Foreground process and, Background process. An integrity constraint is a declarative way to define a business rule for a column of a table.

Planning for backup and recovery of database information. Lastly RAID10 perform exceedingly well in all types of databases. Give Details On Acms? When you create database link with Public clause it is available for access to all the users. queetion

Top 40 oracle dba interview questions and answers

It is possible that changes made by these uncommitted transactions have gotten saved in data files. After that asm can be removed using srvctl tool as follows:.

A Partial Backup is any operating system backup short of questlon full backup, taken while the database is open or shut down.

Present the data in a different perspective from that of the base table. It is a clustering solution from Oracle Corporation that ensures high availability of databases by providing instance failover, media failover features.

Oracle DBA Interview Questions & Answers

It is possible to create it manually from scratch but that would take long and would be erroneous. If you are going to do batch installations, it is best to do it with Oracle Universal Installer in silent mode.

Only one LONG column is allowed. If a failure prevents modified data from being permanently written to the datafiles, then the changes can be obtained from the redo log, so work is wuestion lost. Post-form commit fires once during the post and commit transactions process, anf the database commit occurs.

The goal of the optimizer qustion to choose the most efficient way to execute a SQL statement. We can also specify that only idle sessions blocking other sessions be terminated.

Top 40 oracle dba interview questions and answers - Techgoeasy

Statistics should only be gathered when there are no active users or system activity is very low. It represents a major new version of the software that contains significant new functionality. All users need a temporary tablespace where they can perform operations such as sorting data during SQL execution.

A hot backup is basically taking a backup of the database while it is still up and running and it must be in archive log mode. Explain what partitioning is and what its benefit is.

The Best Oracle DBA Interview Questions & Answers [UPDATED]

Privilege auditing is the auditing of the use of powerful system privileges without regard to specifically named dna. How can you determine which shared memory and semaphores are associated with which instance? It is formed of the following components that helps us manage security for the database instance. Windows clusters use the TCP protocol. Once you create a library, you can attach it to any other form, menu, or quesyion modules.

The process can be shared by all users. The Tablespace to contain schema objects created without specifying a tablespace name. These are known as next extents.

Explain About Stacked Canvas Views? Database triggers can be used to enforce business rules, to maintain derived values and perform value-based auditing.

1 thoughts on “Oracle dba interview question and answer”

Leave a Reply

Your email address will not be published. Required fields are marked *