显示标签为“1Z0-053”的博文。显示所有博文
显示标签为“1Z0-053”的博文。显示所有博文

2014年3月20日星期四

Oracle 1Z0-238 1Z0-055 1Z0-204 1Z0-052 1Z0-242 1Z0-053, de formation et d'essai

Le test simulation Oracle 1Z0-238 1Z0-055 1Z0-204 1Z0-052 1Z0-242 1Z0-053 sorti par les experts de Pass4Test est bien proche du test réel. Nous sommes confiant sur notre produit qui vous permet à réussir le test Oracle 1Z0-238 1Z0-055 1Z0-204 1Z0-052 1Z0-242 1Z0-053 à la première fois. Si vous ne passe pas le test, votre argent sera tout rendu.

Pass4Test a une équipe se composant des experts qui font la recherche particulièrement des exercices et des Q&As pour le test certification Oracle 1Z0-238 1Z0-055 1Z0-204 1Z0-052 1Z0-242 1Z0-053, d'ailleurs ils peuvent vous proposer à propos de choisir l'outil de se former en ligne. Si vous avez envie d'acheter une Q&A de Pass4Test, Pass4Test vous offrira de matériaux plus détailés et plus nouveaux pour vous aider à approcher au maximum le test réel. Assurez-vous de choisir le Pass4Test, vous réussirez 100% le test Oracle 1Z0-238 1Z0-055 1Z0-204 1Z0-052 1Z0-242 1Z0-053.

On doit faire un bon choix pour passer le test Oracle 1Z0-238 1Z0-055 1Z0-204 1Z0-052 1Z0-242 1Z0-053. C'est une bonne affaire à choisir la Q&A de Pass4Test comme le guide d'étude, parce que vous allez obtenir la Certification Oracle 1Z0-238 1Z0-055 1Z0-204 1Z0-052 1Z0-242 1Z0-053 en dépensant d'un petit invertissement. D'ailleur, la mise à jour gratuite pendant un an est aussi gratuite pour vous. C'est vraiment un bon choix.

Code d'Examen: 1Z0-238
Nom d'Examen: Oracle (R12 Oracle: install,Patch and Maintain Oracle Applications)
Questions et réponses: 165 Q&As

Code d'Examen: 1Z0-055
Nom d'Examen: Oracle (Oracle Database 11g: New Features for 9i OCPs)
Questions et réponses: 150 Q&As

Code d'Examen: 1Z0-204
Nom d'Examen: Oracle (Oracle EBS R12: E-Business Essentials)
Questions et réponses: 199 Q&As

Code d'Examen: 1Z0-052
Nom d'Examen: Oracle (Oracle Database 11g: Administrator I )
Questions et réponses: 205 Q&As

Code d'Examen: 1Z0-242
Nom d'Examen: Oracle (PeopleSoft Application Developer II: App Engine and Integration)
Questions et réponses: 102 Q&As

Code d'Examen: 1Z0-053
Nom d'Examen: Oracle (Oracle Database 11g: Administration II)
Questions et réponses: 673 Q&As

Selon les feedbacks les professionnels bien réputés dans l'Industrie IT, Pass4Test est un bon catalyseur de leurs succès. L'outil de formation offert par Pass4Test leur aide d'économiser le temps et l'argent, le plus important est qu'ils aient passé le test Oracle 1Z0-238 1Z0-055 1Z0-204 1Z0-052 1Z0-242 1Z0-053 avec succès. Pass4Test est un fournissur fiable. Vous allez réaliser votre rêve avec l'aide de Pass4Test.

Dans cette Industrie IT intense, le succès de test Oracle 1Z0-238 1Z0-055 1Z0-204 1Z0-052 1Z0-242 1Z0-053 peut augmenter le salaire. Les gens d'obtenir le Certificat Oracle 1Z0-238 1Z0-055 1Z0-204 1Z0-052 1Z0-242 1Z0-053 peuvent gagner beaucoup plus que les gens sans Certificat Oracle 1Z0-238 1Z0-055 1Z0-204 1Z0-052 1Z0-242 1Z0-053. Le problème est comment on peut réussir le test plus facile?

En quelques années, le test de certification de Oracle 1Z0-238 1Z0-055 1Z0-204 1Z0-052 1Z0-242 1Z0-053 faisait un grand impact sur la vie quotidienne pour pas mal de gens. Voilà le problème, comme on peut réussir facilement le test de Oracle 1Z0-238 1Z0-055 1Z0-204 1Z0-052 1Z0-242 1Z0-053? Notre Pass4Test peut vous aider à tout moment à résourdre ce problème rapidement. Pass4Test peut vous offrir une bonne formation particulière à propos du test de certification 1Z0-238 1Z0-055 1Z0-204 1Z0-052 1Z0-242 1Z0-053. Notre outil de test formation est apporté par les IT experts. Chez Pass4Test, vous pouvez toujours trouver une formations à propos du test Certification 1Z0-238 1Z0-055 1Z0-204 1Z0-052 1Z0-242 1Z0-053, plus nouvelle et plus proche d'un test réel. Tu choisis le Pass4Test aujourd'hui, tu choisis le succès de test Certification demain.

