Exit demo 1Z0-046 Oracle Database 10g: Managing Oracle on Linux for DBAs PDF format · free preview

Oracle 1Z0-046 - Questions & Answers

Free preview · every answer includes a full explanation

Product page: https://prepkeys.com/1z0-046.html

Question 1
Single choice

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.

Question 2
Single choice

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

Question 3
Single choice

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.

Question 4
Single choice

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.

Question 5
Single choice

Examine the content of the /proc/sys/kernel/tainted file on your Linux machine:

[root@edtdt6p1 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.

Question 6
Multiple choice

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.

Question 7
Single choice

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

Question 8
Single choice

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.

Question 9
Multiple choice

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.

Question 10
Single choice

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.

Showing 10 of 117 questions · Unlock the full set