Web Apps Programing

What contributed to traditional broadband subscriber losses in 2024?

Competition from wireless and satellite internet

Which trend is increasing opportunities for web developers?

Increase in e-commerce and mobile app usage

HTML is primarily used to:

Create website structure and content

CSS is mainly responsible for:

Styling and layout

Which of the following best describes the World Wide Web (WWW)?

A system of interlinked hypertext documents and multimedia content accessed via the internet

Which protocol is fundamental to the functioning of the World Wide Web?

HTTP (Hypertext Transfer Protocol)

What distinguishes a web application from a traditional website?

Web applications require user interaction and perform functions, whereas websites primarily provide information

Which of the following is an example of a web application?

An e-commerce platform with shopping cart functionality

Which characteristic is typical of web applications but not traditional websites?

User authentication and personalized content

What is a key characteristic of a traditional website?

Displays fixed or interactive content via web pages

Which feature best distinguishes a web application from a basic website?

It integrates with backend services and supports dynamic user interaction

How does a dynamic website differ from a static one?

It displays the same content to all users

Which of the following technologies is typically used in web application development?

HTML, CSS, Javascript with server-side integration

Which example best represents a web application?

An e-commerce platform with shopping and payment features

Which of the following is considered a low-cost online business idea that relies more on human creativity than automation?

Freelance writing

Why is selecting a specific niche important when starting an online business?

It helps in establishing authority and attracting a dedicated customer base

How does personal branding contribute to the success of an online business?

It builds trust and differentiates the business from competitors

Why is gathering customer feedback crucial for online businesses?

It provides insights for improving products and services

What is a primary benefit of using social media platforms for an online business?

It enhances brand visibility and customer engagement

Which of the following is a characteristic of microservices architecture?

Each service operates independently and communicates via APIs

What is a primary disadvantage of monolithic architecture as applications grow?

Difficulty in scaling specific features independently

Which of the following is an advantage of microservices architecture?

Independent deployment and scaling of services

 In serverless architecture, developers primarily focus on:

Writing code for individual functions without worrying about server management

Which layer in the three-tier architecture is responsible for handling business logic?

Logic layer

Which perspective views a database as a combination of data, software, and custom procedures to address specific problems?

Database as a combination of data, software, and custom procedures

In the perspective of a database as a body of data, what is emphasized?

The organization and storage of raw information

What does the perspective of a database as software focus on?

The Database Management System (DBMS) that manages data

Which of the following is an example of a custom procedure in a database?

A stored procedure that automatically updates inventory when an order is placed

Why are custom procedures important in a database?

They automate tasks and enforce business logic

What the following SQL code does? What will be the output of the SQL for the given data?

SELECT  
FROM student  
WHERE des IN (  
    SELECT des  
    FROM student  
    GROUP BY des  
    HAVING COUNT() > 1  
);

All students whose designation appears more than once in the table

What the following SQL code does? What will be the output of the SQL for the given data?

SELECT  
FROM student  
WHERE major = (  
    SELECT major  
    FROM student  
    GROUP BY major  
    ORDER BY COUNT() DESC  
    LIMIT 1  
);

All students who belong to the most common major in the table

Which of the following queries correctly selects all unique job titles from a employees table where the department is 'Sales'?

SELECT DISTINCT job_title FROM employees WHERE department = 'Sales';

What is the result of the following query if the orders table has no row with customer_id = 5?

SELECT COUNT(*) FROM orders WHERE customer_id = 5;

Returns 0

What does the following SQL query return?

SELECT *  
FROM student  
WHERE major = (  
    SELECT major  
    FROM student  
    WHERE SID = (  
        SELECT SID  
        FROM student  
        WHERE fname = (  
            SELECT fname  
            FROM student  
            WHERE des LIKE '%sausage%'  
            LIMIT 1  
        )  
        LIMIT 1  
    )  
    LIMIT 1  
);

All students who have the same major as the first student whose designation contains the word "sausage"

What is a key advantage of using external CSS over inline CSS?

External CSS can be applied to multiple pages, ensuring consistency.

