Quiz 1Z0-051

Quiz 1Z0-051, Oracle Database 11g, SQL Fundamentals I

Which data type would you use for such a column in the table?

Which statement finds students who have a grade point average (GPA) greater than 3.0 for the calendar year 2001?

Which two SQL statements give the required result?

Which statement is true regarding the execution of the above UPDATE statement?

What would be the outcome?

Which two statements are true regarding the USING and ON clauses in table joins?

Which INSERT statement is valid?

Which SQL statement accomplishes this?

Which is an iSQL*Plus command?

Which query would give the required result?