Oracle 1Z0-238 Online Practice Questions and Exam Preparation

Oracle 1Z0-238 Online Questions & Answers

• Question 111:

  You run the adadmin utility to generate message files. It completes with errors. Where will you find the log file (adadmin.log)?

  A. $INST_TOP/logs/appl/admin/log
  B. $INST_TOP/logs/ora/10.1.2/log
  C. $APPL_TOP/admin/$CONTEXT_NAME/log
  D. $AD_TOP//log, where is the value of your ORACLE_SID or TWO_TASK variable (UNIX) or LOCAL variable (Windows)
  E. $APPL_TOP/admin//log, where is the value of your ORACLE_SID or TWO_TASK variable (UNIX) or LOCAL variable (Windows)
  E. $APPL_TOP/admin//log, where is the value of your ORACLE_SID or TWO_TASK variable (UNIX) or LOCAL variable (Windows)

• Question 112:

  Which command can be used only with a single-node installation?

  A. rapidwiz -restart
  B. rapidwiz -techstack
  C. rapidwiz -servername
  D. rapidwiz -silent -config
  C. rapidwiz -servername

• Question 113:

  You have a multi-node installation with Forms services and Batch Processing services configured on separate nodes. You attempt to update the Context variable on the batch processing node although Oracle Applications Manager (OAM) fails. What should you do to resolve the problem? (Choose two.)

  A. Check whether the Web service is up on Forms services.
  B. Check whether the Forms service is up on the middle tier.
  C. Check whether the listener service is up on Forms services.
  D. Check whether the batch processing service is up on the middle tier.
  E. Enable the TNS listener service in the Application's Context file and run AutoConfig.
  C. Check whether the listener service is up on Forms services.
  E. Enable the TNS listener service in the Application's Context file and run AutoConfig.

• Question 114:

  John is working for XYZ company. He received a tape from a customer that has the.dbf files and ORACLE_HOME database. He extracted the .dbf files from the tape to the server. After checking, he realized that the customer's DBA forgot to run preclone on the source database tier before taking a B ckup on the tape. To bring up the database successfully using adcfgclone.pl (postclone) on target, what action would you ask the customer's DBA to perform instead of requesting for a full backup again?

  A. Run preclone on the source database tier and request the customer's DBA to send only .xml.
  B. Run preclone on the source database tier and request the customer's DBA to send only the oraInventory directory.
  C. Run preclone on the source database tier and request the customer's DBA to send only the dbf system tablespace files.
  D. Run preclone on the source database tier and request the customer's DBA to send only bin under the $ORACLE_HOME database.
  E. Run preclone on the source database tier and request the customer's DBA to send only the appsutil directory under the $ORACLE_HOME database.
  E. Run preclone on the source database tier and request the customer's DBA to send only the appsutil directory under the $ORACLE_HOME database.

• Question 115:

  As an Applications DBA, you are tasked with cloning a User Acceptance Test System (UAT) to Test System on July 28. You ran preclone on database tier on July 23 itself. Between July 23 and July 28, some changes have happened to the database. Identify three scenarios in which you would have to run preclone again. (Choose three.)

  A. A database was restarted
  B. A tablespace was dropped.
  C. A custom schema was dropped.
  D. A database data file was resized.
  E. A data file was added to the database.
  B. A tablespace was dropped.
  C. A custom schema was dropped.
  E. A data file was added to the database.

• Question 116:

  Which two statements are correct about Rapid Clone? (Choose two.)

  A. Rapid Clone does not take care of oraInventory.
  B. Rapid Clone updates only site-level profile options.
  C. Rapid Clone itself does not start the application services automatically on the node.
  D. Rapid Clone automatically creates a control file and brings up the database on the database tier.
  E. Rapid Clone does not configure the source application printer configuration in the target system.
  B. Rapid Clone updates only site-level profile options.
  D. Rapid Clone automatically creates a control file and brings up the database on the database tier.

• Question 117:

  How do you restore an older configuration (a configuration that is older than that immediately prior to the current one) in the Oracle Applications R12 environment?

  A. Use the restore.sh rollback script and run the AutoConfig script to generate new configuration iles.
  B. Use the Support Cart feature in Oracle Applications Manager (OAM) and run the AutoConfig script to generate new configuration files.
  C. Use the Context Editor Wizard from the command line and run the AutoConfig utility manually from /bin.
  D. Use OAM AutoConfig to compare and replace individual values in the current configuration with the corresponding values from the older configuration, and save them. Then run the adautocfg.sh script.
  D. Use OAM AutoConfig to compare and replace individual values in the current configuration with the corresponding values from the older configuration, and save them. Then run the adautocfg.sh script.

• Question 118:

  Identify two ways in which you validate the APPS schema in the Oracle Applications R12 EBusiness Suite setup. (Choose two.)

  A. Run the /appsutil/scripts//advrfapp.sh script.
  B. Run the AD Administration utility in noninteractive mode with the default file having menu_option=VALIDATE_APPS.
  C. Run the AD Administration utility in interactive mode, and then select Compile/Reload Applications Database Entities menu > Compile APPS Schema option.
  D. Use SQL*PLUS / @$AD_TOP/admin/sql/advrfapp.sql .
  B. Run the AD Administration utility in noninteractive mode with the default file having menu_option=VALIDATE_APPS.
  D. Use SQL*PLUS / @$AD_TOP/admin/sql/advrfapp.sql .

• Question 119:

  Which two values must be set for changing the temporary directory for log and output files from the PL/ SQL concurrent program? (Choose two.)

  A. TMP_DIR variable
  B. APPLPTMP variable
  C. APPLTMP parameter
  D. Utl_file_dir parameter
  B. APPLPTMP variable
  D. Utl_file_dir parameter

• Question 120:

  The Applications DBA needs to clone the Production system. Examine the list of steps that the Applications DBA is considering.

  A. step A
  B. step B
  C. step C
  D. step D
  E. step E
  F. step F
  G. step G
  H. Perform the finishing tasks.
  I. Test the target system.
  J. Back up the target system. Which step is NOT a part of the cloning process?
  G. step G