SQL PLUS HELP!

Given the FACULTY table:

FACULTY (Fac_ID, Fac_name, Salary)

Will the following query give syntax error?

Select Fac_name

From Faculty

Where upper(Fac_name) = smith;

1. will give compilation error
2. will not give an error
3. Query is incomplete
4. None of the above

CEO of IBM wants to put data access restrictions on some of its employees. What would be the best way to do it?

A) Use primary key (PK) C) Use alter statement

B). Use Foreign Key (FK) D) None of the above

What will be the outcome of following query

MPROPERTY (Property_ID, Owner_ID, Owner_Name, Owner_email)

SELECT owner_ID, Owner_name

FROM Mproperty

WHERE Property_Id = X456;

A) Will give ID and name of all owners.

B) Will give ID and name of owner whose owner id is X456.

C) Will give ID and name of owner who own property id isX456

D) None of the above

Typically, in the query syntax, which part creates a subset of rows

Given MPROPERTY (Property_ID, Owner_ID, Owner_Name, Owner_email, Owner_type)

SELECT owner_ID, Owner_name FROM Mproperty WHERE Property_Id = X456;

A) From Mproperty part

B) WHERE WHERE Property_Id = X456 part

C) SELECT SELECT owner_ID, Owner_name part

D) None of the above