You execute this command:

Sufficient storage is available in filesystem /u01.
Which two statements are true about the BIG_TBStablespace? (Choose two.)

• A.Additional data files may not be added
• B.It will always have a 32K blocksize
• C.AUTOEXTEND is possible for the datafile
• D.It must be bigger than the largest SMALLFILE tablespace
• E.It will be a dictionary-managed tablespace by default

Comment: *

Name: *

Email: *

Verification: *

Which three are true about the Oracle Optimizer? (Choose three.)

• A.It determines the optimal table join order and method.
• B.It generates execution plans for SQL statements based on relevant schema objects, system and session parameters, and information found in the Data Dictionary.
• C.It can optimize only SELECT statements.
• D.It can re-optimize execution plans after previous executions detect suboptimal plans.
• E.It will only generate SQL Plan Directives specific to a given SQL statement.
• F.It updates stale object statistics in the Data Dictionary.

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

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true concerning logical and physical database structures? (Choose three.)

• A.The extents of a segment must always reside in the same datafile
• B.Segments can span multiple tablespsaces
• C.All tablespaces may have one or more data files
• D.A segment can span multiple data files in some tablespaces
• E.A segment might have only one extent
• F.A smallfile tablespace might be bigger than a bigfile tablespace
• G.A segment's blocks can be of different sizes

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about a self join? (Choose three.)

• A.It can be an outer join
• B.It must be an equijoin
• C.It must be an inner join
• D.The ON clause must be used
• E.The ON clause can be used
• F.The query must use two different aliases for the table

Comment: *

Name: *

Email: *

Verification: *