Question:
Which of the following is related to DBMS?
Which of the following is related to DBMS?
Show Hint
A candidate key in a relational database is a set of one or more columns that can uniquely identify a row in a table. A primary key is selected from the candidate keys.
Updated On: May 4, 2025
- Public key
- Private key
- Symmetric key
- Candidate key
Hide Solution
Verified By Collegedunia
The Correct Option is D
Solution and Explanation
- Public key: A public key is used in cryptography for secure communication but is not directly related to DBMS.
- Private key: A private key is also a cryptographic concept and is not associated with DBMS concepts.
- Symmetric key: Symmetric key encryption is a cryptographic concept and is not directly related to DBMS.
- Candidate key: In the context of a DBMS, a candidate key is a set of attributes that uniquely identifies a record in a relation (table). It is a core concept of database design.
Therefore, the correct answer is 4. Candidate key.
- Private key: A private key is also a cryptographic concept and is not associated with DBMS concepts.
- Symmetric key: Symmetric key encryption is a cryptographic concept and is not directly related to DBMS.
- Candidate key: In the context of a DBMS, a candidate key is a set of attributes that uniquely identifies a record in a relation (table). It is a core concept of database design.
Therefore, the correct answer is 4. Candidate key.
Was this answer helpful?
0
0
Top Questions on Database Concepts
- Consider the following database schema: \[ \text{Person (aadhar CHAR(12) PK, name VARCHAR(32))} \] \[ \text{Customer (name VARCHAR(32), email VARCHAR(32) PK, phone CHAR, aadhar CHAR(12) FK(aadhar))} \] Which of the following statements is/are correct?
- GATE DA - 2025
- Data Science and Artificial Intelligence
- Database Concepts
- Given the relation: \[ R = \{A, B, C, D, E, F, G\} \] With the following functional dependencies (FDs): \[ A \rightarrow BCEF, \quad E \rightarrow DG, \quad BC \rightarrow A \] Which of the following statements is correct?
- GATE DA - 2025
- Data Science and Artificial Intelligence
- Database Concepts
- Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R, it will
- AP PGECET - 2024
- Computer Science & Information Technology
- Database Concepts
- In a particular bank, a loan can belong to only one customer and a customer can have several loans. Then the relationship from customer to loans is
- AP PGECET - 2024
- Computer Science & Information Technology
- Database Concepts
- The number of clock cycles that it takes to process 200 tasks in a six-segment pipeline is
- AP PGECET - 2024
- Computer Science & Information Technology
- Database Concepts
View More Questions
Questions Asked in AP PGECET exam
The rank of matrix \(\begin{bmatrix} k & -1 & 0 \\[0.3em] 0 & k & -1 \\[0.3em] -1 & 0 & k \end{bmatrix}\) is 2, for \( k = \)
- AP PGECET - 2024
- Rank of a Matrix
If \(A = \begin{bmatrix} 4 & 2 \\[0.3em] -3 & 3 \end{bmatrix}\), then \(A^{-1} =\)
- AP PGECET - 2024
- Inverse of a Matrix
A two-port network is defined by the relation
\(\text{I}_1 = 5V_1 + 3V_2 \)
\(\text{I}_2 = 2V_1 - 7V_2 \)
The value of \( Z_{12} \) is:- AP PGECET - 2024
- Two Port Networks
An induction motor when started on load does not accelerate up to full speed but runs at \({\frac {1}{17}}\)th of the rated speed. The motor is said to be:
- AP PGECET - 2024
- Induction Motor
A 0 to 30 V voltmeter has an error of \(\pm 2\%\) of FSD. What is the range of readings if the voltage is 30V?
- AP PGECET - 2024
- Errors in Measurement
View More Questions