Which of the following is a DML statement? MCQ with Answer and Explanation
Question
Report Error
Discuss this Question (0)
Practice More Database Management System (DBMS) Questions
Question #1
Report Error
What is an alternate key?
Correct Answer: Option C
Explanation:
An alternate key is any candidate key that is not the primary key.
An alternate key is any candidate key that is not the primary key.
This question belongs to:
Computer
Database Management System (DBMS)
Question #2
Report Error
Which of the following terms refers to the duplication of data across multiple locations in a non-DBMS file system?
Correct Answer: Option D
Explanation:
Data Redundancy refers to the unnecessary duplication of the exact same data in multiple files or locations, which wastes storage and can cause inconsistencies.
Data Redundancy refers to the unnecessary duplication of the exact same data in multiple files or locations, which wastes storage and can cause inconsistencies.
This question belongs to:
Computer
Database Management System (DBMS)
Question #3
Report Error
Which of the following is a valid SQL statement to add a new column to a table?
Correct Answer: Option D
Explanation:
Both 'ADD column_name datatype' and 'ADD COLUMN column_name datatype' are valid syntax in some DBMS, but standard SQL uses 'ADD column_name datatype'. However, many DBMS support both.
Both 'ADD column_name datatype' and 'ADD COLUMN column_name datatype' are valid syntax in some DBMS, but standard SQL uses 'ADD column_name datatype'. However, many DBMS support both.
This question belongs to:
Computer
Database Management System (DBMS)
No comments yet. Be the first to start the discussion!