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 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 modify the table structure such as key constraints and Column size?Marks : 1Negative Marks : 0Answer hereRENAMETRUNCATEALTERREVOKE

ulti Choice Type QuestionWhich command allows the removal of all rows from a table but flushes a table more efficiently since no rollback information is retained?Marks : 1Negative Marks : 0Answer hereTRUNCATECREATEDROPALTER

Which command is used to remove all records from a table, including all spaces allocated for the records that are removed?

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