Certification Oracle de téléchargement gratuit pratique d'examen 1Z0-202 1Z0-047 1Z1-403 1Z1-050 1Z0-048, questions et réponses

L'équipe de Pass4Test se composant des experts dans le domaine IT. Toutes les Q&As sont examinées par nos experts. Les Q&As offertes par Pass4Test sont réputées pour sa grande couverture ( presque 100%) et sa haute précision. Vous pouvez trouver pas mal de sites similaires que Pass4Test, ces sites peut-être peuvent vous offrir aussi les guides d'études ou les services en ligne, mais on doit admettre que Pass4Test peut être la tête de ces nombreux sites. La mise à jour, la grande couverture des questions, la haute précision des réponses nous permettent à augmenter le taux à réussir le test Certification Oracle 1Z0-202 1Z0-047 1Z1-403 1Z1-050 1Z0-048. Tous les points mentionnés ci-dessus seront une assurance 100% pour votre réussite de test Certification Oracle 1Z0-202 1Z0-047 1Z1-403 1Z1-050 1Z0-048.

Pass4Test est un bon site qui provide la façon efficace à se former à court terme pour réussir le test Oracle 1Z0-202 1Z0-047 1Z1-403 1Z1-050 1Z0-048, c'est un certificat qui peut améliorer le niveau de vie. Les gens avec le Certificat gagent beaucoup plus que les gens sans Certificat Oracle 1Z0-202 1Z0-047 1Z1-403 1Z1-050 1Z0-048. Vous aurez une space plus grande à se développer.

Pass4Test a capacité d'économiser vos temps et de vous faire plus confiant à réussir le test. Vous pouvez télécharger le démo Oracle 1Z0-202 1Z0-047 1Z1-403 1Z1-050 1Z0-048 gratuit à connaître mieux la bonne fiabilité de Pass4Test. Nous nous font toujours confiant sur nos produits, et vous aussi dans un temps proche. La réussite de test Oracle 1Z0-202 1Z0-047 1Z1-403 1Z1-050 1Z0-048 n'est pas loin de vous une fois que vous choisissez le produit de Pass4Test. C'est un choix élégant pour vous faciliter à réussir le test Oracle 1Z0-202 1Z0-047 1Z1-403 1Z1-050 1Z0-048.

Les spécialiste profitant leurs expériences et connaissances font sortir les documentations particulière ciblées au test Oracle 1Z0-202 1Z0-047 1Z1-403 1Z1-050 1Z0-048 pour répondre une grande demande des candidats. Maintenant, la Q&A plus nouvelle, la version plus proche de test Oracle 1Z0-202 1Z0-047 1Z1-403 1Z1-050 1Z0-048 réel est lancée. C'est possible à réussir 100% avec le produit de Oracle 1Z0-202 1Z0-047 1Z1-403 1Z1-050 1Z0-048. Si malheureusement, vous ne passez pas le test, votre argent sera tout rendu. Vous pouvez télécharger le démo gratuit en Internet pour examiner la qualité de Q&A. N'hésitez plus d'ajouter le produit au panier, Pass4Test peut vous aider à réussir le rêve.

Code d'Examen: 1Z0-202
Nom d'Examen: Oracle (Siebel 8 Consultant Exam)
Questions et réponses: 146 Q&As

Code d'Examen: 1Z0-047
Nom d'Examen: Oracle (Oracle Database SQL Expert)
Questions et réponses: 260 Q&As

Code d'Examen: 1Z1-403
Nom d'Examen: Oracle (Enterprise Linux System Administration)
Questions et réponses: 115 Q&As

Code d'Examen: 1Z1-050
Nom d'Examen: Oracle (Oracle Database 11g: New Features for Administrators)
Questions et réponses: 183 Q&As

Code d'Examen: 1Z0-048
Nom d'Examen: Oracle (Oracle Database 10g R2: Administering RAC)
Questions et réponses: 150 Q&As

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

NO.1 Which two statements are true with respect to the maintenance window? (Choose two.)
A.A DBA can enable or disable an individual task in all maintenance windows.
B.A DBA cannot change the duration of the maintenance window after it is created.
C.In case of a long maintenance window, all Automated Maintenance Tasks are restarted every four
hours.
D.A DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in
each window.
Answer: AD

certification Oracle   1Z1-050 examen   1Z1-050   1Z1-050

NO.2 Which two are the prerequisites to enable Flashback Data Archive? (Choose two.)
A.Undo retention guarantee must be enabled.
B.Database must be running in archivelog mode.
C.Automatic undo management must be enabled.
D.The tablespace on which the Flashback Data Archive is created must be managed with Automatic
Segment Space Management (ASSM).
Answer: CD

certification Oracle   1Z1-050 examen   1Z1-050 examen   1Z1-050   certification 1Z1-050

NO.3 Examine the following PL/SQL block:
Which statement describes the effect of the execution of the above PL/SQL block?
A.The plan baselines are verified with the SQL profiles.
B.All fixed plan baselines are converted into nonfixed plan baselines.
C.All the nonaccepted SQL profiles are accepted into the plan baseline.
D.The nonaccepted plans in the SQL Management Base are verified with the existing plan baselines.
Answer: D

Oracle   1Z1-050   1Z1-050   1Z1-050 examen   1Z1-050   certification 1Z1-050

NO.4 Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a
multiprocessor environment. At the end of the upgrade, you observe that the DBA executes the following
script:
SQL> @utlrp.sql
What is the significance of executing this script?
A.It performs parallel recompilation of only the stored PL/SQL code.
B.It performs sequential recompilation of only the stored PL/SQL code.
C.It performs parallel recompilation of any stored PL/SQL as well as Java code.
D.It performs sequential recompilation of any stored PL/SQL as well as Java code.
Answer: C

Oracle examen   1Z1-050 examen   1Z1-050 examen   1Z1-050 examen   certification 1Z1-050

NO.5 Which two statements about Oracle Direct Network File System (NFS) are true? (Choose two.)
A.It bypasses the OS file system cache.
B.A separate NFS interface is required for use across Linux, UNIX, and Windows platforms.
C.It uses the operating system kernel NFS layer for user tasks and network communication modules.
D.File systems need not be mounted by the kernel NFS system when being served through Direct NFS.
E.Oracle Disk Manager can manage NFS on its own, without using the operating system kernel NFS
driver.
Answer: AE

Oracle examen   1Z1-050   1Z1-050 examen   certification 1Z1-050

NO.6 You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database.
As a part of the upgrade process, you execute the following script:
SQL>@utlu111i.sql
Which statement about the execution of this script is true?
A.It must be executed from the Oracle Database 11g environment.
B.It must be executed only after the SYSAUX tablespace has been created.
C.It must be executed from the environment of the database that is being upgraded.
D.It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.
E.It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.
Answer: C

Oracle examen   1Z1-050 examen   1Z1-050   1Z1-050

NO.7 What are the recommendations for Oracle Database 11g installation to make it Optimal Flexible
Architecture (OFA)-compliant? (Choose all that apply.)
A.ORACLE_BASE should be set explicitly.
B.An Oracle base should have only one Oracle home created in it.
C.Flash recovery area and data file location should be on separate disks.
D.Flash recovery area and data file location should be created under Oracle base in a non-Automatic
Storage Management (ASM) setup.
Answer: ACD

certification Oracle   certification 1Z1-050   1Z1-050 examen   1Z1-050