1Z0-238 Démo gratuit à télécharger: http://www.pass4test.fr/1Z0-238.html

NO.1 Identify the patch that you apply to upgrade the Oracle Applications system from the 11.5.5 version to
the 11.5.10 version.
A.diagnostic patch
B.stand-alone patch
C.maintenance pack
D.product family release update pack
Answer: C

Oracle examen   1Z0-238 examen   certification 1Z0-238   1Z0-238 examen   1Z0-238

NO.2 When does the FND_INSTALL_PROCESSES table get created in the Oracle Applications R12
E-Business Suite database?
A.whenever the AD Controller utility is used
B.when AutoPatch, AutoUpgrade, or AD Administration programs process jobs
C.during the upgrade to R12 E-Business Suite from the earlier version of Oracle Applications
D.when the R12 E-Business Suite database is created in a Real Application Clusters (RAC) setup
E.during the R12 E-Business Suite installation and, more specifically, at the time of the database APPS
schema creation
Answer: B

Oracle examen   1Z0-238   1Z0-238   1Z0-238

NO.3 Which two statements are true if you choose the "Recreate grants and synonyms for APPS schema"
task option from the adadmin utility? (Choose two.)
A.This option re-creates grants on some packages from APPS to SYSTEM.
B.This option re-creates grants and synonyms for the APPLSYSPUB schema.
C.This option re-creates grants and synonyms for the code objects of the APPS schema to the base
product schemas.
D.This option spawns parallel workers to re-create grants and synonyms linking sequences and tables in
the base product schemas to the APPS schema.
Answer: BD

Oracle   1Z0-238 examen   1Z0-238   1Z0-238

NO.4 A report output file is generated when you run "Validate APPS schema" by using the adadmin utility in
the Oracle Applications R12 E-Business Suite environment.
If the report shows something similar to "GL_CODE_COMBINATIONS table does not exist or is an invalid
object," what is the first step that the database administrator (DBA) should perform to correct this issue?
A.Run the AD Relink utility and relink the GL product.
B.Use License Manager, and register the GL product.
C.Run Rapid Install to reinstall database components.
D.Run AutoPatch, and apply the GL latest available patch.
E.Run the "Recreate grants and synonyms for the APPS schema" task by using the adadmin utility.
Answer: E

Oracle   certification 1Z0-238   certification 1Z0-238

NO.5 In your Oracle Applications R12 E-Business Suite implementation, the database is corrupt. To resolve
it, the database Java Virtual Machine (JVM) was reloaded. Identify the type of problem that may occur
and the related correct solution.
A.Problem: Many invalid objects are found in the APPS schema.
Solution: Run the "Validate APPS schema" task by using the adadmin utility.
B.Problem: All Oracle Applications Java classes are missing.
Solution: Run the "Reload JAR files to the DB" task by using the adadmin utility.
C.Problem: The Application screen display does not come up with one of the installed language
characters.
Solution: Run the "Convert Character set" task by using the adadmin utility.
D.Problem: The Application window does not show any of the Accounts Receivables data.
Answer: B

Oracle examen   1Z0-238   certification 1Z0-238

NO.6 What are the two possible sequences of worker status while a job is being completed by a worker?
(Choose two.)
A.Waiting => Assigned => Running => Completed
B.Assigned => Waiting => Running => Completed
C.Waiting => Assigned => Running => Failed => Fixed, Restart => Restarted => Completed
D.Assigned => Waiting => Running => Failed => Fixed, Restart => Restarted => Completed
E.Waiting => Assigned => Running => Failed => Fixed, Restart => Restarted => Running => Completed
Answer: AC

Oracle   1Z0-238 examen   1Z0-238 examen   1Z0-238   certification 1Z0-238   1Z0-238

NO.7 You discover that you will be applying an application patch on your APPL_TOP by using AutoPatch,
which
contains a compatible feature, the prereq line.
To ensure that the automatic, prerequisite patch-checking feature operates during the application of the
patch, you must run AD Administration, Maintain Snapshot Information, then perform some key tasks, and
then AutoPatch.
Select four key Maintain Snapshot Information tasks or combination of tasks that will ensure that the
prerequisite patch-checking feature operates during the application of the patch. (Choose four.)
A.Update a current view snapshot, or create a named snapshot.
B.Export a snapshot to a file, and then delete the named snapshot.
C.Import an up-to-date snapshot from a file from a different APPL_TOP.
D.List snapshots, delete the named snapshot, and create a named snapshot.
E.Copy the existing snapshot, delete the named snapshot, and then create a named snapshot.
Answer: ACDE

