Database Management Systems (DBMS)
The following statement describes a specific concept. What is it called? a key formed by combining two or more columns to uniquely identify a row in a table.
Difficulty: Medium
About this MCQ
This Medium Database Management Systems (DBMS) MCQ checks one syllabus fact.
The question is: “The following statement describes a specific concept. What is it called? a key formed by combining two or more columns to uniquely identify a row in a table.”
The accepted answer is C. Composite key. The following statement describes a specific concept What is it called a key formed by combining two or more columns to uniquely identify a row in a table is answered by Composite key option C Option A Data Manipulation Language DML does not match the stem it is a near-miss used to catch incomplete recall of Composite key Option B Data Definition Language DDL does not match the stem it is a near-miss used to catch incomplete recall of Composite key Remaining alternatives Concurrency control fall outside the same rule and should be eliminated once Composite key is identified Database Management Systems DBMS questions of this type reward precise definitions rather than approximate associations Database Management Systems DBMS recall of.
- A. Data Manipulation Language (DML)
Why not A: “Data Manipulation Language (DML)” is not correct. The accepted answer is C. Composite key. The following statement describes a specific concept What is it called a key formed by combining two or more columns to uniquely identify a row in a table is answered by Composite
- B. Data Definition Language (DDL)
Why not B: “Data Definition Language (DDL)” is not correct. The accepted answer is C. Composite key. The following statement describes a specific concept What is it called a key formed by combining two or more columns to uniquely identify a row in a table is answered by Composite
- C. Composite key ✓
- D. Concurrency control
Why not D: “Concurrency control” is not correct. The accepted answer is C. Composite key. The following statement describes a specific concept What is it called a key formed by combining two or more columns to uniquely identify a row in a table is answered by Composite
Correct answer
C. Composite key
Explanation
The following statement describes a specific concept What is it called a key formed by combining two or more columns to uniquely identify a row in a table is answered by Composite key option C Option A Data Manipulation Language DML does not match the stem it is a near-miss used to catch incomplete recall of Composite key Option B Data Definition Language DDL does not match the stem it is a near-miss used to catch incomplete recall of Composite key Remaining alternatives Concurrency control fall outside the same rule and should be eliminated once Composite key is identified Database Management Systems DBMS questions of this type reward precise definitions rather than approximate associations Database Management Systems DBMS recall of.
Source: Database Management Systems (DBMS) Official Reference Guide
Tags: computer science, dbms, SQL, databases
Submitted by: MCQsHub Editorial
Related MCQs
- Which concept is defined as follows: a precompiled collection of SQL statements stored in a database that can...
- Which term refers to a database property ensuring that relationships between tables remain consistent, typical...
- Which statement correctly explains Data Query Language (DQL)?
- What does Referential integrity refer to?
- Select the correct name for: a subset of SQL primarily represented by the SELECT statement, used to retrieve d...
- What is the name for a set of techniques used in a DBMS to ensure correct results for concurrent transaction o...