Pass4Test offre de RedHat RH-202 matériaux d'essai

Il y a nombreux façons à vous aider à réussir le test RedHat RH-202. Le bon choix est l'assurance du succès. Pass4Test peut vous offrir le bon outil de formation, lequel est une documentation de qualité. La Q&A de test RedHat RH-202 est recherchée par les experts selon le résumé du test réel. Donc l'outil de formation est de qualité et aussi autorisé, votre succès du test RedHat RH-202 peut bien assuré. Nous allons mettre le jour successivement juste pour répondre les demandes de tous candidats.

Si vous travaillez quand même très dur et dépensez beaucoup de temps pour préparer le test RedHat RH-202, mais ne se savez pas du tout c'est où le raccourci pour passer le test certification, Pass4Test peut vous donner une solution efficace. Vous vous sentirez magiquement jouer un effet multiplicateur.

Code d'Examen: RH-202
Nom d'Examen: RedHat (Redhat Certified Technician on Redhat Enterprise Linux 5 (Labs))
Questions et réponses: 171 Q&As

Choisissez le Pass4Test, choisissez le succès. Le produit offert par Pass4Test vous permet à réussir le test RedHat RH-202. C'est necessaire de prendre un test simulation avant participer le test réel. C'est une façon bien effective. Choisir Pass4Test vous permet à réussir 100% le test.

Beaucoup de travailleurs dans l'Industrie IT peut obenir un meilleur travail et améliorer son niveau de vie à travers le Certificat RedHat RH-202. Mais la majorité des candidats dépensent beaucoup de temps et d'argent pour préparer le test, ça ne coûte pas dans cette société que le temps est tellement précieux. Pass4Test peut vous aider à économiser le temps et l'effort pendant le cours de la préparation du test RedHat RH-202. Choisir le produit de Pass4Test particulier pour le test Certification RedHat RH-202 vous permet à réussir 100% le test. Votre argent sera tout rendu si malheureusement vous ne passez pas le test.

RH-202 Démo gratuit à télécharger: http://www.pass4test.fr/RH-202.html

NO.1 vi /etc/fstab /dev/hda? swap swap defaults 0 0

RedHat   RH-202   RH-202 examen   RH-202   RH-202 examen   RH-202 examen

NO.2 edquota -u user1 /data and Specified the Soft limit and hard limit on opened file.
To verify either quota is working or not:
Soft limit specify the limit to generate warnings to users and hard limit can't cross by the user. Use the
quota command or repquota command to monitor the quota information.
3. One Logical Volume named lv1 is created under vg0. The Initial Size of that Logical Volume is 100MB.
Now you required the size 500MB. Make successfully the size of that Logical Volume 500M without losing
any data. As well as size should be increased online.
Answer and Explanation:
The LVM system organizes hard disks into Logical Volume (LV) groups. Essentially, physical hard disk
partitions (or possibly RAID arrays) are set up in a bunch of equalsized chunks known as Physical Extents
(PE). As there are several other concepts associated with the LVM system, let's start with some basic
definitions:
Physical Volume (PV) is the standard partition that you add to the LVM mix. Normally, a physical volume
is a standard primary or logical partition. It can also be a RAID array.
Physical Extent (PE) is a chunk of disk space. Every PV is divided into a number of equal sized PEs.
Every PE in a LV group is the same size. Different LV groups can have different sized PEs.
Logical Extent (LE) is also a chunk of disk space. Every LE is mapped to a specific PE.
Logical Volume (LV) is composed of a group of LEs. You can mount a filesystem such as /home and /var
on an LV.
Volume Group (VG) is composed of a group of LVs. It is the organizational group for LVM. Most of the
commands that you'll use apply to a specific VG.
1. Verify the size of Logical Volume: lvdisplay /dev/vg0/lv1
2. Verify the Size on mounted directory: df -h or df -h mounted directory name
3. Use : lvextend -L+400M /dev/vg0/lv1
4. ext2online -d /dev/vg0/lv1 to bring extended size online.
5. Again Verify using lvdisplay and df -h command.
4. Create one partitions having size 100MB and mount it on /data.
Answer and Explanation:
1. Use fdisk /dev/hda To create new partition.
2. Type n For New partitions
3. It will ask for Logical or Primary Partitions. Press l for logical.
4. It will ask for the Starting Cylinder: Use the Default by pressing Enter Key.
5. Type the Size: +100M You can Specify either Last cylinder of Size here.
6. Press P to verify the partitions lists and remember the partitions name.

RedHat   RH-202   RH-202 examen   RH-202   RH-202 examen   RH-202 examen

NO.3 Reboot the System and verify that swap is automatically enabled or not.
10. You are a System administrator. Using Log files very easy to monitor the system. Now there are 50
servers running as Mail, Web, Proxy, DNS services etc. You want to centralize the logs from all servers
into on LOG Server. How will you configure the LOG Server to accept logs from remote host ?
Answer and Explanation:
By Default system accept the logs only generated from local host. To accept the Log
from other host configure:
1. vi /etc/sysconfig/syslog SYSLOGD_OPTIONS="-m 0 -r"
Where
-m 0 disables 'MARK' messages.
-r enables logging from remote machines
-x disables DNS lookups on messages recieved with -r
2. service syslog restart

RedHat   RH-202   RH-202 examen   RH-202   RH-202 examen   RH-202 examen

NO.4 Either Reboot or use partprobe command.

RedHat   RH-202   RH-202 examen   RH-202   RH-202 examen   RH-202 examen

NO.5 Quota is implemented on /data but not working properly. Find out the Problem and implement the quota
to user1 to have a soft limit 60 inodes (files) and hard limit of 70 inodes (files).
Answer and Explanation:
Quotas are used to limit a user's or a group of users' ability to consume disk space. This prevents a small
group of users from monopolizing disk capacity and potentially interfering with other users or the entire
system. Disk quotas are commonly used by ISPs, by Web hosting companies, on FTP sites, and on
corporate file servers to ensure continued availability of their systems.
Without quotas, one or more users can upload files on an FTP server to the point of filling a filesystem.
Once the affected partition is full, other users are effectively denied upload access to the disk. This is also
a reason to mount different filesystem directories on different partitions. For example, if you only had
partitions for your root (/) directory and swap space, someone uploading to your computer could fill up all
of the space in your root directory (/). Without at least a little free space in the root directory (/), your
system could become unstable or even crash.
You have two ways to set quotas for users. You can limit users by inodes or by kilobytesized disk blocks.
Every Linux file requires an inode. Therefore, you can limit users by the number of files or by absolute
space. You can set up different quotas for different filesystems. For example, you can set different quotas
for users on the /home and /tmp directories if they are mounted on their own partitions.
Limits on disk blocks restrict the amount of disk space available to a user on your system.
Older versions of Red Hat Linux included LinuxConf, which included a graphical tool to configure quotas.
As of this writing, Red Hat no longer has a graphical quota configuration tool. Today, you can configure
quotas on RHEL only through the command line interface.
1. vi /etc/fstab /dev/hda11 /data ext3 defaults,usrquota 1 2
2. Either Reboot the System or remount the partition.
Mount -o remount /dev/hda11 /data

