2902032025 - JAVA-DSA-DBMS-OOP

In an ER diagram, what do entities represent?

• Relationships between tables
• Physical storage location
• Real-world objects or concepts
• Database queries

Which of the following best describes an attribute in an ER model?

• A link between entities
• A primary key
• A characterstic or property of an entity
• A type of relationship

A relationship in an ER model that involves more than two entity types is known as:

• A binary relationship
• A ternary relationship
• A primary relationship
• An associative relationship

To add a column named "Email" of type VARCHAR to an existing table named "Users", which SQL statement is correct?

• ALTER TABLE Users ADD COLUMN Email VARCHAR
• ALTER TABLE Users ADD Email VARCHAR
• UPDATE TABLE Users ADD Email VARCHAR
• INSERT INTO Users (Email) VALUES ('VARCHAR')

What is the correct SQL statement to create a foreign key in the "Orders" table that references the "Customers" table's primary key?

• CREATE FOREIGN KEY (CustomerID) REFERENCES Customers(CustomerID)
• ALTER TABLE Orders ADD CONSTRAINT fk_customer FOREIGN KEY (CustomerID) REFERENCES Customers(CustomerID)
• ALTER TABLE Orders ADD FOREIGN KEY (CustomerID) REFERENCES Customers
• CREATE TABLE Orders ADD FOREIGN KEY CustomerID REFERENCES Customers

In a graph of n nodes and n edges, how many cycles will be present?

• Exactly 1
• At most 1
• At most 2
• Depends on the graph

Which of the following algorithms are used to find the shortest path from a source node to all other nodes in a weighted graph?

• BFS
• Dijkstra's Algorithm
• Prims Algorith
• Kruskal's Algorithm

Which data structure is mainly used for implementing the recursive algorithm?

• Queue
• Stack
• Array
• List

The time factor when determining the efficiency of algorithm is measured by

• Counting microseconds
• Counting the number of key operations
• Counting the number of statements
• Counting the kilobytes of algorithm

The Average case occur in linear search algorithm

• When Item is somewhere in the middle of the array
• When Item is not in the array at all
• When Item is the last element in the array
• When Item is the last element in the array or is not there at all