INTERVIEW QUESTIONS ORACLE DETAILS

Question: If a View on a single base table is manipulated will the changes be reflected on the base table ?

Answer: If changes are made to the tables which are base tables of a view will the changes be reference on the view.

The following describes means to create a OEM V1.x (very old!!!) repository on WindowsNT:

. Create a tablespace that would hold the repository data. A size between 200- 250 MB would be ideal. Let us call it Dummy_Space.
. Create an Oracle user who would own this repository. Assign DBA, SNMPAgent, Exp_Full_database, Imp_Full_database roles to this user. Lets call this user Dummy_user. Assign Dummy_Space as the default tablespace.
. Create an operating system user with the same name as the Oracle username. I.e. Dummy_User. Add 'Log on as a batch job' under advanced rights in User manager.
. Fire up Enterprise manager and log in as Dummy_User and enter the password. This would trigger the creation of the repository. From now on, Enterprise manager is ready to accept jobs.

If changes are made to the tables which are base tables of a view will the changes be reference on the view.

The following describes means to create a OEM V1.x (very old!!!) repository on WindowsNT:

. Create a tablespace that would hold the repository data. A size between 200- 250 MB would be ideal. Let us call it Dummy_Space.
. Create an Oracle user who would own this repository. Assign DBA, SNMPAgent, Exp_Full_database, Imp_Full_database roles to this user. Lets call this user Dummy_user. Assign Dummy_Space as the default tablespace.
. Create an operating system user with the same name as the Oracle username. I.e. Dummy_User. Add 'Log on as a batch job' under advanced rights in User manager.
. Fire up Enterprise manager and log in as Dummy_User and enter the password. This would trigger the creation of the repository. From now on, Enterprise manager is ready to accept jobs. Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question