QUESTION: 49

What are three characteristics of volatile tables? (Choose three.)

They are materialized in spool space.
Their table definitions are kept in cache.
They are restricted to a single query statement.
They require no Data Dictionary access or transaction locks.
They do not have to be explicitly created in the current session with DDL.

Answer(s): A,B,D

Reveal Solution Next Question

QUESTION: 50

What are three characteristics of Global Temporary tables? (Choose three.)

They can be referenced from a macro.
They can utilize permanent journaling.
They can be created using the WITH DATA option.
Their table definitions are stored in the Data Dictionary.
They are materialized in the login user's temporary space.

Answer(s): A,D,E

Reveal Solution Next Question

QUESTION: 51

A report of sales totals by day-of-week (i.e., Saturday sales, Sunday sales, etc.) is requested.
Which three techniques can be employed to design the query? (Choose three.)

Use a minor entity table.
Use the system calendar.
Use the CASE statement.
Use the SET SESSION DATEFORM statement.

Answer(s): A,B,C

Reveal Solution Next Question

You are creating an application to export some date values. You want to override the current default date form of INTEGERDATE with the statement SET SESSION DATEFORM=ANSIDATE; Which statement is true?

Date values will be returned in CHAR(8) form.
Date values will be returned in CHAR(10) form.
The statement is syntactically incorrect as written.
Date values will continue to be returned in INTEGER form.

Answer(s): B

Reveal Solution Next Question

Free NR0-016 Exam Braindumps (page: 14)

QUESTION: 49

QUESTION: 50

QUESTION: 51

QUESTION: 52

NR0-016 Discussions & Posts