Question
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}
Posted under UGC NET computer science question paper DBMS
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. Consider the following schemas : Branch_Schema = (branch_name, assets, city) Customer_Schema = (cutstomer_name, street, city) Deposit_Schema = (branch_name, account_number,...
Similar Questions
Discover Related MCQs
Q. Match the following :
(a) Create (i) The E-R Model
(b) Select (ii) Relationship Model
(c) Rectangle (iii) DDL
(d) Record (iv) DML
Codes :
(a) (b) (c) (d)
View solution
Q. Which of the following is not a type of Database Management System?
View solution
Q. Manager's salary details are to be hidden from Employee Table. This Technique is called as
View solution
Q. A Network Schema
View solution
Q. Which normal form is considered as adequate for usual database design?
View solution
Q. If D1, D2,…. Dn are domains in a relational model, then the relation is a table, which is a subset of
View solution
Q. Given an open address hash table with load factor a < 1, the expected number of probes in a successful search is
View solution
Q. The “PROJECT” operator of a relational algebra creates a new table that has always
View solution
Q. The employee information of an Organization is stored in the relation:
Employee (name, sex, salary, deptname)
Consider the following SQL query
Select deptname from Employee Where sex = ‘M’ group by deptname having avg (salary) > {select avg (salary) from Employee}
Output of the given query corresponds to
View solution
Q. For a database relation R(a, b, c, d) where the domains of a, b, c, d include only the atomic values. The functional dependency a → c, b → d holds in the following relation
View solution
Q. Match the following:
a. Foreign keys i. Domain constraint
b. Private key ii. Referential integrity
c. Event control action model iii. Encryption
d. Data security iv. Trigger
Codes:
a b c d
View solution
Q. In multiuser database if two users wish to update the same record at the same time, they are prevented from doing so by
View solution
Q. What deletes the entire file except the file structure ?
View solution
Q. Which command is the fastest among the following ?
View solution
Q. B+ tree are preferred to binary tree in Database because
View solution
Q. A Transaction Manager is which of the following ?
View solution
Q. A B+ tree index is to be built on the name attribute of the relation STUDENT. Assume that all students names are of length 8 bytes, disk block are of size 512 bytes and index pointers are of size 4 bytes. Given this scenario what would be the best choice of the degree (i.e. the number of pointers per node) of the B+ tree ?
View solution
Q. What is Granularity ?
View solution
Q. Which level of Abstraction describes what data are stored in the Database ?
View solution
Q. The problem that occurs when one transaction updates a database item and then the transaction fails for some reason is …………….
View solution
Suggested Topics
Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!
