CS540_C_HW4_14223_NISHANT_PATEL.docx -...

CS540_C_HW4_14223_NISHANT_PATEL
Name :- Nishant Patel
Course id :- cs540
ID:- 14223
HW:- 4

1: Briefly describe Oracle Net is use for and type can be?
Oracle Net is used to establish connections between applications on a network depending on the
following:
- The network configuration.
- The location of the nodes.
- The application.
- The network protocol.
The connections types can be:
- Client-Server Application.
- Web Application Connection.
2: Briefly describe what are Oracle data dictionary contents?
The data dictionary provides information about:
- Logical and physical database structure.
- Definitions and space allocations of objects.
- Integrity constraints.
- Users.
- Roles.
- Privileges.
- Auditing.
3: Briefly describe how the data dictionary is used?
The data dictionary has three primary uses:
- The Oracle server uses it to find information about: Users, Schema objects, Storage
Structure.
- The Oracle server modifies it when a DDL statement is executed.
- Users and DBAs can use it as read –only reference for information about the database.