NO.8 You opened the encryption wallet and then issued the following command:
Then you closed the wallet. Later, you issued the following command to create the EMPLOYEES table in
the SECURESPACE tablespace and you use the NO SALT option for the EMPID column.
What is the outcome?
A.It creates the table and encrypts the data in it.
B.It generates an error because the wallet is closed.
C.It creates the table but does not encrypt the data in it.
D.It generates an error because the NO SALT option cannot be used with the ENCRYPT option.
Answer: B

certification Oracle   certification 1Z1-050   1Z1-050   1Z1-050   1Z1-050

NO.9 Following is the list of locations in random order where oranfstab can be placed.
What is the sequence in which Direct NFS will search the locations?
A.1, 2, 3
B.3, 2, 1
C.2, 3, 1
D.1, 3, 2
Answer: C

Oracle examen   1Z1-050 examen   certification 1Z1-050

NO.10 You are managing the APPPROD database as a DBA. You plan to duplicate this database in the same
system with the name DUPDB.
You issued the following RMAN commands to create a duplicate database:
Which three are the prerequisites for the successful execution of the above command? (Choose three.)
A.The source database should be open.
B.The target database should be in ARCHIVELOG mode if it is open.
C.RMAN should be connected to both the instances as SYSDBA.
D.The target database backups should be copied to the source database backup directories.
E.The password file must exist for the source database and have the same SYS user password as the
target.
Answer: BCE

Oracle examen   1Z1-050 examen   certification 1Z1-050   certification 1Z1-050

NO.11 You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the
oranfstab file in /etc.
Which two statements are true regarding this oranfstab file? (Choose two.)
A.Its entries are specific to a single database.
B.It contains file systems that have been mounted by Direct NFS.
C.It is globally available to all Oracle 11g databases on the machine.
D.It contains file systems that have been mounted by the kernel NFS system.
Answer: CD

Oracle   certification 1Z1-050   certification 1Z1-050   1Z1-050   1Z1-050

NO.12 In which two aspects does hot patching differ from conventional patching? (Choose two.)
A.It consumes more memory compared with conventional patching.
B.It can be installed and uninstalled via OPatch unlike conventional patching.
C.It takes more time to install or uninstall compared with conventional patching.
D.It does not require down time to apply or remove unlike conventional patching.
E.It is not persistent across instance startup and shutdown unlike conventional patching.
Answer: AD

Oracle   1Z1-050   certification 1Z1-050   1Z1-050   1Z1-050   1Z1-050

NO.13 During the installation of Oracle Database 11g, you do not set ORACLE_BASE explicitly. You selected
the option to create a database as part of the installation. How would this environment variable setting
affect the installation?
A.The installation terminates with an error.
B.The installation proceeds with the default value without warnings and errors.
C.The installation proceeds with the default value but it would not be an OFA-compliant database.
D.The installation proceeds with the default value but a message would be generated in the alert log file.
Answer: D

Oracle   1Z1-050   certification 1Z1-050   certification 1Z1-050

NO.14 Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)
A.The database files are corrupted when the database is open.
B.The archived log files are missing for which backup is not available.
C.The user has dropped an important table that needs to be recovered.
D.You are not able to start up the database instance because the required database files are missing.
Answer: AD

Oracle examen   1Z1-050   1Z1-050   1Z1-050   certification 1Z1-050

NO.15 You are managing an Oracle 11g database with ASM storage, for which the COMPATIBLE initialization
parameter is set to 11.1.0. In the ASM instance, the COMPATIBLE.RDBMS attribute for the disk group is
set to 10.2 and the COMPATIBLE.ASM attribute is set to 11.1.
Which two statements are true in this scenario for the features enabled for ASM? (Choose two.)
A.The ASM-preferred mirror read feature is enabled.
B.The ASM supports variable sizes for extents of 1, 8, and 64 allocation units.
C.The ASM disk is dropped immediately from a disk group when it becomes unavailable.
D.The RDBMS always reads the primary copy of a mirrored extent of the ASM disk group.
Answer: AB

Oracle   certification 1Z1-050   1Z1-050   1Z1-050 examen

NO.16 Which steps are mandatory to enable Direct NFS?
A.2 and 3
B.1 and 3
C.1 and 2
D.1, 2 and 3
Answer: B

Oracle   1Z1-050   1Z1-050   1Z1-050

NO.17 Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework?
A.SQL statements that are part of the AWR baseline only
B.SQL statements based on the AWR top SQL identification
C.SQL statements that are part of the available SQL Tuning Set (STS) only
D.SQL statements that are available in the cursor cache and executed by a user other than SYS
Answer: B

certification Oracle   1Z1-050   1Z1-050   1Z1-050 examen   1Z1-050

NO.18 Which dependent object will get invalidated even if it is not affected by the table redefinition?
A.views
B.triggers
C.packages
D.synonyms
Answer: B

Oracle examen   1Z1-050   1Z1-050   1Z1-050

NO.19 Which two statements are true regarding the starting of the database instance using the following
command? (Choose two.)
SQL>STARTUP UPGRADE
A.It enables all system triggers.
B.It allows only SYSDBA connections.
C.It ensures that all job queues remain active during the upgrade process.
D.It sets system initialization parameters to specific values that are required to enable database upgrade
scripts to be run.
Answer: BD

Oracle examen   certification 1Z1-050   1Z1-050   1Z1-050

NO.20 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

Oracle   1Z1-050   certification 1Z1-050   1Z1-050

Pass4Test offre une formation sur Oracle 1Z0-048 matériaux examen

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-048 avec succès. Pass4Test est un fournissur fiable. Vous allez réaliser votre rêve avec l'aide de Pass4Test.

L'importance de la position de Certificat Oracle 1Z0-048 dans l'industrie IT est bien claire pour tout le monde, mais c'est pas facile à obtenir ce Certificat. Il y a beaucoup de Q&As qui manquent une haute précision des réponses. Cependant, Pass4Test peut offrir des matériaux pratiques pour toutes les personnes à participer l'examen de Certification, et il peut aussi offrir à tout moment toutes les informations que vous auriez besoin à réussir l'examen Oracle 1Z0-048 par votre première fois.

Code d'Examen: 1Z0-048
Nom d'Examen: Oracle (Oracle Database 10g R2: Administering RAC)
Questions et réponses: 150 Q&As

La Q&A Oracle 1Z0-048 est étudiée par les experts de Pass4Test qui font tous effort en profitant leurs connaissances professionnelles. La Q&A de Pass4Test est ciblée aux candidats de test IT Certification. Vous voyez peut-être les Q&As similaires dansn les autres site web, mais il n'y a que Pass4Test d'avoir le guide d'étude plus complet. C'est le meilleur choix à s'assurer le succès de test Certification Oracle 1Z0-048.

Si vous êtes intéressé par l'outil formation Oracle 1Z0-048 étudié par Pass4Test, vous pouvez télécharger tout d'abord le démo. Le service de la mise à jour gratuite pendant un an est aussi offert pour vous.

Si vous traviallez dur encore pour préparer le test de Oracle 1Z0-048 et réaliser votre but plus vite, Pass4Test peut vous donner une solution plus pratique. Choisir la Q&As de Pass4Test qui vous assure que c'est pas un rêve à réussir le test Oracle 1Z0-048.

Vous aurez le service de la mise à jour gratuite pendant un an une fois que vous achetez le produit de Pass4Test. Vous pouvez recevoir les notes immédiatement à propos de aucun changement dans le test ou la nouvelle Q&A sortie. Pass4Test permet tous les clients à réussir le test Oracle 1Z0-048 à la première fois.

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

NO.1 Which two initialization parameters must be set to start up an ASM instance in a RAC
environment? (Choose two.)
A.INSTANCE_TYPE
B.DB_UNIQUE_NAME
C.ASM_DISKSTRING
D.ASM_DISKGROUPS
E.ASM_POWER_LIMIT
F.CLUSTER_DATABASE
Correct:A F

certification Oracle   1Z0-048   certification 1Z0-048   1Z0-048 examen   1Z0-048 examen

NO.2 Several steps must be followed to successfully add a new node to your cluster database.
Assuming that a UNIX platform is used, which of the three steps below are correct? (Choose
three.)
A.Add instances using OUI.
B.Reconfigure listeners for the new node with netca.
C.Configure the OS and hardware for the new node.
D.Add the node to the cluster using the addnode.sh script run from ORA_CRS_HOME.
E.Add the RAC software to the new node using addnode.sh from ORA_CRS_HOME.
Correct:B C D

certification Oracle   1Z0-048   certification 1Z0-048   1Z0-048 examen   1Z0-048 examen

NO.3 You are about to build a new Oracle Clusterware-based cluster and you want to make the
installation process as smooth as possible. You decide to use the Cluster Verification Utility
(CLUVFY) to check whether or not your system administrator has set up the hardware and system
software correctly. Which two statements about CLUVFY are true? (Choose two.)
A.You can run CLUVFY only from a privileged operating system account.
B.You can run CLUVFY directly from the Oracle Clusterware distribution media.
C.CLUVFY cannot be used until the Oracle Clusterware is installed successfully.
D.After the Oracle Clusterware installation, you can run CLUVFY from the Oracle Home that holds the
CRS binaries.
E.You have to install CLUVFY on all cluster nodes in order to use CLUVFY on other nodes than the one
from which you perform the installation.
F.To use CLUVFY during the Oracle Clusterware installation, you have to download CLUVFY from the
Oracle Technology Network (OTN) Web site and install it before you can use it.
Correct:B D

certification Oracle   1Z0-048   certification 1Z0-048   1Z0-048 examen   1Z0-048 examen

NO.4 You have a well-tuned, non-RAC single instance Oracle database with several services, all of
which perform perfectly. You plan to migrate the database to RAC in the next two weeks and all file
systems would be shared using Oracle Cluster File System. After the migration, you want to
perform a test to monitor RAC-specific tuning issues that would not have occurred on a non-RAC
database. Which six areas would you monitor to determine whether there are RAC-specific
performance problems after migration? (Choose six.)
A.Interconnect latency
B.Instance recovery time
C.Services with applications that use external tables
D.Services with applications that truncate large tables
E.Services with applications using local context variables
F.Services with query-intensive applications relying on full table scans
G.Services with insert-intensive applications that use Oracle sequences for index keys
H.Services with applications that have occasional queries, using index access on modestly sized tables
I.Services with insert-intensive applications that generate their own keys without Oracle sequences
Correct:A B D F G I

certification Oracle   1Z0-048   certification 1Z0-048   1Z0-048 examen   1Z0-048 examen

NO.5 Oracle Cluster Registry (OCR) can be recovered on a UNIX platform using which two
commands? (Choose two.)
A.ocrconfig -import /u01/logical_ocr/yesterday.ocr where yesterday.ocr is an automatically generated
OCR backup
B.ocrconfig -import /u01/logical_ocr/yesterday.ocr_exp where yesterday.ocr_exp is a logical backup
created using the ocrconfig -export command
C.cp /app/oracle/product/10.1.0/crs_1/cdata/dbclust01/day.ocr /ocfs/OCR/crs.dbf where
/ocfs/OCR/crs.dbf is the cluster registry file
D.ocrconfig -restore /app/oracle/product/10.1.0/crs_1/cdata/dbclust01/day.ocr where day.ocr is an
automatically generated OCR backup
Correct:B D

certification Oracle   1Z0-048   certification 1Z0-048   1Z0-048 examen   1Z0-048 examen

NO.6 Which three storage types are suitable as a flash recovery area for an Oracle 10g RAC database?
(Choose three.)
A.Raw volume
B.ASM disk group
C.Local file system
D.Cluster file system
E.Shared NFS directory
Correct:B D E

certification Oracle   1Z0-048   certification 1Z0-048   1Z0-048 examen   1Z0-048 examen

NO.7 In a RAC environment, you see a steep increase for enq:HW - contention and gc current grant
wait events. What would you do to fix this issue?
A.Increase the cache size of sequences.
B.Reduce the time of transactions by committing more often.
C.Use larger uniform extent sizes for objects.
D.Reduce the number of updates causing locks on tables accessed by multiple instances.
Correct:C

certification Oracle   1Z0-048   certification 1Z0-048   1Z0-048 examen   1Z0-048 examen

NO.8 Which three statements regarding backup of the voting disk are true? (Choose three.)
A.On UNIX platforms, the voting disk can be backed up with the dd command.
B.A backup of the voting disk should be taken whenever an RMAN catalog reset is done.
C.A backup of the voting disk should be taken whenever a new node is added to the cluster.
D.A backup of the voting disk should be taken whenever an existing node is removed from the cluster.
E.Whenever a voting disk backup is made, the Clusterware software should be stopped on all nodes in
the cluster.
Correct:A C D

certification Oracle   1Z0-048   certification 1Z0-048   1Z0-048 examen   1Z0-048 examen

NO.9 View the Exhibit, which displays the cluster database performance page after the same
workload has been executed three times on your cluster without varying any non-Oracle
workloads on the cluster. What are the two ways by which you can tell that the corresponding
application was better tuned during the second and third execution? (Choose two.)
A.There is less paging each time.
B.The run queue length is going down each time.
C.It takes less time to execute the workload each time.
D.The number of transactions per second is getting higher each time.
E.The database throughput graphic is below the red dashed line during the last execution.
Correct:C D

certification Oracle   1Z0-048   certification 1Z0-048   1Z0-048 examen   1Z0-048 examen

NO.10 Your company has certain standard practices for technology and you are configuring ASM disk
groups for your four-node RAC cluster. The company guidelines suggest that there is one disk
group for the flash recovery area that is shared by all databases and a separate disk group for the
database area of all databases. Which three exceptions exist that may require you to create
additional disk groups? (Choose three.)
A.The retention policy for backups are different for different databases.
B.There are large nonpartitioned tables accessed frequently using indexes.
C.The disk farm has different disk models with different characteristics and ages.
D.Some databases operate in ARCHIVELOGMODE and others in NOARCHIVELOGMODE.
E.Some database instances are shut down every night while others are always running.
F.Applications using the databases have different Service-Level Agreements for response time and
throughput.
G.There are partitioned tables where the older partitions are in read-only tablespaces and seldom
accessed, but the more recent partitions are frequently accessed.
Correct:C F G

certification Oracle   1Z0-048   certification 1Z0-048   1Z0-048 examen   1Z0-048 examen

NO.11 You have attended a user group presentation on RAC and based on what you have learned you
feel that your company would benefit from having the RAC option to meet its Oracle database
requirements in several ways. Your manager does not know much about RAC and asks you to
create a presentation to the team explaining RAC, and whether it should be implemented in your
installation. Which three statements explain the benefits and implications of RAC? (Choose three.)
A.RAC alone would not help protect from human errors.
B.RAC would increase availability in the event of data failures.
C.RAC would increase availability in the event of a network failure.
D.RAC alone would increase availability when doing release upgrades.
E.RAC would increase scalability for all application workloads in all cases.
F.RAC would increase availability in the event of node and instance failures.
G.RAC used in conjunction with parallel execution may provide speedup of DSS queries.
H.RAC used in conjunction with parallel execution may provide for speedup of OLTP workload processes.
Correct:A F G

certification Oracle   1Z0-048   certification 1Z0-048   1Z0-048 examen   1Z0-048 examen

NO.12 After the cluster database has been successfully created, several postinstallation tasks should
be completed. Identify three of them. (Choose three.)
A.Create the ASM instance.
B.Back up the root.sh script.
C.Initialize the cluster backup procedure.
D.Set up additional required user accounts.
E.Verify the Enterprise Manager/Oracle Cluster Registry configuration by running srvctl config database
-d db_name.
Correct:B D E

certification Oracle   1Z0-048   certification 1Z0-048   1Z0-048 examen   1Z0-048 examen

NO.13 After migrating from a 10g R1 cluster to 10g R2, you decide to multiplex your voting disk.
Which are the two ways in which you can accomplish this task? (Choose two.)
A.You should not use symbolic links.
B.You can add additional voting disks online.
C.You must add additional voting disks offline.
D.You may use the VIPCA utility to add new voting disks.
E.You may use the command: crsctl add css votedisk
Correct:B E

certification Oracle   1Z0-048   certification 1Z0-048   1Z0-048 examen   1Z0-048 examen

NO.14 You are working as a DBA in a RAC environment that is available for testing. The RAC
environment has all the database files stored in the OCFS file system. You plan to install ASM and
move all the database files to ASM to achieve better performance. During the installation, you
selected redundancy level as normal for the disk group being added. What is the reason for
selecting this redundancy level?
A.You want to use hardware mirroring.
B.You do not want to have any mirroring in the disk group.
C.You have two failure groups defined, so you want to use two-way mirroring.
D.You have three failure groups defined, so you want to use three-way mirroring.
Correct:C

certification Oracle   1Z0-048   certification 1Z0-048   1Z0-048 examen   1Z0-048 examen

NO.15 After a power failure, you noticed that one of your cluster database instances did not start
automatically, whereas all other instances came up successfully. What would you do to determine
the precise cause for the instance startup failure? (Choose three.)
A.Check the resource state by using the CRS_STAT command.
B.Check for OCR corruptions by using the OCRCHECK command.
C.Check the alert.log file that belongs to the instance that did not start.
D.Check the alert.log file that belongs to the Oracle Clusterware software.
E.Check if the Oracle Clusterware is functional by using the CRSCTL command.
F.Reboot the node where the failing instance resides to check if the problem is persistent.
G.Enable extra debugging in the Oracle Clusterware software by using the CRSCTL command.
Correct:A C D

certification Oracle   1Z0-048   certification 1Z0-048   1Z0-048 examen   1Z0-048 examen

NO.16 Your company has a combination of high availability and scalability requirements that need to
be addressed, and RAC has been discussed as a solution. There are a mix of "off-the-shelf"
software products and homegrown applications currently in use in your environment that run on
single-instance Oracle databases. You have been asked by the IT director to provide an impact
analysis report to help assess the impact on applications when migrating to RAC. Which three are
among the areas that should be examined for performance impact and application functionality
impact or for both? (Choose three.)
A.applications that use large parallel full table scans
B.applications that truncate tables in a data warehouse process
C.three-tier applications that use application global context variables
D.client/server type applications that use application local context variables
E.applications that access small tables using the same index occasionally
F.applications that use SQL profiles created by the ATO optimizer in the SQL Tuning Advisor
Correct:A B C

certification Oracle   1Z0-048   certification 1Z0-048   1Z0-048 examen   1Z0-048 examen

NO.17 Which initialization parameter would you use for each RAC instance to make sure that each
listener on each RAC node is aware of the load of all the others?
A.LOCAL_LISTENER
B.REMOTE_LISTENER
C.REMOTE_DEPENDENCIES_MODE
D.PREFER_LEAST_LOADED_NODE_
Correct:B

certification Oracle   1Z0-048   certification 1Z0-048   1Z0-048 examen   1Z0-048 examen

NO.18 You decide to implement a Data Guard configuration to support a disaster recovery plan for
your RAC database. Your primary database has all shared files and the flash recovery area is
stored on ASM disk groups. Which three options exist for storing the data guard broker
configuration files at the primary location? (Choose three.)
A.can be in any shared ASM disk group
B.can be stored on shared Raw Devices
C.must be stored on Oracle Cluster File System if a cluster file system is used
D.may be stored on any supported cluster file system if a cluster file system is used
E.must be in the same shared ASM disk group as the database data files if the broker configuration files
are stored in ASM disk groups
F.must be in the same shared ASM disk group as the Flash Recovery Area if the broker configuration files
are stored in ASM disk groups.
Correct:A B D

certification Oracle   1Z0-048   certification 1Z0-048   1Z0-048 examen   1Z0-048 examen

NO.19 Which optional parameter of the DESCRIPTION clause of a TNS entry can you use to randomize
the access to available listeners?
A.FAILOVER
B.LOAD_BALANCE
C.SOURCE_ROUTE
D.TYPE_OF_SERVICE
Correct:B

certification Oracle   1Z0-048   certification 1Z0-048   1Z0-048 examen   1Z0-048 examen

NO.20 You are running a two-instance database with six redo log groups defined and decide to add a
third thread to support a third database instance on the third node of the cluster. Which three
commands would you issue to achieve this using command line administration? (Choose three.)
A.ALTER SYSTEM ENABLE THREAD 3;
B.ALTER DATABASE ENABLE THREAD 3;
C.ALTER SYSTEM ADD LOGFILE THREAD 3 GROUP 8;
D.ALTER SYSTEM ADD LOGFILE THREAD 3 GROUP 7;
E.ALTER DATABASE ADD LOGFILE THREAD 3 GROUP 7;
F.ALTER DATABASE ADD LOGFILE THREAD 3 GROUP 8;
Correct:B E F

certification Oracle   1Z0-048   certification 1Z0-048   1Z0-048 examen   1Z0-048 examen

Pass4Test vous promet de vous aider à passer le test Oracle 1Z0-048, vous pouvez télécharger maintenant les Q&As partielles de test Oracle 1Z0-048 en ligne. Il y a encore la mise à jour gratuite pendant un an pour vous. Si vous malheureusement rater le test, votre argent sera 100% rendu.

Oracle meilleur examen 1Z0-048, questions et réponses

Pass4Test est un site d'offrir l'outil de formation convenable pour les candidats de test Certification IT. Le produit de Pass4Test peut aider les candidats à économiser les temps et les efforts. L'outil de formation est bien proche que test réel. Vous allez réussir le test 100% avec l'aide de test simulation de Pass4Test. C'est une bonne affaire à prendre le Certificat IT en coûtant un peu d'argent. N'hésitez plus d'ajouter l'outil de formation au panier.

C'est sûr que le Certificat Oracle 1Z0-048 puisse améliorer le lendemain de votre carrière. Parce que si vous pouvez passer le test Oracle 1Z0-048, c'est une meilleure preuve de vos connaissances professionnelles et de votre bonne capacité à être qualifié d'un bon boulot. Le Certificat Oracle 1Z0-048 peut bien tester la professionnalité de IT.

Dans cette société de l'information technologies, c'est bien populaire que l'on prenne la formation en Internet, Pass4Test est l'un des sites d'offrir la formation particulère pour le test Oracle 1Z0-048. Pass4Test a une expérience riche pour répondre les demandes des candidats.

Pass4Test peut non seulement vous aider à réussir votre rêve, mais encore vous offre le service gratuit pendand un an après vendre en ligne. Q&A offerte par l'équipe de Pass4Test vous assure à passer 100% le test de Certification Oracle 1Z0-048.

Code d'Examen: 1Z0-048
Nom d'Examen: Oracle (Oracle Database 10g R2: Administering RAC)
Questions et réponses: 150 Q&As

C'est pas facile à passer le test Certification Oracle 1Z0-048, choisir une bonne formation est le premier bas de réussir, donc choisir une bonne resource des informations de test Oracle 1Z0-048 est l'assurance du succès. Pass4Test est une assurance comme ça. Une fois que vous choisissez le test Oracle 1Z0-048, vous allez passer le test Oracle 1Z0-048 avec succès, de plus, un an de service en ligne après vendre est gratuit pour vous.

Pass4Test est un site particulier d'offrir la formation à propos de test Certification IT. C'est un bon choix pour vous aider à réussir le test Oracle 1Z0-048. Pass4Test offre toutes les informations et les documentations plus nouvelles qui peut vous donner plus de chances à réussir le test.

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

NO.1 After migrating from a 10g R1 cluster to 10g R2, you decide to multiplex your voting disk.
Which are the two ways in which you can accomplish this task? (Choose two.)
A.You should not use symbolic links.
B.You can add additional voting disks online.
C.You must add additional voting disks offline.
D.You may use the VIPCA utility to add new voting disks.
E.You may use the command: crsctl add css votedisk
Correct:B E

Oracle   1Z0-048   1Z0-048

NO.2 After the cluster database has been successfully created, several postinstallation tasks should
be completed. Identify three of them. (Choose three.)
A.Create the ASM instance.
B.Back up the root.sh script.
C.Initialize the cluster backup procedure.
D.Set up additional required user accounts.
E.Verify the Enterprise Manager/Oracle Cluster Registry configuration by running srvctl config database
-d db_name.
Correct:B D E

Oracle   1Z0-048   1Z0-048

NO.3 You decide to implement a Data Guard configuration to support a disaster recovery plan for
your RAC database. Your primary database has all shared files and the flash recovery area is
stored on ASM disk groups. Which three options exist for storing the data guard broker
configuration files at the primary location? (Choose three.)
A.can be in any shared ASM disk group
B.can be stored on shared Raw Devices
C.must be stored on Oracle Cluster File System if a cluster file system is used
D.may be stored on any supported cluster file system if a cluster file system is used
E.must be in the same shared ASM disk group as the database data files if the broker configuration files
are stored in ASM disk groups
F.must be in the same shared ASM disk group as the Flash Recovery Area if the broker configuration files
are stored in ASM disk groups.
Correct:A B D

Oracle   1Z0-048   1Z0-048

NO.4 Which three statements regarding backup of the voting disk are true? (Choose three.)
A.On UNIX platforms, the voting disk can be backed up with the dd command.
B.A backup of the voting disk should be taken whenever an RMAN catalog reset is done.
C.A backup of the voting disk should be taken whenever a new node is added to the cluster.
D.A backup of the voting disk should be taken whenever an existing node is removed from the cluster.
E.Whenever a voting disk backup is made, the Clusterware software should be stopped on all nodes in
the cluster.
Correct:A C D

Oracle   1Z0-048   1Z0-048

NO.5 After a power failure, you noticed that one of your cluster database instances did not start
automatically, whereas all other instances came up successfully. What would you do to determine
the precise cause for the instance startup failure? (Choose three.)
A.Check the resource state by using the CRS_STAT command.
B.Check for OCR corruptions by using the OCRCHECK command.
C.Check the alert.log file that belongs to the instance that did not start.
D.Check the alert.log file that belongs to the Oracle Clusterware software.
E.Check if the Oracle Clusterware is functional by using the CRSCTL command.
F.Reboot the node where the failing instance resides to check if the problem is persistent.
G.Enable extra debugging in the Oracle Clusterware software by using the CRSCTL command.
Correct:A C D

Oracle   1Z0-048   1Z0-048

NO.6 Oracle Cluster Registry (OCR) can be recovered on a UNIX platform using which two
commands? (Choose two.)
A.ocrconfig -import /u01/logical_ocr/yesterday.ocr where yesterday.ocr is an automatically generated
OCR backup
B.ocrconfig -import /u01/logical_ocr/yesterday.ocr_exp where yesterday.ocr_exp is a logical backup
created using the ocrconfig -export command
C.cp /app/oracle/product/10.1.0/crs_1/cdata/dbclust01/day.ocr /ocfs/OCR/crs.dbf where
/ocfs/OCR/crs.dbf is the cluster registry file
D.ocrconfig -restore /app/oracle/product/10.1.0/crs_1/cdata/dbclust01/day.ocr where day.ocr is an
automatically generated OCR backup
Correct:B D

Oracle   1Z0-048   1Z0-048

NO.7 Which three storage types are suitable as a flash recovery area for an Oracle 10g RAC database?
(Choose three.)
A.Raw volume
B.ASM disk group
C.Local file system
D.Cluster file system
E.Shared NFS directory
Correct:B D E

Oracle   1Z0-048   1Z0-048

NO.8 Your company has a combination of high availability and scalability requirements that need to
be addressed, and RAC has been discussed as a solution. There are a mix of "off-the-shelf"
software products and homegrown applications currently in use in your environment that run on
single-instance Oracle databases. You have been asked by the IT director to provide an impact
analysis report to help assess the impact on applications when migrating to RAC. Which three are
among the areas that should be examined for performance impact and application functionality
impact or for both? (Choose three.)
A.applications that use large parallel full table scans
B.applications that truncate tables in a data warehouse process
C.three-tier applications that use application global context variables
D.client/server type applications that use application local context variables
E.applications that access small tables using the same index occasionally
F.applications that use SQL profiles created by the ATO optimizer in the SQL Tuning Advisor
Correct:A B C

Oracle   1Z0-048   1Z0-048

NO.9 You are running a two-instance database with six redo log groups defined and decide to add a
third thread to support a third database instance on the third node of the cluster. Which three
commands would you issue to achieve this using command line administration? (Choose three.)
A.ALTER SYSTEM ENABLE THREAD 3;
B.ALTER DATABASE ENABLE THREAD 3;
C.ALTER SYSTEM ADD LOGFILE THREAD 3 GROUP 8;
D.ALTER SYSTEM ADD LOGFILE THREAD 3 GROUP 7;
E.ALTER DATABASE ADD LOGFILE THREAD 3 GROUP 7;
F.ALTER DATABASE ADD LOGFILE THREAD 3 GROUP 8;
Correct:B E F

Oracle   1Z0-048   1Z0-048

NO.10 Which optional parameter of the DESCRIPTION clause of a TNS entry can you use to randomize
the access to available listeners?
A.FAILOVER
B.LOAD_BALANCE
C.SOURCE_ROUTE
D.TYPE_OF_SERVICE
Correct:B

Oracle   1Z0-048   1Z0-048

NO.11 Which initialization parameter would you use for each RAC instance to make sure that each
listener on each RAC node is aware of the load of all the others?
A.LOCAL_LISTENER
B.REMOTE_LISTENER
C.REMOTE_DEPENDENCIES_MODE
D.PREFER_LEAST_LOADED_NODE_
Correct:B

Oracle   1Z0-048   1Z0-048

NO.12 You are working as a DBA in a RAC environment that is available for testing. The RAC
environment has all the database files stored in the OCFS file system. You plan to install ASM and
move all the database files to ASM to achieve better performance. During the installation, you
selected redundancy level as normal for the disk group being added. What is the reason for
selecting this redundancy level?
A.You want to use hardware mirroring.
B.You do not want to have any mirroring in the disk group.
C.You have two failure groups defined, so you want to use two-way mirroring.
D.You have three failure groups defined, so you want to use three-way mirroring.
Correct:C

Oracle   1Z0-048   1Z0-048

NO.13 In a RAC environment, you see a steep increase for enq:HW - contention and gc current grant
wait events. What would you do to fix this issue?
A.Increase the cache size of sequences.
B.Reduce the time of transactions by committing more often.
C.Use larger uniform extent sizes for objects.
D.Reduce the number of updates causing locks on tables accessed by multiple instances.
Correct:C

Oracle   1Z0-048   1Z0-048

NO.14 You have a well-tuned, non-RAC single instance Oracle database with several services, all of
which perform perfectly. You plan to migrate the database to RAC in the next two weeks and all file
systems would be shared using Oracle Cluster File System. After the migration, you want to
perform a test to monitor RAC-specific tuning issues that would not have occurred on a non-RAC
database. Which six areas would you monitor to determine whether there are RAC-specific
performance problems after migration? (Choose six.)
A.Interconnect latency
B.Instance recovery time
C.Services with applications that use external tables
D.Services with applications that truncate large tables
E.Services with applications using local context variables
F.Services with query-intensive applications relying on full table scans
G.Services with insert-intensive applications that use Oracle sequences for index keys
H.Services with applications that have occasional queries, using index access on modestly sized tables
I.Services with insert-intensive applications that generate their own keys without Oracle sequences
Correct:A B D F G I

Oracle   1Z0-048   1Z0-048

NO.15 You are about to build a new Oracle Clusterware-based cluster and you want to make the
installation process as smooth as possible. You decide to use the Cluster Verification Utility
(CLUVFY) to check whether or not your system administrator has set up the hardware and system
software correctly. Which two statements about CLUVFY are true? (Choose two.)
A.You can run CLUVFY only from a privileged operating system account.
B.You can run CLUVFY directly from the Oracle Clusterware distribution media.
C.CLUVFY cannot be used until the Oracle Clusterware is installed successfully.
D.After the Oracle Clusterware installation, you can run CLUVFY from the Oracle Home that holds the
CRS binaries.
E.You have to install CLUVFY on all cluster nodes in order to use CLUVFY on other nodes than the one
from which you perform the installation.
F.To use CLUVFY during the Oracle Clusterware installation, you have to download CLUVFY from the
Oracle Technology Network (OTN) Web site and install it before you can use it.
Correct:B D

Oracle   1Z0-048   1Z0-048

NO.16 View the Exhibit, which displays the cluster database performance page after the same
workload has been executed three times on your cluster without varying any non-Oracle
workloads on the cluster. What are the two ways by which you can tell that the corresponding
application was better tuned during the second and third execution? (Choose two.)
A.There is less paging each time.
B.The run queue length is going down each time.
C.It takes less time to execute the workload each time.
D.The number of transactions per second is getting higher each time.
E.The database throughput graphic is below the red dashed line during the last execution.
Correct:C D

Oracle   1Z0-048   1Z0-048

NO.17 You have attended a user group presentation on RAC and based on what you have learned you
feel that your company would benefit from having the RAC option to meet its Oracle database
requirements in several ways. Your manager does not know much about RAC and asks you to
create a presentation to the team explaining RAC, and whether it should be implemented in your
installation. Which three statements explain the benefits and implications of RAC? (Choose three.)
A.RAC alone would not help protect from human errors.
B.RAC would increase availability in the event of data failures.
C.RAC would increase availability in the event of a network failure.
D.RAC alone would increase availability when doing release upgrades.
E.RAC would increase scalability for all application workloads in all cases.
F.RAC would increase availability in the event of node and instance failures.
G.RAC used in conjunction with parallel execution may provide speedup of DSS queries.
H.RAC used in conjunction with parallel execution may provide for speedup of OLTP workload processes.
Correct:A F G

Oracle   1Z0-048   1Z0-048

NO.18 Several steps must be followed to successfully add a new node to your cluster database.
Assuming that a UNIX platform is used, which of the three steps below are correct? (Choose
three.)
A.Add instances using OUI.
B.Reconfigure listeners for the new node with netca.
C.Configure the OS and hardware for the new node.
D.Add the node to the cluster using the addnode.sh script run from ORA_CRS_HOME.
E.Add the RAC software to the new node using addnode.sh from ORA_CRS_HOME.
Correct:B C D

Oracle   1Z0-048   1Z0-048

NO.19 Which two initialization parameters must be set to start up an ASM instance in a RAC
environment? (Choose two.)
A.INSTANCE_TYPE
B.DB_UNIQUE_NAME
C.ASM_DISKSTRING
D.ASM_DISKGROUPS
E.ASM_POWER_LIMIT
F.CLUSTER_DATABASE
Correct:A F

Oracle   1Z0-048   1Z0-048

NO.20 Your company has certain standard practices for technology and you are configuring ASM disk
groups for your four-node RAC cluster. The company guidelines suggest that there is one disk
group for the flash recovery area that is shared by all databases and a separate disk group for the
database area of all databases. Which three exceptions exist that may require you to create
additional disk groups? (Choose three.)
A.The retention policy for backups are different for different databases.
B.There are large nonpartitioned tables accessed frequently using indexes.
C.The disk farm has different disk models with different characteristics and ages.
D.Some databases operate in ARCHIVELOGMODE and others in NOARCHIVELOGMODE.
E.Some database instances are shut down every night while others are always running.
F.Applications using the databases have different Service-Level Agreements for response time and
throughput.
G.There are partitioned tables where the older partitions are in read-only tablespaces and seldom
accessed, but the more recent partitions are frequently accessed.
Correct:C F G

Oracle   1Z0-048   1Z0-048

Vous allez choisir Pass4Test après essayer une partie de Q&A Oracle 1Z0-048 (gratuit à télécharger). Le guide d'étude produit par Pass4Test est une assurance 100% à vous aider à réussir le test Certification Oracle 1Z0-048.

1Z0-048 dernières questions d'examen certification Oracle et réponses publiés

Si vous hésitez encore à nous choisir, vous pouvez tout d'abord télécharger le démo gratuit dans le site Pass4Test pour connaître mieux la fiabilité de Pass4Test. Nous avons la confiance à vous promettre que vous allez passer le test Oracle 1Z0-048 à la première fois.

Participer au test Oracle 1Z0-048 est un bon choix, parce que dans l'Industire IT, beaucoup de gens tirent un point de vue que le Certificat Oracle 1Z0-048 symbole bien la professionnalité d'un travailleur dans cette industrie.

Vous aurez une assurance 100% à réussir le test Oracle 1Z0-048 si vous choisissez le produit de Pass4Test. Si malheuresement, vous ne passerez pas le test, votre argent seront tout rendu.

Aujourd'hui, c'est une société pleine de gens talentueux, la meilleure façon de suivre et assurer la place dans votre carrière est de s'améliorer sans arrêt. Si vous n'augmentez pas dans votre carrière, vous êtes juste sous-développé parce que les autres sont meilleurs que vous. Pour éviter ce cas, vous devez vous former successivement.

Maintenant, beaucoup de professionnels IT prennent un même point de vue que le test Oracle 1Z0-048 est le tremplin à surmonter la pointe de l'Industrie IT. Beaucoup de professionnels IT mettent les yeux au test Certification Oracle 1Z0-048.

Le produit de Pass4Test peut assurer les candidats à réussir le test Oracle 1Z0-048 à la première fois, mais aussi offrir la mise à jour gratuite pendant un an, les clients peuvent recevoir les ressources plus nouvelles. Pass4Test n'est pas seulement un site, mais aussi un bon centre de service.

Code d'Examen: 1Z0-048
Nom d'Examen: Oracle (Oracle Database 10g R2: Administering RAC)
Questions et réponses: 150 Q&As

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

NO.1 Which three storage types are suitable as a flash recovery area for an Oracle 10g RAC database?
(Choose three.)
A.Raw volume
B.ASM disk group
C.Local file system
D.Cluster file system
E.Shared NFS directory
Correct:B D E

Oracle examen   1Z0-048 examen   1Z0-048   1Z0-048 examen   certification 1Z0-048

NO.2 You have attended a user group presentation on RAC and based on what you have learned you
feel that your company would benefit from having the RAC option to meet its Oracle database
requirements in several ways. Your manager does not know much about RAC and asks you to
create a presentation to the team explaining RAC, and whether it should be implemented in your
installation. Which three statements explain the benefits and implications of RAC? (Choose three.)
A.RAC alone would not help protect from human errors.
B.RAC would increase availability in the event of data failures.
C.RAC would increase availability in the event of a network failure.
D.RAC alone would increase availability when doing release upgrades.
E.RAC would increase scalability for all application workloads in all cases.
F.RAC would increase availability in the event of node and instance failures.
G.RAC used in conjunction with parallel execution may provide speedup of DSS queries.
H.RAC used in conjunction with parallel execution may provide for speedup of OLTP workload processes.
Correct:A F G

Oracle examen   1Z0-048 examen   1Z0-048   1Z0-048 examen   certification 1Z0-048

NO.3 You are running a two-instance database with six redo log groups defined and decide to add a
third thread to support a third database instance on the third node of the cluster. Which three
commands would you issue to achieve this using command line administration? (Choose three.)
A.ALTER SYSTEM ENABLE THREAD 3;
B.ALTER DATABASE ENABLE THREAD 3;
C.ALTER SYSTEM ADD LOGFILE THREAD 3 GROUP 8;
D.ALTER SYSTEM ADD LOGFILE THREAD 3 GROUP 7;
E.ALTER DATABASE ADD LOGFILE THREAD 3 GROUP 7;
F.ALTER DATABASE ADD LOGFILE THREAD 3 GROUP 8;
Correct:B E F

Oracle examen   1Z0-048 examen   1Z0-048   1Z0-048 examen   certification 1Z0-048

NO.4 Your company has a combination of high availability and scalability requirements that need to
be addressed, and RAC has been discussed as a solution. There are a mix of "off-the-shelf"
software products and homegrown applications currently in use in your environment that run on
single-instance Oracle databases. You have been asked by the IT director to provide an impact
analysis report to help assess the impact on applications when migrating to RAC. Which three are
among the areas that should be examined for performance impact and application functionality
impact or for both? (Choose three.)
A.applications that use large parallel full table scans
B.applications that truncate tables in a data warehouse process
C.three-tier applications that use application global context variables
D.client/server type applications that use application local context variables
E.applications that access small tables using the same index occasionally
F.applications that use SQL profiles created by the ATO optimizer in the SQL Tuning Advisor
Correct:A B C

Oracle examen   1Z0-048 examen   1Z0-048   1Z0-048 examen   certification 1Z0-048

NO.5 After a power failure, you noticed that one of your cluster database instances did not start
automatically, whereas all other instances came up successfully. What would you do to determine
the precise cause for the instance startup failure? (Choose three.)
A.Check the resource state by using the CRS_STAT command.
B.Check for OCR corruptions by using the OCRCHECK command.
C.Check the alert.log file that belongs to the instance that did not start.
D.Check the alert.log file that belongs to the Oracle Clusterware software.
E.Check if the Oracle Clusterware is functional by using the CRSCTL command.
F.Reboot the node where the failing instance resides to check if the problem is persistent.
G.Enable extra debugging in the Oracle Clusterware software by using the CRSCTL command.
Correct:A C D

Oracle examen   1Z0-048 examen   1Z0-048   1Z0-048 examen   certification 1Z0-048

NO.6 You have a well-tuned, non-RAC single instance Oracle database with several services, all of
which perform perfectly. You plan to migrate the database to RAC in the next two weeks and all file
systems would be shared using Oracle Cluster File System. After the migration, you want to
perform a test to monitor RAC-specific tuning issues that would not have occurred on a non-RAC
database. Which six areas would you monitor to determine whether there are RAC-specific
performance problems after migration? (Choose six.)
A.Interconnect latency
B.Instance recovery time
C.Services with applications that use external tables
D.Services with applications that truncate large tables
E.Services with applications using local context variables
F.Services with query-intensive applications relying on full table scans
G.Services with insert-intensive applications that use Oracle sequences for index keys
H.Services with applications that have occasional queries, using index access on modestly sized tables
I.Services with insert-intensive applications that generate their own keys without Oracle sequences
Correct:A B D F G I

Oracle examen   1Z0-048 examen   1Z0-048   1Z0-048 examen   certification 1Z0-048

NO.7 After the cluster database has been successfully created, several postinstallation tasks should
be completed. Identify three of them. (Choose three.)
A.Create the ASM instance.
B.Back up the root.sh script.
C.Initialize the cluster backup procedure.
D.Set up additional required user accounts.
E.Verify the Enterprise Manager/Oracle Cluster Registry configuration by running srvctl config database
-d db_name.
Correct:B D E

Oracle examen   1Z0-048 examen   1Z0-048   1Z0-048 examen   certification 1Z0-048

NO.8 Your company has certain standard practices for technology and you are configuring ASM disk
groups for your four-node RAC cluster. The company guidelines suggest that there is one disk
group for the flash recovery area that is shared by all databases and a separate disk group for the
database area of all databases. Which three exceptions exist that may require you to create
additional disk groups? (Choose three.)
A.The retention policy for backups are different for different databases.
B.There are large nonpartitioned tables accessed frequently using indexes.
C.The disk farm has different disk models with different characteristics and ages.
D.Some databases operate in ARCHIVELOGMODE and others in NOARCHIVELOGMODE.
E.Some database instances are shut down every night while others are always running.
F.Applications using the databases have different Service-Level Agreements for response time and
throughput.
G.There are partitioned tables where the older partitions are in read-only tablespaces and seldom
accessed, but the more recent partitions are frequently accessed.
Correct:C F G

Oracle examen   1Z0-048 examen   1Z0-048   1Z0-048 examen   certification 1Z0-048

