Exams Net
Unrestricted Exams Practice
Home
Exams
Banking
CUET
Defence
Engineering
Finance
GATE
Insurance
International
JEE
LAW
MBA
MCA
Medical
Other
Police
PSC
RRB
SSC
State Govt
Subjectwise
Teacher
SET Exams
UPSC
Aptitude
Algebra and Higher Mathematics
Arithmetic
Commercial Mathematics
Data Based Mathematics
Geometry and Mensuration
Number System and Numeracy
Problem Solving
Board Exams
Andhra
Bihar
CBSE
Gujarat
Haryana
ICSE
Jammu and Kashmir
Karnataka
Kerala
Madhya Pradesh
Maharashtra
Odisha
Tamil Nadu
Telangana
Uttar Pradesh
English
Competitive English
CBSE
CBSE Class 10 Solutions
CBSE Class 12 Solutions
CBSE Question Papers (Pdf)
NCERT Books (Pdf)
NCERT Exemplar Books (Pdf)
NCERT Study Notes (Pdf)
CBSE Study Concepts (Pdf)
NCERT Text Book Class 11 Solutions
NCERT Text Book Class 12 Solutions
ICSE Class 10 Papers
Certifications
Technical
Cloud Tech Certifications
Security Tech Certifications
Management
IT Infrastructure
More
About
Contact Us
Our Apps
Privacy
+
-
Default
Dark
Blue
Green
Violet
Crimson
Red
Cafe
Gold
Orange
Olive
Grey
Test Index
GATE Computer Science (CS) 2020 Solved Papers
Show Para
Hide Para
Share question:
© examsnet.com
Question : 39 of 65
Marks:
+1
,
-0
Consider a relational table R that is in 3NF, but not in BCNF. Which one following statements is TRUE?
A cell in R holds a set instead of an atomic value.
R
R
R
has a nontrivial functional dependency
X
→
A
X \rightarrow A
X
→
A
, wh
R
R
R
has a nontrivial functional dependency
X
→
A
X \rightarrow A
X
→
A
, where
X
X
X
is not a sup and
A
A
A
is a prime attribute.ere
X
X
X
is not a sup and
A
A
A
is a prime attribute.
R
R
R
has a nontrivial functional dependency
X
→
A
X \rightarrow A
X
→
A
, where
X
X
X
is not a sup and
A
A
A
is a non- prime attribute and
X
X
X
is a proper subset of some key.
R
R
R
has a nontrivial functional dependency
X
→
A
X \rightarrow A
X
→
A
, where
X
X
X
is not a sup and
A
A
A
is a non- prime attribute and
X
X
X
is not a proper subset of any key.
Validate
Go to Question:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
Prev Question
Next Question
Advertisements
More Free Exams
GATE Civil Engineering Previous Papers
GATE Electrical Engineering Previous
GATE Electronic & Communications Previous
GATE Mechanical Engineering Previous
GMAT Exam Practice Tests
GRE Practice Tests
More Free Exams
GATE Civil Engineering Previous Papers
GATE Electrical Engineering Previous
GATE Electronic & Communications Previous
GATE Mechanical Engineering Previous
GMAT Exam Practice Tests
GRE Practice Tests