Examine the commands used to create the DEPARTMENT_DETAILS and the COURSE- DETAILS tables:
SQL> CREATE TABLE DEPARTMfiNT_DeTAILS
DEPARTMENT_ID NUMBER PRIMARY KEY ,
DEPARTMEHT_NAME VARCHAR2(50) ,
HOD VARCHAP2(50));
SQL> CREATE TABLE COURSE-DETAILS
(COURSE ID NUMBER PRIMARY KEY ,
COURS_NAME VARCHAR2 (50) ,
DEPARTMEHT_ID NUMBER REFERENCES DEPARTMENT_DETAIL
You want to generate a list of all department IDs along with any course IDs that may have been assigned to them.
Which SQL statement must you use?

Which two statements are true about the ORDER BY clause?

Which two tasks can be performed by using Oracle SQL statements?

You execute the SQL statement:
SQL> CREATE TABLE citizens
(citizen_id CHAR (10) PRIMARY KEY,
last_name VARCHAR2 (50) NOT NULL,
first_name VARCHAR2 (50),
address VARCHAR2 (100),
city VARCHAR2 (30) DEFAULT 'SEATTLE' NOT NULL,
CONSTRAINT cnames CHECK (first_name<>last_name) );
What is the outcome?

View the Exhibit and examine the data in the PRODUCTS table.

Which statement would add a column called PRICE, which cannot contain NULL?