What is a join ? Explain the different Types of joins ?

What is a join ? Explain the different types of joins ? 
Join is a query which retrieves related columns or rows from multiple tables.Self Join - Joining the table with itself.Equi Join - Joining two tables by equating two common columns.Non-Equi Join - Joining two tables by equating two common columns.Outer Join - Joining two tables in such a way that query can also retrieve rows that do not have corresponding join value in the other table.

If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE ? 
It won't, Because SYSDATE format contains time attached with it.

page 20

How does one stop and start the OMS? (for DBA)
Use the following command sequence to stop and start the OMS (Oracle Management Server):
oemctl start oms
oemctl status oms sysman/oem_temp
oemctl stop oms sysman/oem_temp
Windows NT/2000 users can just stop and start the required services. The default OEM administrator is "sysman" with a password of "oem_temp".
NOTE: Use command oemctrl instead of oemctl for Oracle 8i and below.

What is an Integrity Constraint ? 
Integrity constraint is a rule that restricts values to a column in a table.

How does one create a repository? (for DBA)
For OEM v2 and above, start the Oracle Enterprise Manager Configuration Assistant (emca on Unix) to create and configure the management server and repository. Remember to setup a backup for the repository database after creating it.

If a View on a single base table is manipulated will the changes be reflected on the base table ? 
If changes are made to the tables which are base tables of a view will the changes be reference on the view.

The following describes means to create a OEM V1.x (very old!!!) repository on WindowsNT:

. Create a tablespace that would hold the repository data. A size between 200- 250 MB would be ideal. Let us call it Dummy_Space.
. Create an Oracle user who would own this repository. Assign DBA, SNMPAgent, Exp_Full_database, Imp_Full_database roles to this user. Lets call this user Dummy_user. Assign Dummy_Space as the default tablespace.
. Create an operating system user with the same name as the Oracle username. I.e. Dummy_User. Add 'Log on as a batch job' under advanced rights in User manager.
. Fire up Enterprise manager and log in as Dummy_User and enter the password. This would trigger the creation of the repository. From now on, Enterprise manager is ready to accept jobs.

What is a database link ? 
Database Link is a named path through which a remote database can be accessed.