Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database?

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

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about current_timestamp?

• A.It returns the same date as CURRENT_date.
• B.The date Is In the time zone of DBTIMEZONE.
• C.It returns a value of data type timestamp.
• D.It always returns the same value as SYSTIMESTAMP.
• E.The time is In the time zone of DBTIMEZONE.
• F.The value varies depending on the setting of SESSIONTIMEZONE.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about using constraints? (Choose two.)

• A.A table can have only one PRIMARY KEYbut may have multiple FOREIGN KEYconstraints.
• B.A table can have multiple PRIMARY KEYand multiple FOREIGN KEYconstraints.
• C.PRIMARY KEYand FOREIGN KEYconstraints can be specified at the column and at the table level.
• D.NOT NULLcan be specified at the column and at the table level.
• E.A FOREIGN KEY column in a child table and the referenced PRIMARY KEYcolumn in the parent table must have the same names.
• F.A table can have only one PRIMARY KEYand one FOREIGN KEYconstraint.

Comment: *

Name: *

Email: *

Verification: *

Which statement is true regarding the INTERSECT operator?

• A.It ignores NULL values
• B.The number of columns and data types must be identical for all SELECT statements in the query
• C.The names of columns in all SELECT statements must be identical
• D.Reversing the order of the intersected tables the result

Comment: *

Name: *

Email: *

Verification: *

Which two are true about the precedence of opertors and condtions

• A.|| has a higher order of precedence than +(addition)
• B.+ (addition) has a higher order of precedence than * (mliplpition)
• C.AND and OR have the same order of precedence in a condition
• D.Operators are evaluated before conditions.
• E.NOT has a higher order of precedence than AND and OR in a condition.

Comment: *

Name: *

Email: *

Verification: *