Tuesday, August 25, 2026

Complete G.C.E. A/L ICT Unit 10.5 (CSS - Style Sheets, Selectors, Formatting) and 10.6 (Web Authoring Tools) notes in Tamil with code examples and exam Q&A

ЁЯОи G.C.E. A/L ICT (родрооிро┤் роКроЯроХроо்)

Unit 10.5: CSS (Style Sheets) & Unit 10.6: Web Authoring Tools

ЁЯУМ роЗрои்родрок் рокாроЯрод்родிрой் роиோроХ்роХроо்: Unit 10.5-ро▓் CSS роЕроЯிрок்рокроЯைроХро│், Selectors, Insertion Methods, Formatting рооро▒்ро▒ுроо் Unit 10.6-ро▓் Web Authoring Tools рокро▒்ро▒ி Theory, Examples, Code Blocks, рооро▒்ро▒ுроо் Question & Answer ро╡роЯிро╡ிро▓் роОро│ிрооைропாроХроХ் роХро▒்ро▒ுроХ்роХொро│்ро│ро▓ாроо்.
10.5.1

Style Sheet / CSS роОрой்ро▒ாро▓் роОрой்рой?

CSS = Cascading Style Sheets

HTML elements-рой் родோро▒்ро▒роо் (Appearance) рооро▒்ро▒ுроо் ро╡роЯிро╡рооைрок்рокு (Formatting) роЖроХிропро╡ро▒்ро▒ை роХроЯ்роЯுрок்рокроЯுрод்род рокропрой்рокроЯுрод்родрок்рокроЯுроо் ро╡ிродிроХро│ிрой் родொроХுрок்рокு.

  • HTML → Web page-рой் structure/content роЙро░ுро╡ாроХ்роХுроХிро▒родு
  • CSS → Web page-рой் appearance/design рооாро▒்ро▒ுроХிро▒родு
h1 {
    color: blue;
    font-size: 30px;
}
CSS Benefits

CSS роЗрой் рооுроХ்роХிроп роирой்рооைроХро│்

  • Web page-рой் design-роР роОро│ிродாроХ рооாро▒்ро▒ рооுроЯிропுроо்
  • роТро░ே Style-роР рокро▓ elements-роХ்роХு рокропрой்рокроЯுрод்род рооுроЯிропுроо்
  • Code duplication роХுро▒ைроХிро▒родு
  • Website maintenance роОро│ிродாроХிро▒родு
10.5.2

CSS Syntax

selector {
    property: value;
}
рокроХுродிрокொро░ுро│்роЙродாро░рогроо்
SelectorроОрои்род element-роХ்роХு stylep, h1
PropertyроОродை рооாро▒்ро▒ ро╡ேрог்роЯுроо்color, font-size
ValueроОро╡்ро╡ாро▒ு рооாро▒்ро▒ ро╡ேрог்роЯுроо்red, 20px
p {
    color: red;
    font-size: 20px;
}
10.5.3

CSS Comments

CSS code-роР browser-ро▓் display роЪெроп்ропாрооро▓் developer-роХ்роХு explanation роОро┤ுрод рокропрой்рокроЯுроХிро▒родு.

/* This is a comment */

/* Heading style */
h1 {
    color: green;
    font-size: 30px;
}
⚠️ Exam Point: CSS comment → /* comment */ | HTML comment → <!-- comment -->
4 Types

роиாрой்роХு рооுроХ்роХிроп CSS Selectors

SelectorSymbolрокропрой்рокாроЯுроЙродாро░рогроо்
ElementNoneTag name рооூро▓роо்p { }
ID#роТро░ு specific element#special { }
Class.рокро▓ elements-роХ்роХு.important { }
GroupCommaрокро▓ selectors-роХ்роХுh1, h2, p { }
1. Element Selector

Element Selector

HTML element рокெропро░ை роиேро░роЯிропாроХ рокропрой்рокроЯுрод்родுро╡родு.

p {
    color: blue;
}

h1 {
    color: red;
}
2. ID Selector

ID Selector (#)

HTML: <p id="special">Important Message</p>

#special {
    color: red;
    font-size: 25px;
}
ЁЯОп роиிройைро╡ிро▓் ро╡ைроХ்роХ: ID → # (роТро░ே роТро░ு element-роХ்роХு роороЯ்роЯுроо்)
3. Class Selector

Class Selector (.)

HTML: <p class="important">Hello</p>

.important {
    color: green;
    font-weight: bold;
}
ЁЯОп роиிройைро╡ிро▓் ро╡ைроХ்роХ: Class → . (рокро▓ elements-роХ்роХு)
4. Group Selector

Group Selector (,)

рокро▓ selectors-роХ்роХு роТро░ே style рокропрой்рокроЯுрод்род comma рокропрой்рокроЯுрод்родுро╡родு.

h1, h2, p {
    color: blue;
}
ID vs Class

ID vs Class - ро╡ேро▒ுрокாроЯு

IDClass
# рокропрой்рокроЯுрод்родрок்рокроЯுроо். рокропрой்рокроЯுрод்родрок்рокроЯுроо்
роТро░ு element-роХ்роХு роороЯ்роЯுроо் (Unique)рокро▓ elements-роХ்роХு
Example: #headerExample: .box
3 Ways

Inline, Internal, External CSS

TypeCSS роЗро░ுроХ்роХுроо் роЗроЯроо்рокропрой்рокாроЯு
InlineHTML tag-роХ்роХுро│்Single element
Internal<style> tagSingle webpage
External.css fileMultiple webpages
1. Inline CSS

Inline CSS (Style Attribute)

HTML tag-рой் роЙро│்ро│ே style attribute рокропрой்рокроЯுрод்родுро╡родு.

<p style="color:red;">Hello World</p>
  • Advantage: роТро░ு element-роХ்роХு роЙроЯройроЯிропாроХ style роХொроЯுроХ்роХ рооுроЯிропுроо்
  • Disadvantage: Code duplication, Maintenance роХроЯிройроо்
2. Internal CSS

Internal CSS (<style> Tag)

HTML document-рой் <head> рокроХுродிропிро▓் <style> tag рокропрой்рокроЯுрод்родுро╡родு.

<head>
<style>
p {
    color: blue;
    font-size: 20px;
}
</style>
</head>
3. External CSS

External CSS (.css File)

CSS code-роР родройிропாрой .css file-ро▓் роЪேрооிрод்родு HTML document-роХ்роХு link роЪெроп்ро╡родு.

