Which three are types of segments in an Oracle Database? (Choose three.)

• A.clusters
• B.index
• C.tables
• D.sequences
• E.stored procedures
• F.undo

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.)

• A.Connect Time Failover requires the use of Transparent Application Failover (TAF)
• B.Source Routing requires the use of a name server
• C.Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall
• D.Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration
• E.Load Balancing requires the use of a name server
• F.Connect Time Failover requires the connect string to have two or more listener addresses configured

Comment: *

Name: *

Email: *

Verification: *

View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables.
You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval.
Examine this SQL statement:

Exhibit 1.

Exhibit 2.

What will be the result?

• A.It gives an error because the ALL keyword is not valid
• B.It gives an error because the GROUP BY clause is not valid
• C.It executes successfully but does not give the required result
• D.It executes successfully and gives the required result

Comment: *

Name: *

Email: *

Verification: *

You want to apply the principle of Least Privilege in all your live databases.
One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis.
Which three types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package? (Choose three.)

• A.analysis of all privileges used by all users including administrative users in the database
• B.analysis of all privileges used by all users but excluding administrative users in the database
• C.analysis of privileges that a user has on their own schema objects that they did not use
• D.analysis of privileges that a user has on their own schema objects that they did use
• E.analysis of privileges granted directly to a role that are then used by a user who has been granted that role
• F.analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about external tables in Oracle 18c and later releases? (Choose three.)

• A.They cannot be partitioned
• B.The ORACLE_LOADER access driver can be used to unload data from a database into an external table
• C.The ORACLE_DATAPUMP access driver can be used to load data into a database from an external table
• D.The ORACLE_DATAPUMP access driver can be used to unload data from a database into an external table
• E.They support UPDATEs but not INSERTs and DELETEs
• F.External table files can be used for other external tables in a different database

Comment: *

Name: *

Email: *

Verification: *