In an Entity-Relationship (ER) diagram, attributes are represented using which shape? MCQ with Answer and Explanation

In an Entity-Relationship (ER) diagram, attributes are represented using which shape?
A. Rectangle
B. Diamond
C. Ellipse/Oval
D. Square
Answer: Option C
Solution (By JKSSB Mock Tests)
Ellipses or ovals are used to represent attributes (properties) of entities in ER diagrams.

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1
Which SQL keyword is used within a SELECT query to filter records matching a specified pattern using wildcards?
A. LIKE
B. IN
C. EXISTS
D. BETWEEN

Correct Answer: Option A


Explanation:
The LIKE operator is specifically used in a WHERE clause to perform pattern matching on string columns using wildcards (% and _).

This question belongs to: Computer Database Management System (DBMS)
Question #2
What type of join produces a Cartesian product, matching every single row of the first table with every single row of the second table?
A. Left Join
B. Inner Join
C. Cross Join
D. Natural Join

Correct Answer: Option C


Explanation:
A Cross Join returns the Cartesian product of the two tables, multiplying the total number of rows from the first table by the number of rows in the second table.

This question belongs to: Computer Database Management System (DBMS)
Question #3
Which of the following is a property of a transaction that ensures that the database remains in a valid state before and after the transaction?
A. Atomicity
B. Consistency
C. Durability
D. Isolation

Correct Answer: Option B


Explanation:
Consistency ensures that a transaction brings the database from one valid state to another, maintaining all defined rules and constraints.

This question belongs to: Computer Database Management System (DBMS)