certification Oracle   1Z0-238   1Z0-238   1Z0-238

NO.8 Which command can be used only with a single-node installation?
A.rapidwiz -restart
B.rapidwiz -techstack
C.rapidwiz -servername
D.rapidwiz -silent -config
Answer: C

Oracle   1Z0-238   certification 1Z0-238   1Z0-238   1Z0-238

NO.9 Identify two ways in which you validate the APPS schema in the Oracle Applications R12 E-Business
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 .
Answer: BD

Oracle examen   1Z0-238 examen   1Z0-238

NO.10 While working with Web forms an application user sometimes comes across a performance issue. The
initial screen takes too long to appear with the Web form screen, showing the status "Downloading JAR
files..." for a long time.
Identify the reasons for this. (Choose two.)
A.It always takes time to load the Web forms.
B.An older version of Sun J2SE plug-in is installed on the Desktop tier.
C.JAR files for the Forms client applet are downloaded automatically the first time it is used.
D.The browser will automatically retrieve new JAR files if they have changed on the application tier.
E.The Internet Explorer browser security level should be set as "Low" for the zone that contains the
Oracle Application Release 12 Web pages.
Answer: CD

Oracle   1Z0-238   certification 1Z0-238   1Z0-238 examen   1Z0-238 examen

NO.11 You experience report-error problems in the Inventory module after applying a patch to the same
module.
You run the AD Administration utility, and select the Generate Application Files menu. Because you have
report problems, you decide to run Generate Report Files.
You answered the following questions during the utility run:
1. Do you want to generate Oracle report objects using the current character set? (You answer Yes.)
2. Do you want to regenerate the Oracle reports PL/SQL library files? (You answer No.)
3. Do you want to regenerate Oracle reports executable files? (You answer Yes.)
4. For which products do you want to generate Oracle report objects? (You answer "all reports in INV.")
After you run the AD utilities, most reports in Inventory run with no errors. However, you still experience
errors with two reports.
Which two statements explain why the two reports still run with errors? (Choose two.)
A.You have reports in a different language.
B.You have reports with external library files.
C.You have custom reports in a custom directory.
D.You have reports from a different module being referenced on the Inventory report menu.
Answer: B

Oracle   certification 1Z0-238   1Z0-238 examen

NO.12 You want to apply a patch on your Oracle Applications system. Before doing this, you want to view the
files that are new, changed, and ignored while applying the patch.
Which feature of the Patch Wizard would help you accomplish this?
A.Patch Filters
B.Patch Impact Analysis
C.Recommended Patches
D.Patch Information Bundle
Answer: B

certification Oracle   1Z0-238   certification 1Z0-238

NO.13 What is the default value of ?
A.APPS_
B.APPS_
C._
D._
E.APPS_
Answer: D

Oracle   certification 1Z0-238   certification 1Z0-238   1Z0-238 examen   1Z0-238

NO.14 After the successful installation of Oracle Applications Release 12, environment files are created.
Which environment file is used to identify and describe third-party and custom applications linked with
Oracle Applications?
A.the context file
B.the devenv.env file
C.the fndenv.env file
D.the adovars.env file
E.the adconfig.txt file
Answer: B

Oracle   1Z0-238   1Z0-238   1Z0-238

NO.15 What are the two occasions when it is appropriate to run "Compile APPS schema" by using the AD
Administration utility in the Oracle Applications R12 E-Business Suite environment? (Choose two.)
A.during the Oracle Applications R12 E-Business Suite upgrade process
B.when custom packages are moved to the APPS schema and need to be compiled
C.after enabling the multiple reporting currencies in the Oracle Applications R12 E-Business Suite
environment
D.after enabling the multiorganization functionality in the Oracle Applications R12 E-Business Suite
environment
E.when encountering invalid objects in the SYS and SYSTEM schemas in the Oracle Applications R12
E-Business Suite database
Answer: AB

Oracle   1Z0-238 examen   1Z0-238 examen   certification 1Z0-238   1Z0-238   1Z0-238

NO.16 AD Administration contains a utility named Maintain Snapshot Information. Which statements
correctly describe the functionality of this utility? (Choose all that apply.)
A.You can create a copy of an existing snapshot.
B.You can delete the current view snapshot.
C.You can create a list of the current view and named snapshots stored in your system.
D.You can export an existing snapshot to a file for storage or to another system.
E.You can update the current view snapshot with any changes to the snapshot since the last update.
Answer: ACDE

