Tag: databases

Questions Related to databases

What are the special characters allowed in a table name? (Choose two answers.)
technology databases

  1. &

  2. #

  3. @

  4. $

Show answer
Correct Option: C,D

If char data type column contain number value (say 9) than condition 9>12 IS ?
technology databases

  1. True

  2. False

Show answer
Correct Option: A

IN which condition X is NOT equal to Y ?
technology databases

  1. X<>Y

  2. X!=Y

  3. X^=Y

  4. X!=!Y

Show answer
Correct Option: A,B,C

Trim('0' from 000435600 )?
technology databases

  1. 435600

  2. 0004356

  3. 00043560

  4. 4356

Show answer
Correct Option: D

Which variable specifies to which version we are connected to ORACLE?
technology databases

  1. COMPATIBILITY

  2. VERSION

  3. System.field_status

  4. System.current_field

Show answer
Correct Option: A

Which is correct ? I DDL-Create,alter.delete II DML-Update,drop,delete III DCL-Grant,revoke IV DDL-Create,drop,alter
technology databases

  1. I

  2. II

  3. III

  4. IV

Show answer
Correct Option: C,D

which is correct about TABLE
technology databases

  1. Table can have 100 column at MAX

  2. Table can have 1000 column at MAX

  3. Table can have 10,000 column at MAX

  4. Table can have unlimited column

Show answer
Correct Option: B

Column ALIASE can be used in Order by clause ?
technology databases

  1. True

  2. False

Show answer
Correct Option: A

Table (having constraint) can only be delete by
technology databases

  1. TRUNCATE

  2. DELETE

  3. DROP

  4. REMOVE

Show answer
Correct Option: C

Which is correct about index?
technology databases

  1. B-tree index used for table having completely unique colum

  2. REVERSE key index used for oracle parallel serve

  3. BIT MAP index is used for low cardinality

  4. None of these

Show answer
Correct Option: A,B,C