RedHat   RH-202   RH-202 examen   RH-202   RH-202 examen   RH-202 examen

NO.6 mkswap /dev/hda? To create Swap File system on partition.

RedHat   RH-202   RH-202 examen   RH-202   RH-202 examen   RH-202 examen

NO.7 Press w to write on partitions table.

RedHat   RH-202   RH-202 examen   RH-202   RH-202 examen   RH-202 examen

NO.8 vi /etc/fstab
Write:
/dev/hda? /data ext3 defaults 1 2

RedHat   RH-202   RH-202 examen   RH-202   RH-202 examen   RH-202 examen

NO.9 quotaon -u /data

RedHat   RH-202   RH-202 examen   RH-202   RH-202 examen   RH-202 examen

NO.10 swapon /dev/hda? To enable the Swap space from partition.

RedHat   RH-202   RH-202 examen   RH-202   RH-202 examen   RH-202 examen

NO.11 Verify by mounting on current Sessions also:
mount /dev/hda? /data
5. You are new System Administrator and from now you are going to handle the system and your main
task is Network monitoring, Backup and Restore. But you don't know the root password. Change the root
password to redhat and login in default Runlevel.
Answer and Explanation:
When you Boot the System, it starts on default Runlevel specified in /etc/inittab: Id:?:initdefault:
When System Successfully boot, it will ask for username and password. But you don't know the root's
password. To change the root password you need to boot the system into single user mode. You can pass
the kernel arguments from the boot loader.
1. Restart the System.
2. You will get the boot loader GRUB screen.
3. Press a and type 1 or s for single mode ro root=LABEL=/ rhgb queit s
4. System will boot on Single User mode.
5. Use passwd command to change.
6. Press ctrl+d
6. There are more then 400 Computers in your Office. You are appointed as a System Administrator. But
you don't have Router. So, you are going to use your One Linux Server as a Router. How will you enable
IP packets forward?
Answer and Explanation:
1. /proc is the virtual filesystem, we use /proc to modify the kernel parameters at running time.
# echo "1" >/proc/sys/net/ipv4/ip_forward
2. /etc/sysctl.conf when System Reboot on next time, /etc/rc.d/rc.sysinit scripts reads the file
/etc/sysctl.conf. To enable the IP forwarding on next reboot also you need to set the parameter.
net.ipv4.ip_forward=1
Here 0 means disable, 1 means enable.
7. You Completely Install the Redhat Enterprise Linux ES 4 on your System. While start the system, it's
giving error to load X window System. How will you fix that problem and make boot successfully run X
Window System.
Answer and Explanation:
Think while Problems occurred on booting System on Runlevel 5 (X Window).
1. /tmp is full or not
2. Quota is already reached
3. Video card or resolution or monitor is misconfigured.
4. xfs service is running or not.
Do These:
1. df -h /tmp /tmp is full remove the unnecessary file
2. quota username if quota is already reached remove unnecessary file from home directory.
3. Boot the System in runlevel 3. you can pass the Kernel Argument from boot loader.
4. Use command: system-config-display It will display a dialog to configure the monitor, Video card,
resolution etc.
5. Set the Default Runlevel 5 in /etc/inittab id:5:initdefault:
6. Reboot the System you will get the GUI login Screen.
8. There are two different networks, 192.168.0.0/24 and 192.168.1.0/24. Your System is in 192.168.0.0/24
Network. One RHEL 4 Installed System is going to use as a Router. All required configuration is already
done on Linux Server. Where 192.168.0.254 and 192.168.1.254 IP Address are assigned on that Server.
How will make successfully ping to 192.168.1.0/24 Network's Host?
Answer:
1. vi /etc/sysconfig/network
GATEWAY=192.168.0.254
OR
vi /etc/sysconf/network-scripts/ifcfg-eth0
DEVICE=eth0
BOOTPROTO=static
ONBOOT=yes
IPADDR=192.168.0.?
NETMASK=255.255.255.0
GATEWAY=192.168.0.254
2. service network restart
Explanation: Gateway defines the way to exit the packets. According to question System working as a
router for two networks have IP Address 192.168.0.254 and 192.168.1.254. To get the hosts on
192.168.1.0/24 should go through 192.168.0.254.
9. Make a swap partition having 100MB. Make Automatically Usable at System Boot Time.
Answer and Explanation:
1. Use fdisk /dev/hda To create new partition.
2. Type n For New partition
3. It will ask for Logical or Primary Partitions. Press l for logical.
4. It will ask for the Starting Cylinder: Use the Default by pressing Enter Key.
5. Type the Size: +100M You can Specify either Last cylinder of Size here.
6. Press P to verify the partitions lists and remember the partitions name.
Default System ID is 83 that means Linux Native.
7. Type t to change the System ID of partition.
8. Type Partition Number
9. Type 82 that means Linux Swap.
10. Press w to write on partitions table.
11. Either Reboot or use partprobe command.

RedHat   RH-202   RH-202 examen   RH-202   RH-202 examen   RH-202 examen

NO.12 quotacheck -ufm /data

RedHat   RH-202   RH-202 examen   RH-202   RH-202 examen   RH-202 examen

NO.13 Use mkfs -t ext3 /dev/hda?
Or
mke2fs -j /dev/hda? To create ext3 filesystem.

RedHat   RH-202   RH-202 examen   RH-202   RH-202 examen   RH-202 examen

NO.14 free -m Verify Either Swap is enabled or not.

RedHat   RH-202   RH-202 examen   RH-202   RH-202 examen   RH-202 examen

NO.15 Make Successfully Resolve to server1.example.com where DNS Server is 192.168.0.254.
Answer: 1. vi /etc/resolv.conf

RedHat   RH-202   RH-202 examen   RH-202   RH-202 examen   RH-202 examen

NO.16 touch /data/aquota.user

RedHat   RH-202   RH-202 examen   RH-202   RH-202 examen   RH-202 examen

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

Pass4Test offre de Oracle 1Z0-040 matériaux d'essai

Il demande les connaissances professionnelles pour passer le test Oracle 1Z0-040. Si vous manquez encore ces connaissances, vous avez besoin de Pass4Test comme une resourece de ces connaissances essentielles pour le test. Pass4Test et ses experts peuvent vous aider à renfocer ces connaissances et vous offrir les Q&As. Pass4Test fais tous efforts à vous aider à se renforcer les connaissances professionnelles et à passer le test. Choisir le Pass4Test peut non seulement à obtenir le Certificat Oracle 1Z0-040, et aussi vous offrir le service de la mise à jour gratuite pendant un an. Si malheureusement, vous ratez le test, votre argent sera 100% rendu.

Il y a beaucoup de gans ambitieux dansn l'Industrie IT. Pour monter à une autre hauteur dans la carrière, et être plus proche du pic de l'Industrie IT. On peut choisir le test Oracle 1Z0-040 à se preuver. Mais le taux du succès et bien bas. Participer le test Oracle 1Z0-040 est un choix intelligent. Dans l'Industrie IT de plus en plus intense, on doit trouver une façon à s'améliorer. Vous pouvez chercher plusieurs façons à vous aider pour réussir le test.

Pour vous laisser savoir mieux que la Q&A Oracle 1Z0-040 produit par Pass4Test est persuadante, le démo de Q&A Oracle 1Z0-040 est gratuit à télécharger. Sous l'aide de Pass4Test, vous pouvez non seulement passer le test à la première fois, mais aussi économiser vos temps et efforts. Vous allez trouver les questions presque même que lesquels dans le test réel. C'est pourquoi tous les candidats peuvent réussir le test Oracle 1Z0-040 sans aucune doute. C'est aussi un symbole d'un meilleur demain de votre carrière.

Vous pouvez télécharger tout d'abord le démo gratuit pour prendre un essai. Vous serez confiant davantage sur Pass4Test après l'essai de démo. Vous allez réussir le test Oracle 1Z0-040 sans aucune doute si vous choisissez le Pass4Test.

Code d'Examen: 1Z0-040
Nom d'Examen: Oracle (Oracle database 10g:new features for adminsitrators)
Questions et réponses: 200 Q&As

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

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

NO.1 You plan to create an external table from the EMPLOYEES, DEPARTMENTS, and LOCATIONS
database tables. Which method or command should you use to create and populate the external table?
A.the expdp and impdp commands
B.conventional export and import
C.CREATE TABLE.. and SQL*Loader
D.CREATE TABLE.. and INSERT INTO.. SELECT.. FROM..
E.CREATE TABLE.. ORGANIZATION EXTERNAL ..AS SELECT.. FROM..
Answer: E

Oracle   1Z0-040   1Z0-040

NO.2 An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace
threshold alerts were generated for the TEST_TBS tablespace. What could be the reason, if the
TEST_TBS tablespace does not include autoextensible data files?
A.TEST_TBS is a small file tablespace.
B.TEST_TBS is a bigfile tablespace (BFT).
C.TEST_TBS is the default temporary tablespace.
D.TEST_TBS is a dictionary-managed tablespace.
E.Threshold values for the TEST_TBS tablespace are not explicitly specified.
Answer: D

Oracle examen   1Z0-040 examen   1Z0-040 examen   1Z0-040

NO.3 View the exhibit and examine the sparsely populated EMP table segment.
You execute the following SQL command.
ALTER TABLE emp SHRINK SPACE;
Identify how the data in the segment will be reorganized as a result of the above statement.
A. Exhibit 1.
B. Exhibit 2.
C. Exhibit 3
D. Exhibit 4
E. Exhibit 5
Answer: A

Oracle   certification 1Z0-040   1Z0-040 examen

NO.4 Which two statements regarding the FLASHBACK_TRANSACTION_QUERY view are correct?
(Choose two.)
A.You can find information about only active transactions from the view.
B.You can find information about read only transactions from the view.
C.You require the SELECT ANY TRANSACTION system privilege to access the view.
D.You can find information about both active and committed transactions from the view.
E.You require the SELECT ON FLASHBACK_TRANSACTION_QUERY object privilege to access the
view.
Answer: CD

Oracle   1Z0-040   1Z0-040 examen   certification 1Z0-040   1Z0-040

NO.5 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
Answer: BG

certification Oracle   1Z0-040   1Z0-040

NO.6 Which are the three levels at which the Segment Advisor generates advice? (Choose three.)
A.block level
B.object level
C.schema level
D.segment level
E.tablespace level
Answer: BDE

Oracle   1Z0-040   1Z0-040   1Z0-040

NO.7 You explicitly specified the tablespace usage threshold values while creating a tablespace. You need
to revert to the database-wide default tablespace usage threshold values for the tablespace. Which
PL/SQL package would you use?
A.DBMS_STATS
B.DBMS_ALERT
C.DBMS_SPACE
D.DBMS_MONITOR
E.DBMS_SERVER_ALERT
F.DBMS_SPACE_ADMIN
Answer: E

Oracle   certification 1Z0-040   1Z0-040 examen

NO.8 View the Exhibit and examine the recommendation graph provided for a test database by the Undo
Advisor.
The graph recommends that the size of undo tablespace should be set to _____.
A.1 MB
B.6 MB
C.10 MB
D.15 MB
E.11 MB
Answer: E

Oracle examen   1Z0-040 examen   1Z0-040   1Z0-040   1Z0-040 examen

NO.9 Which two statements regarding the Policy Framework in Enterprise Manager (EM) are correct?
(Choose two.)
A.Policy violations are prioritized as High, Medium, or Informational by category.
B.Policies can be disabled completely, or flagged as ignored, for the specified target.
C.Policies can be flagged as ignored, but never completely disabled, for the specified target.
D.Policy violations must be corrected, otherwise the database will shut down until corrective action
occurs.
Answer: AB

Oracle examen   1Z0-040   1Z0-040

NO.10 View the Exhibit and examine the SQL statement used to create the EMP table.
You need to shrink the EMP table segment. Which SQL statement would you execute as a prerequisite
before you execute the ALTER TABLE emp SHRINK SPACE; command?
A.ALTER TABLESPACE emp OFFLINE;
B.ALTER TABLESPACE emp READ ONLY;
C.ALTER TABLE emp DEALLOCATE UNUSED;
D.ALTER TABLE emp ENABLE ROW MOVEMENT;
E.ALTER TABLE emp DISABLE ALL TRIGGERS;
F.ALTER TABLE emp ENABLE NOVALIDATE CONSTRAINT emp_last_name_nn;
Answer: D

Oracle examen   1Z0-040   1Z0-040

NO.11 View the Exhibit and examine the highlighted alert.
You have received an alert with the Category specified as Snapshot Too Old. Which page would you
open from the Advisor Central page to determine the system recommendations to avoid such alerts in
future?
A.ADDM
B.Memory Advisor
C.Segment Advisor
D.Undo Management
E.SQL Tuning Advisor
F.SQL Access Advisor
Answer: D

Oracle   1Z0-040 examen   1Z0-040

NO.12 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.
Answer: C

Oracle examen   certification 1Z0-040   1Z0-040 examen   1Z0-040 examen

NO.13 You created a locally managed tablespace by using the following SQL statement:
CREATE TABLESPACE hr_tbs
DATAFILE 'data.dat' SIZE 1M REUSE
AUTOEXTEND ON MAXSIZE 100M;
The warning and critical tablespace usage threshold values are set to 85% and 97%, respectively. Which
two statements regarding the threshold-based alerts generation for the HR_TBS tablespace are correct?
(Choose two.)
A.A critical alert will be generated when 97 MB space is used.
B.A critical alert will be generated when 970 KB space is used.
C.A warning alert will be generated when 85 MB space is used.
D.A warning alert will be generated when 850 KB space is used.
E.A critical alert will be generated when 970 KB is left as free space.
F.A warning alert will be generated when 850 KB is left as free space.
G.No critical alert will be generated because it is a small file tablespace.
H.No warning alert will be generated because the tablespace is autoextensible.
Answer: AC

Oracle examen   1Z0-040   1Z0-040

NO.14 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.
Answer: D

Oracle   1Z0-040   1Z0-040   1Z0-040 examen   1Z0-040

NO.15 You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the
EXAMPLE tablespace:
ALTER TABLE employees SHRINK SPACE CASCADE;
Which statement is correct in this scenario?
A.The data in the segment will be compacted but the high water mark will not be adjusted.
B.The EMPLOYEES table will be changed to read-only mode during the shrink operation.
C.The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.
D.The shrink behavior will be cascaded to all dependent segments of the table that support a shrink
operation.
E.Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the
COMPACTION phase of the shrink operation.
Answer: D

Oracle   1Z0-040 examen   1Z0-040 examen

NO.16 You have 100 segments in the USERS tablespace. You get an alert that the USERS tablespace is
running low on space. You decide to shrink some segments. Which option would you use to determine
which segments to shrink?
A.Segment Advisor
B.SQL Tuning Advisor
C.SQL Access Advisor
D.Segment Resource Estimation
E.Automatic Database Diagnostic Monitor (ADDM)
Answer: A

Oracle examen   certification 1Z0-040   1Z0-040 examen   1Z0-040

NO.17 You want to perform the database backup when user activity on your system is low, such as between
12:00 a.m. and 2:00 a.m.
Which command terminates with an error if the backup is not complete at the end of the specified
duration?
A.RMAN> BACKUP DURATION 2:00 MINIMIZE LOAD DATABASE;
B.RMAN> BACKUP DURATION 2:00 PARTIAL FILESPERSET 1 DATABASE;
C.RMAN> BACKUP DURATION 2:00 PARTIAL MINIMIZE TIME DATABASE;
D.RMAN> BACKUP AS COPY DURATION 2:00 PARTIAL MINIMIZE LOAD DATABASE;
Answer: A

certification Oracle   1Z0-040   1Z0-040 examen

NO.18 The system was running a normal workload during the last 24 hours. You need to ensure that with the
same workload you should be able to flashback tables by three hours. What would you do to find the
system recommendations for the undo retention period and the undo tablespace size?
A.set DB_FLASHBACK_RETENTION_TARGET=10800
B.create a new scheduler window for the time period of 24 hours and use the optimizer statistics
C.modify the Automatic Workload Repository (AWR) snapshot time interval to three hours and use ADDM
findings
D.specify New Undo Retention as three hours and Analysis Time period as Last One Day in the Undo
Advisor page and use its recommendations
Answer: D

Oracle examen   1Z0-040 examen   1Z0-040   1Z0-040

NO.19 You are checking every 10 minutes for alerts regarding the violation of tablespace usage threshold.
Some of the tablespaces' fullness was not detected on time. As a result the transactions were aborted
before you had a chance to resolve the space issue. What would you do to avoid transaction failures?
A.use bigfile tablespaces (BFTs)
B.enable resumable space allocation
C.modify the background process PMON settings
D.modify the LOG_CHECKPOINT_TIMEOUT parameter
E.reduce the default tablespace usage threshold values for the database
Answer: B

Oracle examen   1Z0-040   1Z0-040   certification 1Z0-040   1Z0-040 examen

NO.20 You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running
low on space. You can use Segment Advisor to _____.
A.add data files to the tablespace
B.identify the segments that you should shrink
C.modify the storage parameters for the tablespace
D.automatically shrink the segments with unused space
E.check the alerts generated for the tablespace that is running low on space
Answer: B

certification Oracle   1Z0-040   certification 1Z0-040   1Z0-040   certification 1Z0-040

Pass4Test est un site de vous ramener au succès. Pass4Test peut vous aider à promouvoir les connaissances essentielles pour le test Oracle 1Z0-040 et passer le test à la première fois.

Dernières Oracle 1Z0-035 de la pratique de l'examen questions et réponses téléchargement gratuit

La partie plus nouvelle de test Certification Oracle 1Z0-035 est disponible à télécharger gratuitement dans le site de Pass4Test. Les exercices de Pass4Test sont bien proches de test réel Oracle 1Z0-035. En comparaison les Q&As dans les autres sites, vous trouverez que les nôtres sont beaucoup plus complets. Les Q&As de Pass4Test sont tout recherchés par les experts de Pass4Test, y compris le test simulation.

Pass4Test est un catalyseur de votre succès de test Oracle 1Z0-035. En visant la Certification de Oracle, la Q7A de Pass4Test avec beaucoup de recherches est lancée. Si vous travillez dur encore juste pour passer le test Oracle 1Z0-035, la Q&A Oracle 1Z0-035 est un bon choix pour vous.

Pass4Test est un bon site qui provide la façon efficace à se former à court terme pour réussir le test Oracle 1Z0-035, 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-035. Vous aurez une space plus grande à se développer.

Code d'Examen: 1Z0-035
Nom d'Examen: Oracle (Oracle9i dba new features for Oracle7.3 and Oracle9 ocps)
Questions et réponses: 168 Q&As

Le test Oracle 1Z0-035 est populaire dans l'Industrie IT. Il y a beaucoup de professionnels IT veulent ce passport de IT. Votre vie et salaire sera améliorée avec ce Certificat. Vous aurez une meilleure assurance.

Nous croyons que pas mal de candidats voient les autres site web qui offrent les ressources de Q&A Oracle 1Z0-035. En fait, le Pass4Test est le seul site qui puisse offrir la Q&A recherchée par les experts réputés dans l'Industrie IT. Grâce à la Q&A de Pass4Test impressionée par la bonne qualité, vous pouvez réussir le test Oracle 1Z0-035 sans aucune doute.

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-035 à la première fois.

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

NO.1 Online index rebuild functionality has been extended to include which four index structures?
(Choose four.)
A.bitmap indexes
B.reverse key indexes
C.function-based indexes
D.key-compressed indexes on regular tables
E.key-compressed indexes on IOT (including secondary indexes)
Correct:B C D E

Oracle   certification 1Z0-035   1Z0-035   1Z0-035   1Z0-035

NO.2 Which three features are provided by Recovery Manager and NOT provided by user-managed
backup and recovery? (Choose three.)
A.online backups
B.skipping unused blocks
C.partial database backups
D.incremental block-level backup
E.detection of corrupted blocks during backup
Correct:B D E

Oracle   certification 1Z0-035   1Z0-035   1Z0-035   1Z0-035

NO.3 What is true about version-enabled tables?
A.The unit of versioning is the schema.
B.It is possible to version enable a table pertaining to SYS.
C.There are as many segments as versions for the same base table.
D.It is possible to create workspaces if there is no version-enabled table in the database.
Correct:D

Oracle   certification 1Z0-035   1Z0-035   1Z0-035   1Z0-035

