Question Bank

What is a Sliver in Flutter?

Flutter's Flex layout (Row and Column) uses absolute positioning for child widgets.

The pubspec.yaml file must include a unique package name for registration on pub.dev.

CupertinoTextField is optimized for iOS-style text input and maintains platform familiarity.

Widgets in Flutter are built using inheritance rather than composition.

What is the main entry point for a Flutter application?

What percentage of code can typically be shared across platforms in a Flutter application?

What are Platform Channels used for in Flutter?

Flutter can only be used to develop mobile applications for Android and iOS.

Material and Cupertino libraries in Flutter provide ready-to-use components consistent with Google's Material Design and Apple's iOS design respectively.

What is the purpose of the Flutter Engine?

Which of the following are valid solutions to the N+1 query problem?

Which of the following are advantages of using prepared statements?

What is the main characteristic of a FULL OUTER JOIN compared to an INNER JOIN?

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?

ROW_NUMBER() function can be used with PARTITION BY to identify and track duplicate records along with their unique row numbers.

Lazy loading in ORM frameworks always prevents the N+1 query problem.

The HAVING clause can only be used in conjunction with the GROUP BY clause.

While indexes speed up read operations, they can slow down write operations like INSERT, UPDATE, and DELETE.