Which of the following constraints can be defined only at the column level?

Which of the following SQL statements defines a FOREIGN KEY constraint on the DEPT NO column of the EMP table?

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

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

_______ operator can be used with a multiple row subquery.

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

Which of the following components are required to run iSQL*plus on PC?

An outer join is used when:

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

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

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?