Database Management Systems (DBMS)

Select the accurate description of Composite key.

Difficulty: Medium

• A. A subset of SQL commands used to define and modify database structures, such as CREATE and ALTER.

  Why not A: “A subset of SQL commands used to define and modify database structures, such as CREATE and ALTER.” is not correct. The accepted answer is B. A key formed by combining two or more columns to uniquely identify a row in a table.. Composite key refers to a key formed by combining two or more columns to uniquely identify a row in a table.

• B. A key formed by combining two or more columns to uniquely identify a row in a table. ✓
• C. A large, centralized repository of integrated data from multiple sources used for reporting and analysis.

  Why not C: “A large, centralized repository of integrated data from multiple sources used for reporting and analysis.” is not correct. The accepted answer is B. A key formed by combining two or more columns to uniquely identify a row in a table.. Composite key refers to a key formed by combining two or more columns to uniquely identify a row in a table.

• D. A precompiled collection of SQL statements stored in a database that can be executed as a single unit.

  Why not D: “A precompiled collection of SQL statements stored in a database that can be executed as a single unit.” is not correct. The accepted answer is B. A key formed by combining two or more columns to uniquely identify a row in a table.. Composite key refers to a key formed by combining two or more columns to uniquely identify a row in a table.

Source: Database Management Systems (DBMS) Official Reference Guide

Tags: computer science, dbms, SQL, databases

Submitted by: MCQsHub Editorial

More Database Management Systems (DBMS) MCQs