Oracle   1Z0-238   1Z0-238   1Z0-238

NO.17 You run the AD Administration utility and select the Relink Applications programs.
You answered the following questions during the utility run:
Do you wish to proceed with the relink [Yes]? (You answer Yes.)
Enter the list of products to link ("all" for all products) [all]? (You answer "ad." )
Do you want to generate specific executables for each selected product [No]? (You answer Yes.)
AD Administration can relink your Oracle Applications programs with debug
information. Oracle recommends that you do not relink your programs
with debug information unless asked to do so by Oracle Support Services.
Do you want to relink with debug information [No]? (You answer No.)
What is the next question asked by adadmin?
A.It gives you a list of all executables to choose from.
B.It gives you the list of "ad" executables to choose from.
C.It gives you the list of all executables except "ad" to choose from.
D.It asks no question. It displays the message "Review the messages above, then press [Return] to
continue."
Answer: D

Oracle   1Z0-238 examen   certification 1Z0-238   1Z0-238 examen

NO.18 Where can you find the generated report file after running the "Validate APPS schema" task in the
Oracle Applications R12 E-Business Suite setup?
A./admin/.lst
B./admin/out/.lst
C./admin/out/.lst
D./admin//out/.lst
E./admin//out/.lst
Answer: E

certification Oracle   1Z0-238   1Z0-238   1Z0-238

NO.19 You suddenly start receiving errors indicating that there are numerous Java files in the database that
are corrupted and cannot be run. You determined that you must reload the Java Virtual Machine (JVM) to
fix the errors.
In addition to reloading the JVM, what Oracle database utilities, if any, do you need to run and why?
(Choose all that apply.)
A.Compile the Menu information to restore Java menu files to the application forms.
B.Reload JAR files to the database because after reloading the JVM, the Java class files would be
missing.
C.Compile the APPS schema because after the JVM has been reloaded, APPS permissions need to be
reestablished.
D.None of the Oracle database utilities need to be run because by reloading the JVM, all corrected Java
files are corrected with the new files loaded during this process.
Answer: B

Oracle   1Z0-238   1Z0-238

NO.20 Which table is used by AutoPatch as a staging area for the job information in parallel mode and needs
to be dropped to start a new autopatch session if the earlier session failed?
A.FND_JOBS
B.FND_PROCESSES
C.FND_INSTALL_PROCESSES
D.FND_INSTALLED_PROCESSES
Answer: C

Oracle   1Z0-238   certification 1Z0-238   1Z0-238   1Z0-238

NO.21 In which three cases is it most effective to run validation on the APPS schema in the Oracle
Applications R12 E-Business Suite setup? (Choose three.)
A.before performing an export or import
B.after a patch or multiple patches are applied
C.immediately after an upgrade or after applying a maintenance pack
D.after converting to multiple organizations or multiple reporting currencies
E.whenever you receive a run-time error that suggests that a problem is caused by the AD_DDL package
Answer: BCE

certification Oracle   1Z0-238   1Z0-238   certification 1Z0-238   certification 1Z0-238

NO.22 As a database administrator (DBA), you have been trying to apply a maintenance patch, but it has
failed to
run successfully to completion. You check the AD Administration log file for an error. The log file reveals
several entries that are generic errors about the inability of patch codes to have access to product
packages from the GL product modules.
You remember that one of the occasions when you should run the "Recreate Grants and Synonyms" AD
Administration utility is if the patch and the administrative sessions fail to run successfully to completion.
You have found one occasion to use this utility in the case above. Now choose three other occasions
when you would run this process again. (Choose three.)
A.after custom development
B.when applying a patch to the operating system
C.after applying a patch to the Applications technology stack
D.in case of incomplete database migrations (exports or imports)
E.when installing or maintaining underlying database components or options such as Replication
Answer: ADE

Oracle   1Z0-238   1Z0-238   1Z0-238

NO.23 If the patch is running in Pre-Install mode, where would the patch history files be stored in Oracle
Applications R12 configured on a UNIX operating system?
A.$AD_TOP/admin
B.$APPL_TOP/admin
C.$TEMP/runInstaller
D.$APPL_TOP/admin/
E.$COMMON_TOP/admin/
Answer: D

Oracle examen   1Z0-238   1Z0-238   1Z0-238   1Z0-238

NO.24 Before you apply a patch, you read the readme.txt file.
One of the areas of Oracle Applications to which the patch will be applied is JAVA_TOP.
The readme file mentions that you may need to generate product JAR files in the AD Administration
utilities after the patch is applied.
When generating product JAR files, the AD Administration utility will prompt you with the question: Do you
want to force the generation of all JAR files?
What are the three occasions when you need to force the generation of all JAR files? (Choose three.)
A.after changing your digital signature
B.after updating to a new Java version
C.if you find you have missing or out-of-date JAR files
D.if you are upgrading the Oracle Developer technology stack
Answer: ABD

