The subnet mask is a 32-bit binary number used to identify the network and subnet of an IP address. It is used to determine which portion of an IP address is the network and which portion is the host.
For example, the subnet mask for a Class C IP address is 255.255.255.0. This means that the first three octets (24 bits) of the IP address are used for the network portion and the last octet (8 bits) is used for the host portion.
The port number is a numerical identifier used to differentiate different applications or services that are running on the same computer. It is like a street address for a computer, allowing it to receive data from other computers. For example, web servers usually use port 80 to receive data from web browsers. Similarly, email servers use port 25 for incoming emails.
The IP address is a numerical label assigned to each device connected to a computer network that uses the Internet Protocol for communication. It serves two primary functions: host or network interface identification and location addressing.
Example:
An IP address is a series of numbers and decimals that are assigned to each device connected to a network. For example, a computer connected to a network may have an IP address of 192.168.1.1. This address is used to identify the device and its location on the network.
TCP (Transmission Control Protocol) is a connection-oriented protocol that provides reliable communication between two endpoints. It ensures that all data is received in the order it was sent and requires acknowledgement of each packet to guarantee delivery. An example of a TCP protocol is HTTP, which is used to transfer web pages from a server to a web browser.
UDP (User Datagram Protocol) is a connectionless protocol that provides an unreliable communication between two endpoints. It does not guarantee that all data will be received in the order it was sent and does not require acknowledgement of each packet. An example of a UDP protocol is DNS, which is used to resolve domain names to IP addresses.
TCP/IP, or Transmission Control Protocol/Internet Protocol, is a set of communications protocols used to connect hosts on the Internet or a network. It is the primary set of protocols used to connect computers to the Internet. TCP/IP is responsible for ensuring that data is correctly formatted, addressed, transmitted, routed, and received.
For example, when you type a website address into your browser, the browser uses the TCP/IP protocol to connect to the website’s server. Once connected, the browser sends a request for the web page, which the server then sends back to the browser. The browser then displays the page on your screen.
TCP/IP stands for Transmission Control Protocol/Internet Protocol. It is a set of communication protocols used for connecting computers on the Internet. TCP/IP is the language computers use to communicate with each other over the Internet.
Example: When you type in a website address in your browser, your computer sends a message to the web server using TCP/IP. The web server then responds with the requested web page, also using TCP/IP.
A trigger is a stored PL/SQL block that is executed automatically when a particular event occurs. Triggers are used to enforce business rules and to maintain data integrity.
For example, you can create a trigger that is fired when an INSERT statement is issued on a particular table. The trigger can check to make sure that the data being inserted meets certain criteria before it is accepted into the table.
A schema in Oracle Database is a collection of logical structures of data, or schema objects. A schema is owned by a database user and has the same name as that user. For example, a user named “John” would have a schema also named “John”. The schema would contain all of John’s tables, views, sequences, stored procedures, and other database objects.
To create a user in Oracle Database, you need to use the CREATE USER command.
For example:
CREATE USER new_user
IDENTIFIED BY new_password
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp
QUOTA 10M ON users;
This command will create a new user called “new_user” with a password of “new_password”. It will also assign the user a default tablespace of “users” and a temporary tablespace of “temp”. It will also assign the user a quota of 10MB on the “users” tablespace.
Oracle Database is an enterprise-level relational database management system (RDBMS) developed by Oracle Corporation. It is used to store, manage, and retrieve data for applications. Oracle Database is a powerful and feature-rich database platform that enables organizations to deploy and manage data-driven applications, including online transaction processing (OLTP), data warehousing (DW), and analytics.
SQL (Structured Query Language) is a language used to interact with databases. It is used to create, modify, and query databases. It is used to retrieve, add, delete, and update data stored in the database. For example, an SQL statement can be used to create a table, insert data into the table, update data in the table, or delete data from the table.
Vaibhav Kothia