Register

Search results for key

17.3k
views
4 answers
53 votes
GATE CSE 2011 | Question: 12
Consider a relational table with a single record for each registered student with the following attributes:$\text {Registration_Num:}$ Unique registration number for each registered ... $S \cup \text{UID}$ is also a superkey
User Avatar
13.8k
views
4 answers
39 votes
GATE CSE 2014 Set 3 | Question: 22
A prime attribute of a relation scheme $R$ is an attribute that appearsin all candidate keys of $R$in some candidate key of $R$in a foreign key of $R$only in the primary key of $R$
User Avatar
9.3k
views
4 answers
34 votes
GATE CSE 1994 | Question: 3.7
An instance of a relational scheme $R(A, B, C)$ has distinct values for attribute $A$. Can you conclude that $A$ is a candidate key for $R?$
User Avatar
537
views
2 answers
0 votes
DBMS
The correct answer is a and d. I just wanted to know that why not b and c. It is possible that it may be speed and color is also a candidate key. If you have any clarification on this let me know!!!
User Avatar
533
views
1 answers
2 votes
made easy test series 2023
Consider a relation R having seven attributes ABCDEFG. Fields of R contain only atomic values.FDs = {CD → G, A → BC, B → CF, E → A, F → EG, G → D} is set of functional dependencies. So, how many candidates key does the relation R have?
User Avatar
1.7k
views
1 answers
1 votes
Made easy || Database
Consider a relation schema r(A, B, C, D, E, F) and attribute A is element of every candidate key of r. Maximum number of possible candidate keys of r is ________.
User Avatar
612
views
0 answers
1 votes
Finding Candidate Keys | Class Practice | Unacademy
Find the candidate key(s) of the relation R(UVWXYZ) with FD set F={UV-->W, XW-->Y, U-->XZ, Y-->U}XWUV, YV, WXVYUV, XV, WVNone of these
User Avatar
748
views
1 answers
0 votes
Test Series 2022
Please explain Ans is 22
User Avatar
12.1k
views
8 answers
35 votes
GATE CSE 2014 Set 2 | Question: 21
The maximum number of superkeys for the relation schema $R(E,F,G,H)$ with $E$ as the key is _____.
User Avatar
3.0k
views
7 answers
1 votes
UGC NET CSE | January 2017 | Part 3 | Question: 8
Which one is correct w.r.t. RDBMS?primary key $\subseteq$ super key $\subseteq$ candidate keyprimary key $\subseteq$ candidate key $\subseteq$ super key ... $\subseteq$ primary key $\subseteq$ candidate key
User Avatar
1.2k
views
2 answers
2 votes
CANDIDATE KEY
User Avatar
520
views
1 answers
2 votes
NIELIT Scientific Assistant A 2020 November: 86
A minimal super key (i.e, one of the super keys for which no proper subset is a superkey) is called:Super KeyCandidate KeyPrimary KeyBoth Candidate and Primary Key
User Avatar
6.8k
views
2 answers
7 votes
UGC NET CSE | June 2016 | Part 2 | Question: 20
Consider the following database table having $\text{A, B, C}$ and $\text{D}$ as its four attributes and four possible candidate keys $\text{(I, II, III and IV)}$ for ... only$\text{III}$ and $\text{IV}$ only$\text{II}$ only$\text{I}$ only
User Avatar
1.0k
views
3 answers
4 votes
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$
User Avatar
473
views
1 answers
2 votes
NIELIT Scientific Assistant A 2020 November: 72
Let $\text{R=(A,B,C,D,E)}$ ... $\text{B}$\text{E}$\text{BC}$
User Avatar
985
views
2 answers
0 votes
NIELIT 2016 DEC Scientist B (IT) - Section B: 36
The primary key is selected from the:Composite keysDeterminantsCandidate keysForeign keys
User Avatar
3.0k
views
1 answers
0 votes
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 asprime keysuper keycandidate keyprimary key
User Avatar
1.4k
views
2 answers
3 votes
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_
User Avatar
4.4k
views
2 answers
2 votes
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\}$ ... $\{a,b\}$\{x,y,z\}$ and $\{a,b,c\}$\{z\}$ and $\{c\}$
User Avatar
3.9k
views
2 answers
1 votes
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 keyPrimary keyCandidate keyCheck key
User Avatar
Page: