Here i am listing some very general interview questions for Oracle Apps DBA with 0-6 months experience :
Ques 1 Where are the front end user details stored?
The front end user details are stored in table fnd_user in database. You can query the database for the details you want to know as follows:
logon as database user apps then
sql> desc fnd_user;
sql> select <Column name> from <table>;
you will get the list of details that the table contain from which you can get the further details.
Ques 2 Is “apps” a database user or “application user”?
“apps” is a Database user.All the information about database users is defined in table dba_users so you can query the database to know about users.
sql> desc dba_users;
sql> select * from dba_users where username=’APPS’;
This query will give you all details of apps user.
Ques 3 Where are the database objects stored for the products ‘BEN’ &’FND’?
Database objects for the products like ‘BEN’ & ‘FND’ are stored in their own schema like BEN or APPLSYS (for FND), GL for GL objects
Ques 4 Can Middle Tier & DB run on different versions of OS?
Yes, Middle Tier & DB can run on different versions of OS. This type of configuration are known as Split Configuration.
Ques 5 Can different Middle Tier’s have different flavours of OS?
Yes different Middle tier’s can run on different flavours of OS.
Ques 6 How do we verify the no. of CPU’s running on a node?
Proc (/proc) file system provides easy information about CPU and their speed.To display the number of processors in linux you need to use /proc/cpuinfo file. This is a collection of CPU and system architecture dependent items, for each supported architecture a different list.Type the following command:
$ cat /proc/cpuinfo
Ques 7 How do i identify whether my environment is shared APPL_TOP or not?
To know whether the environment is shared APPL_TOP or not , login to first Middle Tier & create any file (like abc.txt) in the APPL_TOP. Now logout & login to other Middle Tier. If you can see that respective file in APPL_TOP, this means you are having shared APPL_TOP.
Question for readers:
Is it possible to start database from Middle Tier? If yes then how?