Tag: databases

Questions Related to databases

Which is a DML Statement ?
technology databases

  1. DROP

  2. MERGE

  3. CREATE

  4. COMMIT

Show answer
Correct Option: B

Which is a character manipulation functions ?
technology databases

  1. CASE

  2. TRUNC

  3. REPLACE

  4. MOD

Show answer
Correct Option: C

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