Study tips 1z0-007

Study tips 1z0-007, Introduction to Oracle9i SQL

Which SQL statement do you use?

What happens when you execute this DELETE statement?

Which statement accomplishes this?

which capabilities of a SELECT statement are performed?

Which three are DATETIME data types that can be used when specifying column definitions?

Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?

Which three statements insert a row into the table?

Which SELECT statement should you use to extract the year from the system date and display it in the format "1998"?

Which two statements about sequences are true?

which two cases would you use an outer join?