Software Testing

1) Why are we able to see all other schemas along with the schema which we provided in the connection pool settings (odbc / OCI ) A: We will be able to see all other schemas along with the schema credentials which we provide, only when provided schema has a read / write permissions to the schemas available in that instance. 2) How will RPD get the number of records count even when we open RPD in offline and all the services are down. A: Through ODBC / OCI 3) Is Between operator supported by OBIEE when you create joins in RPD ? A: No 4) We have only 1 connection pool with "SCOTT" user but want to import tables from "HR" schema and view data. (Assuming SCOTT has read only permission to HR schema). A: We need to select the check box in connection pool settings "Require Fully Qualified Table Names" 5) Can you delete a parent table if you have created an alias table A: No,  Alias table has to be deleted first before deleting parent table 6)

select trunc(months_between(date2,date1)) months,        date2 - add_months(date1,trunc(months_between(date2,date1))) days   from (select to_date('25-Aug-2013','dd-Mon-yyyy') date1,to_date('23-Oct-2013','dd-Mon-yyyy') date2           from dual        ) MONTHS DAYS 1 28