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

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

Comment: *

Name: *

Email: *

Verification: *

The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.
Segment creation is not deferred.
You execute this command:

Which three statements must be true so that the SALES user can create tables in SALES_Q1? (Choose three.)

• A.The sales user must have a quota on the TEMP tablespace
• B.The sales user must have been granted the CREATE SESSION privilege
• C.The sales user must have a quota on the SALES_Q1 tablespace to hold all the rows to be inserted into any table in their schema
• D.The sales user must have a quota on the SALES_Q1 tablespace to hold the initial extends of all tables they plan to create in their schema
• E.The sales user must have their quota on the users tablespace removed
• F.The sales user must have been granted the CREATE TABLE privilege

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the rules of precedence for operators? (Choose two.)

• A.The concatenation operator | | is always evaluated before addition and subtraction in an expression
• B.NULLS influence the precedence of operators in an expression
• C.The + binary operator has the highest precedence in an expression in a SQL statement
• D.Arithmetic operators with equal precedence are evaluated from left to right within an expression
• E.Multiple parentheses can be used to override the default precedence of operators in an expression

Comment: *

Name: *

Email: *

Verification: *

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 configuration and use of UNDO_RETENTION with GURANTEED RETENTION? (Choose two.)

• A.UNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO.
• B.Active UNDO is always retained.
• C.Unexpired UNDO is always retained.
• D.UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unexpired UNDO.
• E.UNDO_RETENTION specifies how long all types of UNDO are retained.

Comment: *

Name: *

Email: *

Verification: *