SQLite اسئلة واجوبة المقابلات
Test your skills through the online practice test: SQLite Quiz Online Practice Test
سؤال 51. Explain the purpose of the SAVEPOINT statement in SQLite.
The SAVEPOINT statement in SQLite is used to create a savepoint within a transaction, allowing you to roll back to that point without affecting the entire transaction.
هل هذا مفيد؟
اضف تعليقا
عرض التعليقات
سؤال 52. How to create a trigger in SQLite?
You can create a trigger in SQLite using the CREATE TRIGGER statement, specifying the trigger name, timing (BEFORE or AFTER), event (INSERT, UPDATE, DELETE), and the SQL statements to execute.
هل هذا مفيد؟
اضف تعليقا
عرض التعليقات
سؤال 53. Explain the purpose of the PRAGMA foreign_keys command in SQLite.
The PRAGMA foreign_keys command in SQLite is used to enable or disable the enforcement of foreign key constraints during a transaction.
هل هذا مفيد؟
اضف تعليقا
عرض التعليقات
الاكثر فائدة حسب تقييم المستخدمين: