Question 1

Which option represents a function of Global Data Services (GDS)?

Options :

A : performs data replication

B : performs database failovers

C : replaces the functionality of Oracle Clusterware and Oracle RAC

D : coordinates site failovers

E : works seamlessly with Oracle Site Guard

Answer: A,B

Question 2

Which two statements about Automatic Data Optimization (ADO) are true?

Options :

A : ADO policies can automatically compress data when it qualifies.

B : ADO policies can automatically move segments when necessary.

C : ADO is not dependent on Heat Map, and works even if Heat Map is disabled.

D : You cannot compress at block level, but you can compress at segment level.

E : You can compress at row level only for QUERY LOW.

Answer: D,E

Question 3

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 4

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 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: