Tag Archives: time

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

Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.) A. The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC) B. The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC) C. A TIMESTAMP data type column contains information about year, month,… Read More »

You want to write a query that prompts for two column names and the WHERE condition each time it is executed

You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a session but only prompts for the table name the first time it is executed.The variables used in your query are never undefined in your session.Which query can be used? A. SELECT &col1, &col2FROM &&tableWHERE &condition;… Read More »

You want to write a query that prompts for two column names and the WHERE condition each time it is executed

You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a session but only prompts for the table name the first time it is executed.The variables used in your query are never undefined in your session.Which query can be used? A. SELECT `&&col1′, `&&col2′FROM &tableWHERE `&&condition’… Read More »

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

Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.) A. A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row B. The CURRENT_TIMESTAMP function returns data without time zone information C. The… Read More »

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

Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.) A. A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row B. The CURRENT_TIMESTAMP function returns data without time zone information C. A… Read More »

A customer has chosen to override learned activity durations for a period of time, after which they will

A customer has chosen to override learned activity durations for a period of time, after which they will revert bads; to having Oracle Field Service Cloud (OFSC) provide duration estimations based on learned behavior.Which statement is accurate regarding how the statistics override option works? A. OFSC will begin updating statistically learned values from reported field activities once the… Read More »

A new customer has logged into Oracle Cloud Infrastructure (OCI) as an administrator for the first time.

A new customer has logged into Oracle Cloud Infrastructure (OCI) as an administrator for the first time. The admin would like to deploy Infrastructure into a region other then their home region.What is the first Stop they must take in order to accomplish this task? A. Use API endpoints to create resources in the desired region. B. Navigate… Read More »

Which two problems related to time slot-based quota can you overcome when using the based booking approach

Which two problems related to time slot-based quota can you overcome when using the based booking approach with customized booking Intervals? A. quota for extended activities being consumed from a single, shorter time slot B. managing quota and capacity for service windows C. average quota and capacity calculation for time slots D. overlapping time slots stranding quota Correct… Read More »