Valid Oracle 1Z0-046 Exam Practice Test To Pass Exam Easily Free Download

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

Correct Answer: A QUESTION 2
You executed the following command on a Linux machine:
$ cat /proc/slabinfo | grep kio kioctx 270 270 128 9 9 1 : 252 126 kiocb 66080 66080 96 1652 1652 1 : 252 126 kiobuf 236 236 64 4 4 1 : 252 126
Which statement describes the purpose of executing the command?
A. To check the virtual memory usage in the Linux system
B. To compare the I/O statistics of different channels in the system
C. To check whether the asynchronous I/O is working in the Linux system
D. To check whether multiple data bus adapters are being used in the Linux system
E. To check whether the shared memory file system is being used in the Linux system

Correct Answer: C QUESTION 3
Which statement correctly describes the swap cache in the Linux memory model?
A. It is an area in the swap file that maintains the number of page ins and page outs for every process.
B. It contains the page entry table to record the addresses of in-memory pages that are not swapped out at all.
C. It is an area in the RAM that is used to record the number of swap in and swap out operation for every page.
D. It is an area in the RAM that tracks the pages that are swapped out and have not been modified since they were swapped out.

Correct Answer: D QUESTION 4
Which statement correctly describes the functionality of OS Watcher (OSW)?
A. It is a utility that gathers information about the database server and network in HTML format.
B. It is a collection of scripts that collects and archives the operating system (OS) and network metrics.
C. It is a utility that is used to prepare the setup before collecting information using the rda.sh -v command.
D. It is a Linux command that records and archives system calls triggered by processes as well as signals received by the processes.

Correct Answer: B QUESTION 5
Examine the content of the /proc/sys/kernel/tainted file on your Linux machine:
[[email protected] 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.

Correct Answer: E QUESTION 6
View the Exhibit and examine the highlighted entry.

You added a call to the oraenv script in a user’s login script. Which two statements are true about this entry? (Choose two.)
A. The entry will run the oraenv script in the current shell.
B. The entry will prompt the user for ORACLE_SID that the user wants to set.
C. The entry will call another script orainst to verify Oracle environment variables.
D. The entry will set up the ORACLE_HOME environment variable without prompting the user.

Correct Answer: AB QUESTION 7
You have the following operating system (OS) groups:
1)dba This is the OSDBA group.
2)oper This is the OSOPER group.
3)oinstall This is the owner of Oracle software.
Which groups do you need to assign to an OS user to enable that user to connect as “I as sysdba”?

A. Only 1
B. 1,2, and 3
C. 1 and 2; 3 not required
D. 2 and 3; 1 not required
E. 1 and 3; 2 not required

Correct Answer: A QUESTION 8
In an online transaction processing (OLTP) database, a large number of concurrent users are performing small transactions on a specific schema. You observe the statistics and find that total_waits for buffer busy event is increasing significantly. You are in the process of creating another OLTP database with similar workload. What would you do to avoid the wait event in the new database?
A. Consider setting a larger value for DB_BLOCK_SIZE for the database.
B. Consider setting a smaller value for DB_BLOCK_SIZE for the database.
C. Consider setting a larger value for the DB_CACHE_SIZE parameter for the database.
D. Consider using the DB_BLOCK_BUFFERS parameter instead of the DB_CACHE_SIZE parameter for the database.

Correct Answer: B QUESTION 9
You modified the Linux memory map and lowered mapped base for Oracle shared libraries to increase the System Global Area (SGA) size. Which three statements are true in this scenario? (Choose three.)
A. You cannot use the extended buffer cache feature.
B. You cannot use the Oracle Enterprise Manager (OEM) console.
C. All the components of SGA can make use of the additional memory allocated to SGA.
D. The database will not support dynamic SGA and multiple data block sizes.
E. You may need to retune the SORT_AREA_SIZE parameter because less virtual memory remains available for Program Global Area (PGA).
F. You must ensure that every Linux shell that spawns an Oracle process must have the same lowered mapped base as that for the Oracle shared libraries.

Correct Answer: CEF QUESTION 10
Following are the parameters set in your Oracle database instance:
USE_INDIRECT_DATA_BUFFERS=true DB_BLOCK_SIZE=8192 DB_BLOCK_BUFFERS=1048576 SHARED_POOL_SIZE=2831155200 You executed the following command: $ Is -al /dev/shm
total 120
drwxr-xr-x 1 oracle dba 0 Nov 20 16:29 . drwxr-xr-x 22 root root 118784 Nov 20 16:25 .. -rw-r—1 oracle dba 8589934592 Nov 20 16:30 ora_orcl_458754
Which statement is correct in this scenario?
A. The SGA is available in the shared memory file system.
B. The shared pool is available in the shared memory file system.
C. The database buffer cache is available in the shared memory file system.
D. Every oracle process can have virtual address space more than 4 GB. Correct Answer: C
QUESTION 11
You have an Oracle Database 10g installation on a Linux machine. The OS user, oracle, is the owner of the Oracle software. oracle is a member of osdba, osoper, and oinstall OS groups. You created another user on the OS and you want this user to access the database as “/ as sysdba”.
Which step would you perform to accomplish this task?
A. Assign the osdba group to the user.
B. Set the OS_AUTHENT_PREFIX parameter to “”.
C. Set the REMOTE_OS_AUTHENT parameter to TRUE.
D. Set the REMOTE_LOGIN_PASSWORDFILE parameter to none.

Correct Answer: A