Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION? (Choose two.)

• A.Each SELECT statement in the compound query can have its own ORDER BY clause
• B.The first column in the first SELECT of the compound query with the UNION operator is used by default to sort output in the absence of an ORDER BY clause
• C.Each SELECT statement in the compound query must have its own ORDER BY clause
• D.Column positions must be used in the ORDER BY clause
• E.Only column names from the first SELECT statement in the compound query are recognized

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

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

• A.Display the total number of products supplied by supplier 102 which have a product status of obsolete
• 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 products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable
• E.Display the minimum PROD_LIST_PRICE for each product status

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true regarding indexes? (Choose three.)

• A.A table belonging to one user can have an index that belongs to a different user
• B.A SELECT statement can access one or more indices without accessing any tables
• C.When a table is dropped and is moved to the RECYCLE BIN, all indexes built on that table are permanently dropped
• D.An update to a table can result in updates to any or all of the table's indexes
• E.An update to a table can result in no updates to any of the table's indexes
• F.A UNIQUE index can be altered to be non-unique

Comment: *

Name: *

Email: *

Verification: *

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

• A.A full outer join returns matched and unmatched rows
• B.An inner join returns matched rows
• C.Outer joins can only be used between two tables per query
• D.A full outer join must use Oracle syntax
• 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: *