Which of the following statement is wrong? 2 - phase locking protocol suffers from deadlock. Timestamp protocol suffers from more aborts. A block hole in a DFD is a data store with only inbound flows. Multivalued dependency among attributes is checked at 3NF level. An entity-relationship diagram is a tool to represent the event model.a)1 and 3b)2c)4d)5Correct answer is option 'C,D'. Can you explain this answer? - EduRev Computer Science Engineering (CSE) Question

Explore Courses UPSC Exam UPSC Test Series Free Notes EduRev Infinity

Open App

Computer Science Engineering (CSE) Exam > Computer Science Engineering (CSE) Questions > Which of the following statement is wrong? 2 ...

Join the Discussion on the App

Which of the following statement is wrong?

2 - phase locking protocol suffers from deadlock.
Timestamp protocol suffers from more aborts.
A block hole in a DFD is a data store with only inbound flows.
Multivalued dependency among attributes is checked at 3NF level.
An entity-relationship diagram is a tool to represent the event model.

a)
1 and 3
b)
2
c)
4
d)
5

Correct answer is option 'C,D'. Can you explain this answer?

FREE This question is part of

GATE Mock Test Computer Science Engineering (CSE) - 7

Attempt Test

Attempt this Test

Most Upvoted Answer

Which of the following statement is wrong? 2 - phase locking protocol ...

2 - phase locking protocol suffers from the deadlock is a true statement.

Timestamp protocol suffers from more aborts is a true statement (suffer from cascading rollback).

A block hole in a DFD is a data store with only inbound flows is a true statement.

Multivalued dependency among attributes is checked at 3NF level. It is a false statement (checked at 4NF level).

An entity-relationship diagram is a tool to represent the event model. It is a false statement (tool to represent data model).

Hence, the correct options are (C) and (D).

Answered by Gate Gurus · View profile

Free Test

FREE

GATE Mock Test Computer Science Engineering (CSE) - 7
65 Ques | 180 Min

Start Free Test

View all free Computer Science Engineering (CSE) tests

Community Answer

Which of the following statement is wrong? 2 - phase locking protocol ...

1. 2-phase locking protocol suffers from deadlock.
This statement is correct. The 2-phase locking protocol is a concurrency control method used in databases to ensure serializability of transactions. However, it can lead to deadlock situations where two or more transactions are waiting for each other to release their locks, resulting in a circular dependency and no progress being made.

2. Timestamp protocol suffers from more aborts.
This statement is incorrect. The timestamp protocol is another concurrency control method used in databases. It assigns a unique timestamp to each transaction and uses this timestamp to determine the order in which transactions can access data items. The timestamp protocol aims to avoid conflicts between transactions and does not necessarily result in more aborts.

3. A block hole in a DFD is a data store with only inbound flows.
This statement is incorrect. A block hole in a Data Flow Diagram (DFD) is a data store with no inbound or outbound flows. It represents a data store that is not accessed or modified by any process or external entity.

4. Multivalued dependency among attributes is checked at 3NF level.
This statement is correct. Multivalued dependencies are a type of dependency in database normalization. They occur when a set of attributes functionally determines multiple sets of attributes. Multivalued dependency is checked and resolved at the third normal form (3NF) level in the normalization process.

5. An entity-relationship diagram is a tool to represent the event model.
This statement is incorrect. An entity-relationship (ER) diagram is a graphical representation of entities, attributes, and relationships in a database. It is used to model the structure of a database and the relationships between entities. The event model, on the other hand, is a conceptual model used to represent the behavior and interactions of entities in a system. It is not represented by an ER diagram.

In conclusion, the wrong statements are:
- Statement 3: A block hole in a DFD is a data store with only inbound flows.
- Statement 5: An entity-relationship diagram is a tool to represent the event model.

Share via Whatsapp

Attention Computer Science Engineering (CSE) Students!

