Question 1

Consider an application in which memory required for each session is 400 KB and memory required for each server process is 4 MB. The pool size is 100 and the number of shared servers used is 100. If there are 5000 client connections, what is the amount of memory used by a dedicated server?

Options :

A : 615 MB

B : 2.5 GB

C : 4 GB

D : 12 GB

E : 22 GB

Answer: B

Question 2

You are about to apply a patch to a database. Which recommended action is incorrect?

Options :

A : You should check the patch conflict with installed patches before applying the patch

B : You should make sure that you have a good backup of the software, database, and configuration files.

C : You should install the latest O patch before applying the patch.

D : You should check the fifth digit of the release information to confirm that the Patch Set Update (PSU) is applied successfully.

E : You should stop all applications running from the software directory that is being patched.

Answer: B

Question 3

Which statement is true regarding this connect string?(DESCRIPTION(FAILOVER=on)(ADDRESS_LIST=(LOAD_BALANCE=ON)(ADDRESS=(host=sales-east1) (port=1522) )(ADDRESS=(host=sales-east2)(port=1522))(ADDRESS=(host=sales-east3) (port=1522) ))(ADDRESS_LIST=(LOAD_BALANCE=ON) (ADDRESS=(host=sales-west1) (port=1522) )(ADDRESS=(host=sales-west2) (port=JS22))(ADDRESS=(host=sales-west3) (port=lS22) ) )(CONNECT_DATA=(SERVICE_NAME=sales)(REGION=east)))

Options :

A : It contains three global service managers in the client's local region (east).

B : Client-side load balancing has been enabled only for the global service managers within the client's buddy (west).

C : Connect-time failover between regions has not been enabled.

D : The REGION parameter is optional.

Answer: D

Question 4

YOU want to move all objects of the CONSULTANT user from the test database to theDB-USER schema of the production database. Which option of IMPDP would you use to accomplish this task?c

Options :

A : FULL

B : SCHEMAS

C : TRANSFORM

D : REMAP_SCHEMA

E : REMAP_TABLESPACE

Answer: D

Question 5

Examine the command:sqlplus /nologIn which scenario would this command execute successfully?

Options :

A : only from the server, if the database instance is not up

B : from either a client or server, even if the database instance is not up

C : from either a client or server, only if the database instance is up, and the command connects the session to the instance

D : from either a client or server, only if the database instance is up, but the command does not connect the session to the instance

Answer: B

Smartly Prepare Exam with Free Online 1Z0-497 Practice Test

Buying Options: