Oracle AppsDBA Online Quiz

JavaScript isn't enabled in your browser, so this file can't be opened. Enable and reload.

Which tool will be used to repair corrupted database objects from odf files?

1 point

adodfcmp

adrelink

autoconfig

adsplicer

Clear selection

Please select all TRUE statements related to socket and servlet modes.

1 point

In socket mode, one can find a dedicated connection between client desktop and the forms server

Servlet mode HTTP & HTTPS traffic can be easily recognized by routers

Socked mode is supported on windows-based platforms.

In servlet mode, Jserv processes the forms requested

What is the version of the (default) Java Oracle home in Oracle Applications Release 12?

1 point

8.0.6

10.2

10.1.3

8.1.7

Clear selection

In Oracle Applications R12, to which directory does the $OA_HTML environment variable point?

1 point

$INST_TOP/webapps/oacore/html

$INST_TOP/html

$COMMON_TOP/webapps/oacore/html

$COMMON_TOP/html

Clear selection

Which two statements are TRUE about the APPS schema?

1 point

APPS schema owns the technology-layer data

APPS schema owns all code objects

APPS schema owns all the product's data objects

APPS schema has synonyms for all base tables and sequences

What is the adpatch log file location?

1 point

$APPL_TOP/admin/SID

$APPL_TOP/admin/SID/log

$AU_TOP/java

$RDBMS_ORACLE_HOME/.patch_storage

Clear selection

What is the location of adpreclone.pl for applmgr user?

1 point

$RDBMS_ORACLE_HOME/appsutil/clone/bin

$RDBMS_ORACLE_HOME/appsutil/scripts/

$COMMON_TOP/clone/bin

$COMMON_TOP/admin/scripts/

Clear selection

When does FND_INSTALL_PROCESSES table get created in the Oracle Applications R12 (E-Business Suite) database?

1 point

When the is created in a Real Application Clusters (RAC) setup

During Database upgrad

After creating APPS schema

When AutoPatch, AutoUpgrade, or AD Administration programs process jobs

Clear selection

How to skip copy portion while applying a patch?

1 point

adpatch options=noapply

adpatch options=nocopyportion

adpatch options=skip

Clear selection

Which adpatch command you will use to apply only the database driver?

1 point

adpatch options=applydatabaseportion

adpatch options=nocopyportion,nogenerateportion

adpatch options=nodatabaseportion,nocopyportion,nogenerateportion

Clear selection

Which patch driver is responsible for regenerating the JAR files and compiling the JSP files ?

1 point

generate driver

database driver

copy driver

unified driver

Clear selection

What are the components of Oracle Applications technology layer? [select all applicable options]

1 point

Oracle Applications Utilities (AU)

Oracle Workflow (WF)

Oracle Alert (ALR)

Oracle Applications DBA (AD)

Oracle Applications object library (FND)

How do you enable maintenance mode?

1 point

By running adsetmmd.sql START

Using adadmin

Using adpatch

By running adsetmmd.sql ENABLE

Which two reports can you get by using the License Manager Web utility?

1 point

Languages report

Licensing terms and conditions report

Applied product patches report

Country specific functionalities report

What is the location of init.ora ? *

1 point

$RDBMS_ORACLE_HOME

$RDBMS_ORACLE_HOME/dbs

$RDBMS_ORACLE_HOME/rdms

$RDBMS_ORACLE_HOME/bin

Choose three valid AD utilities for Oracle E-Business Suite R12.

1 point

adident

adcontrol

adlicmgr.sh

adsplice

adjkey

Which patch driver is responsible for generating forms, reports and message files ?

1 point

Generate driver

Database driver

Unified driver

Copy driver

Clear selection

Which tool will be used to manage ad workers ?

1 point

adsplicer

adrelink

adctrl

adjkey

Clear selection

Does clone preserve the patch history? *

1 point

Yes

Maybe

Which is NOT a patch driver?

1 point

Clear selection

Which utility is used for changing the password of the application users?

1 point

How many Oracle Homes are there in Oracle Applications (11g) ?

1 point

Clear selection

Which schema contains FND_INSTALL_PROCESSES and AD_DEFERRED_JOBS tables?

1 point

applsyspub

applsys

apps

sys

Clear selection

Which table you will check whether a patch is applied or not?

1 point

ad_patch_driver_langs

ad_applied_patches

ad_bugs

ad_patch_driver_minpks

Clear selection

What are various types of profile options?

1 point

Site level

Application level

Responsibility level

User level

Submit

Clear form

Never submit passwords through Google Forms.

Forms

This content is neither created nor endorsed by Google.