To make sure you are not studying endlessly, EduRev has designed Computer Science Engineering (CSE) study material, with Structured Courses, Videos, & Test Series. Plus get personalized analysis, doubt solving and improvement plans to achieve a great score in Computer Science Engineering (CSE).

GATE Computer Science Engineering(CSE) 2025 Mock Test Series

Question Bank for GATE Computer Science Engineering

General Aptitude for GATE

Computer Networks

View all answers Start learning for free

< Previous Question Next Question >

Explore Courses for Computer Science Engineering (CSE) exam

Similar Computer Science Engineering (CSE) Doubts

Which of the following statement is wrong? Timestamp protocol suffers from more aborts. A block hole in a DFD is a data store with only inbound flows. Multivalued dependency among attributes is checked at 3 NF level. An entity-relationship diagram is a tool to represent the event model.

View answer

Consider the following entity relationship diagram (ERD), where two entities E1 and E2 have arelation R of cardinality 1 : m.The attributes of E1 are A11, A12 and A13where , A11 is key attribute. The attributes of E2 are A21, A22, and A23 where A21is the key attribute andA23 is a multi-valued attribute. Relation R doesnot have any attribute. A relational database containing minimum number of tables with each table satisfying the requirements of the third normal form (3NF) is designed from the above ERD. The number of tables in the database is

View answer

Consider the following entity relationship diagram (ERD), where two entities E1 and E2 have a relation R of cardinality 1 : m.The attributes of E1 are A11, A12 and A13 where A11 is the key attribute. The attributes of E2 are A21, A22 and A23 where A21 is the key attribute and A23 is a multi-valued attribute. Relation R does not have any attribute. A relational database containing minimum number of tables with each table satisfying the requirements of the third normal form (3NF) is designed from the above ERD. The number of tables in the database is

View answer

Consider an Entity-Relationship (ER) model in which entity sets E1 and E2 are connected by an m : n relationship R12, E1 and E3 are connected by a 1 : n (1 on the side of E1 and n on the side of E3) relationship R13. E1 has two single-valued attributes a11and a12of which a11is the key attribute. E2 has two single-valued attributes a21and a22is the key attribute. E3 has two single-valued attributes a31and a32of which a31is the key attribute. The relationships do not have any attributes. If a relational model is derived from the above ER model, then the minimum number of relations that would be generated if all the relations are in 3NF is ___________.

View answer

Direction: Two Statements I and II are given. These statements may be either independent causes or may be effects of independent causes or a common cause. One of these statements may be the effect of the other statements. Read both statements and decide which of the following answer choice correctly depicts the relationship between these two statements:Statement I. A large number of Primary Schools in the rural areas are run by only one teacher.Statement II. There has been a huge dropout from the primary schools in rural areas.

View answer

Top Courses for Computer Science Engineering (CSE)View all

GATE Computer Science Engineering(CSE) 2025 Mock Test Series

Question Bank for GATE Computer Science Engineering

General Aptitude for GATE

Computer Networks

Programming and Data Structures

Top Courses for Computer Science Engineering (CSE)

View all

Which of the following statement is wrong? 2 - phase locking protocol suffers from deadlock. Timestamp protocol suffers from more aborts. A block hole in a DFD is a data store with only inbound flows. Multivalued dependency among attributes is checked at 3NF level. An entity-relationship diagram is a tool to represent the event model.a)1 and 3b)2c)4d)5Correct answer is option 'C,D'. Can you explain this answer?

Share with a Friend

Answer this doubt

Question Description
Which of the following statement is wrong? 2 - phase locking protocol suffers from deadlock. Timestamp protocol suffers from more aborts. A block hole in a DFD is a data store with only inbound flows. Multivalued dependency among attributes is checked at 3NF level. An entity-relationship diagram is a tool to represent the event model.a)1 and 3b)2c)4d)5Correct answer is option 'C,D'. Can you explain this answer? for Computer Science Engineering (CSE) 2024 is part of Computer Science Engineering (CSE) preparation. The Question and answers have been prepared according to the Computer Science Engineering (CSE) exam syllabus. Information about Which of the following statement is wrong? 2 - phase locking protocol suffers from deadlock. Timestamp protocol suffers from more aborts. A block hole in a DFD is a data store with only inbound flows. Multivalued dependency among attributes is checked at 3NF level. An entity-relationship diagram is a tool to represent the event model.a)1 and 3b)2c)4d)5Correct answer is option 'C,D'. Can you explain this answer? covers all topics & solutions for Computer Science Engineering (CSE) 2024 Exam. Find important definitions, questions, meanings, examples, exercises and tests below for Which of the following statement is wrong? 2 - phase locking protocol suffers from deadlock. Timestamp protocol suffers from more aborts. A block hole in a DFD is a data store with only inbound flows. Multivalued dependency among attributes is checked at 3NF level. An entity-relationship diagram is a tool to represent the event model.a)1 and 3b)2c)4d)5Correct answer is option 'C,D'. Can you explain this answer?.

Solutions for Which of the following statement is wrong? 2 - phase locking protocol suffers from deadlock. Timestamp protocol suffers from more aborts. A block hole in a DFD is a data store with only inbound flows. Multivalued dependency among attributes is checked at 3NF level. An entity-relationship diagram is a tool to represent the event model.a)1 and 3b)2c)4d)5Correct answer is option 'C,D'. Can you explain this answer? in English & in Hindi are available as part of our courses for Computer Science Engineering (CSE). Download more important topics, notes, lectures and mock test series for Computer Science Engineering (CSE) Exam by signing up for free.

Here you can find the meaning of Which of the following statement is wrong? 2 - phase locking protocol suffers from deadlock. Timestamp protocol suffers from more aborts. A block hole in a DFD is a data store with only inbound flows. Multivalued dependency among attributes is checked at 3NF level. An entity-relationship diagram is a tool to represent the event model.a)1 and 3b)2c)4d)5Correct answer is option 'C,D'. Can you explain this answer? defined & explained in the simplest way possible. Besides giving the explanation of Which of the following statement is wrong? 2 - phase locking protocol suffers from deadlock. Timestamp protocol suffers from more aborts. A block hole in a DFD is a data store with only inbound flows. Multivalued dependency among attributes is checked at 3NF level. An entity-relationship diagram is a tool to represent the event model.a)1 and 3b)2c)4d)5Correct answer is option 'C,D'. Can you explain this answer?, a detailed solution for Which of the following statement is wrong? 2 - phase locking protocol suffers from deadlock. Timestamp protocol suffers from more aborts. A block hole in a DFD is a data store with only inbound flows. Multivalued dependency among attributes is checked at 3NF level. An entity-relationship diagram is a tool to represent the event model.a)1 and 3b)2c)4d)5Correct answer is option 'C,D'. Can you explain this answer? has been provided alongside types of Which of the following statement is wrong? 2 - phase locking protocol suffers from deadlock. Timestamp protocol suffers from more aborts. A block hole in a DFD is a data store with only inbound flows. Multivalued dependency among attributes is checked at 3NF level. An entity-relationship diagram is a tool to represent the event model.a)1 and 3b)2c)4d)5Correct answer is option 'C,D'. Can you explain this answer? theory, EduRev gives you an ample number of questions to practice Which of the following statement is wrong? 2 - phase locking protocol suffers from deadlock. Timestamp protocol suffers from more aborts. A block hole in a DFD is a data store with only inbound flows. Multivalued dependency among attributes is checked at 3NF level. An entity-relationship diagram is a tool to represent the event model.a)1 and 3b)2c)4d)5Correct answer is option 'C,D'. Can you explain this answer? tests, examples and also practice Computer Science Engineering (CSE) tests.

Explore Courses for Computer Science Engineering (CSE) exam