New Year Special Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: scxmas70

1z0-497 Exam Dumps - Oracle Database 12c Essentials

Go to page:
Question # 4

Which three statements about common and local roles are true?

A.

When a role is granted to a user, the privileges in the role are limited to the context of the PDB.

B.

Local roles can be granted only to local users.

C.

Common roles can be granted to both local and common users.

D.

A user can create common roles if the user has the CREATE ROLE privilege, and SET CONTAINER for all PDBs

E.

Common roles can be created in the root and PDBs.

Full Access
Question # 5

Which four statements about users in Oracle Database 12c are correct?

A.

A common user cannot have the same name as any local user across all PDBs.

B.

A common user can be created only in the root container.

C.

A local user with the proper privileges can also create a common user.

D.

If a PDB is closed, the common and local users of the PDB are not visible.

E.

A common user with the proper privileges can create a common user by using the CONTAINER=CURRENT clause.

F.

A common user is one that has the same username and authentication credentials across multiple PDBs.

Full Access
Question # 6

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

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.

Full Access
Question # 7

Your customer is looking for zero-data-loss failover with maximum data protection and high availability for their primary database. Which two solutions would you recommend to the customer if the distance between the primary and the standby location is more than 300 miles?

A.

Asynchronous redo transport with Data Guard

B.

Synchronous redo transport with Data Guard

C.

Active Data Guard Far Sync

D.

Data Guard SQL Apply

Full Access
Question # 8

A standby database is in mounted state and you are required to perform a failover to the physical standby. Which solution is best suited forthis scenario?

A.

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE statement with the FINISH keyword

B.

ALTER DATABASE PREPARE TO SWITCHOVER and ALTER DATABASE COMMIT TO SWITCHOVER statements

C.

ALTER DATABASE RECOVER TO STANDBY DATABASE statement with the FINISH keyword

D.

D) ALTER DATABASE PREPARE SWITCHOVER and ALTER DATABASE COMMIT TO SWITCHOVER Statements

Full Access
Go to page: