Oracle 1Z1-050 1Z0-048 1Z0-045 1Z0-020 1Z0-147認定試験に関連する最高な過去問問題集

みなさんにJPexamを選ぶのはより安心させるためにJPexamは部分のOracle 1Z1-050 1Z0-048 1Z0-045 1Z0-020 1Z0-147試験材料がネットで提供して、君が無料でダウンロードすることができます。安心に弊社の商品を選ぶとともに貴重な時間とエネルギーを節約することができる。JPexamは真実のOracle 1Z1-050 1Z0-048 1Z0-045 1Z0-020 1Z0-147認証試験の問題集が100%で君の試験の合格を保証します。君の明るい将来を祈っています。

JPexamの1Z1-050 1Z0-048 1Z0-045 1Z0-020 1Z0-147問題集はあなたが信じられないほどの的中率を持っています。この問題集は実際試験に出る可能性があるすべての問題を含んでいます。したがって、この問題集をまじめに勉強する限り、試験に合格することが朝飯前のことになることができます。Oracle試験の重要なの一環として、1Z1-050 1Z0-048 1Z0-045 1Z0-020 1Z0-147認定試験はあなたに大きな恩恵を与えることができます。ですから、あなたを楽に試験に合格させる機会を逃してはいけません。JPexamは試験に失敗した場合は全額返金を約束しますから、1Z1-050 1Z0-048 1Z0-045 1Z0-020 1Z0-147試験に合格することができるように、はやくJPexamのウェブサイトに行ってもっと詳細な情報を読んでください。

Oracleの認定試験は最近ますます人気があるようになっています。IT認定試験は様々あります。どの試験を受験したことがありますか。たとえば1Z1-050 1Z0-048 1Z0-045 1Z0-020 1Z0-147認定試験などです。これらは全部大切な試験です。どちらを受験したいですか。ここで言いたいのは1Z1-050 1Z0-048 1Z0-045 1Z0-020 1Z0-147試験です。この試験を受けたいなら、JPexamの1Z1-050 1Z0-048 1Z0-045 1Z0-020 1Z0-147問題集はあなたが楽に試験に合格するのを助けられます。

試験番号：1Z1-050問題集
試験科目：Oracle Database 11g: New Features for Administrators
最近更新時間：2014-02-09
問題と解答：全183問
100％の返金保証。1年間の無料アップデート。

試験番号：1Z0-048問題集
試験科目：Oracle Database 10g R2: Administering RAC
最近更新時間：2014-02-09
問題と解答：全150問
100％の返金保証。1年間の無料アップデート。

試験番号：1Z0-045問題集
試験科目：Oracle database 10g:new features for Oracle8i ocps
最近更新時間：2014-02-09
問題と解答：全156問
100％の返金保証。1年間の無料アップデート。

試験番号：1Z0-020問題集
試験科目：Oracle8l:new features for administrators
最近更新時間：2014-02-09
問題と解答：全83問
100％の返金保証。1年間の無料アップデート。

試験番号：1Z0-147問題集
試験科目：Oracle9i program with pl/sql
最近更新時間：2014-02-09
問題と解答：全111問
100％の返金保証。1年間の無料アップデート。

Oracle 1Z1-050 1Z0-048 1Z0-045 1Z0-020 1Z0-147認証はIT業界にとても重要な地位があることがみんなが、たやすくその証本をとることはではありません。いまの市場にとてもよい問題集が探すことは難しいです。でも、JPexamにいつでも最新な問題を探すことができ、完璧な解説を楽に勉強することができます。

Oracleの1Z1-050 1Z0-048 1Z0-045 1Z0-020 1Z0-147認定試験がIT業界には極めて重要な地位があるがよく分かりましょう。試験に合格するのは簡単ではないもよくわかりましょう。“簡単に合格できる方法がありますか？”答えはもちろんですよ。JPexamはこの問題を着々解決できますよ。IT専門家がOracleの1Z1-050 1Z0-048 1Z0-045 1Z0-020 1Z0-147認定試験に関する特別な問題集を開発しています。それをもって、試験は問題になりませんよ。

購入前にお試し,私たちの試験の質問と回答のいずれかの無料サンプルをダウンロード：http://www.jpexam.com/1Z0-045_exam.html

NO.1 View the Exhibit. You want to unload data from the ORDERS, ORDER_ITEMS, and PRODUCTS
database tables to four OS flat files by using the External Table Population method. To achieve
this objective, you execute the command shown on the Exhibit. After successful execution of the
command, you find that only two files have been created and not four. Which option do you need
to change to achieve your objective?
A.TYPE
B.LOCATION
C.PARALLEL
D.DEFAULT DIRECTORY
E.ORGANIZATION EXTERNAL
Correct:C

Oracle認定証   1Z0-045問題集   1Z0-045

NO.2 You decide to activate the resumable space allocation feature for all your database users by
enabling the feature in a logon trigger. This causes a statement that requires space beyond a
user's quota _____.
A.to wait indefinitely for the quota to be increased, regardless of the timeout setting for other space
allocation problems.
B.to fail because quota limits do not activate the resumable space allocation feature
C.to wait in a suspended state until the quota is increased or until the timeout value is reached
D.to invoke the default trigger that resets user quota, if there is free space in the related tablespace
Correct:C

Oracle認定証   1Z0-045問題集   1Z0-045

NO.3 You define the Warning threshold for the tablespace usage metric for the USERS tablespace to
be 35%. Because of this, several alerts are being raised. After observing this, you decide to
increase the Warning threshold and clear all old alerts related to tablespace usage metric. Where
would you find the information about cleared alerts?
A.the alert.log file
B.the DBA_ALERT_HISTORY data dictionary table
C.the DBA_ALERT_ARGUMENTS data dictionary table
D.the DBA_TAB_STATS_HISTORY data dictionary table
E.the DBA_OUTSTANDING_ALERTS data dictionary table
F.the V$ACTIVE_SESSION_HISTORY data dictionary table
Correct:B

Oracle認定証   1Z0-045問題集   1Z0-045

NO.4 Which three file types are managed by Data Pump jobs? (Choose three.)
A.out files
B.log files
C.alert files
D.SQL files
E.error files
F.dump files
Correct:B D F

Oracle認定証   1Z0-045問題集   1Z0-045

NO.5 Which three files can be managed using an ASM Instance? (Choose three.)
A.Data files
B.Audit files
C.Trace files
D.Export files
E.Alert log files
F.Archived log files
G.Change tracking files
Correct:A F G

Oracle認定証   1Z0-045問題集   1Z0-045

NO.6 Identify four uses of the Oracle Scheduler. (Choose four.)
A.Enables you to set idle time limits for a resource plan.
B.Enables you to schedule job execution based on time.
C.Enables you to execute jobs in a clustered environment.
D.Enables you to assign priorities to the consumer groups.
E.Enables you to map a consumer group to an Oracle user.
F.Enables you to create a job that makes use of saved programs and schedules.
G.Enables you to periodically execute operating system script files located on the same server as the
database.
Correct:B C F G

Oracle認定証   1Z0-045問題集   1Z0-045

NO.7 While observing database statistics, you find that the Automatic Workload Repository (AWR)
snapshots are being purged after each day. You want the snapshots to be purged on a weekly
basis. Which two options would you use to increase the purge interval? (Choose two.)
A.Enterprise Manager
B.DBMS_JOB.INTERVAL
C.DBMS_SCHEDULER.CHANGE
D.DBMS_SCHEDULER.INTERVAL
E.DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS
Correct:A E

Oracle認定証   1Z0-045問題集   1Z0-045

NO.8 You need to ensure that the database users should be able to use the various flashback query
features in order to go back in time by four hours. What would you do to achieve this? (Choose
two.)
A.set SQL_TRACE=True
B.set UNDO_RETENTION=14400
C.set FAST_START_MTTR_TARGET=240
D.set LOG_CHECKPOINT_INTERVAL=240
E.set DB_FLASHBACK_RETENTION_TARGET=14400
F.issue ALTER DATABASE FLASHBACK ON; command
G.set the RETENTION GUARANTEE clause for the undo tablespace
Correct:B G

Oracle認定証   1Z0-045問題集   1Z0-045

NO.9 You performed an incomplete recovery and opened the database with the RESETLOGS option.
The LOG_ARCHIVE_FORMAT parameter is set to 'ora_%t_%s_%r.log'. Which statement regarding
the archived redo log files, created in an earlier incarnation of the database, is true?
A.The archived redo log files cannot be used.
B.The archived redo log files will be overwritten.
C.The archived redo log files are deleted automatically.
D.The archived redo log files should be moved to some other location.
E.The archived redo log files are still maintained because the file names are unique.
Correct:E

Oracle認定証   1Z0-045問題集   1Z0-045

NO.10 You have three temporary tablespace groups named G1, G2, and G3 in your database. You are
creating a new temporary tablespace as follows: CREATE TEMPORARY TABLESPACE TEMP1
TEMPFILE '/u1/data/temp1.dbf' SIZE 10M TABLESPACE GROUP ''; Which statement regarding the
above command is correct?
A.It will create the tablespace TEMP1 in group G1.
B.It will create the tablespace TEMP1 in group G3.
C.It will not add the tablespace TEMP1 to any group.
D.It will create the tablespace TEMP1 in the default group.
E.It will throw an error with message 'specified group is not available'.
F.It will create a new group with a system-generated name and add the tablespace TEMP1 to it.
Correct:C

Oracle認定証   1Z0-045問題集   1Z0-045

NO.11 Examine the statement: SQL> CREATE TABLESPACE user_data 2> EXTENT MANAGEMENT
LOCAL 3> SEGMENT SPACE MANAGEMENT AUTO; Which two assumptions must be true for this
statement to execute successfully? (Choose two.)
A.Oracle Managed Files are used for this instance.
B.The USER_DATA tablespace is managed using FET$/UET$ tables.
C.The database will manage the free space of segments in the tablespace using a bitmap.
D.Space within segments in the USER_DATA tablespace is managed with freelists.
Correct:A C

Oracle認定証   1Z0-045問題集   1Z0-045

NO.12 You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM
instance. At the end of the day, you execute the following command on the ASM instance to shut
down: SQL> shutdown immediate; What is the result of executing this command?
A.All the instances, including the ASM instance, are shut down in the ABORT mode.
B.The ASM instance is shut down, but the other instances are still running.
C.The ASM instance is still functional, but the other instances are shut down.
D.All the instances, including the ASM instance, are shut down in the IMMEDIATE mode.
E.HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is
shut down in the IMMEDIATE mode.
F.HRDB, FINDB, and ORGDB instances are shut down in the NORMAL mode and the ASM instance is
shut down in the IMMEDIATE mode.
Correct:D

Oracle認定証   1Z0-045問題集   1Z0-045

NO.13 Which statements are true regarding the new Persistent Configuration feature in RMAN?
(Choose two.)
A.It allows you to set the retention period of backups.
B.It remembers the last backup command you used so that you can reschedule it easily.
C.It enables you to store your Channel attribute settings in the Recovery Catalog with each script.
D.It enables you to store the settings for Channel attributes so that you do not have to specify them in
each backup or restore command.
Correct:A D

Oracle認定証   1Z0-045問題集   1Z0-045

NO.14 Which two statements regarding unusable indexes are correct? (Choose two.)
A.You can set SKIP_UNUSABLE_INDEXES to true to skip unusable indexes.
B.You can check the alert log file to get a message recorded about unusable indexes.
C.You do not need to set any parameter because unusable indexes are skipped automatically.
D.Your Data Definition Language (DDL) statement shows a warning message when an index is made
unusable.
Correct:A B

Oracle認定証   1Z0-045問題集   1Z0-045

NO.15 When WORKAREA_SIZE_POLICY is set to AUTO, the work areas are sized to accomplish which
two goals? (Choose two).
A.To tune memory using the existing *_AREA_SIZE parameters.
B.To allocate memory to work areas in order to optimize throughput only.
C.To allocate memory to work areas in order to optimize response time only.
D.To allocate memory to work areas in order to optimize both throughput and response time.
E.To ensure that the overall size of the PGA will never exceed the value of PGA_AGGREGATE_TARGET.
Correct:D E

Oracle認定証   1Z0-045問題集   1Z0-045

NO.16 You want to retain the job entries for the last five days and purge all job entries from the job log
that are older than five days. Select the command that will enable you to do the job.
A.EXECUTE DBMS_SCHEDULER.PURGE_LOG( log_history => 5, which_log =>'JOB_LOG');
B.EXECUTE DBMS_SCHEDULER.PURGE_LOG();
C.EXECUTE DBMS_SCHEDULER.PURGE_LOG( log_history => 5, job_name => 'JOB_LOG');
D.EXECUTE DBMS_SCHEDULER.PURGE_LOG( log_history => 5, which_log => 'WINDOW_LOG');
Correct:A

