Tag: databases

Questions Related to databases

You may use the CREATE INDEX statement to create an index on (choose all that apply):

technology databases

  1. This is hard to determine

  2. One or more scalar typed object attributes of a cluster

  3. One or more columns of a table

  4. A nested table storage table

Show answer
Correct Option: B,C,D

An inner join is always a:

technology databases

  1. outer join

  2. equil join

  3. simple join

  4. right join

  5. left join

Show answer
Correct Option: C

When will a Cartesian product be returned

technology databases

  1. when two tables in a join query have only a single join condition

  2. when two tables in a join query have too many join conditions

  3. This is hard to determine.

  4. when two tables in a join query have no join condition

Show answer
Correct Option: D

The UNION ALL operator does not eliminate duplicate selected rows from the result set

technology databases

  1. True

  2. False

Show answer
Correct Option: A

The ALTER SEQUENCE statement can affect only the future sequence numbers

technology databases

  1. True

  2. False

Show answer
Correct Option: A

If you use the CREATE DATABASE statement on an existing database, all data in the datafiles will be lost

technology databases

  1. True

  2. False

Show answer
Correct Option: A

which datatype store pointer to binary file on disk

technology databases

  1. BLOB

  2. CLOB

  3. BFILE

  4. NCLOB

Show answer
Correct Option: C

For Which datatype Maximum size is 4GB

technology databases

  1. CLOB

  2. BLOB

  3. NCLOB

  4. ALL

Show answer
Correct Option: D

A) Long raw - Variable length binary strings B) LONG - Character data of variable length
technology databases

  1. A is correct

  2. B is correct

  3. A & B Both correct

  4. A & B both Incorrect

Show answer
Correct Option: C

32-bit floating point number datatype is?

technology databases

  1. BINARY_FLOAT

  2. BINARY_DOUBLE

  3. ROWID

  4. NCHAR

Show answer
Correct Option: A