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

But que Pass4Test n'offre que les produits de qualité est pour vous aider à réussir le test Oracle 1Z0-046 100%. Le test simulation offert par Pass4Test est bien proche de test réel. Si vous ne pouvez pas passer le test Oracle 1Z0-046, votre argent sera tout rendu.

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

Code d'Examen: 1Z0-046
Nom d'Examen: Oracle (Oracle Database 10g: Managing Oracle on Linux for DBAs)
Questions et réponses: 120 Q&As

Pass4Test possède un l'outil de formation particulier à propos de test Oracle 1Z0-046. Vous pouvez améliorer les techniques et connaissances professionnelles en coûtant un peu d'argent à courte terme, et vous preuver la professionnalité dans le future proche. L'outil de formation Oracle 1Z0-046 offert par Pass4Test est recherché par les experts de Pass4Test en profitant les expériences et les connaissances riches.

Beaucoup de travailleurs espèrent obtenir quelques Certificat IT pour avoir une plus grande space de s'améliorer. Certains certificats peut vous aider à réaliser ce rêve. Le test Oracle 1Z0-046 est un certificat comme ça. Mais il est difficile à réussir. Il y a plusieurs façons pour se préparer, vous pouvez dépenser plein de temps et d'effort, ou vous pouvez choisir une bonne formation en Internet. Pass4Test est un bon fournisseur de l'outil formation de vous aider à atteindre votre but. Selons vos connaissances à propos de Pass4Test, vous allez faire un bon choix de votre formation.

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

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

NO.1 You need to ensure that whenever you create a new file, it should have the following set of permissions:
u=rwx,g=rx,o=rx.
Which statement can you add to the .bashrc script to set the desired file permissions?
A.umask 455
B.umask 012
C.umask 0755
D.chmod u=rwx,g=rx,o=rx
ANSWER: C

Oracle   certification 1Z0-046   1Z0-046 examen   1Z0-046 examen   1Z0-046

NO.2 ho.sh is an executable shell script. You executed the following command that leads to an error:
$ strace -o /tmp/ho.out ./ho.sh
strace: exec: Permission denied
What could you do to execute the command successfully in the next attempt?
A.Provide the shell reference with the command.
B.Remove the shell reference present inside the shell script.
C.Execute the command as the root operating system user.
D.The extension for the output file should be changed to .log.
ANSWER: A

Oracle examen   certification 1Z0-046   1Z0-046   1Z0-046

NO.3 You executed the ipcs -m command to list all the shared memory segments in your Oracle server.
View the Exhibit exhibit1 that shows the output of this command.
Later, you executed the same command to check the shared memory segments.
View the Exhibit exhibit2 that shows the output of this command.
Why is the large shared memory segment not listed in the second Exhibit?
A.The Oracle database instance is shut down.
B.The swap space has been increased in the system.
C.The Oracle database instance is configured in shared server mode.
D.The large pool size set for the Oracle database instance is reset to zero.
ANSWER: A

Oracle   1Z0-046   certification 1Z0-046   1Z0-046

NO.4 Which three statements are true about Oracle Clustered File System (OCFS)? (Choose three.)
A.There is no limit on the number of files on OCFS.
B.You can use OCFS for database files as well as general files.
C.You can create an OCFS using Logical Volume Manager (LVM).
D.You must modify the Linux kernel parameters before mounting OCFS.
E.Standard file system commands, such as mkdir, rmdir, and mv, are available on OCFS.
ANSWER: ABE

Oracle   certification 1Z0-046   1Z0-046   1Z0-046 examen

NO.5 Which three statements are true about the built-in shell variables? (Choose three.)
A.The $? variable stores true and false values.
B.The $* variable stores all the command-line parameters passed.
C.The $# variable stores the total number of command-line parameters.
D.The values for these variables are retained in the session until it is reset.
E.The $n variable can store n number of positional command-line parameters.
ANSWER: BCE

certification Oracle   certification 1Z0-046   1Z0-046   1Z0-046

NO.6 View the Exhibit.
Which two statements are true about the output of the cat /proc/partitions command? (Choose two.)
A.The hard disk has four partitions.
B.The hard disk has six partitions.
C.The swap partition is not shown in the output.
D.The major column shows the device number with partitions.
E.The #blocks column shows the number of inode blocks in that partition.
ANSWER: AD

Oracle examen   certification 1Z0-046   1Z0-046   certification 1Z0-046

NO.7 View the Exhibit and examine the output.
What do you infer from this? (Choose all that apply.)
A.The command output is stored in the pmon.txt file.
B.The command shows all the processes running on the machine.
C.The command appends the pmon.txt file with the output of the command.
D.The command shows only those processes that contain the text _pmon running on your machine.
E.The logs generated while executing the command will be stored in the pmon.txt file.
ANSWER: AD

Oracle   1Z0-046   certification 1Z0-046   1Z0-046

NO.8 The OS user BOB is a member the osoper OS group in the database server. You want BOB :
Which of the option would fulfill the requirement?
A.Assign the sysdba privilege to BOB.
B.Assign the osdba OS group to BOB.
C.Set the REMOTE_LOGIN_PASSWORDFILE initialization parameter to SHARED.
D.Set the REMOTE_LOGIN_PASSWORDFILE initialization parameter to EXCLUSIVE.
ANSWER: B

Oracle   1Z0-046   certification 1Z0-046   1Z0-046

