Quiz 1Z0-051

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

What happens when you execute this DELETE statement?

Which MERGE statement is valid?

Which SQL statement will return the ENAME, length of the ENAME, and the numeric position of the letter…?

Which four are valid Oracle constraint types?

Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?

Which is an iSQL*Plus command?

Which statement produces the number of different departments that have employees with last name Smith?

Which statement adds a constraint that ensures the CUSTOMER_NAME column of the CUSTOMERS table holds a value?

Which change must be made to the above syntax to calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"?