Quiz — 9_chapitre5_mode_assiste_suppression_dune_bd.pdf

Question 1 sur 10 20:00

[{"id":45938,"question":"Quelle commande SQL permet de supprimer des lignes d'une table tout en conservant sa structure ?","option_a":"DELETE","option_b":"TRUNCATE","option_c":"DROP","option_d":"REMOVE","option_e":"","option_f":"","bonne_reponse":"a","explication":"La commande DELETE supprime des lignes spécifiques d'une table sans modifier sa structure, contrairement à TRUNCATE qui supprime toutes les lignes ou DROP qui supprime la table entière.","points":1,"type":"qcm","actif":1,"section_id":null,"ordre":0,"_debug_answer_data_type":"string","_debug_answer_data_preview":"{\"correct\": \"a\", \"options\": {\"a\": \"DELETE\", \"b\": \"TRUNCATE\", \"c\": \"DROP\", \"d\": \"REMOVE\"}}","_debug_options_count":4},{"id":45939,"question":"TRUNCATE est plus rapide que DELETE car il ne génère pas de journalisation des transactions.","option_a":"Vrai","option_b":"Faux","option_c":"","option_d":"","option_e":"","option_f":"","bonne_reponse":"a","explication":"TRUNCATE est effectivement plus rapide car il ne journalise pas chaque suppression individuelle, contrairement à DELETE.","points":1,"type":"qcm","actif":1,"section_id":null,"ordre":0,"_debug_answer_data_type":"string","_debug_answer_data_preview":"{\"correct\": \"a\", \"options\": {\"a\": \"Vrai\", \"b\": \"Faux\", \"c\": \"\", \"d\": \"\"}}","_debug_options_count":4},{"id":45940,"question":"Quelle clause SQL est indispensable pour limiter une suppression à certaines lignes ?","option_a":"WHERE","option_b":"LIMIT","option_c":"GROUP BY","option_d":"HAVING","option_e":"","option_f":"","bonne_reponse":"a","explication":"La clause WHERE permet de spécifier les conditions pour sélectionner les lignes à supprimer.","points":1,"type":"qcm","actif":1,"section_id":null,"ordre":0,"_debug_answer_data_type":"string","_debug_answer_data_preview":"{\"correct\": \"a\", \"options\": {\"a\": \"WHERE\", \"b\": \"LIMIT\", \"c\": \"GROUP BY\", \"d\": \"HAVING\"}}","_debug_options_count":4},{"id":45941,"question":"Une suppression effectuée avec TRUNCATE peut être annulée avec un ROLLBACK.","option_a":"Vrai","option_b":"Faux","option_c":"","option_d":"","option_e":"","option_f":"","bonne_reponse":"b","explication":"TRUNCATE ne peut pas être annulé avec ROLLBACK car il n'est pas journalisé comme DELETE.","points":1,"type":"qcm","actif":1,"section_id":null,"ordre":0,"_debug_answer_data_type":"string","_debug_answer_data_preview":"{\"correct\": \"b\", \"options\": {\"a\": \"Vrai\", \"b\": \"Faux\", \"c\": \"\", \"d\": \"\"}}","_debug_options_count":4},{"id":45942,"question":"Quelle commande permet de supprimer une table entière, y compris sa structure ?","option_a":"DELETE FROM table","option_b":"TRUNCATE TABLE table","option_c":"DROP TABLE table","option_d":"REMOVE TABLE table","option_e":"","option_f":"","bonne_reponse":"c","explication":"DROP TABLE supprime la table et toutes ses données, contrairement à DELETE ou TRUNCATE qui conservent la structure.","points":1,"type":"qcm","actif":1,"section_id":null,"ordre":0,"_debug_answer_data_type":"string","_debug_answer_data_preview":"{\"correct\": \"c\", \"options\": {\"a\": \"DELETE FROM table\", \"b\": \"TRUNCATE TABLE table\", \"c\": \"DROP TABLE","_debug_options_count":4},{"id":45943,"question":"Dans une interface graphique comme phpMyAdmin, la suppression d'une ligne se fait toujours via une requête SQL.","option_a":"Vrai","option_b":"Faux","option_c":"","option_d":"","option_e":"","option_f":"","bonne_reponse":"b","explication":"Certaines interfaces graphiques permettent de supprimer des lignes sans écrire de requête SQL, via des boutons ou menus.","points":1,"type":"qcm","actif":1,"section_id":null,"ordre":0,"_debug_answer_data_type":"string","_debug_answer_data_preview":"{\"correct\": \"b\", \"options\": {\"a\": \"Vrai\", \"b\": \"Faux\", \"c\": \"\", \"d\": \"\"}}","_debug_options_count":4},{"id":45944,"question":"Quelle commande permet de supprimer toutes les lignes d'une table sans supprimer la table elle-même ?","option_a":"DELETE FROM table","option_b":"TRUNCATE TABLE table","option_c":"DROP TABLE table","option_d":"REMOVE * FROM table","option_e":"","option_f":"","bonne_reponse":"b","explication":"TRUNCATE TABLE supprime toutes les lignes d'une table tout en conservant sa structure.","points":1,"type":"qcm","actif":1,"section_id":null,"ordre":0,"_debug_answer_data_type":"string","_debug_answer_data_preview":"{\"correct\": \"b\", \"options\": {\"a\": \"DELETE FROM table\", \"b\": \"TRUNCATE TABLE table\", \"c\": \"DROP TABLE","_debug_options_count":4},{"id":45945,"question":"Une suppression avec DELETE peut être annulée si elle est effectuée dans une transaction non validée.","option_a":"Vrai","option_b":"Faux","option_c":"","option_d":"","option_e":"","option_f":"","bonne_reponse":"a","explication":"Oui, si la suppression est faite dans une transaction et que celle-ci n'est pas validée (COMMIT), elle peut être annulée avec ROLLBACK.","points":1,"type":"qcm","actif":1,"section_id":null,"ordre":0,"_debug_answer_data_type":"string","_debug_answer_data_preview":"{\"correct\": \"a\", \"options\": {\"a\": \"Vrai\", \"b\": \"Faux\", \"c\": \"\", \"d\": \"\"}}","_debug_options_count":4},{"id":45946,"question":"Quelle commande SQL est utilisée pour supprimer des données dans une table en fonction d'une condition ?","option_a":"UPDATE ... SET","option_b":"DELETE ... WHERE","option_c":"INSERT INTO","option_d":"SELECT ... FROM","option_e":"","option_f":"","bonne_reponse":"b","explication":"DELETE ... WHERE permet de supprimer des lignes spécifiques en fonction d'une condition.","points":1,"type":"qcm","actif":1,"section_id":null,"ordre":0,"_debug_answer_data_type":"string","_debug_answer_data_preview":"{\"correct\": \"b\", \"options\": {\"a\": \"UPDATE ... SET\", \"b\": \"DELETE ... WHERE\", \"c\": \"INSERT INTO\", \"d\"","_debug_options_count":4},{"id":45947,"question":"La commande TRUNCATE peut être utilisée sur une table référencée par une clé étrangère.","option_a":"Vrai","option_b":"Faux","option_c":"","option_d":"","option_e":"","option_f":"","bonne_reponse":"b","explication":"Faux, TRUNCATE échouera si la table est référencée par une clé étrangère, sauf si la contrainte de clé étrangère est désactivée.","points":1,"type":"qcm","actif":1,"section_id":null,"ordre":0,"_debug_answer_data_type":"string","_debug_answer_data_preview":"{\"correct\": \"b\", \"options\": {\"a\": \"Vrai\", \"b\": \"Faux\", \"c\": \"\", \"d\": \"\"}}","_debug_options_count":4}]