What is the correct HTML5 semantic element to group introductory content like a site title and tagline?

<header>

Which of the following is the correct way to make a hyperlink open in a new browser tab?

<a href="page.html" target="_blank">

What is the result of the following CSS rule?

p + ul { margin-top: 20px; }

Applies 20px top margin to any <ul> immediately preceded by a <p>

Which CSS selector is used to select elements with a specific class?

.classname

Which of the following best describes server-side programming?

Scripts that run on the server to process requests and generate dynamic content.

What does PHP stand for, and what is its primary use?

PHP: Hypertext Preprocessor; a server-side scripting language for web development.

How is a PHP code block typically initiated and terminated?

<?php to start and ?> to end the PHP code.

Which symbol is used to declare a variable in PHP?

$

Which of the following is a valid way to write a single-line comment in PHP?

// This is a comment

In the given PHP script, which of the following statements best describes what happens when the "LOAD" button is clicked and the page is refreshed immediately after?

The script prevents form re-submission by redirecting, so the cart remains unchanged on refresh after clicking "LOAD".

Which of the following describes an application of the PHP $_GET method?

Passing query parameters in URLs

Which best describes a usage of the PHP $_SESSION method?

Allows user data to be held persistently across several pages on the site

What is the function of the following code?

Make a request for form submission and process locally

Which of the following describes the PHP $_POST method?

A superglobal array that securely collects submitted HTML data

What is the purpose of this code?

Enabling dark mode from the client side with embedded javascript

Which of the following is JavaScript most suited for?

DOM manipulation

Which of the following stores the value of the "email" element in a variable?

var email = document.getElementById("email").value;

Why might you use Javascript for client-side form validation over HTML?

Javascript can validate complex relationships between form elements

What is the function of this code?

<button id="changeTextButton">Click me to change text</button>
<p id="text">Hello, World!</p>

<script>
  document.getElementById('changeTextButton').onclick = function() {               document.getElementById('text').innerText = "Text has been changed!";

};
</script>

Dynamically modify DOM elements

What is a primary purpose of using a web framework in web development?

To provide a structured foundation for building and maintaining web applications efficiently

Which of the following is a common benefit of utilizing web frameworks in development?

They offer reusable code modules and standardized practices, accelerating development

What distinguishes front-end frameworks from back-end frameworks?

Front-end frameworks focus on the user interface and experience, whereas back-end frameworks handle server-side logic and database interactions.

Which of the following is a widely-used back-end web framework?

Django

When selecting a web framework for a project, which factor is most important to consider?

The framework's compatibility with the project's specific requirements and goals

What is the primary purpose of authentication in web applications?

To verify the identity of users before granting access to certain resources or functionalities

Which of the following is a common method used for user authentication in web applications?

Implementing multi-factor authentication

Why is it important to securely store user credentials in web applications?

To protect user information and prevent unauthorized access

What is the role of session management after a user has been authenticated?

To maintain the user's login state throughout their interaction with the application

What is the purpose of using authentication tokens like JWT in web applications?

To facilitate secure communication between clients and servers without maintaining session state on the server

Which of the following best describes the importance of SEO for web applications?

SEO improves visibility in search engine results, increases organic traffic, enhances user experience, builds credibility, and offers long-term ROI

Which of the following is NOT a key component of effective SEO?

Increasing server hardware

Which practice is considered an on-page SEO technique?

Optimizing meta tags and content within the website

Which of the following is a technical SEO consideration for web applications?

Improving site speed and ensuring mobile responsiveness

Which activity is considered an off-page SEO strategy?

Building backlinks from reputable external websites

What is the initial step in setting up a dynamic website using cPanel?

Creating an online account in cPanel and setting up a MySQL database

How can you display data from an online MySQL database in your browser?

By using PHP scripts to connect to the database and fetch data

How can you enhance your web application by displaying images along with database results?

By storing image URLs in the database and using HTML to display them

What is an effective way to improve the visual presentation of database results on a web page?

By applying CSS styles to the HTML elements displaying the data

Why is pagination important in displaying database records on a web page?

It helps in displaying a fixed number of records per page, improving user experience