Which three actions would you perform to increase the SGA size?

You are working in a Linux 32-bit processor environment with 4 GB RAM. You need to increase the size of System Global Area (SGA) from the maximum of 1.7 GB up to 2.7 GB by lowering the memory base and relocating SGA. Which three actions would you perform to increase the SGA size? (Choose three.) […]

Read More

Which three factors would affect the speed?

You are monitoring the input/output (I/O) speed of your system. Which three factors would affect the speed? (Choose three.) A.Wait time B.Transfer rate C.Service time D.Idle time percentage E.Number of user processes Show Answer

Read More

Which set of commands would you use to restore the original settings?

You attempt to modify the ksms.s library and relink the Oracle database executable to use theaddress 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 […]

Read More

Which two actions would you recommend in this scenario?

You require multiple groups of DBAs to administer different databases on the same server. Which two actions would you recommend in this scenario? (Choose two.) A.Run Oracle Universal Installer (OUI) as the user root. B.Create a separate OSDBA group for each set of databases. C.Create database instances in separate ORACLE_HOME directories. D.Create a separate OPER […]

Read More

Which three statements about the shmmax parameter are true?

Which three statements about the shmmax parameter are true? (Choose three.) A.Affects the kernel settings B.Specifies the maximum size of the swap C.Limits the size of the shared memory segments D.Sets the shared memory values only when a new shell is invoked E.Defines the maximum number of shared memory segments across the system F.Should be […]

Read More

Which two statements are correct about user1?

User1 is a member of the OSOPER group only. Which two statements are correct about user1? (Choose two.) A.User1 can create a database. B.User1 owns the Oracle database files. C.User1 owns the Oracle installation files. D.User1 can connect to the database as SYSOPER. E.User1 can connect to that database through operating system (OS) authentication. Show […]

Read More