| 1 | What is a columnstore index in SQL Server, and how is it different from a regular index? SQL Server › Columnstore Indexes | SQL Server | Columnstore Indexes | Beginner |
| 2 | What is the difference between a clustered columnstore index and a nonclustered columnstore index? SQL Server › Columnstore Indexes | SQL Server | Columnstore Indexes | Beginner |
| 3 | What are Row and Column, and how do they let you arrange several separate child widgets either horizontally or vertically alongside one another? Flutter › Layout Widgets (Row, Column, Stack, Container) | Flutter | Layout Widgets (Row, Column, Stack, Container) | Beginner |
| 4 | How does columnstore compression work, and why does it typically achieve much higher compression ratios than regular row based storage? SQL Server › Columnstore Indexes | SQL Server | Columnstore Indexes | Intermediate |
| 5 | What kinds of workloads benefit the most from columnstore indexes, and which workloads should avoid them? SQL Server › Columnstore Indexes | SQL Server | Columnstore Indexes | Intermediate |
| 6 | What tools or queries can you use to monitor the health and effectiveness of a columnstore index over time? SQL Server › Columnstore Indexes | SQL Server | Columnstore Indexes | Intermediate |
| 7 | How do Expanded and Flexible let you properly control exactly how much genuinely available space a specific given child should actually take up relative to its own siblings within a surrounding Row or Column? Flutter › Layout Widgets (Row, Column, Stack, Container) | Flutter | Layout Widgets (Row, Column, Stack, Container) | Intermediate |
| 8 | How do mainAxisAlignment and crossAxisAlignment properly control the specific alignment of children within a Row or Column along each of those particular widget's own two genuinely separate distinct axes? Flutter › Layout Widgets (Row, Column, Stack, Container) | Flutter | Layout Widgets (Row, Column, Stack, Container) | Intermediate |
| 9 | What are delta stores and rowgroups in the context of columnstore indexes, and how do they affect performance over time? SQL Server › Columnstore Indexes | SQL Server | Columnstore Indexes | Advanced |
| 10 | How would you decide whether to use a clustered columnstore index or a traditional partitioned rowstore table for a very large historical sales table? SQL Server › Columnstore Indexes | SQL Server | Columnstore Indexes | Advanced |
| 11 | How do you extract a value from an XML column using the value method? SQL Server › XML Data Type & Querying | SQL Server | XML Data Type & Querying | Beginner |
| 12 | What is columnar storage, and why does Redshift use it? AWS › Amazon Redshift & Data Warehousing | AWS | Amazon Redshift & Data Warehousing | Beginner |
| 13 | What is the difference between COUNT(*), COUNT(1), and COUNT(column_name) in SQL Server? SQL Server › Aggregate Functions & GROUP BY | SQL Server | Aggregate Functions & GROUP BY | Intermediate |
| 14 | How do you choose an appropriately sized data type for a column to balance storage efficiency with future flexibility? SQL Server › Data Types & Schema Design | SQL Server | Data Types & Schema Design | Intermediate |
| 15 | How do computed columns work in SQL Server, and what are some practical use cases for them? SQL Server › Data Types & Schema Design | SQL Server | Data Types & Schema Design | Intermediate |
| 16 | How do you remove dynamic data masking from a column once it is no longer needed? SQL Server › Dynamic Data Masking | SQL Server | Dynamic Data Masking | Intermediate |
| 17 | How would you build a dynamic SQL query where the table or column names themselves need to change based on input, since parameters cannot be used for object names? SQL Server › Dynamic SQL | SQL Server | Dynamic SQL | Intermediate |
| 18 | How do you decide which columns to choose, and in what order, when creating a composite index covering multiple columns? SQL Server › Indexes | SQL Server | Indexes | Intermediate |
| 19 | How do you convert a JSON array stored in a column into a relational table format that can be queried like normal rows? SQL Server › JSON Support in SQL Server | SQL Server | JSON Support in SQL Server | Intermediate |
| 20 | How do you update a specific value within a JSON document stored in a column without replacing the entire JSON text? SQL Server › JSON Support in SQL Server | SQL Server | JSON Support in SQL Server | Intermediate |
| 21 | How would you handle a pivoting scenario where the set of columns needed is not known ahead of time and could change over time? SQL Server › Pivoting & Unpivoting Data | SQL Server | Pivoting & Unpivoting Data | Intermediate |
| 22 | How do you use a view to help enforce a basic level of security by limiting which columns or rows different groups of users can see? SQL Server › Views | SQL Server | Views | Intermediate |
| 23 | What is the difference between RANK, DENSE_RANK, and ROW_NUMBER when there are tied values in the ordering column? SQL Server › Window Functions | SQL Server | Window Functions | Intermediate |
| 24 | How do you modify a specific part of an XML document stored in a column without replacing the entire document? SQL Server › XML Data Type & Querying | SQL Server | XML Data Type & Querying | Intermediate |
| 25 | How do you properly implement database migrations in sqflite, correctly handling a schema change such as adding a genuinely new column when a user actually updates to a newer version of your app? Flutter › SQLite & Local Databases (sqflite) | Flutter | SQLite & Local Databases (sqflite) | Intermediate |
| 26 | How would you apply dynamic data masking to an existing table with sensitive columns as part of a broader compliance initiative, such as meeting data privacy regulations? SQL Server › Dynamic Data Masking | SQL Server | Dynamic Data Masking | Advanced |
| 27 | How does dynamic data masking behave differently when a masked column is used in a JOIN, WHERE clause, or exported through an application, compared to a simple SELECT query? SQL Server › Dynamic Data Masking | SQL Server | Dynamic Data Masking | Advanced |
| 28 | How would you validate that a value stored in a column actually contains well formed JSON before allowing it to be inserted or updated? SQL Server › JSON Support in SQL Server | SQL Server | JSON Support in SQL Server | Advanced |
| 29 | What are the performance considerations and limitations of querying JSON data stored as text compared to using normalized relational columns? SQL Server › JSON Support in SQL Server | SQL Server | JSON Support in SQL Server | Advanced |
| 30 | How do you implement row level security to restrict which specific rows a user can see within a shared table, beyond simply controlling access to entire tables or columns? SQL Server › SQL Server Security & Permissions | SQL Server | SQL Server Security & Permissions | Advanced |
| 31 | How does an XML index improve query performance against large or frequently queried XML columns? SQL Server › XML Data Type & Querying | SQL Server | XML Data Type & Querying | Advanced |
| 32 | What is the Container widget, and how does it let you conveniently combine padding, margin, background color, and border decoration all together within just one single genuinely convenient widget? Flutter › Layout Widgets (Row, Column, Stack, Container) | Flutter | Layout Widgets (Row, Column, Stack, Container) | Beginner |
| 33 | How does the Stack widget let you genuinely layer several separate child widgets directly on top of one another, and how does the Positioned widget let you precisely control exactly where each individual layered child actually appears within that Stack? Flutter › Layout Widgets (Row, Column, Stack, Container) | Flutter | Layout Widgets (Row, Column, Stack, Container) | Intermediate |
| 34 | How does Flutter's own underlying constraint based layout system genuinely work, specifically regarding how constraints actually flow down the widget tree while sizes actually flow back up? Flutter › Layout Widgets (Row, Column, Stack, Container) | Flutter | Layout Widgets (Row, Column, Stack, Container) | Advanced |
| 35 | How can you properly build a genuinely fully custom layout widget by directly extending MultiChildLayoutDelegate or CustomMultiChildLayout, for a genuinely specific complex arrangement not already covered by any of Flutter's own existing standard layout widgets? Flutter › Layout Widgets (Row, Column, Stack, Container) | Flutter | Layout Widgets (Row, Column, Stack, Container) | Advanced |
| 36 | What is In-Memory OLTP in SQL Server, and what performance benefit does it provide? SQL Server › In-Memory OLTP (Memory-Optimized Tables) | SQL Server | In-Memory OLTP (Memory-Optimized Tables) | Beginner |
| 37 | What is table partitioning in SQL Server, and what problem does it help solve for very large tables? SQL Server › Partitioning | SQL Server | Partitioning | Beginner |
| 38 | What is the Scaffold widget in Flutter, and how does it provide the basic overall visual structure for a typical Material Design screen, including an app bar, a body area, and a floating action button? Flutter › Flutter Material Design Components | Flutter | Flutter Material Design Components | Beginner |
| 39 | What is a sliver in Flutter, and how does using a CustomScrollView built from several individual slivers let you create a genuinely more complex, custom scrolling effect than a simple regular ListView could achieve on its own? Flutter › Flutter Slivers & Custom Scroll Effects | Flutter | Flutter Slivers & Custom Scroll Effects | Beginner |
| 40 | What is the difference between responsive design and adaptive design in the specific context of building a Flutter app that genuinely needs to properly work well across phones, tablets, and desktop screens? Flutter › Responsive & Adaptive UI Design | Flutter | Responsive & Adaptive UI Design | Beginner |
| 41 | How does the MediaQuery class let you actually retrieve the current specific screen size and other genuinely useful device information, such as whether the device is currently genuinely in portrait or landscape orientation? Flutter › Responsive & Adaptive UI Design | Flutter | Responsive & Adaptive UI Design | Beginner |
| 42 | What is a covering index, and how does it help avoid an expensive lookup operation? SQL Server › Indexes | SQL Server | Indexes | Intermediate |
| 43 | What SQL Server edition requirements exist for using In-Memory OLTP features? SQL Server › In-Memory OLTP (Memory-Optimized Tables) | SQL Server | In-Memory OLTP (Memory-Optimized Tables) | Intermediate |
| 44 | How does partition elimination improve query performance for a partitioned table? SQL Server › Partitioning | SQL Server | Partitioning | Intermediate |
| 45 | What is a schema bound view, and what specific benefit does the WITH SCHEMABINDING option provide? SQL Server › Views | SQL Server | Views | Intermediate |
| 46 | What is an indexed view, and how can it improve the performance of complex, frequently run queries? SQL Server › Views | SQL Server | Views | Intermediate |
| 47 | How should a Flutter web app's overall layout properly and gracefully adapt across a genuinely much wider range of possible screen sizes compared to a typical mobile app, spanning anywhere from a small mobile browser window all the way up to a genuinely very large desktop monitor? Flutter › Flutter for Web Development | Flutter | Flutter for Web Development | Intermediate |
| 48 | How do Card and ListTile work together as commonly used Material widgets specifically for displaying a clean, well structured, scrollable list of individual items, such as a list of orders or messages? Flutter › Flutter Material Design Components | Flutter | Flutter Material Design Components | Intermediate |
| 49 | How does using ListView.builder instead of manually constructing a plain ListView with a fully complete, fixed list of children genuinely improve performance specifically for a very long scrollable list? Flutter › Flutter Performance Optimization | Flutter | Flutter Performance Optimization | Intermediate |
| 50 | What is the difference between SliverList and SliverGrid, and how do you actually properly combine both of them together within exactly the same single CustomScrollView? Flutter › Flutter Slivers & Custom Scroll Effects | Flutter | Flutter Slivers & Custom Scroll Effects | Intermediate |
| 51 | How does SliverPersistentHeader let you create a genuinely persistent, pinned section header that remains visibly fixed and stuck at the very top of the screen while its own related content continues scrolling normally underneath it? Flutter › Flutter Slivers & Custom Scroll Effects | Flutter | Flutter Slivers & Custom Scroll Effects | Intermediate |
| 52 | How does Flutter properly handle right to left text direction support, such as for Arabic or Hebrew, and what specific layout adjustments genuinely need to actually happen automatically for these particular specific languages? Flutter › Internationalization & Localization (i18n) | Flutter | Internationalization & Localization (i18n) | Intermediate |
| 53 | What is the difference between using MediaQuery and using LayoutBuilder for making a genuine responsive layout decision, and when would you genuinely prefer one particular approach over the other? Flutter › Responsive & Adaptive UI Design | Flutter | Responsive & Adaptive UI Design | Intermediate |
| 54 | How do you properly define and consistently use breakpoints, meaning specific screen width thresholds, to properly organize your app's own overall responsive layout logic in a genuinely clean, maintainable way? Flutter › Responsive & Adaptive UI Design | Flutter | Responsive & Adaptive UI Design | Intermediate |
| 55 | How do filtered indexes work, and what specific scenarios benefit most from using one? SQL Server › Indexes | SQL Server | Indexes | Advanced |