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

The default sorting order of SQL statement is ASC....

  1. True

  2. False


Correct Option: A

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

To write a query that performs an outer join of tables A and B and returns all rows from B, You need to write

  1. any outer join

  2. left outer join

  3. cross join

  4. right outer join


Correct Option: D

Which is valid Oracle constraint type ?

  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

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

  1. True

  2. False


Correct Option: B

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

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

  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

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

  1. v$timezone_names

  2. v$timezone

  3. user_timezone_names

  4. dba_timezone_names


Correct Option: A

Which function will take input parameter...?

  1. tz_offse

  2. sessiontimezone

  3. systemstamp

  4. sysdate


Correct Option: A
- Hide questions