Oracle認定証   1Z0-045問題集   1Z0-045

NO.17 Examine this startup script called startmydb.sql: CONNECT myid/mypwd AS SYSDBA STARTUP
EXIT In Oracle8i, you could have executed this script by invoking Server Manager with the
command: svrmgrl @startmydb.sql Which alternative command could you use to run the
startmydb.sql script with SQL*Plus to start your Oracle 10g database?
A.sqlplus @startmydb.sql
B.sqlplus -Sstartmydb.sql
C.sqlplus -S @startmydb.sql
D.sqlplus /NOLOG @startmydb.sql
Correct:D

Oracle認定証   1Z0-045問題集   1Z0-045

NO.18 Which process performs the rebalance data extent movements across ASM disk groups in
ASM?
A.Checkpoint (CKPT)
B.System Monitor (SMON)
C.ASM Rebalance (ARBn)
D.Process Monitor (PMON)
E.ASM Background (ASMB)
F.ASM Rebalance Master (RBAL)
Correct:C

Oracle認定証   1Z0-045問題集   1Z0-045

NO.19 Examine the following commands of Data Pump to import objects to new non-existent users
hr1 and oe1. $ expdp system/manager schemas = hr,oe directory = EXP_DIR dumpfile = export.dat
include = table $ impdp system/manager schemas = hr1,oe1 directory = EXP_DIR dumpfile =
export.dat remap_schema = hr:hr1, oe:oe1 Which objective would be achieved by the above
command sets?
A.expdp will fail because no path has been defined for the dumpfile.
B.expdp will succeed but Impdp will fail because users do not exist.
C.impdp would create two schemas called hr1 and oe1 and copy the schema objects to the new users.
D.impdp would create two schemas called hr1 and oe1 and import tables owned by hr and oe schemas to
hr1 and oe1 schemas, respectively.
Correct:B

Oracle認定証   1Z0-045問題集   1Z0-045

NO.20 You need to create a schedule that will run a job on the second Friday of each month. What
should the repeat interval of the schedule be set to?
A.FREQ = MONTHLY; BYDAY = 2FRI;
B.FREQ = MONTHLY; BYDAY = FRI2;
C.FREQ = MONTHLY; BYDAY = -2FRI;
D.FREQ = MONTHLY; BYDAY = FRI(2);
Correct:A

Oracle認定証   1Z0-045問題集   1Z0-045

Oracle certification 1Z1-403 1Z1-050 1Z0-048 1Z0-045 1Z0-020 the latest exam questions and answers

To choose our IT-Tests.com to is to choose success! IT-Tests.com provide you Oracle certification 1Z1-403 1Z1-050 1Z0-048 1Z0-045 1Z0-020 exam practice questions and answers, which enable you to pass the exam successfully. Simulation tests before the formal Oracle certification 1Z1-403 1Z1-050 1Z0-048 1Z0-045 1Z0-020 examination are necessary, and also very effective. If you choose IT-Tests, you can 100% pass the exam.

IT-Tests.com is a website that specializes in providing IT exam information. The pass rate can achieve 100%. Which is one of the reasons that most candidates willing to believe the IT-Tests.com. IT-Tests.com have been always concerned about the needs of the majority of candidates. We always with the greatest ability to meet the needs of the candidates . IT-Tests.com's Oracle 1Z1-403 1Z1-050 1Z0-048 1Z0-045 1Z0-020 exam training materials is an unprecedented IT certification training materials. With it, your future career will be rain or shine.

IT-Tests.com Oracle 1Z1-403 1Z1-050 1Z0-048 1Z0-045 1Z0-020 exam information are cheap and fine. We use simulation questions and answers dedication to our candidates with ultra-low price and high quality . We sincerely hope that you can pass the exam. We provide you with a convenient online service to resolve any questions about Oracle 1Z1-403 1Z1-050 1Z0-048 1Z0-045 1Z0-020 exam questions for you.

