Quiz — 6550ce6226fe9_Corrigé-Les commandes SQL.pdf

Question 1 sur 10 20:00

[{"id":41815,"question":"Quelle commande SQL permet d'extraire des données d'une table ?","option_a":"INSERT","option_b":"SELECT","option_c":"UPDATE","option_d":"DELETE","option_e":"","option_f":"","bonne_reponse":"b","explication":"La commande SELECT est utilisée pour récupérer des données d'une ou plusieurs tables dans une base de données.","points":1,"type":"qcm","actif":1,"section_id":null,"ordre":0,"_debug_answer_data_type":"string","_debug_answer_data_preview":"{\"correct\": \"b\", \"options\": {\"a\": \"INSERT\", \"b\": \"SELECT\", \"c\": \"UPDATE\", \"d\": \"DELETE\"}}","_debug_options_count":4},{"id":41816,"question":"La commande UPDATE permet de modifier les données d'une table.","option_a":"Vrai","option_b":"Faux","option_c":"","option_d":"","option_e":"","option_f":"","bonne_reponse":"a","explication":"La commande UPDATE modifie effectivement les données existantes dans une table, ce qui est une fonctionnalité clé du langage SQL.","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":41817,"question":"Quelle commande permet d'ajouter une nouvelle ligne dans une table ?","option_a":"ALTER TABLE","option_b":"INSERT INTO","option_c":"CREATE TABLE","option_d":"DROP TABLE","option_e":"","option_f":"","bonne_reponse":"b","explication":"La commande INSERT INTO est utilisée pour ajouter une ou plusieurs lignes dans une table existante.","points":1,"type":"qcm","actif":1,"section_id":null,"ordre":0,"_debug_answer_data_type":"string","_debug_answer_data_preview":"{\"correct\": \"b\", \"options\": {\"a\": \"ALTER TABLE\", \"b\": \"INSERT INTO\", \"c\": \"CREATE TABLE\", \"d\": \"DROP","_debug_options_count":4},{"id":41818,"question":"La commande DELETE FROM supprime définitivement une table.","option_a":"Vrai","option_b":"Faux","option_c":"","option_d":"","option_e":"","option_f":"","bonne_reponse":"b","explication":"La commande DELETE FROM supprime les lignes d'une table, tandis que DROP TABLE supprime la table elle-même.","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":41819,"question":"Quelle commande permet de créer une nouvelle table dans une base de données ?","option_a":"CREATE TABLE","option_b":"ALTER TABLE","option_c":"INSERT INTO","option_d":"SELECT","option_e":"","option_f":"","bonne_reponse":"a","explication":"La commande CREATE TABLE est utilisée pour créer une nouvelle table dans une base de données relationnelle.","points":1,"type":"qcm","actif":1,"section_id":null,"ordre":0,"_debug_answer_data_type":"string","_debug_answer_data_preview":"{\"correct\": \"a\", \"options\": {\"a\": \"CREATE TABLE\", \"b\": \"ALTER TABLE\", \"c\": \"INSERT INTO\", \"d\": \"SELE","_debug_options_count":4},{"id":41820,"question":"La commande GROUP BY est utilisée pour regrouper des lignes ayant les mêmes valeurs dans une colonne spécifiée.","option_a":"Vrai","option_b":"Faux","option_c":"","option_d":"","option_e":"","option_f":"","bonne_reponse":"a","explication":"La commande GROUP BY permet effectivement de regrouper des lignes en fonction des valeurs d'une ou plusieurs colonnes.","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":41821,"question":"Quelle commande permet de modifier la structure d'une table existante ?","option_a":"UPDATE","option_b":"ALTER TABLE","option_c":"INSERT INTO","option_d":"DELETE FROM","option_e":"","option_f":"","bonne_reponse":"b","explication":"La commande ALTER TABLE est utilisée pour ajouter, modifier ou supprimer des colonnes ou contraintes dans une table existante.","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\", \"b\": \"ALTER TABLE\", \"c\": \"INSERT INTO\", \"d\": \"DELETE FRO","_debug_options_count":4},{"id":41822,"question":"La commande HAVING est utilisée dans une requête SQL pour filtrer les résultats après un GROUP BY.","option_a":"Vrai","option_b":"Faux","option_c":"","option_d":"","option_e":"","option_f":"","bonne_reponse":"a","explication":"La commande HAVING permet de filtrer les groupes créés par la clause GROUP BY, contrairement à WHERE qui filtre les lignes individuelles.","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":41823,"question":"Quelle commande permet de supprimer une table entière d'une base de données ?","option_a":"DELETE FROM","option_b":"DROP TABLE","option_c":"TRUNCATE TABLE","option_d":"REMOVE TABLE","option_e":"","option_f":"","bonne_reponse":"b","explication":"La commande DROP TABLE supprime une table et toutes ses données de manière permanente dans une base de données.","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\", \"b\": \"DROP TABLE\", \"c\": \"TRUNCATE TABLE\", \"d\": \"REM","_debug_options_count":4},{"id":41824,"question":"La commande ORDER BY permet de trier les résultats d'une requête par une ou plusieurs colonnes.","option_a":"Vrai","option_b":"Faux","option_c":"","option_d":"","option_e":"","option_f":"","bonne_reponse":"a","explication":"La commande ORDER BY trie les résultats d'une requête SQL en ordre croissant ou décroissant selon les colonnes spécifiées.","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}]