Which three statements are true about the Oracle join and ANSI join syntax? (Choose three.)

• A.The Oracle join syntax supports creation of a Cartesian product of two tables
• B.The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax
• C.The SQL:1999 compliant ANSI join syntax supports natural joins
• D.The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables
• E.The Oracle join syntax only supports right outer joins
• F.The Oracle join syntax supports natural joins
• G.The Oracle join syntax performs less well than the SQL:1999 compliant ANSI join syntax

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about inner and outer joins? (Choose three.)

• A.Outer joins can only be used between two tables per query
• B.A full outer join returns matched and unmatched rows
• C.A full outer join must use Oracle syntax
• D.An inner join returns matched rows
• E.Outer joins can be used when there are multiple join conditions on two tables
• F.A left or right outer join returns only unmatched rows

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about single-row functions? (Choose three.)

• A.They can be used only in the WHERE clause of a SELECT statement
• B.The argument can be a column name, variable, literal or an expression
• C.The data type returned can be different from the data type of the argument
• D.They can be nested to any level
• E.They can accept only one argument
• F.They return a single result row per table

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about trace files produced by the Oracle Database server? (Choose two.)

• A.They can be written by server processes
• B.Trace files are written to the Fast Recovery Area (FRA)
• C.They can be written by background processes
• D.All trace files contain error information that require contacting Oracle Support
• E.Trace file names are based on the database name concatenated with a sequential number

Comment: *

Name: *

Email: *

Verification: *

Which three are types of segments in an Oracle Database? (Choose three.)

• A.undo
• B.index
• C.stored procedures
• D.sequences
• E.tables
• F.clusters

Comment: *

Name: *

Email: *

Verification: *