IT-Tests.com has a huge team of IT experts, who continue to use their knowledge and experience to study a lot of IT certification examination papers of past few years. Their findings of the research is now the product of IT-Tests, therefore IT-Tests's Oracle 1Z1-403 1Z1-050 1Z0-048 1Z0-045 1Z0-020 practice questions are very similar with the real exam, which can help a lot of people to realize their dreams. IT-Tests.com can ensure you to successfully pass the exam, and you can boldly Add IT-Tests's products to your shopping cart. With IT-Tests.com your dreams can be achieved immediately.

Exam Code: 1Z1-403

Exam Name: Oracle (Enterprise Linux System Administration)

Exam Code: 1Z1-050

Exam Name: Oracle (Oracle Database 11g: New Features for Administrators)

Exam Code: 1Z0-048

Exam Name: Oracle (Oracle Database 10g R2: Administering RAC)

Exam Code: 1Z0-045

Exam Name: Oracle (Oracle database 10g:new features for Oracle8i ocps)

Exam Code: 1Z0-020

Exam Name: Oracle (Oracle8l:new features for administrators)

1Z1-050 (Oracle Database 11g: New Features for Administrators) Free Demo Download: http://www.it-tests.com/1Z1-050.html

NO.1 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 test   1Z1-050 exam prep   1Z1-050   1Z1-050 exam simulations

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

Oracle   1Z1-050   1Z1-050 test questions   1Z1-050 exam dumps

NO.3 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 exam   1Z1-050   1Z1-050   1Z1-050 demo

NO.4 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 test answers   1Z1-050 test answers   1Z1-050   1Z1-050   1Z1-050

NO.5 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 demo   1Z1-050 dumps   1Z1-050   1Z1-050

NO.6 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 pdf   1Z1-050 answers real questions   1Z1-050

NO.7 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   1Z1-050 pdf   1Z1-050   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

Oracle   1Z1-050 pdf   1Z1-050 certification training   1Z1-050   1Z1-050 exam prep

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

Oracle   1Z1-050   1Z1-050 test answers   1Z1-050 exam   1Z1-050 demo

NO.10 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   1Z1-050   1Z1-050

NO.11 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   1Z1-050   1Z1-050 exam dumps

NO.12 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 exam simulations   1Z1-050   1Z1-050

NO.13 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 test questions   1Z1-050 pdf   1Z1-050 exam prep   1Z1-050 exam prep   1Z1-050   1Z1-050 braindump

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

Oracle   1Z1-050 braindump   1Z1-050

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

Oracle   1Z1-050 exam simulations   1Z1-050

NO.16 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 study guide   1Z1-050   1Z1-050 certification training   1Z1-050 exam   1Z1-050 dumps

NO.17 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 practice test   1Z1-050 pdf   1Z1-050 exam

NO.18 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 demo   1Z1-050   1Z1-050   1Z1-050 exam dumps   1Z1-050

NO.19 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 exam dumps   1Z1-050   1Z1-050 study guide

NO.20 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   1Z1-050 certification training   1Z1-050   1Z1-050 certification

IT-Tests.com provides to Oracle 1Z0-048 test materials

Life is full of choices. Selection does not necessarily bring you happiness, but to give you absolute opportunity. Once missed selection can only regret. IT-Tests.com's Oracle 1Z0-048 exam training materials are necessary to every IT person. With this materials, all of the problems about the Oracle 1Z0-048 will be solved. IT-Tests.com's Oracle 1Z0-048 exam training materials have wide coverage, and update speed. This is the most comprehensive training materials. With it, all the IT certifications need not fear, because you will pass the exam.

If you choose IT-Tests, success is not far away for you. And soon you can get Oracle certification 1Z0-048 exam certificate. The product of IT-Tests.com not only can 100% guarantee you to pass the exam, but also can provide you a free one-year update service.

Exam Code: 1Z0-048

Exam Name: Oracle (Oracle Database 10g R2: Administering RAC)

IT-Tests.com is a professional website to specially provide training tools for IT certification exams and a good choice to help you pass 1Z0-048 exam,too. IT-Tests.com provide exam materials about 1Z0-048 certification exam for you to consolidate learning opportunities. IT-Tests.com will provide all the latest and accurate exam practice questions and answers for the staff to participate in 1Z0-048 certification exam.

