adplus-dvertising
frame-decoration

Question

The SQL expression

Select distinct T, branch_name from branch T, branch S where T.assets>S.assets and S.branch_city=”Mumbai”

finds the names of

a.

All branches that have greater assets than some branch located in Mumbai

b.

All branches that have greater assets than all branches in Mumbai

c.

The branch that has greatest asset in Mumbai

d.

Any branch that has greater assets than any branch in Mumbai

Answer: (a).All branches that have greater assets than some branch located in Mumbai

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. The SQL expression Select distinct T, branch_name from branch T, branch S where T.assets>S.assets and S.branch_city=”Mumbai” finds the names of

Similar Questions

Discover Related MCQs

Q. 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 ?

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)

Q. Which of the following is not a type of Database Management System?

Q. Manager's salary details are to be hidden from Employee Table. This Technique is called as

Q. A Network Schema

Q. Which normal form is considered as adequate for usual database design?

Q. If D1, D2,…. Dn are domains in a relational model, then the relation is a table, which is a subset of

Q. Given an open address hash table with load factor a < 1, the expected number of probes in a successful search is

Q. The “PROJECT” operator of a relational algebra creates a new table that has always

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

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

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

Q. In multiuser database if two users wish to update the same record at the same time, they are prevented from doing so by

Q. What deletes the entire file except the file structure ?

Q. Which command is the fastest among the following ?

Q. B+ tree are preferred to binary tree in Database because

Q. A Transaction Manager is which of the following ?

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 ?

Q. What is Granularity ?

Q. Which level of Abstraction describes what data are stored in the Database ?