NO.9 View the following script:
if [ -r /etc/oratab ]
then
ORATAB=/etc/oratab
else
if [ -r /var/opt/oracle/oratab ]
then
ORATAB=/var/opt/oracle/oratab
else
echo "Can't find any oratab file"
exit 1
fi
fi
grep -v [\#\*] $ORATAB | cut -d ":" -f1
Which statement is true about the execution and output of the script?
A.It will execute only in the /etc/oratab directory.
B.It will show all the Oracle homes listed in the oratab file on the local machine.
C.It will show all Oracle database SIDs listed in the oratab file on the local machine.
D.The script output will depend on the command-line arguments passed while executing the script.
ANSWER: C

Oracle examen   1Z0-046 examen   1Z0-046   1Z0-046

NO.10 You attempt to modify the ksms.s library and relink the Oracle database executable to use the address
0X15000000 for the System Global Area (SGA). You receive an error.
Which set of commands would you use to restore the original settings?
A.echo 0X1000000 > ksms.s
make -f ins_rdbms.mk ksms.s
B.echo 0X15000000 > ksms.s
make -f ins_rdbms.mk ioracle
C.make -f ins_rdbms.mk ksms.s
make -f ins_rdbms.mk ioracle
D.genksms > ksms.s
make -f ins_rdbms.mk ksms.o
make -f ins_rdbms.mk ioracle
E.genksms -s 0X10000000 > ksms.o
ANSWER: D

Oracle   1Z0-046 examen   certification 1Z0-046   1Z0-046   certification 1Z0-046

NO.11 Which command is used to identify the kernel version number?
A.which
B.whatis
C.uname -r
D.ulimit -m
E.chkconfig
ANSWER: C

certification Oracle   1Z0-046 examen   certification 1Z0-046   1Z0-046   1Z0-046 examen   1Z0-046 examen

NO.12 In an online transaction processing (OLTP) database instance that involves a high volume of data
manipulation language (DML) operations, you decide to increase the value of the LOG_BUFFER
parameter.
What could be the reason for this change?
A.The buffer busy wait event has been detected.
B.The no free buffers event has been detected.
C.The log buffer space wait event has been detected.
D.The log file completion wait event has been detected.
E.The value for the free buffer inspected statistics is growing.
ANSWER: C

Oracle   certification 1Z0-046   1Z0-046   1Z0-046

NO.13 Which command would you use to identify the users that belong to the oradba group?
A.id -G
B.uname -g
C.grep

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

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.

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

Peut-être vous voyez les guides d'études similaires pour le test Oracle 1Z0-046, mais nous avons la confiance que vous allez nous choisir finalement grâce à notre gravité d'état dans cette industrie et notre profession. Pass4Test se contribue à amérioler votre carrière. Vous saurez que vous êtes bien préparé à passer le test Oracle 1Z0-046 lorsque vous choisissez la Q&A de Pass4Test. De plus, un an de service gratuit en ligne après vendre est aussi disponible pour vous.

Pass4Test peut offrir la facilité aux candidats qui préparent le test Oracle 1Z0-046. Nombreux de candidats choisissent le Pass4Test à préparer le test et réussir finalement à la première fois. Les experts de Pass4Test sont expérimentés et spécialistes. Ils profitent leurs expériences riches et connaissances professionnelles à rechercher la Q&A Oracle 1Z0-046 selon le résumé de test réel Oracle 1Z0-046. Vous pouvez réussir le test à la première fois sans aucune doute.

Vous choisissez l'aide de Pass4Test, Pass4Test fait tous effort à vous aider à réussir le test. De plus, la mise à jour de Q&A pendant un an est gratuite pour vous. Vous n'avez plus raison à hésiter. Pass4Test est une meilleure assurance pour le succès de test Oracle 1Z0-046. Ajoutez la Q&A au panier.

Finalement, la Q&A Oracle 1Z0-046 plus nouvelle est lancé avec tous efforts des experts de Pass4Test. Aujourd'hui, dans l'Industrie de IT, si on veut se renforcer sa place, il faut se preuve la professionnalité aux les autres. Le test Oracle 1Z0-046 est une bonne examination des connaissances professionnelles. Avec le passport de la Certification Oracle, vous aurez un meilleur salaire et une plus grande space à se développer.

On peut télécharger quelques parties de Q&A gratuites dans le site Pass4Test à propos de test Certification Oracle 1Z0-046. Vous pouvez tester notre fiabilité via le démo. Choisir Pass4Test, c'est-à-dire que vous êtes proche d'un pic ensuite de l'Industrie IT.

Code d'Examen: 1Z0-046
Nom d'Examen: Oracle (Oracle Database 10g: Managing Oracle on Linux for DBAs)
Questions et réponses: 120 Q&As

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

NO.1 View the Exhibit and examine the output.
What do you infer from this? (Choose all that apply.)
A.The command output is stored in the pmon.txt file.
B.The command shows all the processes running on the machine.
C.The command appends the pmon.txt file with the output of the command.
D.The command shows only those processes that contain the text _pmon running on your machine.
E.The logs generated while executing the command will be stored in the pmon.txt file.
ANSWER: AD

Oracle examen   1Z0-046   1Z0-046 examen   1Z0-046 examen   1Z0-046 examen

NO.2 Match the following commands with the purpose they are used for:
i chmod a) To create a file with the desired time stamp
ii touch b) To use the variable of the parent shell in child shell
iii alias c) To give write permission to a directory
iv uname d) To simplify long commands
v export e) To see the Linux release number
A.i-a, ii-e, iii-d, iv-c, v-b
B.i-c, ii-a, iii-e, iv-d, v-b
C.i-c, ii-e, iii-b, iv-a, v-b
D.i-c, ii-a, iii-d, iv-e, v-b
ANSWER: D

Oracle   1Z0-046   certification 1Z0-046

NO.3 You executed the ipcs -m command to list all the shared memory segments in your Oracle server.
View the Exhibit exhibit1 that shows the output of this command.
Later, you executed the same command to check the shared memory segments.
View the Exhibit exhibit2 that shows the output of this command.
Why is the large shared memory segment not listed in the second Exhibit?
A.The Oracle database instance is shut down.
B.The swap space has been increased in the system.
C.The Oracle database instance is configured in shared server mode.
D.The large pool size set for the Oracle database instance is reset to zero.
ANSWER: A

