Quiz catalog

beginner

SQL Basics & Queries

SELECT, WHERE, ORDER BY, DISTINCT, LIKE, IN/BETWEEN, NULL handling, COUNT and COALESCE

beginner

SQL & Databases for Java Interview

12 questions on SQL, joins, transactions, ACID and indexes

beginner

SQL Joins

INNER, LEFT/RIGHT, FULL OUTER, CROSS and self joins, anti-joins and the ON vs WHERE pitfall

beginner

SQL Subqueries & CTEs

Correlated/non-correlated subqueries, EXISTS, derived tables, scalar subqueries and recursive CTEs

beginner

SQL Window Functions

OVER/PARTITION BY, ROW_NUMBER/RANK/DENSE_RANK, LAG/LEAD, running totals, NTILE and frames

beginner

Testing & Dependency Injection in C# for the Interview

12 questions on unit testing, xUnit/Moq, AAA, IoC/DI, lifetimes and the Dependency Inversion Principle

beginner

Testing: JUnit & Mockito for Java Interview

12 questions on unit testing, JUnit 5 and Mockito

beginner

Text Processing, Pipes & Redirection

pipes, > >> redirection, grep, sed, awk, wc, sort, uniq, cut and 2>

beginner

Transactions & Concurrency

ACID, commit/rollback, isolation levels, dirty/non-repeatable/phantom reads, deadlocks and locking

beginner

Users, Groups & Package Management

/etc user & shadow files, useradd, passwd, su, whoami, groups, usermod, apt and dnf/yum

beginner

Views, Stored Procedures & Advanced SQL

Views & materialized views, stored procedures vs functions, triggers, UNION, CASE, MERGE and GRANT

Showing 181 to 191 of 191 results