What techniques are used to retrieve data from m

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What techniques are used to retrieve data from more than one table in a single SQL statement?

Joins, Unions and nested selects are used to retrieve data.

(Continued on next question...)

Other Job Interview Questions

• What are the wildcard characters ?
• When can an insert of a new primary key value threaten referntial integrity?
• How is the SUBSTR keyword used in SQL?
• What are some SQL aggregates and other built-in functions?
• What does the term "grant privileges" mean?
• What is the difference between static and dynamic SQL?
• What is a Cartesian product?
• How do you specify and use a cursor in a COBOL program?
• What is the result of this query if no rows are selected: SELECT SUM(SALARY) FROM EMP WHERE QUAL='MSC'; ?
• What is meant by an index?
• More...