Oracle   1Z0-046   1Z0-046 examen   1Z0-046   1Z0-046   certification 1Z0-046

NO.4 Which three statements are true about the built-in shell variables? (Choose three.)
A.The $? variable stores true and false values.
B.The $* variable stores all the command-line parameters passed.
C.The $# variable stores the total number of command-line parameters.
D.The values for these variables are retained in the session until it is reset.
E.The $n variable can store n number of positional command-line parameters.
ANSWER: BCE

certification Oracle   1Z0-046   1Z0-046 examen   1Z0-046   1Z0-046   1Z0-046 examen

NO.5 In an online transaction processing (OLTP) database instance that involves a high volume of data
manipulation language (DML) operations, you decide to increase the value of the LOG_BUFFER
parameter.
What could be the reason for this change?
A.The buffer busy wait event has been detected.
B.The no free buffers event has been detected.
C.The log buffer space wait event has been detected.
D.The log file completion wait event has been detected.
E.The value for the free buffer inspected statistics is growing.
ANSWER: C

Oracle   certification 1Z0-046   1Z0-046   1Z0-046   1Z0-046

NO.6 You want to install Oracle Database 10g on a Linux machine. You want to ensure that no tainted
modules are loaded on the kernel. Which commands will you execute to achieve this?
A.uname -r
B.uname -v
C.cat /proc/version
D.cat /proc/sys/kernel/tainted
ANSWER: D

certification Oracle   certification 1Z0-046   1Z0-046

NO.7 Which three statements are true about Oracle Clustered File System (OCFS)? (Choose three.)
A.There is no limit on the number of files on OCFS.
B.You can use OCFS for database files as well as general files.
C.You can create an OCFS using Logical Volume Manager (LVM).
D.You must modify the Linux kernel parameters before mounting OCFS.
E.Standard file system commands, such as mkdir, rmdir, and mv, are available on OCFS.
ANSWER: ABE

Oracle   1Z0-046 examen   certification 1Z0-046

NO.8 You logged in as user user1 on a Linux machine. You need to check which groups you belong to.
Which commands will you use? (Choose two.)
A.id
B.uname -G
C.cat /etc/passwd
D.cat /etc/group
E.cat .bash_profile
ANSWER: AD

certification Oracle   1Z0-046   1Z0-046

NO.9 ho.sh is an executable shell script. You executed the following command that leads to an error:
$ strace -o /tmp/ho.out ./ho.sh
strace: exec: Permission denied
What could you do to execute the command successfully in the next attempt?
A.Provide the shell reference with the command.
B.Remove the shell reference present inside the shell script.
C.Execute the command as the root operating system user.
D.The extension for the output file should be changed to .log.
ANSWER: A

Oracle   1Z0-046 examen   certification 1Z0-046

NO.10 Which command is used to identify the kernel version number?
A.which
B.whatis
C.uname -r
D.ulimit -m
E.chkconfig
ANSWER: C

certification Oracle   1Z0-046 examen   certification 1Z0-046

NO.11 View the following script:
if [ -d $1 ]
then
for Data in `ls $1 *|tr -s " "| grep .dbf`
do
echo $Data
done
else
echo -e "No Directory specified"
fi
Which statement is true about the script?
A.The script displays the total number of .dbf files on the local machine.
B.The script will not execute because no value for the $1 variable is given.
C.The script displays the .dbf files in the location given as a value in the positional parameter.
D.The script will give an error because the variable name should contain the letters of the English
alphabet.
ANSWER: C

certification Oracle   certification 1Z0-046   1Z0-046 examen

