SQLite perguntas e respostas de entrevista
Test your skills through the online practice test: SQLite Quiz Online Practice Test
Pergunta 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.
Isto e util?
Adicionar comentario
Ver comentarios
Pergunta 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.
Isto e util?
Adicionar comentario
Ver comentarios
Pergunta 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.
Isto e util?
Adicionar comentario
Ver comentarios
Mais uteis segundo os usuarios: