You can create a view in your own schema only if you are granted the CREATE VIEW privilege.
Incorrect Answers
A:. You can create a view in your own schema only.
B:. You can create a view in your own schema only, not in any schema.
D:. There is no sequence view in Oracle.
E:. You cannot create a view that is accessible by everyone. You will need specially grant SELECT privileges on this view for everyone.
F:. You can create a view in your own schema, but not only for tables in your schema. You can use object from other users schemas if you have privileges to retrieve data from them.
OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 292-301 Chapter 7: Creating Other Database Objects in Oracle