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

Which three statements are true about Oracle synonyms? (Choose three.)

• A.A synonym can be available to all users
• B.Any user can drop a PUBLIC synonym
• C.A synonym created by one user can refer to an object belonging to another user
• D.A synonym cannot be created for a PL/SQL package
• E.A SEQUENCE can have a synonym

Comment: *

Name: *

Email: *

Verification: *

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

• A.MOD : returns the quotient of a division operation
• B.FLOOR : returns the smallest integer greater than or equal to a specified number
• C.TRUNC : can be used with NUMBER and DATE values
• D.CONCAT : can be used to combine any number of values
• E.CEIL : can be used for positive and negative numbers

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the WHERE and HAVING clauses in a SELECT statement?
(Choose two.)

• A.The WHERE clause can be used to exclude rows before dividing them into groups
• B.Aggregating functions and columns used in HAVING clauses must be specified in the SELECT list of a query
• C.The WHERE clause can be used to exclude rows after dividing them into groups
• D.WHERE and HAVING clauses can be used in the same statement only if applied to different table columns
• E.The HAVING clause can be used with aggregating functions in subqueries

Comment: *

Name: *

Email: *

Verification: *