HTML-ро▓்:

<link rel="stylesheet" href="style.css">

style.css-ро▓்:

body {
    background-color: lightblue;
}

h1 {
    color: red;
}
⭐ рооிроХ рооுроХ்роХிропрооாрой роирой்рооை: роТро░ே CSS file-роР рокро▓ HTML pages рокропрой்рокроЯுрод்род рооுроЯிропுроо். Website maintenance рооிроХро╡ுроо் роОро│ிродாроХிро▒родு.
Background

A. Background Color & Image

/* Background Color */
body {
    background-color: lightblue;
}

/* Background Image */
body {
    background-image: url("background.jpg");
    background-repeat: no-repeat;
    background-size: cover;
}
Text

B. Text Formatting

p {
    color: red;
    text-align: center;
}

text-align values: left, right, center, justify

Fonts

C. Font Properties

p {
    font-family: Arial;
    font-size: 20px;
    font-weight: bold;
    font-style: italic;
    color: blue;
}
Links

D. Link States

a:link {
    color: blue;
}

a:visited {
    color: purple;
}

a:hover {
    color: red;  /* Mouse pointer link-рой் рооேро▓் роЪெро▓்ро▓ுроо்рокோродு */
}

a:active {
    color: green;
}
⭐ рооிроХ рооுроХ்роХிропрооாройродு: hover = mouse pointer link-рой் рооேро▓் роЪெро▓்ро▓ுроо்рокோродு роиிро▒роо் рооாро▒ுроо்
Lists

E. List Formatting

ul {
    list-style-type: square;
    /* values: disc, circle, square, none */
}

ol {
    list-style-type: upper-roman;
}
Tables

F. Table Formatting

table {
    width: 100%;
    border-collapse: collapse;
}

th {
    background-color: navy;
    color: white;
}

td {
    padding: 8px;
}

th, td {
    border: 1px solid black;
}
Full Example

рооுро┤ுрооைропாрой Practical Example

<!DOCTYPE html>
<html>
<head>
<title>My Website</title>
<style>
body {
    background-color: lightblue;
    font-family: Arial;
}
h1 {
    color: darkblue;
    text-align: center;
}
p {
    color: black;
    font-size: 18px;
}
.important {
    color: red;
    font-weight: bold;
}
#special {
    background-color: yellow;
}
a:hover {
    color: red;
}
table {
    border-collapse: collapse;
}
th, td {
    border: 1px solid black;
    padding: 10px;
}
</style>
</head>
<body>
<h1>My School</h1>
<p>Welcome to my website.</p>
<p class="important">Important Notice</p>
<p id="special">Special Message</p>
<a href="#">Visit Us</a>
<table>
<tr><th>Name</th><th>Marks</th></tr>
<tr><td>Kamal</td><td>85</td></tr>
</table>
</body>
</html>

ЁЯУЭ рооுроХ்роХிроп Exam Q&A

Q1

What is CSS?

Answer: CSS stands for Cascading Style Sheets. It is used to control the appearance and formatting of HTML elements in web pages.

Q2

Write the basic syntax of CSS.

selector {
    property: value;
}
Q3

How do you write a comment in CSS?

/* This is a CSS comment */
Q4

Name four CSS selectors.

  • Element selector
  • ID selector
  • Class selector
  • Group selector
Q5-Q6

ID vs Class Selector Representation

ID: # symbol - #header { color: blue; }

Class: . symbol - .menu { color: red; }

Q7

Name three ways of inserting CSS.

  • Inline CSS
  • Internal CSS
  • External CSS
Q8-Q9

Practical CSS Questions

Make all h1 red & centered:

h1 {
    color: red;
    text-align: center;
}

Change background to yellow:

body {
    background-color: yellow;
}
Q10

Advantage of external CSS?

Answer: External CSS allows the same style rules to be applied to multiple HTML pages. It also makes website maintenance and design changes easier.

10.6.1

Web Authoring Tool роОрой்ро▒ாро▓் роОрой்рой?

Web pages-роР роЙро░ுро╡ாроХ்роХ, edit роЪெроп்роп рооро▒்ро▒ுроо் manage роЪெроп்роп роЙродро╡ுроо் software/application-роХро│் Web Authoring Tools роОройрок்рокроЯுроо்.

Examples:

  • Adobe Dreamweaver
  • Microsoft Expression Web
  • Visual Studio Code
  • KompoZer
  • BlueGriffon
Uses

Web Authoring Tool-рой் рокропрой்рокாроЯுроХро│்

  • Web page роЙро░ுро╡ாроХ்роХро▓ாроо்
  • HTML code роОро┤ுродро▓ாроо்
  • CSS роЪேро░்роХ்роХро▓ாроо்
  • Images & Hyperlinks роЪேро░்роХ்роХро▓ாроо்
  • Tables роЙро░ுро╡ாроХ்роХро▓ாроо்
  • Text formatting роЪெроп்ропро▓ாроо்
  • Web page preview рокாро░்роХ்роХро▓ாроо்
  • Files save/manage роЪெроп்ропро▓ாроо்
Steps

Webpage роЙро░ுро╡ாроХ்роХுроо் Steps

  • Step 1: Authoring tool-роР open роЪெроп்ропро╡ுроо்
  • Step 2: New HTML document роЙро░ுро╡ாроХ்роХро╡ுроо்
  • Step 3: Page title роЪேро░்роХ்роХро╡ுроо்
  • Step 4: Heading & paragraph роЪேро░்роХ்роХро╡ுроо்
  • Step 5: Images роЪேро░்роХ்роХро╡ுроо்
  • Step 6: Hyperlinks роЪேро░்роХ்роХро╡ுроо்
  • Step 7: CSS рооூро▓роо் appearance рооாро▒்ро▒ро╡ுроо்
  • Step 8: Preview роЪெроп்ропро╡ுроо்
  • Step 9: .html extension-ро▓் save роЪெроп்ропро╡ுроо்
  • Step 10: Images/CSS files-роР роЪро░ிропாрой folder-ро▓் ро╡ைроХ்роХро╡ுроо்
Exam Q&A

10.6 рооுроХ்роХிроп Exam Q&A

Q1. What is a Web Authoring Tool?

A: Software used to create, edit, format and manage web pages.

Q2. Give two examples.

A: Adobe Dreamweaver, Microsoft Expression Web

Q3. What can be created?

A: Web pages containing text, images, hyperlinks, tables and other web elements.

Q4. Purpose of previewing?

A: To see how the web page will appear in a web browser before publishing.

Q5. File extension for HTML?

A: .html (Example: index.html)

Q6. Purpose of HTML?

A: Define the structure and content of a web page.

Q7. Purpose of CSS?

A: Control the appearance and presentation of HTML elements.

Quick Notes

HTML vs CSS - ро╡ேро▒ுрокாроЯு

HTMLCSS
StructureAppearance
ContentDesign
Heading tagHeading colour
Paragraph tagFont size
Image tagImage presentation
Link tagLink appearance
Selectors

CSS Selectors Summary

Element → p, h1
ID      → #id
Class   → .class
Group   → h1, h2, p (comma)
Insertion

CSS Insertion Methods

Inline   → style attribute
Internal → <style> tag
External → .css file + <link>
Memory Trick

ЁЯФе A/L Memory Trick

CSS = "Change Style Simply"

Selectors - E I C G:
Element | ID | Class | Group

Insertion - I I E:
Inline | Internal | External

HTML = Structure | CSS = Style | Authoring Tool = Create/Edit Web Pages
Must Write CSS

роиீроЩ்роХро│் роХроЯ்роЯாропроо் роОро┤ுродрод் родெро░ிрои்родிро░ுроХ்роХ ро╡ேрог்роЯிроп CSS

/* CSS Example */

body {
    background-color: lightblue;
    font-family: Arial;
}

h1 {
    color: red;
    text-align: center;
}

p {
    font-size: 18px;
}

#special {
    color: green;
}

.important {
    font-weight: bold;
}

a:hover {
    color: red;
}

table {
    border-collapse: collapse;
}

th, td {
    border: 1px solid black;
    padding: 10px;
}

роЗрои்род code-роР рокுро░ிрои்родுроХொрог்роЯு роОро┤ுродрод் родெро░ிрои்родாро▓் 10.5-ро▓் ро╡ро░ுроо் theory + structured/practical CSS questions-роХ்роХு роиро▓்ро▓ роЕроЯிрок்рокроЯை роХிроЯைроХ்роХுроо்.

❓ роЕроЯிроХ்роХроЯி роХேроЯ்роХрок்рокроЯுроо் роХேро│்ро╡ிроХро│் (FAQ)

Q: CSS роОрой்ро▒ாро▓் роОрой்рой? A: CSS роОрой்рокродு Cascading Style Sheets роЖроХுроо். роЗродு HTML elements-рой் родோро▒்ро▒роо் (Appearance) рооро▒்ро▒ுроо் ро╡роЯிро╡рооைрок்рокு (Formatting) роЖроХிропро╡ро▒்ро▒ை роХроЯ்роЯுрок்рокроЯுрод்род рокропрой்рокроЯுрод்родрок்рокроЯுроо் ро╡ிродிроХро│ிрой் родொроХுрок்рокாроХுроо்.
Q: CSS-рой் роЕроЯிрок்рокроЯை syntax роОрой்рой? A: CSS-рой் роЕроЯிрок்рокроЯை syntax: selector { property: value; } - роОроЯுрод்родுроХ்роХாроЯ்роЯு: p { color: red; font-size: 20px; }
Q: CSS Selectors-рой் ро╡роХைроХро│் ропாро╡ை? A: роиாрой்роХு рооுроХ்роХிроп CSS Selectors: 1. Element Selector (p, h1), 2. ID Selector (#header), 3. Class Selector (.menu), 4. Group Selector (h1, h2, p).
Q: HTML-ро▓் CSS роЪேро░்роХ்роХுроо் рооூрой்ро▒ு ро╡ро┤ிроХро│் ропாро╡ை? A: рооூрой்ро▒ு ро╡ро┤ிроХро│்: 1. Inline CSS (style attribute рооூро▓роо்), 2. Internal CSS (<style> tag рооூро▓роо் head-ро▓்), 3. External CSS (.css file-роР <link> рооூро▓роо் роЗрогைрод்родро▓்).
Q: Web Authoring Tool роОрой்ро▒ாро▓் роОрой்рой? A: Web Authoring Tool роОрой்рокродு web pages-роР роЙро░ுро╡ாроХ்роХ, edit роЪெроп்роп рооро▒்ро▒ுроо் manage роЪெроп்роп роЙродро╡ுроо் software роЖроХுроо். роОроЯுрод்родுроХ்роХாроЯ்роЯுроХро│்: Adobe Dreamweaver, Microsoft Expression Web, Visual Studio Code, KompoZer.

Friday, August 21, 2026

G.C.E. A/L ICT Unit 10 Tamil Medium | HTML5 & Multimedia Web Development, WWW, Website Types, HTML Tags, Tables, Hyperlinks, Audio/Video with exam questions

ЁЯМР G.C.E. A/L ICT (родрооிро┤் роКроЯроХроо்)

Unit 10: HTML5 рооூро▓роо் Multimedia Websites роЙро░ுро╡ாроХ்роХுродро▓்

ЁЯУМ роЗрои்родрок் рокாроЯрод்родிрой் роиோроХ்роХроо்: Competency 10-ро▓் WWW, Website ро╡роХைроХро│், User Requirements Analysis, HTML5 роЕроЯிрок்рокроЯைроХро│், Tags, Tables, Hyperlinks, Audio/Video роЖроХிропро╡ро▒்ро▒ை Theory, Examples, HTML Code, рооро▒்ро▒ுроо் Question & Answer ро╡роЯிро╡ிро▓் роОро│ிрооைропாроХроХ் роХро▒்ро▒ுроХ்роХொро│்ро│ро▓ாроо்.
10.1

World Wide Web (WWW) роОрой்ро▒ாро▓் роОрой்рой?

ро╡ро░ைропро▒ை: Internet рооூро▓роо் роЕрогுроХроХ்роХூроЯிроп, роТрой்ро▒ோроЯொрой்ро▒ு hyperlinks рооூро▓роо் роЗрогைроХ்роХрок்рокроЯ்роЯ web pages рооро▒்ро▒ுроо் web resources-роХро│ிрой் родொроХுрок்рокு.

Internet ≠ WWW

  • Internet: рооிроХрок்рокெро░ிроп network infrastructure
  • WWW: Internet-роРрок் рокропрой்рокроЯுрод்родி web pages-роР роЕрогுроХுроо் роТро░ு service
WWW роХூро▒ுроХро│்

WWW-рой் рооுроХ்роХிроп роХூро▒ுроХро│்

роХூро▒ுро╡ிро│роХ்роХроо்
Web BrowserWeb pages-роР рокாро░்рок்рокродро▒்роХாрой software (Chrome, Firefox)
Web ServerWeb pages/files-роР роЪேрооிрод்родு ро╡ро┤роЩ்роХுроо் computer
WebsiteроТрой்ро▒ோроЯொрой்ро▒ு родொроЯро░்рокுроЯைроп web pages родொроХுрок்рокு
Web PageWebsite-рой் роТро░ு individual page
URLWeb resource-рой் рооுроХро╡ро░ி
HTTP/HTTPSBrowser рооро▒்ро▒ுроо் server роЗроЯைропிро▓ாрой communication protocol
HTMLWeb page-рой் structure роЙро░ுро╡ாроХ்роХுроо் markup language
HyperlinkроТро░ு resource-роЗро▓ிро░ுрои்родு рооро▒்ро▒ொро░ு resource-роХ்роХு роЪெро▓்ро▓ роЙродро╡ுроо் link
Website ро╡роХைроХро│்

Website-рой் ро╡роХைроХро│்

  • Information Website: Government, Health, Weather information ро╡ро┤роЩ்роХுродро▓்.
  • News Website: Local, International, Sports, Business news.
  • Personal Website: роТро░ு родройிроирокро░ைрок் рокро▒்ро▒ிроп portfolio (About Me, Education, Skills).
  • Educational Website: Online learning, School/University websites, Courses.
  • Commercial Website: Online shopping, Company/Product websites.
  • Research Website: Research papers, Scientific information, Academic publications.
Web Portal

Web Portal роОрой்ро▒ாро▓் роОрой்рой?

ро╡ро░ைропро▒ை: рокро▓ ро╡роХைропாрой information рооро▒்ро▒ுроо் services-роР роТро░ே web interface рооூро▓роо் рокропройро░ுроХ்роХு ро╡ро┤роЩ்роХுроо் website.

роЙродாро░рогроо்: Student Portal (Login, Results, Attendance, Timetable, Assignments, Announcements).

10.2

Website Objective (роиோроХ்роХроо்)

Website роЙро░ுро╡ாроХ்роХுро╡родрой் рооுроХ்роХிроп роиோроХ்роХроо் роОрой்рой роОрой்рокродை рооுродро▓ிро▓் родீро░்рооாройிроХ்роХ ро╡ேрог்роЯுроо்.

роЙродாро░рогроо் - School Website Objectives:

  • School information ро╡ро┤роЩ்роХுродро▓்.
  • Students-роХ்роХு announcements ро╡ро┤роЩ்роХுродро▓்.
  • Parents-роХ்роХு important information ро╡ро┤роЩ்роХுродро▓்.
  • School events рокро▒்ро▒ி родெро░ிро╡ிроХ்роХுродро▓்.
  • Contact information ро╡ро┤роЩ்роХுродро▓்.
Content & Structure

Contents рооро▒்ро▒ுроо் Structure

роТро░ு website-ро▓் родேро╡ைропாрой web pages-роР рооுродро▓ிро▓் identify роЪெроп்роп ро╡ேрог்роЯுроо்.

роЙродாро░рогроо் - Educational Website Structure:

Home
│
├── About
├── Lessons
├── Past Papers
├── Videos
── Downloads
└── Contact
          
Navigation

Navigation Structure

User роТро░ு page-ро▓ிро░ுрои்родு рооро▒்ро▒ொро░ு page-роХ்роХு роОро╡்ро╡ாро▒ு роЪெро▓்ро▓ ро╡ேрог்роЯுроо் роОрой்рокродை navigation structure родீро░்рооாройிроХ்роХிро▒родு.

Good Navigation-рой் рокрог்рокுроХро│்: Simple, Clear, Consistent, Easy to understand, Easily accessible.

10.3

HTML роОрой்ро▒ாро▓் роОрой்рой?

HTML = HyperText Markup Language

Web pages-рой் structure роЙро░ுро╡ாроХ்роХрок் рокропрой்рокроЯுрод்родрок்рокроЯுроо் markup language. роЗродு programming language роЕро▓்ро▓ (Variables, Loops, Conditions роЗро▓்ро▓ை).

Basic Structure

HTML Document-рой் роЕроЯிрок்рокроЯை Structure

<html>
  <head>
    <title>My Web Page</title>
  </head>
  <body>
    Welcome to my website.
  </body>
</html>
          
  • <html>: HTML document-рой் рооுро┤ு content.
  • <head>: Metadata рооро▒்ро▒ுроо் page-related information.
  • <title>: Browser tab-ро▓் роХாроЯ்роЯрок்рокроЯுроо் title.
  • <body>: User browser-ро▓் рокாро░்роХ்роХுроо் visible content.
Common Tags

рооுроХ்роХிроп HTML Tags

Tagрокропрой்рокாроЯு
<h1> to <h6>Headings (h1 = рооிроХрок்рокெро░ிроп, h6 = рооிроХроЪ்роЪிро▒ிроп)
<p>Paragraph
<br>Line break (рокுродிроп line)
<b>Bold (родроЯிрод்род роОро┤ுрод்родு)
<i>Italic (роЪாроп்ро╡ு роОро┤ுрод்родு)
<u>Underline (роЕроЯிроХ்роХோроЯு)
<font>Font properties (size, color) - Syllabus
<!-- -->Comment (Browser-ро▓் роХாроЯ்роЯாродு)
Example

Complete Basic HTML Example

<html>
<head>
    <title>My First Website</title>
</head>
<body bgcolor="yellow">

<h1>Welcome to My Website</h1>

<p>
This is my first web page.
<br>
<b>Important:</b> HTML is easy!
</p>

<!-- This is a comment -->

</body>
</html>
          
Lists

HTML Lists (3 ро╡роХைроХро│்)

1. Ordered List (<ol>): ро╡ро░ிроЪை роОрог்роХро│ுроЯрой்.

<ol>
    <li>HTML</li>
    <li>CSS</li>
    <li>JavaScript</li>
</ol>
          

2. Unordered List (<ul>): Bullet points.

3. Definition List (<dl>): Definition/Description.

  • <dl>: Definition List
  • <dt>: Definition Term
  • <dd>: Definition Description
Images

Images (<img>)

<img src="school.jpg" alt="School Logo">
          
  • src: Image file location
  • alt: Alternative text (Image load роЖроХாро╡ிроЯ்роЯாро▓் роХாроЯ்роЯுроо்)
Tables

Tables - роЕроЯிрок்рокроЯை Structure

<table border="1">
<caption>Student Results</caption>
<tr>
    <th>Name</th>
    <th>Marks</th>
</tr>
<tr>
    <td>Ahmed</td>
    <td>85</td>
</tr>
</table>
          
TagMeaning
<table>Table
<tr>Table Row
<th>Table Heading
<td>Table Data
<caption>Table Caption/Title
Merging

colspan рооро▒்ро▒ுроо் rowspan

colspan: роЗро░рог்роЯு роЕро▓்ро▓родு роЕродро▒்роХு рооேро▒்рокроЯ்роЯ columns-роР роТрой்ро▒ாроХ merge роЪெроп்роп.

<td colspan="2">Total</td>

rowspan: роЗро░рог்роЯு роЕро▓்ро▓родு роЕродро▒்роХு рооேро▒்рокроЯ்роЯ rows-роР merge роЪெроп்роп.

<td rowspan="2">ICT</td>
⭐ рооுроХ்роХிроп Exam Point: colspan = columns merge | rowspan = rows merge
10.4

Hyperlink (<a> Tag)

роТро░ு web page роЕро▓்ро▓родு resource-роЗро▓ிро░ுрои்родு рооро▒்ро▒ொро░ு web page/resource-роХ்роХு роЪெро▓்ро▓ роЙродро╡ுроо் clickable link.

<a href="...">Link Text</a>
Link Types

3 ро╡роХைропாрой Hyperlinks

1. Bookmark/Internal Link: роЕродே page-рой் ро╡ேро▒ு section-роХ்роХு.

<a href="#contact">Go to Contact</a>
...
<h2 id="contact">Contact Us</h2>
          

2. Local Link: роЕродே website-ро▓் ро╡ேро▒ு page-роХ்роХு.

<a href="about.html">About Us</a>

3. External Link: ро╡ேро▒ு website-роХ்роХு.

<a href="https://www.google.com">Google</a>
Multimedia

Audio & Video (HTML5)

Audio:

<audio controls>
    <source src="music.mp3" type="audio/mpeg">
</audio>
          

Video:

<video controls width="500">
    <source src="lesson.mp4" type="video/mp4">
</video>
          

controls attribute рооூро▓роо் Play, Pause, Volume controls роХிроЯைроХ்роХுроо்.

ЁЯУМ A/L Structured Questions

Q1

School Website Home page роЙро░ுро╡ாроХ்роХ HTML code роОро┤ுродுроХ.

<html>
<head>
    <title>My School</title>
</head>
<body>

<h1>ABC National School</h1>

<p>Welcome to ABC National School.</p>

<a href="about.html">About Us</a>

<br><br>

<img src="school.jpg" alt="School Logo">

<h2>Subjects</h2>

<ol>
    <li>ICT</li>
    <li>Mathematics</li>
    <li>Science</li>
</ol>

</body>
</html>
          
Q2

Table роЙро░ுро╡ாроХ்роХ HTML code роОро┤ுродுроХ.

<table border="1">
<caption>Student Marks</caption>
<tr>
    <th>Name</th>
    <th>ICT</th>
    <th>Maths</th>
</tr>
<tr>
    <td>Ahmed</td>
    <td>80</td>
    <td>75</td>
</tr>
<tr>
    <td>Fathima</td>
    <td>90</td>
    <td>85</td>
</tr>
</table>
          
Q3

3 ро╡роХைропாрой Hyperlinks-роХ்роХு code роОро┤ுродுроХ.

1. Bookmark: <a href="#contact">Contact</a>

2. Local: <a href="about.html">About Us</a>

3. External: <a href="https://www.google.com">Google</a>

⚡ Quick MCQ Check

  • Q: HTML stands for? A: HyperText Markup Language
  • Q: Browser title tag? A: <title>
  • Q: Ordered list tag? A: <ol>
  • Q: Hyperlink attribute? A: href
  • Q: Column merge attribute? A: colspan
  • Q: Row merge attribute? A: rowspan
⭐ Last-Minute Memory Formulas:
ЁЯМР WWW Components: Browser, Server, Website, Web Page, URL, HTTP, HTML, Hyperlink
HTML Structure: html → head (title) + body (content)
ЁЯФЧ Links: Bookmark (#id), Local (page.html), External (https://)
ЁЯУК Tables: table → tr → th/td | colspan = columns | rowspan = rows
Multimedia: <audio controls> & <video controls>

❓ роЕроЯிроХ்роХроЯி роХேроЯ்роХрок்рокроЯுроо் роХேро│்ро╡ிроХро│் (FAQ)

Q: WWW роОрой்ро▒ாро▓் роОрой்рой? A: World Wide Web (WWW) роОрой்рокродு Internet рооூро▓роо் роЕрогுроХроХ்роХூроЯிроп, роТрой்ро▒ோроЯொрой்ро▒ு hyperlinks рооூро▓роо் роЗрогைроХ்роХрок்рокроЯ்роЯ web pages рооро▒்ро▒ுроо் web resources-роХро│ிрой் родொроХுрок்рокாроХுроо்.
Q: HTML роОрой்рокродрой் ро╡ிро░ிро╡ாроХ்роХроо் роОрой்рой? A: HTML роОрой்рокродு HyperText Markup Language роЖроХுроо். роЗродு web pages-рой் structure роЙро░ுро╡ாроХ்роХрок் рокропрой்рокроЯுрод்родрок்рокроЯுроо் markup language роЖроХுроо்.
Q: Hyperlink-рой் ро╡роХைроХро│் ропாро╡ை? A: Hyperlink-рой் рооூрой்ро▒ு рооுроХ்роХிроп ро╡роХைроХро│்: 1. Bookmark/Internal Link (роЕродே page-рой் ро╡ேро▒ு section), 2. Local Link (роЕродே website-рой் ро╡ேро▒ு page), 3. External Link (ро╡ேро▒ு website).
Q: colspan рооро▒்ро▒ுроо் rowspan-роХ்роХு роЗроЯைропிро▓ாрой ро╡ேро▒ுрокாроЯு роОрой்рой? A: colspan роОрой்рокродு роЗро░рог்роЯு роЕро▓்ро▓родு роЕродро▒்роХு рооேро▒்рокроЯ்роЯ columns-роР роТрой்ро▒ாроХ merge роЪெроп்роп рокропрой்рокроЯுроХிро▒родு. rowspan роОрой்рокродு роЗро░рог்роЯு роЕро▓்ро▓родு роЕродро▒்роХு рооேро▒்рокроЯ்роЯ rows-роР merge роЪெроп்роп рокропрой்рокроЯுроХிро▒родு.

Monday, August 17, 2026

GCE A/L ICT Competency 9 - Part 2: Practice & Revision Must-Practice Questions (A/L Past-Paper Style)

ЁЯОп Competency 9 – Practice & Revision Guide

A/L Past-Paper Style Questions, Common Exam Mistakes & One-Page Memory Map

20 Must-Do Questions Python Solutions Avoid Mistakes
ЁЯОп 20 Must-Practice Questions (A/L Past-Paper Style)

роХீро┤ே роЙро│்ро│ questions-роР роиீроЩ்роХро│் роОро┤ுродி practice роЪெроп்роп ро╡ேрог்роЯுроо். роЙроЩ்роХро│் ро╡роЪродிроХ்роХாроХ рооுроХ்роХிроп coding questions-роХ்роХாрой solutions рооро▒்ро▒ுроо் hints-роо் роЗроЩ்роХே роХொроЯுроХ்роХрок்рокроЯ்роЯுро│்ро│рой.

1 Problem Solving

рокிро░роЪ்роЪிройை родீро░்роХ்роХுроо் роЪெропро▓்рооுро▒ைропிрой் роиாрой்роХு рокроЯிроХро│ை ро╡ிро│роХ்роХுроХ.

Hint: Understanding → Defining → Planning → Implementation

2 Top Down Design

роТро░ு Library Management System-роХ்роХு structure chart ро╡ро░ைроХ.

Hint: Main: Library System. Sub-modules: Books Management, Members Management, Borrow/Return.

3 Algorithm

рооூрой்ро▒ு numbers-ро▓் рокெро░ிроп number-роР роХрог்роЯро▒ிропுроо் algorithm роОро┤ுродுроХ.

Hint: IF A>B AND A>C THEN Print A... (Use AND operator)

4 Flowchart

роТро░ு number positive, negative роЕро▓்ро▓родு zero роОрой்рокродை роХрог்роЯро▒ிропுроо் flowchart ро╡ро░ைроХ.

Hint: Use nested Diamond symbols (N>0? -> Yes: Positive, No: N<0? -> Yes: Neg, No: Zero).

5 Pseudocode

1 рооுродро▓் 100 ро╡ро░ை роЙро│்ро│ even numbers-роР output роЪெроп்роп pseudocode роОро┤ுродுроХ.

START FOR I = 1 TO 100 DO IF I MOD 2 == 0 THEN PRINT I END IF END FOR STOP

6 Hand Trace

роХொроЯுроХ்роХрок்рокроЯ்роЯ Python program-рой் output-роР hand trace рооூро▓роо் роХрог்роЯро▒ிроХ.

Hint: роТро░ு table роЕрооைрод்родு роТро╡்ро╡ொро░ு variable-рой் value-ро╡ைропுроо் step-by-step-ро▓் update роЪெроп்ропро╡ுроо்.

7 Translators

Compiler рооро▒்ро▒ுроо் Interpreter роЖроХிропро╡ро▒்ро▒ை роТрок்рокிроЯுроХ.

Hint: Compiler translates whole program at once. Interpreter translates line-by-line.

8 Python (Grades)

роТро░ு student's marks роЕроЯிрок்рокроЯைропிро▓் A/B/C/F grade ро╡ро┤роЩ்роХுроо் Python program роОро┤ுродுроХ.

marks = int(input("Enter marks: ")) if marks >= 75: print("A") elif marks >= 65: print("B") elif marks >= 50: print("C") else: print("F")

9 Control Structure

Sequence, Selection, Repetition роЖроХிропро╡ро▒்ро▒ை examples роЙроЯрой் ро╡ிро│роХ்роХுроХ.

10 Nested Control

1–50 ро╡ро░ை 3-роЖро▓் ро╡роХுрокроЯுроо் numbers-роР роороЯ்роЯுроо் print роЪெроп்ропுроо் Python program роОро┤ுродுроХ.

for i in range(1, 51): if i % 3 == 0: print(i)

11 Function

роЗро░рог்роЯு numbers-рой் maximum value-роР return роЪெроп்ропுроо் user-defined function роОро┤ுродுроХ.

def max_num(a, b): if a > b: return a else: return b print(max_num(10, 25))

12 Local/Global

Local variable рооро▒்ро▒ுроо் Global variable роЗроЯைропேропாрой ро╡ேро▒ுрокாроЯுроХро│ை ро╡ிро│роХ்роХுроХ.

Hint: Local is inside a function (limited scope). Global is outside (accessible everywhere).

13 String

роТро░ு string-рой் first рооро▒்ро▒ுроо் last character-роР output роЪெроп்роп Python program роОро┤ுродுроХ.

s = "Python" print(s[0]) # First: P print(s[-1]) # Last: n

14 List Methods

append(), remove(), pop() роЖроХிропро╡ро▒்ро▒ிрой் роЪெропро▓்рокாроЯ்роЯை examples роЙроЯрой் ро╡ிро│роХ்роХுроХ.

15 Tuple

List рооро▒்ро▒ுроо் Tuple роЗроЯைропே рооூрой்ро▒ு ро╡ேро▒ுрокாроЯுроХро│ை роОро┤ுродுроХ.

Hint: Syntax ([] vs ()), Mutability (Mutable vs Immutable), Use cases.

16 Dictionary

Student name, age, marks роЖроХிропро╡ро▒்ро▒ை dictionary-ро▓் store роЪெроп்родு marks-роР output роЪெроп்роХ.

student = {"name": "Ali", "age": 18, "marks": 85} print(student["marks"])

17 File Handling

роТро░ு text file-ро▓் data write роЪெроп்родு рокிрой்ройро░் read роЪெроп்роп Python program роОро┤ுродுроХ.

# Write f = open("data.txt", "w") f.write("Hello A/L Students") f.close() # Read f = open("data.txt", "r") print(f.read()) f.close()

18 Database (SQL)

SELECT, INSERT, UPDATE, DELETE SQL statements-роР ро╡ிро│роХ்роХுроХ.

Hint: CRUD Operations (Create, Read, Update, Delete).

19 Sequential Search

роТро░ு list-ро▓் роХுро▒ிрок்рокிроЯ்роЯ number роЗро░ுроХ்роХிро▒родா роОрой்рокродை sequential search рооூро▓роо் роХрог்роЯро▒ிропுроо் Python program роОро┤ுродுроХ.

nums = [10, 20, 30, 40] target = 30 found = False for n in nums: if n == target: found = True break if found: print("Found") else: print("Not Found")

20 Bubble Sort

роХொроЯுроХ்роХрок்рокроЯ்роЯ numbers-роР ascending order-ро▓் Bubble Sort рооூро▓роо் arrange роЪெроп்роп Python program роОро┤ுродுроХ.

arr = [5, 2, 8, 1] n = len(arr) for i in range(n): for j in range(0, n-i-1): if arr[j] > arr[j+1]: arr[j], arr[j+1] = arr[j+1], arr[j] print(arr)
ЁЯЪи Exam-ро▓் роЕродிроХрооாроХ родро╡ро▒ு роЪெроп்ропுроо் роЗроЯроЩ்роХро│் (Common Mistakes)

❌ 1. `=` vs `==`

x = 10 роОрой்рокродு Assignment (value роХொроЯுрод்родро▓்).
x == 10 роОрой்рокродு Comparison (роЪро░ிрокாро░்род்родро▓் - True/False).

❌ 2. `%` (Modulo) рооро▒рои்родுро╡ிроЯாродீро░்роХро│்

Even/Odd роЕро▓்ро▓родு ро╡роХுрокроЯுроо் роОрог்роХро│ைроХ் роХрог்роЯро▒ிроп % рокропрой்рокроЯுрод்родро╡ுроо்.
n % 2 == 0 → Even number check.

❌ 3. `input()` String роОрой்рокродை рооро▒роХ்роХாродீро░்роХро│்

age = input() роЗродு string родро░ுроо். роХрогிродроЪ் роЪெропро▓்рокாроЯுроХро│ுроХ்роХு int() роЕро▓்ро▓родு float() рокропрой்рокроЯுрод்род ро╡ேрог்роЯுроо்.
age = int(input())

❌ 4. List index 0-ро▓் родொроЯроЩ்роХுроо்

[10, 20, 30, 40]
Indices: 0, 1, 2, 3
pop(2)30 remove роЖроХுроо் (20 роЕро▓்ро▓).

❌ 5. `range()` Stop value-роР include роЪெроп்ропாродு

range(1, 6)
Output: 1 2 3 4 5 (6 include роЖроХாродு).
1 to 100 ро╡ро░ை ро╡ேрог்роЯுроо் роОрой்ро▒ாро▓் range(1, 101) роОрой роОро┤ுрод ро╡ேрог்роЯுроо்.

ЁЯПЖ One-Page Memory Map (Competency 9)

роЗрои்род Memory Map-роР роТро░ு рокроХ்роХрод்родிро▓் роОро┤ுродி, родேро░்ро╡ுроХ்роХு рооுрои்родைроп роиாро│் рооройрок்рокாроЯроо் роЪெроп்ропுроЩ்роХро│்:

COMPETENCY 9 │ ├── 9.1 Problem Solving │ └─ Understand → Define → Plan → Implement │ ├── 9.2 Top Down │ └─ Modularization → Refinement → Structure Chart │ ├── 9.3 Algorithms ⭐ │ ├─ Algorithm │ ├─ Flowchart │ ├─ Pseudocode │ └─ Hand Trace │ ├── 9.4 Paradigms │ ├─ Imperative │ ├─ Declarative │ └─ Object-Oriented │ ├── 9.5 Translation │ ├─ Source / Object │ ├─ Compiler / Interpreter │ └─ Linker │ ├── 9.6 IDE │ └─ Edit → Save → Run → Debug │ ├── 9.7 Python Basics ⭐ │ ├─ Variables / Data Types │ ├─ Operators (+, -, %, ==) │ └─ Input / Output │ ├── 9.8 Control ⭐⭐⭐ │ ├─ Sequence │ ├─ Selection (if/else) │ └─ Repetition (for/while) │ ├── 9.9 Functions ⭐⭐⭐ │ ├─ Built-in / User-defined │ ├─ Parameters / Arguments │ └─ Return / Scope │ ├── 9.10 Data Structures ⭐⭐⭐ │ ├─ String / List (Mutable) │ ├─ Tuple (Immutable) │ └─ Dictionary (Key-Value) │ ├── 9.11 Files │ └─ Open ("r","w","a") → Read/Write → Close │ ├── 9.12 Database │ └─ CRUD (SELECT/INSERT/UPDATE/DELETE) │ └── 9.13 Search & Sort ⭐⭐⭐ ├─ Sequential Search └─ Bubble Sort

ЁЯОУ Expert ICT, Coding, School Classes, Digital Marketing & University Project Guidance

Struggling with your university final year project? Want to master coding, upscale your business with expert digital marketing, or learn absolute computer basics from scratch? We offer high-quality individual and group online classes conducted in English, Sinhala, or Tamil mediums. Get guaranteed academic success and professional growth with tailored guidance.


ЁЯОУ University Final Year Project Guidance & AI

Get specialized, end-to-end mentoring and technical support to pass your degree or master's program with flying colors:

  • ЁЯПл Targeted Institutes: Expert guidance tailored for BIT UCSC, UoM, SLIIT, NIBM, and other leading universities.
  • ЁЯФм Postgraduate Support: Comprehensive assistance for MSc Software Final Year Projects.
  • ЁЯдЦ AI & Smart Applications: Step-by-step implementation of AI, Machine Learning (ML), and automation modules.
  • Guaranteed Success: Help with documentation, system architecture, coding, and viva preparation.

ЁЯПл School ICT & Corporate Beginner Classes

  • ЁЯТ╗ Non-IT Staff Computer Basics: Absolute beginner-friendly online classes covering essential computer skills, office tools, and internet operations.
  • ЁЯОТ Primary & Secondary (Grades 1-10): Interactive online ICT classes tailored to build strong foundations from early ages.
  • ЁЯУЭ Exam Prep: Dedicated training packages for GCE O/L, GCE A/L ICT, and GIT exams.
  • ЁЯМН Global Syllabuses: Complete curriculum coverage for Local, Edexcel, and Cambridge in English & Tamil Mediums.

ЁЯУв Software Development & Digital Marketing Services

  • ⚙️ Software & Web Development: Professional custom software application and website development built using PHP & MySQL.
  • ЁЯОп Social Media Management: Content creation, publishing, and channel management for Facebook, Instagram, TikTok, and YouTube.
  • ЁЯУИ Ad Boosting: Highly targeted paid advertising campaigns to drive leads, traffic, and sales to your business.

ЁЯУЮ Connect With Us Instantly

Book your slot for online classes or get a premium tech service quote today!

ЁЯТм WhatsApp: +94 729622034

ЁЯУз Email: ITClassSL@gmail.com


ЁЯМР Explore Our Resources & Communities

Stay updated with our latest tutorials, project ideas, and student guides across all our official platforms:

G.C.E. A/L ICT Unit 9.2: Python Databases, Searching & Sorting Complete A/L ICT Unit 9 notes covering Python SQLite database management

ЁЯТ╗ G.C.E. A/L ICT – Unit 9: Programming

Database Management, Searching & Sorting Algorithms

ЁЯУЪ About this guide: Complete, exam-focused notes for G.C.E. Advanced Level ICT Unit 9. Covers Python SQLite Database Management (SELECT, INSERT, UPDATE, DELETE), Sequential Search, and Bubble Sort with theory, Python code examples, step-by-step sorting passes, and model exam questions.
Definitions

Important Database Terms

  • Database: An organized collection of related data.
  • Table: A structure used to store data in rows and columns.
  • Record: A complete row of information (e.g., 101 | Amal | 18 | 75).
  • Field: A column representing one type of information (e.g., Name).
  • Primary Key: A field that uniquely identifies each record (e.g., StudentID).
SQL Basics

The 4 Main SQL Operations (S-I-U-D)

OperationSQL CommandPurpose
RetrieveSELECTGet data
AddINSERTAdd a new record
ModifyUPDATEChange existing data
DeleteDELETERemove data
ЁЯОп Memory Trick: SELECT = See | INSERT = Add | UPDATE = Change | DELETE = Remove
Setup

Connecting & Creating a Cursor

import sqlite3

# 1. Connect to database
conn = sqlite3.connect("school.db")

# 2. Create a cursor
cursor = conn.cursor()
          

Why a cursor? It is used to execute SQL statements and retrieve results from the database.

Retrieve

SELECT & Fetching Data

# Retrieve all records
cursor.execute("SELECT * FROM Student")
rows = cursor.fetchall()  # Gets ALL remaining records

for row in rows:
    print(row)

# OR retrieve just one record
row = cursor.fetchone()
print(row)
          
Modify

INSERT, UPDATE, DELETE & commit()

# INSERT with Python variables (using ? placeholders)
cursor.execute("INSERT INTO Student VALUES (?, ?, ?, ?)", 
               (106, "Ravi", 18, 88))

# UPDATE specific record
cursor.execute("UPDATE Student SET Marks = 90 WHERE StudentID = 102")

# DELETE specific record
cursor.execute("DELETE FROM Student WHERE StudentID = 103")

# ⭐ ALWAYS save changes!
conn.commit()
conn.close()
          
⚠️ Critical Exam Point: Always use conn.commit() after INSERT, UPDATE, or DELETE to save changes. Also, always use a WHERE clause in UPDATE/DELETE, otherwise you will modify or delete all records!
Searching

Sequential (Linear) Search

Theory: Examines elements one by one from the beginning until the required value is found or all elements are checked.

numbers = [10, 25, 30, 45, 60]
search = 45
found = False

for i in range(len(numbers)):
    if numbers[i] == search:
        print("Found at position", i)
        found = True
        break

if not found:
    print("Not found")
          
Sorting

Bubble Sort

Theory: Repeatedly compares adjacent elements and swaps them if they are in the wrong order. Larger elements "bubble" to the end.

numbers = [5, 3, 8, 4, 2]
n = len(numbers)

for i in range(n - 1):
    for j in range(n - 1 - i):
        if numbers[j] > numbers[j + 1]:
            # Swap elements
            numbers[j], numbers[j + 1] = numbers[j + 1], numbers[j]

print(numbers) # Output: [2, 3, 4, 5, 8]
          
ЁЯОп Why n - 1 - i? After each pass, the largest unsorted element reaches its correct final position at the end. Therefore, we don't need to compare it again, reducing the number of comparisons in each subsequent pass.
Comparison

Sequential Search vs. Bubble Sort

FeatureSequential SearchBubble Sort
PurposeFind dataArrange data
MechanismChecks elements sequentiallyCompares adjacent elements
Data ChangeDoes not change data orderChanges the order of data

ЁЯУМ A/L Exam Practice Questions

Q1

Write an SQL statement to retrieve names of students with marks > 80.

SELECT Name FROM Student WHERE Marks > 80;
Q2

Write an SQL statement to change the marks of StudentID 5 to 95.

UPDATE Student SET Marks = 95 WHERE StudentID = 5;
Q3

What searching technique examines data from the first element toward the last?

Answer: Sequential search.

Q4

What is the purpose of if numbers[j] > numbers[j + 1]: in Bubble Sort?

Answer: It compares two adjacent elements to determine if they need to be swapped to achieve ascending order.

⭐ Memorize vs. Understand

ЁЯза MEMORIZE:
SELECT → Retrieve | INSERT → Add | UPDATE → Modify | DELETE → Delete
fetchall() → all records | fetchone() → one record | commit() → save changes

ЁЯТб UNDERSTAND:
1. How Python connects to a database and executes SQL.
2. How sequential search checks items one by one.
3. How bubble sort compares adjacent values, swaps them, and why comparisons decrease each pass (n - 1 - i).

❓ Frequently Asked Questions (FAQ)

Q: What is a Primary Key in a database? A: A Primary Key is a field that uniquely identifies each record in a database table. For example, a StudentID ensures that no two students have the same identifier.
Q: What is the difference between Sequential Search and Bubble Sort? A: Sequential Search is a searching algorithm used to find a specific item by checking elements one by one from the beginning. Bubble Sort is a sorting algorithm that repeatedly compares adjacent elements and swaps them if they are in the wrong order to arrange data.
Q: Why is conn.commit() used in Python database programming? A: The conn.commit() method is used to save changes made to the database. It is required after executing INSERT, UPDATE, or DELETE statements to permanently apply the modifications.
Q: What are the four main SQL operations? A: The four main SQL operations are: SELECT (Retrieve data), INSERT (Add a new record), UPDATE (Modify existing data), and DELETE (Remove data).
Q: Why does the inner loop in Bubble Sort use range(n - 1 - i)? A: After each pass, the largest unsorted element "bubbles" to its correct final position at the end of the list. Therefore, we don't need to compare it again, reducing the number of comparisons in each subsequent pass.