--Course ID: CS540 (B) --Student ID: 16020 --Student Name: Jaydutt Pathak --Homework#: 04
ANSWER 1: Oracle Net Services provides enterprise wide connectivity solutions in distributed, heterogeneous computing environments. Oracle Net Services ease the complexities of network configuration and management, maximize performance, and improve network diagnostic capabilities. Oracle Ne is also a component of Oracle Net Services, enables a network session from a client application to an Oracle Database server. Once a network session is established, Oracle Net acts as the data courier for both the client application and the database server. It is responsible for establishing and maintaining the connection between the client application and database server, as well as exchanging messages between them. Oracle Net is able to perform these jobs because it is located on each computer in the network. Moreover 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 Oracle types can be: Client Server Application Web Application Connection ANSWER 2: One of the most important parts of an Oracle database is its data dictionary , which is a read-only set of tables that provides information about the database. The definitions of every schema object in the database, including default values for columns and integrity constraint information. The amount of space allocated for and currently used by the schema objects. The names of Oracle Database users, privileges and roles granted to users, and auditing information related to users. Logical and physical database structure Definitions and space allocations of objects Integrity constraints Users Roles Privileges Auditing
ANSWER 3: Data in the base tables of the data dictionary is necessary for Oracle to function . Therefore, only Oracle should write or change data dictionary information. Oracle provides scripts to modify the data dictionary tables when a database is upgraded or downgraded. During database operation, Oracle reads the data dictionary to ascertain that schema objects exist and that users have proper access to them. Oracle also updates the data dictionary continuously to reflect changes in database structures, auditing, grants, and data.
You've reached the end of your free preview.
Want to read all 7 pages?
- Spring '18
- Oracle Database, Client-server