Here i am listing some very general interview questions for Oracle Apps DBA with 0-6 months experience :<\/p>\n
Ques 1 Where are the front end user details stored?<\/strong><\/p>\n The front end user details are stored in table fnd_user<\/strong> in database. You can query the database for the details you want to know as follows:<\/p>\n logon as database user apps<\/strong> then<\/p>\n sql> desc fnd_user;<\/p>\n sql> select <Column name> from <table>;<\/p>\n you will get the list of details that the table contain from which you can get the further details.<\/p>\n Ques 2 Is “apps” a database user or “application user”?<\/strong><\/p>\n “apps” is a Database user.All the information about database users is defined in table dba_users<\/strong> so you can query the database to know about users.<\/p>\n sql> desc dba_users;<\/p>\n sql> select * from dba_users where username=’APPS’;<\/p>\n This query will give you all details of apps user. Database objects for the products like ‘BEN’ & ‘FND’ are stored in their own schema like BEN<\/strong> or APPLSYS (for FND<\/strong>), GL <\/strong>for GL objects Ques 4 Can Middle Tier & DB run on different versions of OS?<\/strong><\/p>\n Yes, Middle Tier & DB can run on different versions of OS. This type of configuration are known as Split Configuration.<\/strong><\/p>\n Ques 5 Can different Middle Tier’s have different flavours of OS? Ques 6 How do we verify the no. of CPU’s running on a node? $ cat \/proc\/cpuinfo<\/p>\n Ques 7 How do i identify whether my environment is shared APPL_TOP or not?<\/strong><\/p>\n 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.<\/p>\n Question for readers<\/strong><\/u>:<\/p>\n Is it possible to start database from Middle Tier? If yes then how? Here i am listing some very general interview questions for Oracle Apps DBA with 0-6 months experience : Ques 1 […]<\/p>\n","protected":false},"author":115,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[188,46],"class_list":["post-315","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-apps-dba-interview-question","tag-interview-question"],"yoast_head":"\n
\nQues 3 Where are the database objects stored for the products ‘BEN’ &’FND’?<\/strong><\/p>\n
\n\u00a0<\/strong><\/p>\n
\n<\/strong>Yes different Middle tier’s can run on different flavours of OS.<\/p>\n
\n<\/strong>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:<\/p>\n
\n<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"