Examine this SQL statement:
SELECT cust_id, cust_last_name "Last Name"
FROM customers
WHERE country_id = 10
UNION
SELECT cust_id CUST_NO, cust_last_name
FROM customers
WHERE country_id = 30
Identify three ORDER BY clauses, any one of which can complete the query successfully.
(Choose three.)

• A.ORDER BY 2, 1
• B.ORDER BY 2, cust_id
• C.ORDER BY "Last Name"
• D.ORDER BY "CUST_NO"
• E.ORDER BY CUST_NO

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 statement is true about aggregate functions?

• A.Aggregate functions can be nested to any number of levels
• B.The AVG function implicitly converts NULLS to zero
• C.The MAX and MIN functions can be used on columns with character data types
• D.Aggregate functions can be used in any clause of a SELECT statement

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.A smallfile tablespace might be bigger than a bigfile tablespace
• C.All tablespaces may have one or more data files
• D.Segments can span multiple tablespaces
• E.A segment can span multiple data files in some tablespaces
• F.A segment might have only one extent
• G.A segment's blocks can be of different sizes

Comment: *

Name: *

Email: *

Verification: *

In the ORCL database, UNDOTBS1 is the active undo tablespace with these properties:
1. A size of 100 MB
2. AUTOEXTEND is off
3. UNDO_RETENTION is set to 15 minutes
4. It has RETENTION GUARANTEE
UNDOTBS1 fills with uncommitted undo 10 minutes after the database opens.
What will happen when the next update is attempted by any transaction?

• A.It succeeds and the generated undo is stored in SYSTEM.
• B.It fails and returns the error message "ORA-30036: unable to extend segment by 8 in undo tablespace
  'UNDOTBS1' ".
• C.It succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the generated undo.
• D.It succeeds and the generated undo is stored in SYSAUX.
• E.It succeeds and the least recently read undo block of UNDOTBS1 is overwritten by the generated undo.

Comment: *

Name: *

Email: *

Verification: *