Question Bank
1899 approved questions from the community
Which SQL statement combination is most effective for identifying duplicate records in a table?
What is the primary security benefit of using prepared statements in SQL?
Lazy loading in ORM frameworks always prevents the N+1 query problem.
While indexes speed up read operations, they can slow down write operations like INSERT, UPDATE, and DELETE.
What is the key difference in how WHERE and HAVING clauses filter data?
Which index type is best suited for range queries and operations using WHERE clauses?
Which index type is most suitable for exact-match lookups, such as primary key searches?
When would a Bitmap index be most efficient?
Top and bottom margins affect inline elements.
What is the purpose of the table-layout property?
A mobile-first CSS strategy is more performant on mobile devices than desktop-first.
Graceful degradation and progressive enhancement are the same approach to building web applications.
CSS3 allows adding multiple background images to a single element.
What is accessibility (a11y) in web applications?
What is the difference between UI and UX?
What is a contextual selector in CSS?
What does the 'cascading' in CSS refer to?
What is the difference between a pseudo-class and a pseudo-element?
What is the CSS Box Model?
What does position: relative do?