You have to calculate the value 12* salary* commission_pct for all the employees in the EMP table. Which of the following statements ensures that a value is displayed in the calculated column for all the employees?

You want to display the titles of books that meet the following criteria: 1. Purchased before Feb 21, 2002 2. Price is less than $500 or greater than $900. You want to sort the result by the date of purchase, starting with the most recently bought book. Which of the following statements should you use?

You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which of the following statements will accomplish this task?

Which of the following data types stores data outside the Oracle database?

Which of the following constitute the correct guidelines for naming database tables?

An outer join is used when:

Which of the following tasks can be performed by using the TO_CHAR function?

Evaluate the SQL statement given below: SELECT ROUND (45.953, -1), TRUNC (45.936, 2) FROM dual; Which of the following values are displayed?

_______ operator can be used with a multiple row subquery.

Which of the following SQL statements should be used to remove a view called EMP_DEPT_VU from the schema?

Which of the following shows the correct use of the Trunc command on a date?