NO.4 Consider the following scenario using incremental backups. A level 1 backup is taken on the
first of the month. A level 2 backup is taken every Sunday, and a level 3 backup is taken daily. If
the database gets corrupted on the second Wednesday of the month and is lost, which scenario
would restore the database completely?
A.the weekly backup (level 2) and the daily backup (level 3)
B.the monthly backup (level 1) and the daily backup (level 3)
C.a base level backup (level 0) is missing and nothing can be recovered
D.the monthly backup (level 1), the weekly backup (level 2) and the daily backup (level 3)
Correct:C

Oracle   certification 1Z0-035   1Z0-035   1Z0-035   1Z0-035

NO.5 Which two statements about dimensions are true? (Choose two.)
A.A hierarchy can consist of multiple levels.
B.A dimension can be based on multiple tables.
C.A dimension can contain only a single hierarchy.
D.No special privileges are required to create a dimension.
Correct:A B

Oracle   certification 1Z0-035   1Z0-035   1Z0-035   1Z0-035

NO.6 Which type of index should be created to spread the distribution of index updates across the
index tree?
A.B-tree indexes
B.bitmap indexes
C.reverse-key indexes
D.function-based indexes
Correct:C

Oracle   certification 1Z0-035   1Z0-035   1Z0-035   1Z0-035

NO.7 Which type of ROWID does Oracle use for global indexes on partitioned tables?
A.local
B.extended
C.restricted
Correct:B

Oracle   certification 1Z0-035   1Z0-035   1Z0-035   1Z0-035

NO.8 Which CREATE TABLE parameter should you be concerned with if the length of rows in an
index-organized table vary over a wide range of values?
A.PCTFREE
B.PCTUSED
C.PCTINCREASE
D.PCTTHRESHOLD
Correct:D

Oracle   certification 1Z0-035   1Z0-035   1Z0-035   1Z0-035

NO.9 In order to speed foreign key creation, Oracle9i will cache the first _____ primary key values
only where there are multirow DML statements.
A.32
B.128
C.256
D.512
Correct:C

Oracle   certification 1Z0-035   1Z0-035   1Z0-035   1Z0-035

NO.10 Users complain that SQL statements using a particular index fail. Using DBVERIFY, you find
that two separate blocks in the index have become corrupt. The database data files for user data
and index are very large. What is the least disruptive recovery strategy available in Oracle9i?
A.Rebuild the index using the online option.
B.Take the individual data file offline (not the whole tablespace), restore and recover the data file from
backup with RMAN, then set the data file online again.
C.Without setting the individual data file offline, use RMAN with Block Media Recovery to restore and
recover only those blocks.
D.Take the individual data file (not the whole tablespace) offline, use RMAN with Block Media Recovery to
restore and recover only those blocks, then set the data file online again.
Correct:C

Oracle   certification 1Z0-035   1Z0-035   1Z0-035   1Z0-035

NO.11 In the Oracle9i Data Guard architecture, what is the purpose of the Log Transport Services?
A.to transfer redo log information to one or more destinations
B.to apply redo log records sent from the primary database to a standby database at the receiving
location
C.to synchronize changes to the control files on all standby databases with changes on the primary
database when a log switch occurs
D.to batch archived log files on the primary database until a defined number of checkpoints have been
processed and then to distribute the archives to each standby database
Correct:A

Oracle   certification 1Z0-035   1Z0-035   1Z0-035   1Z0-035

NO.12 Which two statements are true? (Choose two.)
A.Composite partitioning enables you to prevent partition elimination.
B.Composite partitioning supports hash partitioned global indexes.
C.Composite partitioning is ideal for both historical data and data placement.
D.Composite partitioning provides high performance and manageability, like range partitioning.
Correct:C D

Oracle   certification 1Z0-035   1Z0-035   1Z0-035   1Z0-035

NO.13 What criterion does Oracle9i use to determine whether a database file is an Oracle Managed File?
A.the filename format
B.information stored inside a data dictionary table
C.information stored in the ALERT.LOG file for the corresponding instance
D.information stored inside the corresponding initialization parameter file for the instance
Correct:A

Oracle   certification 1Z0-035   1Z0-035   1Z0-035   1Z0-035

NO.14 What statement is true about taking a database default temporary tablespace offline?
A.You cannot take a default temporary tablespace offline.
B.The database must be quiesced before you perform this action.
C.You must ensure that all users are assigned to an alternative temporary tablespace first.
D.You must first ensure that the default temporary tablespace has the permanent tablespace
characteristic.
Correct:A

Oracle   certification 1Z0-035   1Z0-035   1Z0-035   1Z0-035

NO.15 Consider the following statement: SQL> EXECUTE DBMS_STATS.GATHER_SCHEMA_STATS (- 2>
ownname => 'OE', - 3> estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE, - 4> method_opt
=> 'for all columns size AUTO'); What is the effect of 'for all columns size AUTO' of the
METHOD_OPT option?
A.The Oracle server creates a new histogram based on existing histogram definitions for all table, column,
and index statistics for the OE schema.
B.The Oracle server creates a histogram based on data distribution regardless of how the application
uses the column/s for all table, column, and index statistics for the OE schema.
C.The Oracle server creates a histogram based on data distribution and application usage of the
column/s for all table, column, and index statistics for the OE schema.
D.The Oracle server creates a histogram based on application usage, regardless of data distribution, for
all table, column, and index statistics for the OE schema.
Correct:C

Oracle   certification 1Z0-035   1Z0-035   1Z0-035   1Z0-035

NO.16 Which four are true regarding the Workspace Manager in Oracle9i? (Choose four.)
A.automatically versions all tables
B.automatically installed with Oracle9i
C.merges changes with parent rows or discards changes
D.provides mechanism to identify and resolve conflicts
E.allows for version enabling tables by use of a packaged procedure
Correct:B C D E

Oracle   certification 1Z0-035   1Z0-035   1Z0-035   1Z0-035

NO.17 What do you need to do in order for the Database Resource Manager to estimate, in advance,
the execution time of a statement?
A.Set the TIMED_STATISTICS initialization parameter.
B.Gather optimizer statistics on related objects.
C.Set the TIMED_OS_STATISTICS initialization parameter.
D.Nothing
Correct:B

Oracle   certification 1Z0-035   1Z0-035   1Z0-035   1Z0-035

NO.18 What is one benefit of using the ALTER TABLE ... MOVE command rather than a CREATE
TABLE ... AS SELECT command?
A.row chaining is eliminated.
B.index definitions are retained.
C.duplicate space is not required while the command executes.
D.all operations, such as INSERT, UPDATE, DELETE, and SELECT can be performed while the
operation completes.
Correct:B

Oracle   certification 1Z0-035   1Z0-035   1Z0-035   1Z0-035

NO.19 Examine the statement: DROP TABLESPACE IND2 INCLUDING CONTENTS AND DATAFILES;
What is the result of the statement?
A.The contents and data files belonging to the IND2 tablespace are dropped.
B.The statement will only succeed if the IND2 tablespace was built using Oracle-Managed Files (OMF)
data files.
C.The statement will only succeed if the data files belonging to the IND2 tablespace are Oracle-Managed
Files (OMF) or if the database was created using OMF.
D.The contents of the tablespace are dropped along with all its data files except those identified with the
Oracle-Managed Files (OMF) naming convention.
Correct:A

Oracle   certification 1Z0-035   1Z0-035   1Z0-035   1Z0-035

NO.20 Which two are true regarding external tables? (Choose two.)
A.External tables can be updated.
B.External tables are read-only tables.
C.Indexes can be created on external tables.
D.Indexes cannot be created on external tables.
Correct:B D

Oracle   certification 1Z0-035   1Z0-035   1Z0-035   1Z0-035

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

Pass4Test offre de Oracle 1Z1-050 matériaux d'essai

Pass4Test provide non seulement le produit de qualité, mais aussi le bon service. Si malheureusement vous ne pouvez pas réussir le test, votre argent sera tout rendu. Le service de la mise à jour gratuite est aussi pour vous bien que vous passiez le test Certification.

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

Les experts de Pass4Test ont fait sortir un nouveau guide d'étude de Certification Oracle 1Z1-050, avec ce guide d'étude, réussir ce test a devenu une chose pas difficile. Pass4Test vous permet à réussir 100% le test Oracle 1Z1-050 à la première fois. Les questions et réponses vont apparaître dans le test réel. Pass4Test peut vous donner une Q&A plus complète une fois que vous choisissez nous. D'ailleurs, la mise à jour gratuite pendant un an est aussi disponible pour vous.

Si vous voulez ne se soucier plus à passer le test Oracle 1Z1-050, donc vous devez prendre la Q&A de Pass4Test comme le guide d'étude pendant la préparation de test Oracle 1Z1-050. C'est une bonne affaire parce que un petit invertissement peut vous rendre beaucoup. Utiliser la Q&A Oracle 1Z1-050 offerte par Pass4Test peut vous assurer à réussir le test 100%. Pass4Test a toujours une bonne réputation dans l'Industrie IT.

Vous pouvez télécharger tout d'abord le démo gratuit pour prendre un essai. Vous serez confiant davantage sur Pass4Test après l'essai de démo. Vous allez réussir le test Oracle 1Z1-050 sans aucune doute si vous choisissez le Pass4Test.

Vous pouvez s'exercer en Internet avec le démo gratuit. Vous allez découvrir que la Q&A de Pass4Test est laquelle le plus complète. C'est ce que vous voulez.

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

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

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

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

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

certification Oracle   1Z1-050   certification 1Z1-050

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

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

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

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

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

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

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

NO.8 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   certification 1Z1-050   1Z1-050 examen   1Z1-050 examen   1Z1-050

NO.9 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 examen   1Z1-050   1Z1-050   certification 1Z1-050   1Z1-050 examen

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

NO.11 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 examen   certification 1Z1-050   1Z1-050   1Z1-050

NO.12 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 examen   certification 1Z1-050   certification 1Z1-050

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

NO.14 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 examen   certification 1Z1-050   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   1Z1-050   1Z1-050   1Z1-050

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

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

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

NO.18 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   1Z1-050 examen   1Z1-050 examen   1Z1-050 examen   certification 1Z1-050

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

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

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

Le Pass4Test est un site qui peut offrir les facilités aux candidats et aider les candidats à réaliser leurs rêve. Si vous êtes souci de votre test Certification, Pass4Test peut vous rendre heureux. La haute précision et la grande couverture de la Q&A de Pass4Test vous aidera pendant la préparation de test. Vous n'aurez aucune raison de regretter parce que Pass4Test réalisera votre rêve.

Dernières Oracle 1Z0-402 examen pratique questions et réponses

Pour l'instant, vous pouvez télécharger le démo gratuit de Q&A Oracle 1Z0-402 dans Pass4Test pour se former avant le test Oracle 1Z0-402.

Pour réussir le test Oracle 1Z0-402 demande beaucoup de connaissances professionnelles IT. Il n'y a que les gens qui possèdent bien les connaissances complètes à participer le test Oracle 1Z0-402. Maintenant, on a les autres façons pour se former. Bien que vous n'ayez pas une connaissance complète maintenant, vous pouvez quand même réussir le test Oracle 1Z0-402 avec l'aide de Pass4Test. En comparaison des autres façons, cette là dépense moins de temps et de l'effort. Tous les chemins mènent à Rome.

Code d'Examen: 1Z0-402
Nom d'Examen: Oracle (Oracle Enterprise Linux: Fundamentals)
Questions et réponses: 224 Q&As

Le test certification Oracle 1Z0-402 est une bonne preuve de connaissances professionnelles et la techniques. Dans l'Industrie IT, beaucoiup de humains ressource font l'accent de lesquels certificats que les volontiers obtiennent. C'est clairement que le certificat Oracle 1Z0-402 puisse augmenter la compétition dans ce marché.

Pass4Test est un bon catalyseur du succès pour les professionnels IT. Beaucoup de gens passer le test Oracle 1Z0-402 avec l'aide de l'outil formation. Les experts profitent leurs expériences riches et connaissances à faire sortir la Q&A Oracle 1Z0-402 plus nouvelle qui comprend les exercices de pratiquer et le test simulation. Vous pouvez passer le test Oracle 1Z0-402 plus facilement avec la Q&A de Pass4Test.

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

NO.1 You have to start a process in the bash shell and at the same time want to work in the shell. How would
you achieve this without terminating the process?
A. Press [Ctrl] + [y] while the process is running.
B. Press [Ctrl] + [d] while the process is running.
C. Press [Ctrl] + [z] while the process is running.
D. Press [Ctrl] + [c] while the process is running.
Answer: C

Oracle examen   1Z0-402 examen   1Z0-402   1Z0-402   1Z0-402 examen

NO.2 When bash is invoked as an interactive login shell, what is the order in which the bash configuration
files are read with the assumption that all the files exist and are readable?
A. ~/.bash_profile,~/.bash_login,/etc/profile,~/.profile
B. /etc/profile,~/.bash_profile,~/.bash_login,~/.profile
C. ~/.profile,~/.bash_login,/etc/profile,~/.bash_profile
D. ~/.bash_login,/etc/profile,~/.profile,~/.bash_profile
Answer: B

Oracle   1Z0-402   1Z0-402

NO.3 Why is a Linux operating system always developed and released under a common standard known as
Linux Standard Base (LSB)?
A. to avoid interoperability
B. to avoid POSIX Compliance
C. to ensure application-level diversity
D. to ensure compatibility among distributions
Answer: D

certification Oracle   1Z0-402 examen   1Z0-402

NO.4 UNIX was known as the most stable operating system ever released. Identify two major design
principles that help attain this stability. (Choose two.)
A. easily modifiable end user programs
B. all configuration data stored in binary files
C. entire policy decisions made by the kernel
D. everything in UNIX is either a file or a process
Answer: AD

Oracle   certification 1Z0-402   1Z0-402 examen   1Z0-402   1Z0-402

NO.5 You have logged in as user smith at tty1 terminal and issued the following incomplete command at the
bash prompt:
The shell displays the default secondary prompt ">". What would you do to make "=>" as the default
secondary prompt temporarily only for user smith and for the tty1 terminal current session?
A. Redefine PS1==>.
B. Redefine PS2==>.
C. Redefine PS3==>.
D. Redefine PS4==>.
Answer: B

certification Oracle   certification 1Z0-402   certification 1Z0-402   1Z0-402

NO.6 The GNU project was started by Free Software Foundation (FSF) with a goal to create a Free UNIX
Clone.
What do you understand by the term Free as per the terms of FSF?
A. The source code will be provided free of cost with the software.
B. The software is fully free and is charged only to fix breakdowns.
C. The software is distributed free in runnable (installable) form with no cost.
D. The software is distributed free but does not offer the freedom to redistribute it.
Answer: A

Oracle examen   1Z0-402 examen   1Z0-402   certification 1Z0-402

NO.7 A new user smith wants to customize the bourne shell by creating a new alias for the ls -l command.
He wants to make the new alias persistent across logouts and also reboots.
What could be done to make the new alias persistent only for smith?
A. Add the new alias to ~/.bashrc.
B. Add the new alias to ~/.profile.
C. Add the new alias to /etc/profile.
D. Add the new alias to ~/bash_profile.
Answer: B

Oracle examen   1Z0-402 examen   1Z0-402 examen   1Z0-402 examen

NO.8 As user smith you want the CPU utilization of all the users logged on to server1 server. You want the
information available automatically as soon as you login to the bash login shell and want the information
available only to smith.
What would you do on server1, which has all the default shell configuration files, to accomplish the task?
A. Add the w command to ~/.profile file.
B. Add the who command to ~/.profile file.
C. Add the w command to ~/.bash_profile file.
D. Add the who command to ~/.bash_profile file.
Answer: C

Oracle   1Z0-402 examen   1Z0-402 examen

NO.9 What is the minimum number of disk partitions required to have a successful Linux installation?
A. 2 (two)
B. 4 (four)
C. 1 (one)
D. 3 (three)
Answer: C

Oracle   1Z0-402   1Z0-402   1Z0-402

NO.10 As user smith you want to log in to a remote machine in a securely encrypted channel. Which utility
would you use for the purpose?
A. ssh
B. ftp
C. telnet
D. rlogin
Answer: A

Oracle   1Z0-402 examen   1Z0-402   1Z0-402   1Z0-402   1Z0-402

NO.11 Which statements are true about the File Extensions? (Choose all that apply.)
A. File extensions are just part of the file name.
B. File extensions are cared by all applications.
C. File content depends upon the file extensions.
D. File extensions do not always say what the file is.
E. File extensions have no special meaning to the kernel.
Answer: ADE

Oracle examen   certification 1Z0-402   certification 1Z0-402   1Z0-402   1Z0-402   1Z0-402 examen

NO.12 Match the bash file with its description:
A. 1-c, 2-d, 3-b, 4-a
B. 1-b, 2-c, 3-a, 4-d
C. 1-c, 2-d, 3-a, 4-b
D. 1-b, 2-c, 3-d, 4-a
Answer: C

Oracle examen   1Z0-402   1Z0-402 examen   1Z0-402   1Z0-402   1Z0-402 examen

NO.13 You have set HISTCONTROL=ignoreboth. What are the implications of this setting on history?
A. It saves both duplicates and commands prefixed with a space.
B. It ignores commands prefixed with a space but saves duplicates.
C. It ignores duplicates but saves the commands prefixed with space.
D. It ignores both the duplicate commands and commands prefixed with a space.
Answer: D

Oracle   1Z0-402   1Z0-402

NO.14 Which three statements are true about the mount command? (Choose three.)
A. It supports labels for mounting.
B. It can be used only by root to mount the local file system.
C. By default it can be used by an ordinary user to mount the local file system.
D. It will list all the currently mounted file systems, if executed without any arguments.
E. It will list only the file systems listed in /etc/fstab if executed without any arguments
Answer: ABD

certification Oracle   1Z0-402   1Z0-402 examen

NO.15 Which statements are true about xauth? (Choose all that apply.)
A. It stores all tokens in a file on the system.
B. It must be available to use X11 forwarding.
C. It distributes token on a host-by-host basis.
D. It can be used to control token-based access control.
E. It is not possible to install just xauth without installing the entire X server.
Answer: ABD

certification Oracle   1Z0-402   1Z0-402

NO.16 View the Exhibit.
What are the privileges granted to the user smith on the /tmp/backup directory?
A. He can only list the contents of /tmp/backup.
B. He can only navigate to the /tmp/backup directory.
C. He can change to and copy contents from the /tmp/backup directory.
D. He can only change to and from the /tmp/backup directory but cannot list its contents.
Answer: A

Oracle   1Z0-402   1Z0-402   1Z0-402   certification 1Z0-402

NO.17 Identify the option that has the correct match for an Enterprise Linux standard/feature with its
description:
A. 1-b, 2-d, 3-a, 4-c
B. 1-d, 2-a, 3-b, 4-c
C. 1-c, 2-a, 3-d, 4-b
D. 1-b, 2-c, 3-d, 4-a
Answer: B

Oracle examen   1Z0-402   certification 1Z0-402   1Z0-402   1Z0-402

NO.18 As root user you have set the environment variable HISTIGNORE="ls:man:pwd:cat" with the other
history-related shell variables at their default. What impact does it have on shell history?
A. History will ignore only the commands listed in the HISTIGNORE variable.
B. History will save only the first occurrence of the commands listed in the HISTIGNORE variable.
C. History will ignore only the commands, issued with any valid switch, listed in the HISTIGNORE
variable.
D. History will save only the first occurrence of the commands, issued with any valid switch, listed in the
HISTIGNORE variable.
Answer: A

Oracle examen   certification 1Z0-402   1Z0-402   1Z0-402   1Z0-402 examen   1Z0-402

NO.19 View the Exhibit.
The shell script is executed using the default shell interpreter with the input as w. What will be the output
of the script based on this input?
A. It will print the current date and time.
B. It will list all the currently logged in users.
C. It will show that the input is not a valid option.
D. It will print the currently logged in users, current date, and time.
E. It will not show any result because the case block is terminated with an esac.
Answer: C

certification Oracle   1Z0-402 examen   certification 1Z0-402   1Z0-402 examen

NO.20 As a root user you want to modify the default shell prompt to include the hostname as part of the
prompt. Also you want the change in the hostname to reflect on the prompt immediately.
Which option would help you achieve this task?
A. PS2='[`hostname`]'
B. PS1='[`hostname`]'
C. PS2=''[`hostname`]''
D. PS1=''[`hostname`]''
Answer: B

Oracle   1Z0-402   1Z0-402

NO.21 You executed the following command on a Linux machine:
sed s/hello/fun/g file1.txt | tr a-z A-Z > file2.txt
What three things would this command do? (Choose three.)
A. Save all changes to file2.txt.
B. Translate all uppercase characters to lowercase.
C. Translate all lowercase characters to uppercase.
D. Modifies file1.txt and creates file2.txt.
E. Replace all occurrences of the entry hello with the entry fun.
F. Replace all occurrences of the entry fun with the entry hello.
Answer: ACE

Oracle   1Z0-402   1Z0-402 examen   1Z0-402   certification 1Z0-402   1Z0-402 examen

NO.22 You executed the following command to verify the integrity of sendmail:
What do infer about the /var/log/mail/statistics file from the output?
A. The permissions, user ownership, and file type have changed.
B. The permissions, group ownership and file type have changed.
C. The user ownership, group ownership and file type have changed.
D. The MD5 signature, file size, and modification time have changed.
Answer: D

Oracle   certification 1Z0-402   1Z0-402 examen   1Z0-402   1Z0-402

NO.23 As root you have changed the default login shell to one of the shells listed in /etc/shells file. Which file
entry is modified as a result of this?
A. /etc/shadow
B. /etc/shells
C. /etc/passwd
D. /etc/default/useradd
Answer: C

certification Oracle   1Z0-402 examen   certification 1Z0-402   certification 1Z0-402   1Z0-402

NO.24 Identify the shareable directories according to File system Hierarchy Standard (FHS).
(Choose all that apply.)
A. /etc
B. /usr
C. /var/run
D. /var/lock
E. /var/mail
F. /etc/sysconfig
Answer: BE

Oracle   1Z0-402 examen   certification 1Z0-402

NO.25 Identify the two main branches from the UNIX family tree, where the cross-pollination between these
branches was responsible for making UNIX so powerful. (Choose two.)
A. MIT
B. GNU
C. BSD
D. POSIX
E. BESYS
F. System V
Answer: CF

certification Oracle   1Z0-402   1Z0-402

NO.26 Examine the following output:
Which columns would you analyze to find the most recently invoked shell?
A. Analyze only the PID.
B. Analyze only the UID.
C. Analyze only the PPID.
D. Analyze both the UID and PID.
E. Analyze both the PID and PPID.
F. Analyze both the UID and PPID.
Answer: E

Oracle examen   1Z0-402   certification 1Z0-402   certification 1Z0-402

NO.27 As an administrator you want to make sure that accidentally you do not delete files using rm command.
You also want to make sure that even the use of rm command without any valid switches prompts for
confirmation before file deletion.
Which option would help you achieve this task?
A. alias rm="rm -i".
B. alias rm="rm -f".
C. alias rm="rm -r".
D. alias rm="rm -v".
Answer: A

Oracle examen   1Z0-402 examen   certification 1Z0-402   1Z0-402 examen

NO.28 Multiple users can share a UNIX machine. This is made possible by the OS by using one user's idle
time to service other users. What is this feature of an operating system identified as?
A. data sharing
B. time sharing
C. one-time initialization
D. light weight kernel threading
E. interrupt driven process handling
Answer: B

Oracle   1Z0-402 examen   1Z0-402   1Z0-402   certification 1Z0-402

NO.29 You have logged in as normal user bob with the default login shell. An attempt by bob to change the
default shell to /bin/sh fails with an error.
What could be the possible reason?
A. The SUID bit is not set on chsh by default.
B. The /bin/sh entry is not listed in /etc/shells file.
C. bob does not have the permissions to change the shell by default.
D. bob does not have read permissions on the/etc/shells file by default.
Answer: B

certification Oracle   certification 1Z0-402   1Z0-402 examen   1Z0-402   1Z0-402

NO.30 You have issued the following command:
mkdir -p test/a{dax,connor,bryan}g/vo{in,out,tmp}
Which of the following directories will it create? (Choose all that apply.)
A. test/voin/adaxg
B. test/adaxg/voout
C. test/aconnorg/voin
D. test/adaxnnorg/voinout
E. test/aconnoyang/vointmp
Answer: BC

certification Oracle   certification 1Z0-402   1Z0-402   1Z0-402 examen   1Z0-402 examen

Quand vous hésitez même à choisir Pass4Test, le démo gratuit dans le site Pass4Test est disponible pour vous à essayer avant d'acheter. Nos démos vous feront confiant à choisir Pass4Test. Pass4Test est votre meilleur choix à passer l'examen de Certification Oracle 1Z0-402, et aussi une meilleure assurance du succès du test 1Z0-402. Vous choisissez Pass4Test, vous choisissez le succès.

Certification Oracle de téléchargement gratuit pratique d'examen 1Z0-053, questions et réponses

Pass4Test est un site particulier à offrir les guides de formation à propos de test certificat IT. La version plus nouvelle de Q&A Oracle 1Z0-053 peut répondre sûrement une grande demande des candidats. Comme tout le monde le connait, le certificat Oracle 1Z0-053 est un point important pendant l'interview dans les grandes entreprises IT. Ça peut expliquer un pourquoi ce test est si populaire. En même temps, Pass4Test est connu par tout le monde. Choisir le Pass4Test, choisir le succès. Votre argent sera tout rendu si malheureusement vous ne passe pas le test Oracle 1Z0-053.

Pass4Test est un seul site de provider le guide d'étude Oracle 1Z0-053 de qualité. Peut-être que vous voyiez aussi les Q&A Oracle 1Z0-053 dans autres sites, mais vous allez découvrir laquelle est plus complète. En fait, Pass4Test est aussi une resource de Q&A pour les autres site web.

Si vous traviallez dur encore pour préparer le test de Oracle 1Z0-053 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-053.

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

Pass4Test possède une grande équipe composée des experts IT qui travaillent dur avec leurs riches expériences et connaissances pour produire un bon outil de formation. Selon les anciens test, le test simulation de Pass4Test est bien lié avec le test réel. Pass4Test peut vous assurer à réussir le test. Maintenant vous ajoutez votre outil de formation au panier, et votre rêve réalisera bien tôt.

La Q&A lancée par Pass4Test est bien poupulaire. Pass4Test peut non seulement vous permettre à appendre les connaissances professionnelles, et aussi les expériences importantes résumées par les spécialistes dans l'Industrie IT. Pass4Test est un bon fournisseur qui peut répondre une grande demande des candidats. Avec l'aide de Pass4Test, vous aurez la confiance pour réussir le test. Vous n'aurez pas aucune raison à refuser le Pass4Test.

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-053. Pass4Test a une expérience riche pour répondre les demandes des candidats.

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

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

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

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

Oracle   1Z0-053   1Z0-053

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

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

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

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

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

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

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

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

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

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

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

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

NO.9 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 examen   1Z0-053   1Z0-053   certification 1Z0-053   1Z0-053 examen

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

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

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

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

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

Oracle   1Z0-053   1Z0-053

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

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

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

Oracle   1Z0-053   certification 1Z0-053

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

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

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

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

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

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

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

Oracle examen   1Z0-053   1Z0-053 examen

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

Oracle   1Z0-053   1Z0-053

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

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

Les produits de Pass4Test sont préparés pour le test Certification Oracle 1Z0-053, y compris les formations et les informations ciblées au test Oracle 1Z0-053. D'ailleurs, la Q&A de Pass4Test qui est impressionnée par la grande couverture des questions et la haute précision des réponses vous permet à réussir le test avec une haute note.