NO.12 View the following script:
if [ -r /etc/oratab ]
then
ORATAB=/etc/oratab
else
if [ -r /var/opt/oracle/oratab ]
then
ORATAB=/var/opt/oracle/oratab
else
echo "Can't find any oratab file"
exit 1
fi
fi
grep -v [\#\*] $ORATAB | cut -d ":" -f1
Which statement is true about the execution and output of the script?
A.It will execute only in the /etc/oratab directory.
B.It will show all the Oracle homes listed in the oratab file on the local machine.
C.It will show all Oracle database SIDs listed in the oratab file on the local machine.
D.The script output will depend on the command-line arguments passed while executing the script.
ANSWER: C

Oracle   1Z0-046   certification 1Z0-046

NO.13 You have started an instance with the DBWR_IO_SLAVES initialization parameter set to 2. What will
be the result of setting this parameter? (Choose two.)
A.The DISK_ASYNCH_IO initialization parameter will be set to True.
B.The TAPE_ASYNCH_IO initialization parameter will be set to True.
C.The database instance will simulate asynchronous input/output (I/O).
D.Oracle server will update the value for the DB_CACHE_SIZE initialization parameter as per the system
requirement.
E.If the existing value of the DB_WRITER_PROCESSES initialization parameter is set to greater than 1,
then the DB_WRITER_PROCESSES parameter will be set to 1.
habet.
ANSWER: CE

Oracle   1Z0-046 examen   1Z0-046 examen   1Z0-046   1Z0-046 examen

NO.14 You need to ensure that whenever you create a new file, it should have the following set of permissions:
u=rwx,g=rx,o=rx.
Which statement can you add to the .bashrc script to set the desired file permissions?
A.umask 455
B.umask 012
C.umask 0755
D.chmod u=rwx,g=rx,o=rx
ANSWER: C

certification Oracle   1Z0-046   certification 1Z0-046   certification 1Z0-046

NO.15 Which command would you use to identify the users that belong to the oradba group?
A.id -G
B.uname -g
C.grep

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

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.

Vous n'avez besoin que de faire les exercices à propos du test Oracle 1Z0-046 offertes par Pass4Test, vous pouvez réussir le test sans aucune doute. Et ensuite, vous aurez plus de chances de promouvoir avec le Certificat. Si vous ajoutez le produit au panier, nous vous offrirons le service 24h en ligne.

Le Certificat de Oracle 1Z0-046 peut vous aider à monter un autre degré de votre carrière, même que votre niveau de vie sera amélioré. Avoir un Certificat Oracle 1Z0-046, c'est-à-dire avoir une grande fortune. Le Certificat Oracle 1Z0-046 peut bien tester des connaissances professionnelles IT. La Q&A Oracle 1Z0-046 plus nouvelle vient de sortir qui peut vous aider à faciilter le cours de test préparation. Notre Q&A comprend les meilleurs exercices, test simulation et les réponses.

Code d'Examen: 1Z0-046
Nom d'Examen: Oracle (Oracle Database 10g: Managing Oracle on Linux for DBAs)
Questions et réponses: 120 Q&As

Le test Oracle 1Z0-046 est bien populaire dans l'Industrie IT. Mais ça coûte beaucoup de temps pour bien préparer le test. Le temps est certainemetn la fortune dans cette société. L'outil de formation offert par Pass4Test ne vous demande que 20 heures pour renforcer les connaissances essentales pour le test Oracle 1Z0-046. Vous aurez une meilleure préparation bien que ce soit la première fois à participer le test.

Avec la version plus nouvelle de Q&A Oracle 1Z0-046, réussir le test Oracle 1Z0-046 n'est plus un rêve très loin pour vous. Pass4Test peut vous aider à réaliser ce rêve. Le test simualtion de Pass4Test est bien proche du test réel. Vous aurez l'assurance à réussir le test avec le guide de Pass4Test. Voilà, le succès est juste près de vous.

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

NO.1 The OS user BOB is a member the osoper OS group in the database server. You want BOB :
Which of the option would fulfill the requirement?
A.Assign the sysdba privilege to BOB.
B.Assign the osdba OS group to BOB.
C.Set the REMOTE_LOGIN_PASSWORDFILE initialization parameter to SHARED.
D.Set the REMOTE_LOGIN_PASSWORDFILE initialization parameter to EXCLUSIVE.
ANSWER: B

Oracle examen   1Z0-046   certification 1Z0-046   certification 1Z0-046

NO.2 ho.sh is an executable shell script. You executed the following command that leads to an error:
$ strace -o /tmp/ho.out ./ho.sh
strace: exec: Permission denied
What could you do to execute the command successfully in the next attempt?
A.Provide the shell reference with the command.
B.Remove the shell reference present inside the shell script.
C.Execute the command as the root operating system user.
D.The extension for the output file should be changed to .log.
ANSWER: A

certification Oracle   1Z0-046   1Z0-046   1Z0-046   1Z0-046

NO.3 You executed the ipcs -m command to list all the shared memory segments in your Oracle server.
View the Exhibit exhibit1 that shows the output of this command.
Later, you executed the same command to check the shared memory segments.
View the Exhibit exhibit2 that shows the output of this command.
Why is the large shared memory segment not listed in the second Exhibit?
A.The Oracle database instance is shut down.
B.The swap space has been increased in the system.
C.The Oracle database instance is configured in shared server mode.
D.The large pool size set for the Oracle database instance is reset to zero.
ANSWER: A

Oracle   1Z0-046   1Z0-046 examen   1Z0-046 examen

NO.4 View the following script:
if [ -d $1 ]
then
for Data in `ls $1 *|tr -s " "| grep .dbf`
do
echo $Data
done
else
echo -e "No Directory specified"
fi
Which statement is true about the script?
A.The script displays the total number of .dbf files on the local machine.
B.The script will not execute because no value for the $1 variable is given.
C.The script displays the .dbf files in the location given as a value in the positional parameter.
D.The script will give an error because the variable name should contain the letters of the English
alphabet.
ANSWER: C

certification Oracle   1Z0-046 examen   1Z0-046 examen

NO.5 Which three statements are true about the built-in shell variables? (Choose three.)
A.The $? variable stores true and false values.
B.The $* variable stores all the command-line parameters passed.
C.The $# variable stores the total number of command-line parameters.
D.The values for these variables are retained in the session until it is reset.
E.The $n variable can store n number of positional command-line parameters.
ANSWER: BCE

Oracle examen   1Z0-046 examen   1Z0-046   1Z0-046   1Z0-046

NO.6 Examine the content of the /proc/sys/kernel/tainted file on your Linux machine:
[root@edtdr6p1 root]# cat /proc/sys/kernel/tainted
1
What will happen when you install Oracle Database 10g on this machine?
A.Installation will fail because of the tainted kernel.
B.Installation will be successful, but Oracle will not provide support for the database product.
C.Installation will be successful. Oracle will provide support for the database product but not for the
operating system (OS).
D.Installation will be successful and Oracle will provide support for the database product as well as the
OS.
E.Successful installation and Oracle support for database product as well as Linux OS will depend on the
module tainting the kernel.
ANSWER: E

Oracle   1Z0-046 examen   1Z0-046 examen   1Z0-046   certification 1Z0-046

NO.7 You attempt to modify the ksms.s library and relink the Oracle database executable to use the address
0X15000000 for the System Global Area (SGA). You receive an error.
Which set of commands would you use to restore the original settings?
A.echo 0X1000000 > ksms.s
make -f ins_rdbms.mk ksms.s
B.echo 0X15000000 > ksms.s
make -f ins_rdbms.mk ioracle
C.make -f ins_rdbms.mk ksms.s
make -f ins_rdbms.mk ioracle
D.genksms > ksms.s
make -f ins_rdbms.mk ksms.o
make -f ins_rdbms.mk ioracle
E.genksms -s 0X10000000 > ksms.o
ANSWER: D

Oracle   1Z0-046   1Z0-046   1Z0-046

NO.8 You logged in as user user1 on a Linux machine. You need to check which groups you belong to.
Which commands will you use? (Choose two.)
A.id
B.uname -G
C.cat /etc/passwd
D.cat /etc/group
E.cat .bash_profile
ANSWER: AD

Oracle examen   1Z0-046   1Z0-046 examen

NO.9 You have started an instance with the DBWR_IO_SLAVES initialization parameter set to 2. What will
be the result of setting this parameter? (Choose two.)
A.The DISK_ASYNCH_IO initialization parameter will be set to True.
B.The TAPE_ASYNCH_IO initialization parameter will be set to True.
C.The database instance will simulate asynchronous input/output (I/O).
D.Oracle server will update the value for the DB_CACHE_SIZE initialization parameter as per the system
requirement.
E.If the existing value of the DB_WRITER_PROCESSES initialization parameter is set to greater than 1,
then the DB_WRITER_PROCESSES parameter will be set to 1.
habet.
ANSWER: CE

Oracle examen   1Z0-046 examen   1Z0-046

NO.10 View the following script:
if [ -r /etc/oratab ]
then
ORATAB=/etc/oratab
else
if [ -r /var/opt/oracle/oratab ]
then
ORATAB=/var/opt/oracle/oratab
else
echo "Can't find any oratab file"
exit 1
fi
fi
grep -v [\#\*] $ORATAB | cut -d ":" -f1
Which statement is true about the execution and output of the script?
A.It will execute only in the /etc/oratab directory.
B.It will show all the Oracle homes listed in the oratab file on the local machine.
C.It will show all Oracle database SIDs listed in the oratab file on the local machine.
D.The script output will depend on the command-line arguments passed while executing the script.
ANSWER: C

Oracle examen   1Z0-046   1Z0-046   1Z0-046   1Z0-046 examen

NO.11 Which three statements are true about Oracle Clustered File System (OCFS)? (Choose three.)
A.There is no limit on the number of files on OCFS.
B.You can use OCFS for database files as well as general files.
C.You can create an OCFS using Logical Volume Manager (LVM).
D.You must modify the Linux kernel parameters before mounting OCFS.
E.Standard file system commands, such as mkdir, rmdir, and mv, are available on OCFS.
ANSWER: ABE

Oracle   1Z0-046 examen   1Z0-046   certification 1Z0-046   1Z0-046

NO.12 In an online transaction processing (OLTP) database instance that involves a high volume of data
manipulation language (DML) operations, you decide to increase the value of the LOG_BUFFER
parameter.
What could be the reason for this change?
A.The buffer busy wait event has been detected.
B.The no free buffers event has been detected.
C.The log buffer space wait event has been detected.
D.The log file completion wait event has been detected.
E.The value for the free buffer inspected statistics is growing.
ANSWER: C

Oracle   1Z0-046   1Z0-046   1Z0-046

NO.13 You need to ensure that whenever you create a new file, it should have the following set of permissions:
u=rwx,g=rx,o=rx.
Which statement can you add to the .bashrc script to set the desired file permissions?
A.umask 455
B.umask 012
C.umask 0755
D.chmod u=rwx,g=rx,o=rx
ANSWER: C

certification Oracle   1Z0-046 examen   1Z0-046   1Z0-046

NO.14 Match the following commands with the purpose they are used for:
i chmod a) To create a file with the desired time stamp
ii touch b) To use the variable of the parent shell in child shell
iii alias c) To give write permission to a directory
iv uname d) To simplify long commands
v export e) To see the Linux release number
A.i-a, ii-e, iii-d, iv-c, v-b
B.i-c, ii-a, iii-e, iv-d, v-b
C.i-c, ii-e, iii-b, iv-a, v-b
D.i-c, ii-a, iii-d, iv-e, v-b
ANSWER: D