Oracle examen   certification 1Z0-238   certification 1Z0-238   certification 1Z0-238   1Z0-238   certification 1Z0-238

NO.25 As part of the cloning process, the Applications DBA needs to copy the application tier file system to the
target system.
Which step is NOT a part of this process?
A.Shut down the application tier server processes.
B.Log on to the target system application tier nodes as the oracle user.
C.Copy the APPL_TOP directory from the source node to the target node.
D.Copy the directory from the source node to the target node.
E.Copy the directory from the source node to the target node.
F.Copy the directory from the source node to the target node.
G.Copy the <806 ORACLE_HOME> directory from the source node to the target node.
Answer: B

Oracle examen   1Z0-238 examen   1Z0-238   1Z0-238

NO.26 The AD Administration task utility "Compile APPS Schema" is similar to the "Validate APPS Schema"
task, except that instead of just producing a list of invalid objects, it compiles invalid objects using multiple
workers in an attempt to move them back to the valid object state.
This task is most often run when custom packages are moved into the APPS schema, and during the
upgrade process.
The "Compile APPS Schema" task can be toggled to compile all objects or just the invalid objects.
Choose three correct benefits of using this task. (Choose three.)
A.increases run-time performance in the applications
B.corrects all corrupt schema package bodies and headers
C.finds truly invalid objects before users get a run-time error
D.allows new custom or patched packages to be immediately validated
Answer: ACD

certification Oracle   1Z0-238   1Z0-238 examen

NO.27 During installation, the Rapid Install process creates ______ that are used to start and stop the server
processes on the database tier.
A.JServer load balancers
B.cost-based optimizers
C.database resource managers
D.session-persistent load balancers
E.database-tier server process scripts
Answer: E

certification Oracle   1Z0-238   1Z0-238 examen   1Z0-238 examen   1Z0-238

NO.28 The Oracle Applications R12 database administrator (DBA) runs the "Recreate grants and synonyms
for APPS schema" task by using the adadmin utility when grants or synonyms are missing from the
database.
Which three causes are responsible for this? (Choose three.)
A.incomplete database migrations (exports or imports)
B.patch and administrative sessions that failed to run successfully to completion
C.invoking PL/SQL routines to maintain multilingual tables by adding missing, untranslated rows
D.installing or maintaining Oracle Applications R12 E-Business Suite underlying database components or
options such as Replication
Answer: ABD

Oracle examen   certification 1Z0-238   1Z0-238   certification 1Z0-238

NO.29 You just brought the middle tier back after a hardware problem has been fixed. Oracle Applications
now experience problems with an entire product group of forms (fnd), which includes the sign-on form.
You decide that you will generate the forms files in AD Administration to see whether this will fix
theproblem.
You answered the prompts from the utility as follows:
1. Do you want to generate Oracle Forms using your current character set? (Yes)
2. Do you want to regenerate Oracle Forms PL/SQL library files? (Yes)
3. Do you want to regenerate Oracle Forms executable files? (Yes)
4. Do you want to regenerate Oracle Forms menu files? (Yes)
5. Enter the list of products, or enter 'all' [all]: (fnd)
6. Do you want to generate specific form objects for each selected product? (Yes)
7. Enter libraries and menus to generate, or enter 'all' [all]: (APPCORE.pll, the main library)
8. Enter forms to generate, or enter 'all' [all]: FNDSCSGN.fmx
The utility finished with no errors in the log file.
What is the outcome of running the adadmin utility?
A.All forms in the product group fnd now render with errors.
B.All forms in the product group fnd now render without errors.
C.All forms but one in the product group fnd now render with errors.
D.All forms but one in the product group fnd now render without errors.
Answer: C

certification Oracle   1Z0-238 examen   1Z0-238 examen   1Z0-238

NO.30 Identify the files that are changed when you run AutoConfig. (Choose all that apply.)
A./listener.ora
B./.env
C./admin/adconfig.txt
D./.env
E./appl/admin/.xml
Answer: ABD

Oracle   1Z0-238   1Z0-238

2013年8月24日星期六

L'avènement de la certification Oracle pratique d'examen 1Z0-053 questions et réponses

Différentes façons peuvent atteindre le même but, ça dépend laquelle que vous prenez. Beaucoup de gens choisissent le test Oracle 1Z0-053 pour améliorer la vie et la carrière. Mais tous les gens ont déjà participé le test Oracle 1Z0-053, ils savent qu'il est difficile à réussir le test. Il y a quelques dépensent le temps et l'argent, mais ratent finalement.

