0

databases Online Quiz - 220

Description: databases Online Quiz - 220
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

Null values in select statement with descending order will apppear at the top of the list....

  1. True

  2. False


Correct Option: A

Arithmetic functions returns a NULL for a NULL input...

  1. True

  2. False


Correct Option: A

password files are mandatory Disk components of Oracle....

  1. True

  2. False


Correct Option: B
  1. CASCADE

  2. CONSTANT

  3. CHECK

  4. NONUNIQUE


Correct Option: C

Which is an iSQL*Plus command ?

  1. DESCRIBE

  2. RENAME

  3. DELETE

  4. INSERT


Correct Option: A

Which is a DML Statement ?

  1. DROP

  2. MERGE

  3. CREATE

  4. COMMIT


Correct Option: B

Which is a character manipulation functions ?

  1. CASE

  2. TRUNC

  3. REPLACE

  4. MOD


Correct Option: C

Cast function converts datatypes....

  1. True

  2. False


Correct Option: A

Newfoundland standard time uses daylight saving...

  1. True

  2. False


Correct Option: B

Dump function takes the backup of Oracle....

  1. True

  2. False


Correct Option: B
  1. next_day()

  2. add_months()

  3. new_time()

  4. old_year()


Correct Option: C

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

  1. National Language Set

  2. International Language Set

  3. Oracle Language Set

  4. SQL-99 compliant Language Set


Correct Option: A

Which one is not Oracle Function...?

  1. to_char

  2. to_number

  3. to_string

  4. to_date


Correct Option: C
  1. v$timezone_names

  2. v$timezone

  3. user_timezone_names

  4. dba_timezone_names


Correct Option: A
  1. tz_offse

  2. sessiontimezone

  3. systemstamp

  4. sysdate


Correct Option: A
- Hide questions