Oracle   1Z0-046 examen   1Z0-046 examen

NO.15 Which command would you use to identify the users that belong to the oradba group?
A.id -G
B.uname -g
C.grep

Oracle 1Z0-046 1Z0-043 1Z0-040 1Z0-042, de formation et d'essai

Aujourd'hui, il y a pleine de professionnels IT dans cette société. Ces professionnels sont bien populaires mais ils ont à être en face d'une grande compétition. Donc beaucoup de professionnels IT se prouver par les tests de Certification très difficile à réussir. Pass4Test est voilà pour offrir un raccourci au succès de test Certification.

Chaque expert dans l'équipe de Pass4Test ont son autorité dans cette industrie. Ils profitent ses expériences et ses connaissances professionnelles à préparer les documentations pour les candidats de test Certification IT. Les Q&As produites par Pass4Test ont une haute couverture des questions et une bonne précision des réponses qui vous permettent la réussie de test par une seule fois. D'ailleurs, un an de service gratuit en ligne après vendre est aussi disponible pour vous.

Pass4Test vous offre un choix meilleur pour faire votre préparation de test Oracle 1Z0-046 1Z0-043 1Z0-040 1Z0-042 plus éfficace. Si vous voulez réussir le test plus tôt, il ne faut que ajouter la Q&A de Oracle 1Z0-046 1Z0-043 1Z0-040 1Z0-042 à votre cahier. Pass4Test serait votre guide pendant la préparation et vous permet à réussir le test Oracle 1Z0-046 1Z0-043 1Z0-040 1Z0-042 sans aucun doute. Vous pouvez obtenir le Certificat comme vous voulez.

