Shaha D

Try the Oracle 9i SQL mock exam I have written at
http://www.geocities.com/shaha_atl02
Good Luck,
Shaha

Yep, only DML statements can be rolled back. For DDL (Data Definition Language) statements Oracle issues an implicit COMMIT after the statement. The CREATE TABLE statement you issued to create table is a DDL so the table wont be erased.
You can find detailed explanation on transaction management in most of the database or Oracle books. Or you can refer to oracle manuals at the following site, once you sign up for OTN membership, which is free.
http://otn.oracle.com/docs/products/oracle9i/content.html
Go to "Concepts" link, under "Books for the New Application Developer" on the following site, which contains a chapter on Transactions (Chapter 16):
http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/nav/getting_started.htm
Cheers,
Shaha

Hi All,
Try the mock exam I have prepared for SQL 9i certification exam. I have put together some of the questions, I came across during my exam preparation. Most of the questions I have included are not the easier ones, the questions in the actual exam were little easier .
Click here: http://www.geocities.com/shaha_atl02/
Cheers,
Shaha

Typically, each entity bean has an underlying table in a relational database. Sketch down the abstract schema showing all the relationships between different tables. You can have four types of relationships in CMP : one to one, one to many, many to one, many to many. Each of these relationships can be unidirectional or bidirectional. You can start implementing your abstract schema, as an CMP entity bean for each comonent in the diagram and implement relationships between the CMP beans. Then you can implement finder methods using the EJB-QL.
You can use JBuilder or some other IDE tool, JB generates code and xml descriptors for you, when you create beans using the EJB designer. You can find more info about tools on "IDE's and other tools" forum.
Visit the following links for more details:
http://java.sun.com/j2ee/tutorial/1_3-fcs/doc/EJBConcepts4.html#62950
http://java.sun.com/j2ee/tutorial/1_3-fcs/doc/EJBConcepts.html

Hey,
Don't get upset. You are moving in the right direction. Certification is definitly going to help you. But in this market only that is not enough. You need to learn other skills like databases, web server etc. In computerjobs.com they have a category for visa sponsered jobs. Also try applying through different sources. You
have masters and experience which is a definite plus. Don't loose hope. Good luck.
shaha

Hey,
It's great achievment. Congrats!!!
Shaha