Register

Search results for key

4 votes
3 answers
21
NIELIT 2016 MAR Scientist B - Section C: 43
Let $R=(A,B,C,D,E,F)$ be a relation scheme with the following dependencies: $C\to F,E\to a,EC\to D, A\to B$. Which of the following is a key for $R$? $CD$ $EC$ $AE$ $AC$
Let $R=(A,B,C,D,E,F)$ be a relation scheme with the following dependencies:$C\to F,E\to a,EC\to D, A\to B$.Which of the following is a key for $R$?$CD$$EC$$AE$$AC$
User Avatar
0 votes
2 answers
23
NIELIT 2016 DEC Scientist B (IT) - Section B: 36
The primary key is selected from the: Composite keys Determinants Candidate keys Foreign keys
The primary key is selected from the:Composite keysDeterminantsCandidate keysForeign keys
User Avatar
0 votes
1 answer
24
NIELIT 2016 DEC Scientist B (CS) - Section B: 54
If there is more than one key for relation schema in DBMS then each key in relation schema is classified as prime key super key candidate key primary key
If there is more than one key for relation schema in DBMS then each key in relation schema is classified asprime keysuper keycandidate keyprimary key
User Avatar
3 votes
2 answers
25
Made easy mock test 1 DBMS super keys
Consider the following relation R(A1, A2,...A15) with (A1,A2, ... A6) of relation R are simple candidate key. The number of possible superkey in relation R is_
Consider the following relation R(A1, A2,...A15) with (A1,A2, ... A6) of relation R are simple candidate key. The number of possible superkey in relation R is_
User Avatar
2 votes
2 answers
26
ISRO2014-42
Let $x,y,z,a,b,c$ be the attributes of an entity set E. If $\{x\} ,\{x,y\}, \{a,b\},\{a,b,c\}, \{x,y,z\}$ are superkeys then which of the following are the candidate keys? $\{x,y\}$ and $\{a,b\}$ $\{x\}$ and $\{a,b\}$ $\{x,y,z\}$ and $\{a,b,c\}$ $\{z\}$ and $\{c\}$
Let $x,y,z,a,b,c$ be the attributes of an entity set E. If $\{x\} ,\{x,y\}, \{a,b\},\{a,b,c\}, \{x,y,z\}$ are superkeys then which of the following are the candidate keys...
User Avatar
1 votes
2 answers
27
UGC NET CSE | June 2019 | Part 2 | Question: 35
Which of the following key constraints is required for functioning of foreign key in the context relational databases? Unique key Primary key Candidate key Check key
Which of the following key constraints is required for functioning of foreign key in the context relational databases?Unique keyPrimary keyCandidate keyCheck key
User Avatar
2 votes
1 answer
28
UGC NET CSE | June 2019 | Part 2 | Question: 36
In relational database management, which of the following is/are property/properties of candidate key? P: Uniqueness Q: Irreducibility P only Q only Both P and Q Neither P nor Q
In relational database management, which of the following is/are property/properties of candidate key?P: UniquenessQ: IrreducibilityP onlyQ onlyBoth P and QNeither P nor ...
User Avatar
1 votes
1 answer
29
No of Super Key
R (A1, A2, ….An) and every (n-2) attributes of R forms a candidate key. How many super keys are there in R? a) $_{n-2}^{n}\textrm{C}$ b) $_{n-2}^{n}\textrm{C}$ * 4 c) $_{n-2}^{n}\textrm{C}$ * n d) $_{n-2}^{n}\textrm{C}$ + n +1
R (A1, A2, ….An) and every (n-2) attributes of R forms a candidate key. How many superkeys are there in R?a) $_{n-2}^{n}\textrm{C}$b) $_{n-2}^{n}\textrm{C}$ * 4c) $_{n-...
User Avatar
1 votes
8 answers
30
Gate 2019 answer key
I want to challenge the recursive question of gate 2019.Can u suggest what supporting document can be placed?
I want to challenge the recursive question of gate 2019.Can u suggest what supporting document can be placed?
User Avatar
3 votes
2 answers
31
Test by Bikram | Databases | Test 2 | Question: 4
A relation $R(P,Q,R,S)$ has $\{PQ, QR, RS, PS\}$ as candidate keys. The total number of superkeys possible for relation $R$ is ______
A relation $R(P,Q,R,S)$ has $\{PQ, QR, RS, PS\}$ as candidate keys. The total number of superkeys possible for relation $R$ is ______
User Avatar
33 votes
3 answers
32
GATE CSE 2014 Set 2 | Question: 22
Given an instance of the STUDENTS relation as shown as below ... $(\text{StudentName, StudentAge})$ to be a key for this instance, the value $X$ should NOT be equal to______.
Given an instance of the STUDENTS relation as shown as below$$\begin{array}{|c|c|c|c|c|} \hline \textbf {StudentID} & \textbf{StudentName} & \textbf{StudentEmail} & \text...
User Avatar
0 votes
0 answers
33
Answer key date gate
@Arjun Sir : Last year keys were out only 2-3 days before results. So what made you say this for this time ??
@Arjun Sir : Last year keys were out only 2-3 days before results. So what made you say this for this time ??
User Avatar
0 votes
1 answer
36
Super Keys
How many Super keys Possible for R(A,B,C,D,E) with 1. {A,BC,DE} as the keys ? 2. {A,BC,CDE} as the keys ?
How many Super keys Possible for R(A,B,C,D,E) with1. {A,BC,DE} as the keys ?2. {A,BC,CDE} as the keys ?
User Avatar
1 votes
0 answers
37
Self doubt
Can Prime attribute be NULL in any of the the Candidate key ?? Can Prime attribute be NULL in Primary key ??
Can Prime attribute be NULL in any of the the Candidate key ??Can Prime attribute be NULL in Primary key ??
User Avatar
1 votes
2 answers
39
General doubt dbms
An instance of a relational schema R(A,B,C,D) has distinct values for attribute A then A can be 1) candidate key 2)non key 3)super key 4)none
An instance of a relational schema R(A,B,C,D) has distinct values for attribute A then A can be 1) candidate key2)non key 3)super key4)none
User Avatar
Page: