Quiz — 8_ex3 sql.pdf

Question 1 sur 10 20:00

[{"id":68286,"question":"Quelle commande SQL permet de sélectionner des colonnes spécifiques dans une table ?","option_a":"SELECT","option_b":"FROM","option_c":"WHERE","option_d":"GROUP BY","option_e":"","option_f":"","bonne_reponse":"a","explication":"La commande SELECT est utilisée pour choisir les colonnes à afficher dans le résultat d'une requête 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\": \"SELECT\", \"b\": \"FROM\", \"c\": \"WHERE\", \"d\": \"GROUP BY\"}}","_debug_options_count":4},{"id":68287,"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":"Vrai. La commande UPDATE est utilisée pour mettre à jour les enregistrements existants dans une table.","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":68288,"question":"Quelle clause permet de filtrer les résultats d'une requête en fonction d'une condition ?","option_a":"HAVING","option_b":"ORDER BY","option_c":"WHERE","option_d":"GROUP BY","option_e":"","option_f":"","bonne_reponse":"c","explication":"La clause WHERE permet de spécifier des conditions pour filtrer les lignes retournées par une requête SELECT.","points":1,"type":"qcm","actif":1,"section_id":null,"ordre":0,"_debug_answer_data_type":"string","_debug_answer_data_preview":"{\"correct\": \"c\", \"options\": {\"a\": \"HAVING\", \"b\": \"ORDER BY\", \"c\": \"WHERE\", \"d\": \"GROUP BY\"}}","_debug_options_count":4},{"id":68289,"question":"La commande DELETE FROM table WHERE condition permet de supprimer toutes les lignes d'une table.","option_a":"Vrai","option_b":"Faux","option_c":"","option_d":"","option_e":"","option_f":"","bonne_reponse":"b","explication":"Faux. Sans la clause WHERE, la commande DELETE FROM table supprime toutes les lignes. Avec WHERE, elle supprime uniquement les lignes correspondant à la 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\": \"Vrai\", \"b\": \"Faux\", \"c\": \"\", \"d\": \"\"}}","_debug_options_count":4},{"id":68290,"question":"Quelle commande SQL permet d'ajouter une nouvelle ligne dans une table ?","option_a":"INSERT INTO","option_b":"UPDATE","option_c":"SELECT","option_d":"CREATE","option_e":"","option_f":"","bonne_reponse":"a","explication":"La commande INSERT INTO permet d'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\": \"a\", \"options\": {\"a\": \"INSERT INTO\", \"b\": \"UPDATE\", \"c\": \"SELECT\", \"d\": \"CREATE\"}}","_debug_options_count":4},{"id":68291,"question":"La clause GROUP BY est utilisée pour regrouper des lignes partageant une même valeur dans une colonne.","option_a":"Vrai","option_b":"Faux","option_c":"","option_d":"","option_e":"","option_f":"","bonne_reponse":"a","explication":"Vrai. La clause GROUP BY permet de regrouper les lignes d'une table 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":68292,"question":"Quelle commande SQL permet de créer une nouvelle table dans une base de données ?","option_a":"CREATE TABLE","option_b":"ALTER TABLE","option_c":"DROP TABLE","option_d":"TRUNCATE TABLE","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.","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\": \"DROP TABLE\", \"d\": \"TRUNC","_debug_options_count":4},{"id":68293,"question":"La commande ALTER TABLE permet de modifier la structure d'une table existante.","option_a":"Vrai","option_b":"Faux","option_c":"","option_d":"","option_e":"","option_f":"","bonne_reponse":"a","explication":"Vrai. La commande ALTER TABLE est utilisée pour ajouter, modifier ou supprimer des colonnes ou des 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\": \"a\", \"options\": {\"a\": \"Vrai\", \"b\": \"Faux\", \"c\": \"\", \"d\": \"\"}}","_debug_options_count":4},{"id":68294,"question":"Quelle clause permet de trier les résultats d'une requête par ordre croissant ou décroissant ?","option_a":"WHERE","option_b":"ORDER BY","option_c":"GROUP BY","option_d":"HAVING","option_e":"","option_f":"","bonne_reponse":"b","explication":"La clause ORDER BY permet de trier les résultats d'une requête selon une ou plusieurs colonnes, dans l'ordre croissant ou décroissant.","points":1,"type":"qcm","actif":1,"section_id":null,"ordre":0,"_debug_answer_data_type":"string","_debug_answer_data_preview":"{\"correct\": \"b\", \"options\": {\"a\": \"WHERE\", \"b\": \"ORDER BY\", \"c\": \"GROUP BY\", \"d\": \"HAVING\"}}","_debug_options_count":4},{"id":68295,"question":"La commande TRUNCATE TABLE supprime toutes les lignes d'une table mais conserve sa structure.","option_a":"Vrai","option_b":"Faux","option_c":"","option_d":"","option_e":"","option_f":"","bonne_reponse":"a","explication":"Vrai. TRUNCATE TABLE est plus rapide que DELETE FROM table car il ne génère pas de journalisation pour chaque ligne supprimée.","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}]