Le suucès n'est pas loin de vous une fois que vous choisissez le produit de Q&A Oracle 1Z0-053 de Pass4Test.

Code d'Examen: 1Z0-053
Nom d'Examen: Oracle (Oracle Database 11g: Administration II)
Questions et réponses: 673 Q&As

On doit faire un bon choix pour passer le test Oracle 1Z0-053. C'est une bonne affaire à choisir la Q&A de Pass4Test comme le guide d'étude, parce que vous allez obtenir la Certification Oracle 1Z0-053 en dépensant d'un petit invertissement. D'ailleur, la mise à jour gratuite pendant un an est aussi gratuite pour vous. C'est vraiment un bon choix.

Le Certificat de Oracle 1Z0-053 signifie aussi un nouveau jalon de la carrière, le travail aura une space plus grande à augmenter, et tout le monde dans l'industrie IT sont désireux de l'obtenir. En face d'une grande passion pour le test Certification Oracle 1Z0-053, le contrariété est le taux très faible à réussir. Bien sûr que l'on ne passe pas le test 1Z0-053 sans aucun éffort, en même temps, le test de Oracle 1Z0-053 demande les connaissances bien professionnelles. Le guide d'étude dans le site Pass4Test peut vous fournir un raccourci à réussir le test Oracle 1Z0-053 et à obtenir le Certificat de ce test. Choisissez le guide d'étude de Pass4Test, vous verrez moins de temps dépensés, moins d'efforts contribués, mais plus de chances à réussir le test. Ça c'est une solution bien rentable pour vous.

1Z0-053 Démo gratuit à télécharger: http://www.pass4test.fr/1Z0-053.html

NO.1 Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains
one redo member. When you attempt to start the database, you receive the following errors:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'D:\REDO01.LOG'
You discover that the online redo log file of the current redo group is corrupted.
Which statement should you use to resolve this issue?
A. ALTER DATABASE DROP LOGFILE GROUP 1;
B. ALTER DATABASE CLEAR LOGFILE GROUP 1;
C. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;
D. ALTER DATABASE DROP LOGFILE MEMBER 'D:\REDO01.LOG';
Answer: C

Oracle   1Z0-053 examen   1Z0-053   1Z0-053   certification 1Z0-053

NO.2 Because of a logical corruption in your production database, you wanted to perform Tablespace Point
in Time Recovery (TSPITR). But before you start the recovery, you queried the
TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that
would be dropped when you start the recovery by using this method. You want to preserve these objects.
Which option must you use to perform TSPITR and preserve the object?
A. Perform Export before TSPITR and Import after TSPITR
B. Move objects to another schema that has the same tablespace assigned
C. Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)
D. Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)
Answer: A

Oracle   certification 1Z0-053   1Z0-053

NO.3 You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The
PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery
catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executes
the following command to grant privileges to a new user VPC1 using Oracle Database 11g RMAN
executables:
RMAN> GRANT CATALOG FOR DATABASE prod1, prod2 TO vpc1;
Then you issue the following commands:
RMAN> CONNECT CATALOG vpc1/oracle@catdb;
RMAN> SQL "EXEC catowner.dbms_rcvcat.create_virtual_catalog;"
What is the outcome of the above commands?
A. They execute and create a virtual catalog for pre-Oracle 11g clients.
B. They produce an error because PROD1 and PROD2 databases belong to the older version.
C. They produce an error because you need to connect as CATOWNER to execute this packaged
procedure.
D. They produce an error because you need to connect to the target database to execute this packaged
procedure.
Answer: A

Oracle examen   certification 1Z0-053   1Z0-053

NO.4 While deploying a new application module, the software vendor ships the application software along
with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements describe
the consequences? (Choose two.)
A. The plan baselines can be evolved over time to produce better performance.
B. The newly generated plans are directly placed into the SQL plan baseline without being verified.
C. The new SQL statements initially run with the plans that are known to produce good performance
under standard test configuration.
D. The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline
has been imported.
Answer: AC

Oracle   1Z0-053 examen   1Z0-053   certification 1Z0-053

