Crowdly

Add to Chrome

Universities
moodle.spit.ac.in
SY Common ISE ODD 25-26

SY Common ISE ODD 25-26

Looking for SY Common ISE ODD 25-26 test answers and solutions? Browse our comprehensive collection of verified answers for SY Common ISE ODD 25-26 at moodle.spit.ac.in.

Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!

The double rectangle in an ER diagram denotes:

Derived attribute

Multivalued attribute

Weak entity

Strong entity

View this question

A table

EMP(Emp_ID, Dept_ID, Dept_Name) has FD Dept_ID → Dept_Name.

Which is the best way to

normalize this?

EMP(Emp_ID) and DEPT (Dept_ID, Dept_Name)

❌

EMP(Emp_ID, Dept_ID) and DEPT(Dept_ID, Dept_Name)

✅

EMP(Emp_ID, Dept_ID) and DEPT(Dept_Name)

❌

View this question

Which type of lock allows both read and write operations on data items?

Shared Lock

Exclusive Lock

Timestamp Lock

Read Lock

Which of the following is true for mapping a ternary relationship?

Create one new relation including PKs of all participating entities

It cannot be represented

Merge any two entities

Convert it to three binary relationships

View this question

Which schedule gives the same result as executing transactions one after another?

Cascading Schedule

❌

Non-Serializable Schedule

❌

Recoverable Schedule

❌

Serializable Schedule

✅

View this question

When a transaction is rolled back, it moves to which state?

Committed

Partially Committed

Aborted

Active

View this question

Which of the following SQL constraints ensures that a column cannot have NULL values?

NOT NULL

UNIQUE

DEFAULT

CHECK

View this question

Consider

the relation Construction (Company, Material, Type, Cost) along with the Functional

Dependencies:

FD1:

Company -> Material

FD2:

Material ->Type

FD3: Type

-> Cost

The

relation is decomposed into the following:

Construction1(Company,

Type, Cost)

Construction2(Material,

Type)

Which of the following is true about the

decomposition?

Lossless but not decomposition preserving.

Neither lossless nor decomposition preserving.

Both lossless and decomposition preserving

View this question

In ACID, Atomicity ensures

All or nothing execution

✅

Durable storage

❌

Isolation from other transactions

❌

Consistent database

❌

View this question

Suppose you have:

Employee(EmpID, DeptNo, Salary)

Department(DeptNo, Manager)

Which Relational Algebra expression finds the managers of employees earning more than 50,000?

σ Manager > 50000 (Employee ⨝ Department)

π Salary (Employee ⨝ Department)

π DeptNo (σ Manager > 50000 (Department))

π Manager (σ Salary > 50000 (Employee) ⨝ Department)

View this question

Want instant access to all verified answers on moodle.spit.ac.in?

Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!

Add to Chrome

Telegram Instagram TikTok Question Bank

Add to Chrome