MCQs on Data Definition Language (DDL) in DBMS
- Which SQL statement is used to create a new table in a database?
- a) INSERT TABLE
- b) NEW TABLE
- c) CREATE TABLE
- d) ADD TABLE
Answer: c) CREATE TABLE
- What does the ALTER TABLE statement do?
- a) Deletes an existing table
- b) Creates a new table
- c) Modifies the structure of an existing table
- d) Renames a table
Answer: c) Modifies the structure of an existing table
- Which SQL statement is used to delete a table from the database?
- a) REMOVE TABLE
- b) DELETE TABLE
- c) DROP TABLE
- d) TRUNCATE TABLE
Answer: c) DROP TABLE
- What is the purpose of the TRUNCATE TABLE statement?
- a) To delete a table structure
- b) To remove all records from a table, but keep the table structure
- c) To delete specific records from a table
- d) To alter the structure of a table
Answer: b) To remove all records from a table, but keep the table structure
- Which of the following SQL statements is used to add a new column to an existing table?
- a) MODIFY TABLE
- b) ADD COLUMN
- c) ALTER TABLE
- d) UPDATE TABLE
Answer: c) ALTER TABLE
- Which SQL statement is used to rename an existing table?
- a) RENAME TABLE
- b) ALTER TABLE
- c) MODIFY TABLE
- d) CHANGE TABLE
Answer: b) ALTER TABLE
- What does the SQL command
DROP COLUMNdo?- a) Removes a column and all its data from a table
- b) Deletes the entire table
- c) Removes a column but keeps the data
- d) Changes the name of a column
Answer: a) Removes a column and all its data from a table
- What is the purpose of the CREATE INDEX statement?
- a) To create a new table with an index
- b) To create a unique constraint on a column
- c) To improve the performance of queries by creating an index on a table
- d) To create a new view
Answer: c) To improve the performance of queries by creating an index on a table
- Which SQL command is used to define a new constraint on a table?
- a) CREATE CONSTRAINT
- b) ADD CONSTRAINT
- c) ALTER CONSTRAINT
- d) DEFINE CONSTRAINT
Answer: b) ADD CONSTRAINT
- What does the SQL statement
ALTER TABLE DROP CONSTRAINTdo?- a) Removes the entire table
- b) Deletes a specific constraint from the table
- c) Adds a new constraint to the table
- d) Renames the constraint
Answer: b) Deletes a specific constraint from the table
- Which command is used to change the data type of an existing column in a table?
- a) ALTER TABLE
- b) MODIFY TABLE
- c) UPDATE TABLE
- d) CHANGE COLUMN
Answer: a) ALTER TABLE
- What does the SQL statement
CREATE VIEWdo?- a) Creates a new table in the database
- b) Defines a virtual table based on a query
- c) Deletes an existing table
- d) Modifies the structure of an existing table
Answer: b) Defines a virtual table based on a query
- Which SQL command is used to add a primary key constraint to an existing table?
- a) ALTER TABLE … ADD PRIMARY KEY
- b) MODIFY TABLE … PRIMARY KEY
- c) CREATE PRIMARY KEY
- d) ADD PRIMARY KEY TO TABLE
Answer: a) ALTER TABLE … ADD PRIMARY KEY
- What does the SQL command
RENAME TABLEdo?- a) Changes the name of an existing table
- b) Creates a new table with a different name
- c) Deletes the existing table
- d) Renames a column in the table
Answer: a) Changes the name of an existing table
- Which SQL command is used to remove an index from a table?
- a) DROP INDEX
- b) REMOVE INDEX
- c) DELETE INDEX
- d) ALTER INDEX
Answer: a) DROP INDEX
More MCQs Of Database Systems
- Database Models MCQs in DBMS
- Relational Database Model MCQs in DBMS
- SQL (Structured Query Language) MCQs in DBMS
- Database Design MCQs in DBMS
- Database Management System Architecture MCQs in DBMS
- Storage and File Structure MCQs in DBMS
- Query Processing and Optimization MCQs in DBMS
- Database Transaction Management MCQs in DBMS
- Database Security and Authorization MCQs in DBMS
- Backup and Recovery MCQs in DBMS
- Distributed Databases MCQs in DBMS
- SET 1: database design mcqs (database design mcqs )
- SET 2: database mcqs with answers pdf (database mcqs with answers pdf )
- SET 3: modern database management 12th edition mcqs (modern database management 12th edition mcqs)
- SET 4: database systems mcqs (database systems mcqs)
- SET 5: dbms mcqs (dbms mcqs )
- SET 6: dbms mcqs with answers (dbms mcqs with answers)
- SET 7: solved mcqs of dbms (solved mcqs of dbms)
- SET 8: dbms mcqs with answers pdf(dbms mcqs with answers pdf)
- SET 9: relational database management system mcqs(relational database management system mcqs)
- SET 10: solved mcqs of database management system(solved mcqs of database management system)
- SET 11: basic database mcqs pdf (basic database mcqs pdf)
- SET 12: relational database management system mcqs (relational database management system mcqs )
- SET 13: database mcqs online test (database mcqs online test)
- SET 14: database interview questions mcqs (database interview questions mcqs)
- SET 15: database developer mcqs (database developer mcqs)
- SET 16: database Repeated mcqs (database Repeated mcqs)
- SET 17: Database mcqs PPSC (Database mcqs PPSC)
- SET 18: Database mcqs FPSC (Database mcqs FPSC)
- SET 19: DBMS mcqs FPSC (DBMS mcqs FPSC)
New Arrival