Multi Choice Type QuestionWhich command is used for removing a table and all its data from the database?Marks : 1Negative Marks : 0Answer hereCreate commandDrop table commandAlter table commandAll of the mentioned options

Multi Choice Type QuestionWhich command is used to remove all records from a table, including all spaces allocated for the records that are removed?Marks : 1Negative Marks : 0Answer hereALTERTRUNCATEDROPMODIFY

Multi Choice Type QuestionWhich command is used to modify the table structure such as key constraints and Column size?Marks : 1Negative Marks : 0Answer hereRENAMETRUNCATEALTERREVOKE

Multi Choice Type QuestionIn SQL, which command is used to change a table’s storage characteristics?Marks : 1Negative Marks : 0Answer hereALTER TABLEMODIFY TABLECHANGE TABLEALTER TABLE and CHANGE TABLE

Multi Choice Type QuestionWhich of the following is used to delete an entire MYSQL database?Marks : 1Negative Marks : 0Answer heredrop entiredb dbnamedrop database dbnamedrop db dbnamedrop dbase dbname

Multi Choice Type QuestionWhich among the following is the correct syntax for creating a table?Marks : 1Negative Marks : 0Answer hereCREATE name;CREATE TABLE name;CREATE TABLEAll of the listed options