Fundamentals of Internet and Databases

What is the difference between the Internet and the World Wide Web?

• The Internet is the infrastructure; the World Wide Web is a service that operates over that infrastructure.

• The Internet and the World Wide Web are the same thing.

• The Internet is a type of software; the World Wide Web is hardware.

• The World Wide Web is a network of computers; the Internet is a website.

Define a web page and a home page.

• A web page is a type of software; a home page is a mobile app interface.

• A web page is a physical page; a home page is a printed document.

• A web page is a collection of images; a home page is a blog post.

• A web page is a document on the web; a home page is the main page of a website.

What are static, dynamic, and active web pages?

• Static web pages are fixed content, dynamic web pages change based on user input, and active web pages allow real-time interaction.

• Active web pages are only accessible offline and do not require a server.

• Dynamic web pages are always fixed content and do not change.

• Static web pages are interactive and change frequently.

Explain the purpose of the Hyper Text Transfer Protocol (HTTP).

• The purpose of HTTP is to enable the transfer of data over the web, allowing users to access and interact with web resources.

• HTTP is used for sending emails between servers.

• The purpose of HTTP is to store files on a local computer.

• HTTP is a programming language for web development.

What is the function of Simple Mail Transfer Protocol (SMTP)?

• SMTP is a protocol for managing email contacts.

• SMTP is used for retrieving emails from a server.

• SMTP encrypts email messages for security.

• SMTP is a protocol for sending and relaying email.

Describe the concept of client-server computing.

• Client-server computing is a model where clients request services from a centralized server that hosts resources and applications.

• Client-server computing is a model where all processing is done on the client side without a server.

• Client-server computing is a decentralized model where each client operates independently without a central server.

• Client-server computing involves multiple servers communicating directly with each other without clients.

What is an Object Relational Database Management System (ORDBMS)?

• A database management system that focuses solely on NoSQL technologies.

• A type of database that exclusively uses XML for data storage.

• A system that only supports relational data without object-oriented features.

• An Object Relational Database Management System (ORDBMS) is a database management system that integrates object-oriented database features into a relational database.

What are nested relations in database design?

• Nested relations refer to the use of foreign keys in a single table.

• Nested relations are a method for indexing data in a database.

• Nested relations are a type of database normalization technique.

• Nested relations allow a table to include another table as an attribute, facilitating complex data representation.

Explain the significance of SQL3 in database management.

• SQL3 is primarily focused on improving transaction speed in databases.

• SQL3 is a programming language unrelated to database management.

• SQL3 eliminates the need for relational databases entirely.

• SQL3 is significant for introducing object-oriented features and enhanced data modeling in SQL, improving database versatility and standardization.

Compare RDBMS, OODBMS, and ORDBMS.

• RDBMS uses documents and collections

• RDBMS uses tables and relationships, OODBMS uses objects, and ORDBMS combines both.

• ORDBMS is a type of NoSQL database

• OODBMS is based on spreadsheets