Quiz — 7 - Corrigé-Série de révision Création et modification de la structure d'une base de données relationnelle en mode SQL.

Question 1 sur 3 6:00

[{"id":26637,"question":"Quelle commande SQL permet de créer une nouvelle table ?","option_a":"CREATE DATABASE","option_b":"CREATE TABLE","option_c":"ALTER TABLE","option_d":"DROP TABLE","option_e":"","option_f":"","bonne_reponse":"b","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\": \"b\", \"options\": {\"a\": \"CREATE DATABASE\", \"b\": \"CREATE TABLE\", \"c\": \"ALTER TABLE\", \"d\": \"","_debug_options_count":4},{"id":26638,"question":"Quel mot-clé permet d'ajouter une contrainte NOT NULL à une colonne existante ?","option_a":"ADD COLUMN","option_b":"MODIFY COLUMN","option_c":"ALTER TABLE","option_d":"ADD CONSTRAINT","option_e":"","option_f":"","bonne_reponse":"d","explication":"La commande ALTER TABLE combinée à ADD CONSTRAINT permet d'ajouter une contrainte NOT NULL à une colonne.","points":1,"type":"qcm","actif":1,"section_id":null,"ordre":0,"_debug_answer_data_type":"string","_debug_answer_data_preview":"{\"correct\": \"d\", \"options\": {\"a\": \"ADD COLUMN\", \"b\": \"MODIFY COLUMN\", \"c\": \"ALTER TABLE\", \"d\": \"ADD ","_debug_options_count":4},{"id":26639,"question":"Quelle commande modifie la structure d'une table sans supprimer les données ?","option_a":"DROP TABLE","option_b":"TRUNCATE TABLE","option_c":"ALTER TABLE","option_d":"DELETE FROM","option_e":"","option_f":"","bonne_reponse":"c","explication":"La commande ALTER TABLE permet de modifier la structure d'une table (ajout\/suppression de colonnes) sans perdre les données existantes.","points":1,"type":"qcm","actif":1,"section_id":null,"ordre":0,"_debug_answer_data_type":"string","_debug_answer_data_preview":"{\"correct\": \"c\", \"options\": {\"a\": \"DROP TABLE\", \"b\": \"TRUNCATE TABLE\", \"c\": \"ALTER TABLE\", \"d\": \"DEL","_debug_options_count":4}]