Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)

• A.Column names in each SELECT in the compound query can be different
• B.The number of columns in each SELECT in the compound query can be different
• C.Reversing the order of the intersected tables can sometimes affect the output
• D.INTERSECT returns rows common to both sides of the compound query
• E.INTERSECT ignores NULLs

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the structure of the PRODUCTS table.
Which two tasks require subqueries? (Choose two.)

• A.Display products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable
• B.Display suppliers whose PROD_LIST_PRICE is less than 1000
• C.Display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE
• D.Display the total number of products supplied by supplier 102 which have a product status of obsolete
• E.Display the minimum PROD_LIST_PRICE for each product status

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)

• A.A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.
• B.A GLOBAL TEMPORARY TABLE'S definition is available to multiple sessions.
• C.A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
• D.GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.
• E.GLOBAL TEMPORARY TABLE space allocation occurs at session start.
• F.Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.

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

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