Question Bank

3705 approved questions from the community

What is the key difference in how WHERE and HAVING clauses filter data?

MEDIUM
SINGLE CHOICE
35s
Database
by Mohamed

What is the primary purpose of a database index?

EASY
SINGLE CHOICE
30s
Database
by Mohamed

Which index type is most suitable for exact-match lookups, such as primary key searches?

MEDIUM
SINGLE CHOICE
30s
Database
by Mohamed

When would a Bitmap index be most efficient?

MEDIUM
SINGLE CHOICE
35s
Database
by Mohamed

Which of the following are best practices for database indexing?

HARD
MULTIPLE CHOICE
45s
Database
by Mohamed

What are the primary functions of the GROUP BY clause in SQL?

MEDIUM
MULTIPLE CHOICE
40s
Database
by Mohamed

Which index type is best suited for range queries and operations using WHERE clauses?

MEDIUM
SINGLE CHOICE
30s
Database
by Mohamed

In the context of ORM frameworks, what causes the N+1 query problem?

HARD
SINGLE CHOICE
45s
Database
by Mohamed

Which property is used to create a shadow around an element?

EASY
SINGLE CHOICE
25s
CSS
by Mohamed

What is the purpose of the content-visibility property?

MEDIUM
SINGLE CHOICE
35s
CSS
by Mohamed

The @font-face rule is used to define custom fonts for downloading.

EASY
TRUE FALSE
20s
CSS
by Mohamed

Top and bottom margins affect inline elements.

MEDIUM
TRUE FALSE
25s
CSS
by Mohamed

The @media only screen keyword is used to hide style sheets from older user agents.

MEDIUM
TRUE FALSE
25s
CSS
by Mohamed

The screen keyword in media queries applies to the device's physical screen, not the browser's viewport.

HARD
TRUE FALSE
30s
CSS
by Mohamed

The translate() function can move the position of an element on the z-axis.

EASY
TRUE FALSE
20s
CSS
by Mohamed

What is the purpose of the table-layout property?

MEDIUM
SINGLE CHOICE
30s
CSS
by Mohamed

What is the main benefit of using file splitting in CSS for large projects?

HARD
SINGLE CHOICE
40s
CSS
by Mohamed

Which property is used to create small-caps text?

EASY
SINGLE CHOICE
25s
CSS
by Mohamed

A mobile-first CSS strategy is more performant on mobile devices than desktop-first.

MEDIUM
TRUE FALSE
25s
CSS
by Mohamed

Graceful degradation and progressive enhancement are the same approach to building web applications.

MEDIUM
TRUE FALSE
25s
CSS
by Mohamed
PreviousPage 148 of 186Next