ExamSIDE
Questions (Powered by ExamGOAL)
Database Management System
Er Diagrams
Marks 1Marks 2
Functional Dependencies and Normalization
Marks 1Marks 2
Structured Query Language
Marks 1Marks 2
Relational Algebra
Marks 1Marks 2
Transactions and Concurrency
Marks 1Marks 2
File Structures and Indexing
Marks 1Marks 2
Next
1
GATE CSE 2024 Set 2
MCQ (Single Correct Answer)
+1
-0.33

In the context of owner and weak entity sets in the ER (Entity-Relationship) data model, which one of the following statements is TRUE?

A

The weak entity set MUST have total participation in the identifying relationship

B

The owner entity set MUST have total participation in the identifying relationship

C

Both weak and owner entity sets MUST have total participation in the identifying relationship

D

Neither weak entity set nor owner entity set MUST have total participation in the identifying relationship

2
GATE CSE 2024 Set 1
MCQ (Single Correct Answer)
+1
-0.33

Let S be the specification : "Instructors teach courses. Students register for courses. Courses are allocated classrooms. Instructors guide students." Which one of the following ER diagrams CORRECTLY represents S?

GATE CSE 2024 Set 1 Database Management System - Er Diagrams Question 2 English 1 GATE CSE 2024 Set 1 Database Management System - Er Diagrams Question 2 English 2

A

(i)

B

(ii)

C

(iii)

D

(iv)

3
GATE CSE 2023
MCQ (Single Correct Answer)
+1
-0.33

Which one of the options given below refers to the degree (or arity) of a relation in relational database systems?

A
Number of attributes of its relation schema.
B
Number of tuples stored in the relation.
C
Number of entries in the relation.
D
Number of distinct domains of its relation schema.
4
GATE CSE 2020
MCQ (Single Correct Answer)
+1
-0.33
Which one of the following is used to represent the supporting many-one relationships of a weak entity set in an entity-relationship diagram?
A
Rectangles with double/bold border
B
Diamonds with double/bold border
C
Ovals that contain underlined identifiers
D
Ovals with double/bold border
Next
Questions Asked from Marks 1
GATE CSE 2024 Set 2 (1) GATE CSE 2024 Set 1 (1) GATE CSE 2023 (1) GATE CSE 2020 (1) GATE CSE 2016 Set 1 (1) GATE CSE 2014 Set 2 (1) GATE CSE 2013 (1) GATE CSE 2012 (1) GATE CSE 2011 (1) GATE CSE 2005 (1)
GATE CSE Subjects
Theory of Computation
Operating Systems
Algorithms
Digital Logic
Database Management System
Data Structures
Computer Networks
Software Engineering
Compiler Design
Web Technologies
General Aptitude
Discrete Mathematics
Programming Languages
Computer Organization