Code d'Examen: 1Z0-046

Nom d'Examen: Oracle (Oracle Database 10g: Managing Oracle on Linux for DBAs)

Questions et réponses: 120 Q&As

Code d'Examen: 1Z0-043

Nom d'Examen: Oracle (Oracle database 10g:Administration ii)

Questions et réponses: 186 Q&As

Code d'Examen: 1Z0-040

Nom d'Examen: Oracle (Oracle database 10g:new features for adminsitrators)

Questions et réponses: 200 Q&As

Code d'Examen: 1Z0-042

Nom d'Examen: Oracle (Oracle database 10g:Administration I)

Questions et réponses: 185 Q&As

Les produits de Pass4Test sont préparés pour le test Certification Oracle 1Z0-046 1Z0-043 1Z0-040 1Z0-042, y compris les formations et les informations ciblées au test Oracle 1Z0-046 1Z0-043 1Z0-040 1Z0-042. 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.

Les experts de Pass4Test ont fait sortir un nouveau guide d'étude de Certification Oracle 1Z0-046 1Z0-043 1Z0-040 1Z0-042, avec ce guide d'étude, réussir ce test a devenu une chose pas difficile. Pass4Test vous permet à réussir 100% le test Oracle 1Z0-046 1Z0-043 1Z0-040 1Z0-042 à 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.

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

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

NO.1 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   certification 1Z0-040   1Z0-040   1Z0-040

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

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

NO.3 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   1Z0-040   1Z0-040

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

Oracle examen   1Z0-040   1Z0-040   1Z0-040   certification 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 examen   1Z0-040   1Z0-040 examen

NO.6 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   1Z0-040 examen

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   1Z0-040   certification 1Z0-040   1Z0-040 examen   1Z0-040

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

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

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   certification 1Z0-040   1Z0-040 examen

NO.10 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   certification 1Z0-040   1Z0-040

NO.11 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   certification 1Z0-040   1Z0-040 examen   1Z0-040 examen   1Z0-040 examen

NO.12 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   certification 1Z0-040   certification 1Z0-040

NO.13 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   1Z0-040

NO.14 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 examen   1Z0-040   1Z0-040

NO.15 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   certification 1Z0-040

NO.16 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 examen   1Z0-040   1Z0-040   certification 1Z0-040   1Z0-040 examen   1Z0-040

NO.17 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   certification 1Z0-040   1Z0-040

NO.18 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 examen

NO.19 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   certification 1Z0-040   1Z0-040

NO.20 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   1Z0-040   certification 1Z0-040