CS540_B_HW04_16020.pdf - -Course ID CS540(B-Student ID 16020-Student Name Jaydutt Pathak-Homework 04 ANSWER 1 Oracle Net Services provides enterprise

CS540_B_HW04_16020.pdf - -Course ID CS540(B-Student ID...

This preview shows page 1 - 4 out of 7 pages.

--Course ID: CS540 (B) --Student ID: 16020 --Student Name: Jaydutt Pathak --Homework#: 04
Image of page 1
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
Image of page 2
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.
Image of page 3
Image of page 4

You've reached the end of your free preview.

Want to read all 7 pages?

  • Spring '18
  • Oracle Database, Client-server

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture