ORACLE/ SQL Discussion Question

profileDr Richards
 (Not rated)
 (Not rated)
Chat

1. What is meant by logical independence?


2. Explain the term second normal form.


3. How are comparisons done on character string data in a query's WHERE clause, and why would this be especially useful in comparing certain attributes?


4. In using group functions, we cannot place a group function in a WHERE clause. Explain how the WHERE clause and HAVING clause are similar and why you can use the HAVING with a group function but not a WHERE clause.


5. Write the SQL statement that will remove the database table EMPLOYEE.

 

 

 

 

    • 9 years ago
    ORACLE/ SQL Discussion Question Answer
    NOT RATED

    Purchase the answer to view it

    blurred-text
    • attachment
      oracle.doc