Which two are true about shrinking a segment online? (Choose two.)

• A.It is not possible to shrink either indexes or Index Organized Tables (IOTs)
• B.It always eliminates all migrated rows if any exist in the table
• C.To shrink a table it must have a PRIMARY KEY constraint
• D.To shrink a table it must have a UNIQUE KEY constraint
• E.To shrink a table it must have row movement enabled
• F.It must be in a tablespace that uses Automatic Segment Space Management (ASSM)

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the SET VERIFY ON command? (Choose two.)

• A.It can be used in SQL Developer and SQL*Plus
• B.It displays values for variables prefixed with &&
• C.It displays values for variables used only in the WHERE clause of a query
• D.It displays values for variables created by the DEFINE command
• E.It can be used only in SQL*Plus

Comment: *

Name: *

Email: *

Verification: *

Which three functions are performed by dispatchers in a shared server configuration? (Choose three.)

• A.writing inbound request to the common request queue from all shared server connections
• B.checking for outbound shared server responses on the common outbound response queue
• C.receiving inbound requests from processes using shared server connections
• D.sending each connection input request to the appropriate shared server input queue
• E.broadcasting shared server session responses back to requesters on all connections
• F.sending shared server session responses back to requesters on the appropriate connection

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

Comment: *

Name: *

Email: *

Verification: *

Examine this command and some partial output:

Why does the DB01.abc.com service show unknown status?

• A.The SID_LIST_LISTENER section is not contained in the LISTENER.ORA file
• B.The service DB01.abc.com is dynamically registered
• C.The LOCAL_LISTENER database parameter is not set to a service name that refers to LISTENER_1
• D.The listener is not listening on the default port 1521
• E.The service DB01.abc.com is statically registered

Comment: *

Name: *

Email: *

Verification: *