It's better to hand-lit own light than look up to someone else's glory. IT-Tests.com Oracle 1Z0-048 exam training materials will be the first step of your achievements. With it, you will be pass the Oracle 1Z0-048 exam certification which is considered difficult by a lot of people. With this certification, you can light up your heart light in your life. Start your new journey, and have a successful life.

If you want to buy Oracle 1Z0-048 exam information, IT-Tests.com will provide the best service and the best quality products. Our exam questions have been authorized by the manufacturers and third-party. And has a large number of IT industry professionals and technology experts, based on customer demand, according to the the outline developed a range of products to meet customer needs. Oracle 1Z0-048 exam certification with the highest standards of professional and technical information, as the knowledge of experts and scholars to study and research purposes. All of the products we provide have a part of the free trial before you buy to ensure that you fit with this set of data.

Our IT-Tests.com have a huge IT elite team. They will accurately and quickly provide you with Oracle certification 1Z0-048 exam materials and timely update Oracle 1Z0-048 exam certification exam practice questions and answers and binding. Besides, IT-Tests.com also got a high reputation in many certification industry. The the probability of passing Oracle certification 1Z0-048 exam is very small, but the reliability of IT-Tests.com can guarantee you to pass the examination of this probability.

IT-Tests.com Oracle 1Z0-048 exam information is proven. We can provide the questions based on extensive research and experience. IT-Tests.com has more than 10 years experience in IT certification 1Z0-048 exam training, including questions and answers. On the Internet, you can find a variety of training tools. IT-Tests.com 1Z0-048 exam questions and answers is the best training materials. We offer the most comprehensive verification questions and answers, you can also get a year of free updates.

1Z0-048 (Oracle Database 10g R2: Administering RAC) Free Demo Download: http://www.it-tests.com/1Z0-048.html

NO.1 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 answers real questions   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 answers real questions   1Z0-048   1Z0-048

NO.3 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 answers real questions   1Z0-048   1Z0-048

NO.4 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 answers real questions   1Z0-048   1Z0-048

NO.5 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 answers real questions   1Z0-048   1Z0-048

NO.6 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 answers real questions   1Z0-048   1Z0-048

NO.7 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 answers real questions   1Z0-048   1Z0-048

NO.8 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 answers real questions   1Z0-048   1Z0-048

NO.9 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 answers real questions   1Z0-048   1Z0-048

NO.10 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 answers real questions   1Z0-048   1Z0-048

NO.11 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 answers real questions   1Z0-048   1Z0-048

NO.12 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 answers real questions   1Z0-048   1Z0-048

NO.13 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 answers real questions   1Z0-048   1Z0-048

NO.14 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 answers real questions   1Z0-048   1Z0-048

NO.15 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 answers real questions   1Z0-048   1Z0-048

NO.16 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 answers real questions   1Z0-048   1Z0-048

NO.17 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 answers real questions   1Z0-048   1Z0-048

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

Oracle   1Z0-048 answers real questions   1Z0-048   1Z0-048

NO.19 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 answers real questions   1Z0-048   1Z0-048

NO.20 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 answers real questions   1Z0-048   1Z0-048

IT-Tests.com promise that we will spare no effort to help you pass Oracle certification 1Z0-048 exam. Now you can free download part of practice questions and answers of Oracle certification 1Z0-048 exam on IT-Tests. When you select IT-Tests, you can not only pass Oracle certification 1Z0-048 exam, but also have one year free update service. IT-Tests.com can also promise if you fail to pass the exam, IT-Tests.com will 100% refund.

Latest training guide for Oracle 1Z0-048

Oracle 1Z0-048 certification exam is very important for every IT person. With this certification you will not be eliminated, and you will be a raise. Some people say that to pass the Oracle 1Z0-048 exam certification is tantamount to success. Yes, this is true. You get what you want is one of the manifestations of success. IT-Tests.com of Oracle 1Z0-048 exam materials is the source of your success. With this training materials, you will speed up the pace of success, and you will be more confident.

IT-Tests.com is a website which is able to speed up your passing the Oracle certification 1Z0-048 exams. Our Oracle certification 1Z0-048 exam question bank is produced by IT-Tests's experts's continuously research of outline and previous exam. When you are still struggling to prepare for passing the Oracle certification 1Z0-048 exams, please choose IT-Tests's latest Oracle certification 1Z0-048 exam question bank, and it will brings you a lot of help.

IT-Tests.com is the only one able to provide you the best and fastest updating information about Oracle certification 1Z0-048 exam. Other websites may also provide information about Oracle certification 1Z0-048 exam, but if you compare with each other, you will find that IT-Tests.com provide the most comprehensive and highest quality information. And most of the information of other websites comes mainly from IT-Tests.

If you are sure that you want to pass Oracle certification 1Z0-048 exam, then your selecting to purchase the training materials of IT-Tests.com is very cost-effective. Because this is a small investment in exchange for a great harvest. Using IT-Tests's test questions and exercises can ensure you pass Oracle certification 1Z0-048 exam. IT-Tests.com is a website which have very high reputation and specifically provide simulation questions, practice questions and answers for IT professionals to participate in the Oracle certification 1Z0-048 exam.

Exam Code: 1Z0-048
Exam Name: Oracle (Oracle Database 10g R2: Administering RAC)

In the recent few years, Oracle 1Z0-048 exam certification have caused great impact to many people. But the key question for the future is that how to pass the Oracle 1Z0-048 exam more effectively. The answer of this question is to use IT-Tests.com's Oracle 1Z0-048 exam training materials, and with it you can pass your exams. So what are you waiting for? Go to buy IT-Tests.com's Oracle 1Z0-048 exam training materials please, and with it you can get more things what you want.

If you have IT-Tests.com's Oracle 1Z0-048 exam training materials, we will provide you with one-year free update. This means that you can always get the latest exam information. As long as the Exam Objectives have changed, or our learning material changes, we will update for you in the first time. We know your needs, and we will help you gain confidence to pass the Oracle 1Z0-048 exam. You can be confident to take the exam and pass the exam.

1Z0-048 (Oracle Database 10g R2: Administering RAC) Free Demo Download: http://www.it-tests.com/1Z0-048.html

NO.1 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 test   1Z0-048 exam   1Z0-048 certification   1Z0-048 certification training

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 test   1Z0-048 exam   1Z0-048 certification   1Z0-048 certification training

NO.3 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 test   1Z0-048 exam   1Z0-048 certification   1Z0-048 certification training

NO.4 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 test   1Z0-048 exam   1Z0-048 certification   1Z0-048 certification training

NO.5 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 test   1Z0-048 exam   1Z0-048 certification   1Z0-048 certification training

NO.6 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 test   1Z0-048 exam   1Z0-048 certification   1Z0-048 certification training

NO.7 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 test   1Z0-048 exam   1Z0-048 certification   1Z0-048 certification training

NO.8 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 test   1Z0-048 exam   1Z0-048 certification   1Z0-048 certification training

NO.9 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 test   1Z0-048 exam   1Z0-048 certification   1Z0-048 certification training

NO.10 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 test   1Z0-048 exam   1Z0-048 certification   1Z0-048 certification training

NO.11 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 test   1Z0-048 exam   1Z0-048 certification   1Z0-048 certification training

NO.12 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 test   1Z0-048 exam   1Z0-048 certification   1Z0-048 certification training

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

Oracle test   1Z0-048 exam   1Z0-048 certification   1Z0-048 certification training

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 test   1Z0-048 exam   1Z0-048 certification   1Z0-048 certification training

NO.15 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 test   1Z0-048 exam   1Z0-048 certification   1Z0-048 certification training

NO.16 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 test   1Z0-048 exam   1Z0-048 certification   1Z0-048 certification training

NO.17 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 test   1Z0-048 exam   1Z0-048 certification   1Z0-048 certification training

NO.18 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 test   1Z0-048 exam   1Z0-048 certification   1Z0-048 certification training

NO.19 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 test   1Z0-048 exam   1Z0-048 certification   1Z0-048 certification training

NO.20 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 test   1Z0-048 exam   1Z0-048 certification   1Z0-048 certification training

Our IT-Tests.com have a huge IT elite team. They will accurately and quickly provide you with Oracle certification 1Z0-048 exam materials and timely update Oracle 1Z0-048 exam certification exam practice questions and answers and binding. Besides, IT-Tests.com also got a high reputation in many certification industry. The the probability of passing Oracle certification 1Z0-048 exam is very small, but the reliability of IT-Tests.com can guarantee you to pass the examination of this probability.