Tag: technology

Questions Related to technology

The date got from SYSDATE is date according to client machine....
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Cast function converts datatypes....
technology databases

  1. True

  2. False

Show answer
Correct Option: A

Months_between will return negative numbers....
technology databases

  1. True

  2. False

Show answer
Correct Option: A

Newfoundland standard time uses daylight saving...

technology databases

  1. True

  2. False

Show answer
Correct Option: B

Dump function takes the backup of Oracle....
technology databases

  1. True

  2. False

Show answer
Correct Option: B

AST,GMT,XST..... can be used as parameters for which function..?
technology databases

  1. next_day()

  2. add_months()

  3. new_time()

  4. old_year()

Show answer
Correct Option: C

To change the display of date information, we have to use....
technology databases

  1. National Language Set

  2. International Language Set

  3. Oracle Language Set

  4. SQL-99 compliant Language Set

Show answer
Correct Option: A

Which one is not Oracle Function...?
technology databases

  1. to_char

  2. to_number

  3. to_string

  4. to_date

Show answer
Correct Option: C

Valid time zone names can be found in ....

technology databases

  1. v$timezone_names

  2. v$timezone

  3. user_timezone_names

  4. dba_timezone_names

Show answer
Correct Option: A

Which function will take input parameter...?

technology databases

  1. tz_offse

  2. sessiontimezone

  3. systemstamp

  4. sysdate

Show answer
Correct Option: A