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 statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.)

• A.The CURRENT_TIMESTAMP function returns data without time zone information
• B.A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row
• C.The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC)
• D.The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC)
• E.A TIMESTAMP data type column contains information about year, month, and day

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

Which statement is true about aggregate functions?

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

Comment: *

Name: *

Email: *

Verification: *

Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY.
Only the EMPLOYEE_ID column is indexed.
Rows exist for employees 100 and 200.
Examine this statement:

Which two statements are true? (Choose two.)

• A.Employees 100 and 200 will have the same SALARY as before the update command
• B.Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100
• C.Employee 200 will have SALARY set to the same value as the SALARY of employee 100
• D.Employees 100 and 200 will have the same JOB_ID as before the update command
• E.Employee 100 will have SALARY set to the same value as the SALARY of employee 200
• F.Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200

Comment: *

Name: *

Email: *

Verification: *