1.APPSDBA-INTERVIEW QUESTIONS

1)List out the Configuration files of all the Components of an Oracle Application
2)List out the Log files of all the components of an Oracle Application
3)List out the Executables of all the components of an Oracle application
4)List out the methods to identify whether the Component of application is running or not
5)List out the Ports of all the components
6)List out the method to start up all the components of oracle application
7)What is the application used for in your business
8)Provide the complete path to access the Oracle application
9)List out the steps to verify how each component's function can be verified from front end
10)What is the latest level of ATG,ADX,TXK,AD
11)What is the patcheset level of ATG,ADX,TXK,AD of your application
12)How do you verify the Versions of the components from both front end and backend
13)What is the size of your database
14)How many tablespaces are available in your database
15)How many datafiles are available in your database
16)What type of tablespace management in your database
17)What type of backups do you take, how and when
18)How many filesystems you have
19)How many nodes are available in your application
20)How many instances do you support and what are they
21)How do you identify whether a particular component is running on a node or not
22)How do you make changes to component
24)Where are the worker log files located
25)Where are the patch log files located
26)Where are the adadmin related log files located
27)What are your daily activities
28)How many patches do you apply per day and on what environment
29)What are the various sizes of patches that you applied
30)What is the latest patch that you applied
31)How do your rollback and application patch
32)How do you  apply developer patch
33)How do you rollback an iAS patch
34)How many languages are installed on your application
35)What is multi currency
36)What is Multi Org
37)Where are the errors of Oracle background processes recorded
38)Where are the errors of Oracle database engine recorded
39)Where are the errors of apache written
40)What are datafixes
41)How do you verify the list of patches applied to database engine
42)How do you verify the list of patches applied to your application
43)How do you manually generate a form
44)How do you manually generate a report
45)How do you verify the version of a particular report
46)What are the different self service responsbilities
47)How do you verify the profile options from both front end and backend
48)How do you create an application user
49)How do you create a custom concurrent program
50)How do you enable trace for a db session
51)How do you verify what an db session is doing
52)How do you verify what an os process is doing
53)How do you identify the No. of forms sessions connected to db
54)How do you verify the No. of jdbc connection sessions connected to db
55)How many users use the application
56)How many concurrent programs run daily
57)How do you collect statistics for your database
58)What is RDA and how do you run diagnostics for application/database
59)How do you enable trace for database,db session, listener, apache,concurrent manager,forms,reports, a form
60)How do you verify locks & Blocks
61)How do you run AWH,ADDR reports
62)What is tkprof
63)What is dbverify
64)How do you identify that a db file is corruputed
65)How do you create a concurrent manager
66)How do increase concurrent manager
67)How do you verify concurrent requests
68)What are the different status of concurrent requests
69)What are the different env variables required for running of your application
70)What are the different oracle engine errors and how do you resolve
71)How do you schedule a concurrent program
72)How do you verify how many concurrent programs are running daily
73)What is the difference between a concurrent program and concurrent request
74)What is a database link
75)How do you create a database link
76)How do you compile a view
77)How do you verify view definition
78)What is difference between crash recovery and instance recovery
79)How do you compile invalids
80)How do verify errors related to view
81)How do you verify procedure/package definition
82)How do you compile  a trigger
83)How do you compile a package
84)How do you create a custom database user
85)How do you compile jsps
86)How do you verify forms runaway session
87)How do you verify the history of CPU Usage
88)What is the difference between utlirp and utlrp
89)How do you verify the shared pool usage
90)What is tkprof and how do you use
91)What is dbms _stats and what is its importance
92)How do you analyze your application
93)How do you change password of guest user
94)How do you change password of apps
95)What is an event trace
96)How do enable/disable event trace
97)What are the different patching errors that you have faced
99)How do you run autoconfig on db node
100)How do you identify a shared appltop and shared techstack