Store 1 pen exam

Before the test, refer to previous years' questions.

You can search for this keyword on the Internet.

1. What is the difference between preparedstatment and statement in the steps for connecting Java to the database?

2. Differences between session and COOKIE: How to Use session and cookie to access shared user information

A: For details about the differences between cookies and sessions

1. Cookie data is stored in the client's browser, and session data is stored on the server.

2. Cookies are not very secure. Others can analyze the Cookies stored locally and perform cookie spoofing. For security reasons, session should be used.

3. The session will be stored on the server for a certain period of time. When the number of access requests increases, it will occupy the performance of your server. To reduce the performance of your server, you should use cookies.

4. data stored in a single cookie cannot exceed 4 kb. Many browsers limit that a site can store up to 20 cookies.

3. What is localthred and what is its function. (Syntronized)
4. Database Design: User, role, permision, requiring one user to have multiple role and one role to have multiple Permissions

Find all permissions of Michael Jacob.

Find all users with more than 3 Permissions

A: (I do not know the database permission. I will keep it for reference first)

Answer 1: Select * From dba_tab_privs where grantee = 'zhang san ';

Answer 2:

Select P. priv from user_roles U, role_privs P where u. Role = P. Role and U. Username = 'hangs ';
Select U. username, count (P. priv) from user_roles U, role_privs P where u. Role = P. Role group by U. Username having count (P. priv)> 3;

Store 1 pen exam