NO.9 You are working as a DBA in a RAC environment that is available for testing. The RAC
environment has all the database files stored in the OCFS file system. You plan to install ASM and
move all the database files to ASM to achieve better performance. During the installation, you
selected redundancy level as normal for the disk group being added. What is the reason for
selecting this redundancy level?
A.You want to use hardware mirroring.
B.You do not want to have any mirroring in the disk group.
C.You have two failure groups defined, so you want to use two-way mirroring.
D.You have three failure groups defined, so you want to use three-way mirroring.
Correct:C

Oracle examen   1Z0-048 examen   1Z0-048   1Z0-048 examen   certification 1Z0-048

NO.10 You are about to build a new Oracle Clusterware-based cluster and you want to make the
installation process as smooth as possible. You decide to use the Cluster Verification Utility
(CLUVFY) to check whether or not your system administrator has set up the hardware and system
software correctly. Which two statements about CLUVFY are true? (Choose two.)
A.You can run CLUVFY only from a privileged operating system account.
B.You can run CLUVFY directly from the Oracle Clusterware distribution media.
C.CLUVFY cannot be used until the Oracle Clusterware is installed successfully.
D.After the Oracle Clusterware installation, you can run CLUVFY from the Oracle Home that holds the
CRS binaries.
E.You have to install CLUVFY on all cluster nodes in order to use CLUVFY on other nodes than the one
from which you perform the installation.
F.To use CLUVFY during the Oracle Clusterware installation, you have to download CLUVFY from the
Oracle Technology Network (OTN) Web site and install it before you can use it.
Correct:B D

Oracle examen   1Z0-048 examen   1Z0-048   1Z0-048 examen   certification 1Z0-048

NO.11 Which optional parameter of the DESCRIPTION clause of a TNS entry can you use to randomize
the access to available listeners?
A.FAILOVER
B.LOAD_BALANCE
C.SOURCE_ROUTE
D.TYPE_OF_SERVICE
Correct:B

Oracle examen   1Z0-048 examen   1Z0-048   1Z0-048 examen   certification 1Z0-048

NO.12 Which two initialization parameters must be set to start up an ASM instance in a RAC
environment? (Choose two.)
A.INSTANCE_TYPE
B.DB_UNIQUE_NAME
C.ASM_DISKSTRING
D.ASM_DISKGROUPS
E.ASM_POWER_LIMIT
F.CLUSTER_DATABASE
Correct:A F

Oracle examen   1Z0-048 examen   1Z0-048   1Z0-048 examen   certification 1Z0-048

NO.13 Which initialization parameter would you use for each RAC instance to make sure that each
listener on each RAC node is aware of the load of all the others?
A.LOCAL_LISTENER
B.REMOTE_LISTENER
C.REMOTE_DEPENDENCIES_MODE
D.PREFER_LEAST_LOADED_NODE_
Correct:B

Oracle examen   1Z0-048 examen   1Z0-048   1Z0-048 examen   certification 1Z0-048

NO.14 View the Exhibit, which displays the cluster database performance page after the same
workload has been executed three times on your cluster without varying any non-Oracle
workloads on the cluster. What are the two ways by which you can tell that the corresponding
application was better tuned during the second and third execution? (Choose two.)
A.There is less paging each time.
B.The run queue length is going down each time.
C.It takes less time to execute the workload each time.
D.The number of transactions per second is getting higher each time.
E.The database throughput graphic is below the red dashed line during the last execution.
Correct:C D

Oracle examen   1Z0-048 examen   1Z0-048   1Z0-048 examen   certification 1Z0-048

NO.15 You decide to implement a Data Guard configuration to support a disaster recovery plan for
your RAC database. Your primary database has all shared files and the flash recovery area is
stored on ASM disk groups. Which three options exist for storing the data guard broker
configuration files at the primary location? (Choose three.)
A.can be in any shared ASM disk group
B.can be stored on shared Raw Devices
C.must be stored on Oracle Cluster File System if a cluster file system is used
D.may be stored on any supported cluster file system if a cluster file system is used
E.must be in the same shared ASM disk group as the database data files if the broker configuration files
are stored in ASM disk groups
F.must be in the same shared ASM disk group as the Flash Recovery Area if the broker configuration files
are stored in ASM disk groups.
Correct:A B D

Oracle examen   1Z0-048 examen   1Z0-048   1Z0-048 examen   certification 1Z0-048

NO.16 In a RAC environment, you see a steep increase for enq:HW - contention and gc current grant
wait events. What would you do to fix this issue?
A.Increase the cache size of sequences.
B.Reduce the time of transactions by committing more often.
C.Use larger uniform extent sizes for objects.
D.Reduce the number of updates causing locks on tables accessed by multiple instances.
Correct:C

Oracle examen   1Z0-048 examen   1Z0-048   1Z0-048 examen   certification 1Z0-048

NO.17 Oracle Cluster Registry (OCR) can be recovered on a UNIX platform using which two
commands? (Choose two.)
A.ocrconfig -import /u01/logical_ocr/yesterday.ocr where yesterday.ocr is an automatically generated
OCR backup
B.ocrconfig -import /u01/logical_ocr/yesterday.ocr_exp where yesterday.ocr_exp is a logical backup
created using the ocrconfig -export command
C.cp /app/oracle/product/10.1.0/crs_1/cdata/dbclust01/day.ocr /ocfs/OCR/crs.dbf where
/ocfs/OCR/crs.dbf is the cluster registry file
D.ocrconfig -restore /app/oracle/product/10.1.0/crs_1/cdata/dbclust01/day.ocr where day.ocr is an
automatically generated OCR backup
Correct:B D

Oracle examen   1Z0-048 examen   1Z0-048   1Z0-048 examen   certification 1Z0-048

NO.18 Several steps must be followed to successfully add a new node to your cluster database.
Assuming that a UNIX platform is used, which of the three steps below are correct? (Choose
three.)
A.Add instances using OUI.
B.Reconfigure listeners for the new node with netca.
C.Configure the OS and hardware for the new node.
D.Add the node to the cluster using the addnode.sh script run from ORA_CRS_HOME.
E.Add the RAC software to the new node using addnode.sh from ORA_CRS_HOME.
Correct:B C D

Oracle examen   1Z0-048 examen   1Z0-048   1Z0-048 examen   certification 1Z0-048

NO.19 After migrating from a 10g R1 cluster to 10g R2, you decide to multiplex your voting disk.
Which are the two ways in which you can accomplish this task? (Choose two.)
A.You should not use symbolic links.
B.You can add additional voting disks online.
C.You must add additional voting disks offline.
D.You may use the VIPCA utility to add new voting disks.
E.You may use the command: crsctl add css votedisk
Correct:B E

Oracle examen   1Z0-048 examen   1Z0-048   1Z0-048 examen   certification 1Z0-048

NO.20 Which three statements regarding backup of the voting disk are true? (Choose three.)
A.On UNIX platforms, the voting disk can be backed up with the dd command.
B.A backup of the voting disk should be taken whenever an RMAN catalog reset is done.
C.A backup of the voting disk should be taken whenever a new node is added to the cluster.
D.A backup of the voting disk should be taken whenever an existing node is removed from the cluster.
E.Whenever a voting disk backup is made, the Clusterware software should be stopped on all nodes in
the cluster.
Correct:A C D

Oracle examen   1Z0-048 examen   1Z0-048   1Z0-048 examen   certification 1Z0-048

Si vous choisissez notre l'outil formation, Pass4Test peut vous assurer le succès 100% du test Oracle 1Z0-048. Votre argent sera tout rendu si vous échouez le test.