A directory of Objective Type Questions covering all the Computer Science subjects. Here you can access and discuss Multiple choice questions and answers for various compitative exams and interviews.

Discussion Forum

Que. Consider the following schemas :

Branch_Schema = (branch_name, assets, city)
Customer_Schema = (cutstomer_name, street, city)
Deposit_Schema = (branch_name, account_number, customer_name, balance)
Borrow_Schema = (branch_name, loan_number, customer_name, amount)

Which of the following tuple relational calculus finds all customers who have loan amount more than Rs 12,000 ?
a. {t(customer_name) | t∈borrow[?] t[amount]>12000}
b. {t |t(customer_name) | t∈borrow[?] t[amount]>12000}
c. {t |[?] ∈ borrow (t(customer_name=s(customer_ name))[?] [amount]>12000}
d. {t |[?] ∈ borrow (t(customer_name)[?] s[amount] >12000}
Answer:{t |[?] ∈ borrow (t(customer_name=s(customer_ name))[?] [amount]>12000}
Confused About the Answer? Ask for Details Here
Know Explanation? Add it Here

Similar Questions: