Which SQL statement is used to retrieve data from a database? MCQ with Answer and Explanation
Question
Report Error
Discuss this Question (0)
Practice More Database Management System (DBMS) Questions
Question #1
Report Error
A key that consists of more than one attribute to uniquely identify rows in a table is called a what?
Correct Answer: Option D
Explanation:
When a primary key or unique key comprises two or more columns (attributes) combined together, it is known as a Composite Key.
When a primary key or unique key comprises two or more columns (attributes) combined together, it is known as a Composite Key.
This question belongs to:
Computer
Database Management System (DBMS)
Question #2
Report Error
What type of anomaly occurs when deleting a row inadvertently destroys other independent, valuable historical facts from the database?
Correct Answer: Option B
Explanation:
A Deletion Anomaly occurs when the deletion of a specific data record unintentionally deletes other distinct, unrelated information that should have been preserved.
A Deletion Anomaly occurs when the deletion of a specific data record unintentionally deletes other distinct, unrelated information that should have been preserved.
This question belongs to:
Computer
Database Management System (DBMS)
Question #3
Report Error
An attribute that can be broken down into smaller, independent sub-parts with independent meanings (such as Name into First_Name and Last_Name) is called a what?
Correct Answer: Option D
Explanation:
A Composite Attribute is one that can be divided into smaller sub-components or meaningful independent fields.
A Composite Attribute is one that can be divided into smaller sub-components or meaningful independent fields.
This question belongs to:
Computer
Database Management System (DBMS)
No comments yet. Be the first to start the discussion!