NO.5 The INV_HISTORY table is created using the command:
SQL>CREATE TABLE INV_HISTORY (inv_no NUMBER(3), inv_date DATE, inv_amt NUMBER(10,2))
partition by range (inv_date) interval
(numtoyminterval(1,'month')) (partition p0
values less than (to_date('01-01-2005','dd-mm-yyyy')), partition p1 values less than
(to_date('01-01-2006','dd-mm-yyyy')));
The following data has been inserted into the INV_HISTORY table :
INV_NO INV_DATE INV_AMT 1 30-dec-2004 1000 2 30-dec-2005 2000 3 1-feb-2006 3000 4 1-mar-2006
4000 5 1-apr-2006 5000
You would like to store the data belonging to the year 2006 in a single partition and issue the command:
SQL> ALTER TABLE inv_history MERGE PARTITIONS
FOR(TO_DATE('15-feb-2006','dd-mon-yyyy')), FOR(TO_DATE('15-apr-2006')) INTO PARTITION sys_py;
What would be the outcome of this command?
A. It executes successfully, and the transition point is set to '1-apr-2006'.
B. It executes successfully, and the transition point is set to '15-apr-2006'.
C. It produces an error because the partitions specified for merging are not adjacent.
D. It produces an error because the date values specified in the merge do not match the date values
stored in the table.
Answer: C

Oracle examen   1Z0-053   1Z0-053

NO.6 You need to configure fine-grained access control to external network resources from within your
database. You create an access control list (ACL) using the DBMS_NETWORK_ACL_ADMIN package.
Which statement is true regarding the ACL created?
A. It is a list of remote database links stored in the XML file that are available to the users of the database.
B. It is a list of users and network privileges stored in the XML file according to which a group of users can
connect to one or more hosts.
C. It is a list of users and network privileges stored in the data dictionary according to which a group of
users can connect to one or more hosts.
D. It is the list of the host names or the IP addresses stored in the data dictionary that can connect to your
database through PL/SQL network utility packages such as UTL_TCP.
Answer: B

certification Oracle   certification 1Z0-053   1Z0-053 examen   1Z0-053 examen

NO.7 View the Exhibit that sets the threshold for the Current Open Cursors Count metric. Why is the
Significance Level threshold type not available in the threshold setting?
A. because AWR baseline is not enabled
B. because Current Open Cursors Count is not a basic metric
C. because the STATISTICS_LEVEL parameter is set to BASIC
D. because the AWR baseline is a system-defined moving window baseline
Answer: B

certification Oracle   certification 1Z0-053   1Z0-053   certification 1Z0-053

NO.8 View the Exhibit and examine the resource consumption details for the current plan in use by the
database instance.
Which two statements are true based on the output? (Choose two.)
Exhibit:
A. An attempt to start a new session by the user belonging to DSS_QUERIES fails with an error
B. A user belonging to DSS_QUERIES can log in to a new session but the session will be queued
C. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for
the CPU due to resource management
D. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for
the CPU due to resource management, I/O waits, and latch or enqueue contention
Answer: BC

Oracle examen   1Z0-053   1Z0-053 examen   certification 1Z0-053

NO.9 You create a new Automatic Database Diagnostic Monitor (ADDM) task:
instance_analysis_mode_task. To view the ADDM report, you use the following command:
SQL> SELECT dbms_addm.get_report('my_instance_analysis_mode_task') FROM dual;
You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT's segments.
What would you do to achieve this?
A. Add a finding directive for the ADDM task.
B. Add a segment directive for the ADDM task.
C. Add a parameter directive for the ADDM task.
D. Disable the Segment Advisor from the Automatic Maintenance Task.
Answer: B

Oracle examen   1Z0-053   1Z0-053   certification 1Z0-053

NO.10 Consider the following scenario for your database:
-Backup optimization is enabled in RMAN. The recovery window is set to 7 days in RMAN. The most
recent backup to disk for the TOOLS tablespace was taken on November 3, 2007.
The TOOLS tablespace is read-only since November 4, 2007.
On November 23, 2007, you issue the RMAN command to back up the database to disk. Which statement
is true regarding the backup of the TOOLS tablespace?
A. The RMAN backup fails because the TOOLS tablespace is read-only
B. The RMAN skips the backup of the tablespace because backup optimization is enabled
C. The RMAN makes backup because optimization can be enabled only for backups to disk
D. The RMAN makes the backup because no backup of the tablespace exists within the seven day
window
Answer: D

Oracle   1Z0-053 examen   certification 1Z0-053   certification 1Z0-053

NO.11 Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure
for LOB space usage?
A. It returns space usage of only BasicFile LOB chunks.
B. It returns space usage of only SecureFile LOB chunks.
C. It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.
D. It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned
tables.
Answer: B

Oracle examen   certification 1Z0-053   1Z0-053   1Z0-053   1Z0-053

NO.12 You performed the RMAN database backup having a backupset key number 231 with the KEEP
FOREVER option.
After some days, you want to change the status of the database backup and you issued the following
command:
RMAN>CHANGE BACKUPSET 231 NOKEEP;
What is the implication of this command?
A. The backup is deleted.
B. The backup is marked unavailable.
C. The backup overrides the backup retention policy.
D. the backup becomes eligible for deletion according to the existing retention policy
Answer: D

Oracle   1Z0-053   1Z0-053   1Z0-053

NO.13 Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile
LOBs?
A. It cannot be done in parallel.
B. It can be done at the table level or partition level.
C. It does not require additional storage because the operation is done online.
D. Local and global indexes are maintained automatically during the operation.
Answer: B

Oracle   1Z0-053   1Z0-053

NO.14 Which three components does the Scheduler use for managing tasks within the Oracle environment?
(Choose three.)
A. a job
B. a program
C. a schedule
D. a PL/SQL procedure
Answer: ABC

Oracle   1Z0-053 examen   1Z0-053

NO.15 You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema
owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog
schema owned by the user RCAT10.
You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10,
into the recovery catalog owned by RCO11. You also want to deregister them from the catalog after import.
You executed the following commands to achieve this:
RMAN> CONNECT CATALOG rco11/password@catdb
RMAN> IMPORT CATALOG rcat10/oracle@inst1 DBID=1423241,1423242;
What happens if the RCO11 catalog has scripts with the same name as that of the scripts in RCAT10
catalog?
A. The scripts in the RCO11 catalog are overwritten.
B. RMAN renames the local stored scripts in the RCO11 catalog.
C. The RMAN session in which the command is executed aborts.
D. RMAN renames the global scripts that are imported from the RCAT10 catalog.
Answer: D

Oracle examen   certification 1Z0-053   1Z0-053   1Z0-053

NO.16 View the Exhibit to examine the metrics with a threshold. Which statement is true regarding the
Number of Transactions (per second) metric?
A. Oracle uses statistical relevance to determine when an adaptive threshold has been breached for the
metric.
B. The statistics for the metric values observed over the baseline time period are not examined to
determine threshold values.
C. Oracle determines when an adaptive threshold has been breached based on the maximum value
captured by the baseline.
D. The total concurrent number of threshold violations, which must occur before an alert is raised for the
metric, has been set to zero.
Answer: A

Oracle   1Z0-053   1Z0-053   1Z0-053

NO.17 Which two statements are true regarding hot patching? (Choose two.)
A. It requires relinking of the Oracle binary.
B. It does not require database instance shutdown.
C. It can detect conflicts between two online patches.
D. It is available for installing all patches on all platforms.
E. It works only in a single database instance environment.
Answer: BC

certification Oracle   1Z0-053   1Z0-053

NO.18 You plan to have a larger moving window size for the default system-defined moving window baseline
because you want to use the adaptive threshold.
Which statement factors in this consideration while increasing the size of the moving window.?
A. The collection level for the AWR should be set to BASIC.
B. The moving window size must be less than Undo Retention.
C. The moving window size should be greater than the Automatic Workload Repository (AWR) retention
period.
D. The moving window size should be equal to or less than the Automatic Workload Repository (AWR)
retention period.
Answer: D

certification Oracle   1Z0-053 examen   certification 1Z0-053   1Z0-053

NO.19 Examine the section of the Health Check report given below:
DBMS_HM.GET_RUN_REPORT('HM_RUN_1061')
Run Name : HM_RUN_1061 Run Id : 1061 Check Name : Data Block Integrity Check Mode :
REACTIVE Status : COMPLETED Start Time : 2007-05-12 22:11:02.032292 -07:00 End Time :
2007.05-12 22:11:20.835135 -07:00 Error Encountered : 0
Source Incident Id : 7418
Number of Incidents Created :0
Which two statements are true regarding the Health Check report? (Choose two.)
A. Health Check was performed manually.
B. Health Check was performed to check the disk image block corruptions.
C. Health Check was performed to check interblock and intersegment corruption.
D. Health Check was performed to verify the integrity of database files and report failures.
E. Health Check was performed by the Health Monitor automatically in response to a critical error.
Answer: AB

certification Oracle   1Z0-053   certification 1Z0-053   1Z0-053 examen

NO.20 A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the
online table redefinition. What happens to the PL/SQL procedure after the online table redefinition?
A. It remains valid.
B. It becomes invalid for all options of online table redefinition but automatically gets revalidated the next
time it is used.
C. It becomes invalid for all options of online table redefinition and is automatically recompiled during
online redefinition of the table.
D. It becomes invalid only if the storage parameters have been modified and it automatically gets
revalidated the next time it is used.
Answer: A

Oracle   1Z0-053 examen   1Z0-053 examen   1Z0-053   1Z0-053

Vous pouvez trouver un meilleur boulot dans l'industrie IT à travers d'obtenir le test Oracle 1Z0-053, la voie à la réussite de votre professionnel sera ouverte pour vous.