Tag: databases

Questions Related to databases

which one is the Oracle function in SQL...?
technology databases

  1. floor

  2. window

  3. door

  4. ground

Show answer
Correct Option: A

which keyword can be placed in trim function...?
technology databases

  1. tailoring

  2. travelling

  3. trailing

  4. trucking

Show answer
Correct Option: C

Order by clause cannot have aliases of columns....
technology databases

  1. True

  2. False

Show answer
Correct Option: B

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

  1. True

  2. False

Show answer
Correct Option: A

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

  1. True

  2. False

Show answer
Correct Option: A

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

  1. True

  2. False

Show answer
Correct Option: A

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

  1. True

  2. False

Show answer
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

technology databases

  1. any outer join

  2. left outer join

  3. cross join

  4. right outer join

Show answer
Correct Option: D

Which is valid Oracle constraint type ?
technology databases

  1. CASCADE

  2. CONSTANT

  3. CHECK

  4. NONUNIQUE

Show answer
Correct Option: C

Which is an iSQL*Plus command ?
technology databases

  1. DESCRIBE

  2. RENAME

  3. DELETE

  4. INSERT

Show answer
Correct Option: A