DBA > Interview Resource

Oracle DBA Interview questions and Answers

Part:   1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16 

(Continued from previous part...)

What are few profile options which you update after cloning ?

Rapid clone updates profile options specific to site level . If you have any profile option set at other levels like server, responsibility, user....level then reset them.


How to retrieve SYSADMIN password ?

If forgot password link is enabled and SYSADMIN account is configured with mail id user forget password link else you can reset sSYSADMIN password via FNDCPASS.


Whats is TWO_TASK in Oracle Database ?

TWO_TASK mocks your tns alias which you are going to use to connect to database. Lets assume you have database client with tns alias defined as PROD to connect to Database PROD on machine teachmeoracle.com listening on port 1521. Then usual way to connect is sqlplus username/passwd@PROD ; now if you don't want to use @PROD then you set TWO_TASK=PROD and then can simply use sqlplus username/passwd then sql will check that it has to connect to tnsalias define by value PROD i.e. TWO_TASK


What is GWYUID ?

GWYUID , stands for Gateway User ID and password. Usually like APPLSYSPUB/PUB


Where GWYUID defined and what is its used in Oracle Applications ?

GWYUID is defined in dbc i.e. Database Connect Descriptor file . It is used to connect to database by think clients.


If APPS_MRC schema is not used in 11.5.10 and higher then How MRC is working ?

For products like Payable, Recievables which uses MRC and if MRC is enabled then each transaction table in base schema related to currency now has an assoicated MRC Subtables.


When you apply C driver patch does it require database to be Up and Why ?

Yes , database and db listener should be Up when you apply any driver patch in apps. even if driver is not updating any database object connection is required to validate appsand other schema and to upload patch history information in database tables.

(Continued on next part...)

Part:   1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16