Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY.
Only the EMPLOYEE_ID column is indexed.
Rows exist for employees 100 and 200.
Examine this statement:

Which two statements are true? (Choose two.)

• A.Employees 100 and 200 will have the same JOB_ID as before the update command
• B.Employees 100 and 200 will have the same SALARY as before the update command
• C.Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200
• D.Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100
• E.Employee 200 will have SALARY set to the same value as the SALARY of employee 100
• F.Employee 100 will have SALARY set to the same value as the SALARY of employee 200

Comment: *

Name: *

Email: *

Verification: *

Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces? (Choose three.)

• A.Oracle Managed Files (OMF)
• B.Online table segment shrink
• C.Online index segment shrink
• D.Automatic data file extension (AUTOEXTEND)
• E.Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR)

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about Enterprise Manager Database Express? (Choose two.)

• A.It is available only when the database is open
• B.It can be used to perform database recovery
• C.The same port number can be used for Database Express configurations for databases on different hosts
• D.It can be used to switch a database into ARCHIVELOGMODE
• E.The same port number can be used for multiple Database Express configurations for multiple databases on the same host

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

You want to use table compression suitable for OLTP that will:
1. Compress rows for all DML statements on that table
2. Minimize the overheads associated with compression
Which compression option is best suited for this?

• A.COLUMN STORE COMPRESS FOR QUERY LOW
• B.ROW STORE COMPRESS BASIC
• C.COLUMN STORE COMPRESS FOR ARCHIVE LOW
• D.COLUMN STORE COMPRESS FOR ARCHIVE HIGH
• E.ROW STORE COMPRESS ADVANCED

Comment: *

Name: *

Email: *

Verification: *