Posts Tagged ‘joins’

Siebel 7.7 Certification Questions

 

1.      Base table must have the following relationship with the joined table so that a join can be formed:

  1. 1:M
  2. 1:1
  3. M:M
  4. M:1

 

2.      Outer join is set to

  1. Return all records from the joined table when there is no related row in the base table
  2. Return all records from the base table when there is no related row in the joined table

 

3.      Which statement is true for Cascade delete property if its value is delete

  1. If parent record is deleted, all child record are deleted
  2. Does not delete rows but delete the foreign key
  3. Does not delete the rows nor foreign keys
  4. If parent record is deleted only first child record is deleted