Tag: databases

Questions Related to databases

Oracle server generates a name by using which format
technology databases

  1. sys_cn

  2. ora_cn

  3. tab_cn

  4. col_cn

Show answer
Correct Option: A

Constraints are defined at which level
technology databases

  1. row, column

  2. row, table

  3. column, table

  4. all of above

Show answer
Correct Option: C

Cascade option is used
technology databases

  1. disable dependent integrity constraint

  2. deactivate an integrity constraint

  3. both of above

  4. none of above

Show answer
Correct Option: A

To View all constraint definition and name table used is
technology databases

  1. sys_constraints

  2. user_constraints

  3. tab_constraints

  4. col_constraints

Show answer
Correct Option: B

View column associated with the constraint names view used is
technology databases

  1. user_tab_columns

  2. user_cons_columns

  3. user_sys_columns

  4. all of above

Show answer
Correct Option: B

can we insert a record in dual?
technology databases

  1. True

  2. False

Show answer
Correct Option: A

Can a primary key contain more than one columns?
technology databases

  1. True

  2. False

Show answer
Correct Option: A

Which one among the following is more faster?
technology databases

  1. IN

  2. EXISTS

  3. LIKE

  4. EXIST

Show answer
Correct Option: B

Can we use a scalar data type as return type for CURSOR?
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Can cursor variables be stored in PL/SQL tables?
technology databases

  1. True

  2. False

Show answer
Correct Option: B