SQL · Theory

LOWER()()

Theory

150/439

LOWER()()

LOWER()() (str) sits in a small live site. Riya’s job is LOWER str on Riya's board. Write that first.

LOWER()() (str) on the board: one LOWER str step Riya can write from memory. Then say what LOWER str on Riya's board looks like after.

Skip LOWER()() (str) and only reciting the name of LOWER str shows up in a small live site.

Use LOWER()() (str) when LOWER str on Riya's board must stay clear. If a simpler SQL step works, use that instead.

LOWER()() (str) trap — only reciting the name of LOWER str. Riya loses marks for that every viva.

Place LOWER()() (str) next to nearby SQL work — one LOWER str step Riya can write from memory is the link.

Viva for LOWER()() (str): what it is → one LOWER str step Riya can write from memory → the mistake (only reciting the name of LOWER str).

Exam tip

Board: LOWER str on Riya's board. Dry-run LOWER()() (str). Name the trap: only reciting the name of LOWER str.

LOWER()() — sample query

-- LOWER()()
CREATE TABLE demo (
  id INTEGER PRIMARY KEY,
  label TEXT NOT NULL,
  qty INTEGER DEFAULT 0
);
INSERT INTO demo (id, label, qty) VALUES
  (1, 'alpha', 2),
  (2, 'beta', 5);
SELECT label, qty FROM demo WHERE qty >= 2 ORDER BY qty DESC;

LOWER()(): create two demo rows, then SELECT qty >= 2 ordered. Say which labels come back.

Short notes

DefLOWER()() (str) — Riya uses it for LOWER str on Riya's board in a small live site.
RuleLOWER()() (str) → one LOWER str step Riya can write from memory.
RememberLOWER()() (str) + an index (a small live site).
UseLOWER()() (str) in a small live site (LOWER str on Riya's board).
TrapLOWER()() (str) — only reciting the name of LOWER str.
ExLOWER()() (str) → LOWER str on Riya's board.

-- LOWER()() CREATE TABLE demo ( id INTEGER PRIMARY KEY, label TEXT NOT NULL, qty INTEGER DEFAULT 0 ); INSERT INTO demo (id, label, qty) VALUES (1, 'alpha', 2), (2, 'beta', 5); SELECT label, qty FROM demo WHERE qty >= 2 ORDER BY qty DESC;

LOWER()()

LOWER()() — sample query

Short notes

Questions

LOWER()()

LOWER()() — sample query

Short notes

Questions