Question
Select distinct T. branch name from branch T, branch S where T. assets > S. assets and S. branch-city = DELHI,
finds the name of
a.
all branches that have greater asset than any branch located in DELHI.
b.
all branches that have greater assets than allocated in DELHI.
c.
the branch that has the greatest asset in DELHI.
d.
any branch that has greater asset than any branch located in DELHI.
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. The SQL Expression Select distinct T. branch name from branch T, branch S where T. assets > S. assets and S. branch-city = DELHI, finds the name of
Similar Questions
Discover Related MCQs
Q. Which of the following is the recovery management technique in DDBMS ?
View solution
Q. Which of the following is the process by which a user’s privileges ascertained ?
View solution
Q. The basic variants of time-stampbased method of concurrency control are
View solution
Q. A transaction can include following basic database access operations :
View solution
Q. Consider a hash table of size m = 10000 and the hash function h(k) = ∟m(kA mod 1)'┘ for A = (√5–1)/2. The location to the key k = 123456 is
View solution
Q. The dependency preservation decomposition is a property to decompose database schema D, in which each functional dependency X->Y specified in F,
View solution
Q. Which of the following is an optimistic concurrency control method?
View solution
Q. Which of the following is the process by which a user’s access to physical data in the application is limited, based on his privileges?
View solution
Q. Linear probing suffers from a problem known as
View solution
Q. An entity instance is a single occurrence of an …………..
View solution
Q. Generalization is ………… process.
View solution
Q. Match the following:
Set-I
I. 2 NF
II. 3 NF
III. 4 NF
IV. 5 NF
Set-II
(a) transitive dependencies eliminated
(b) multivalued attribute removed
(c) contain no partial functional dependencies
(d) contains no join dependency
Codes :
I II III IV
View solution
Q. Which data management language component enabled the DBA to define the schema components?
View solution
Q. The PROJECT Command will create new table that has
View solution
Q. A chained hash table has an array size of 100. What is the maximum number of entries that can be placed in the table?
View solution
Q. The E-R model is expressed in term of
I. Entities
II. The relationship among entities.
III. The attributes of the entities.
IV. Functional relationship.
View solution
Q. Specialization is …………… process.
View solution
Q. Match the following :
List-I
(1) Determinants
(2) Candidate key
(3) Non-redundancy
(4) Functional dependency
List-II
(a) No attribute can be added
(b) Uniquely identified a row
(c) A constraint between two attribute
(d) Group of attributes on the left hand side of arrow of function dependency.
View solution
Q. A function that has no partial functional dependencies is in ……………. form.
View solution
Q. Which of the following statement is wrong?
I. 2-phase locking protocol suffer from dead lock.
II. Time stamp protocol suffer from more aborts.
III. A block hole in a DFD is a data store with only inbound flows.
IV. Multivalued dependency among attribute is checked at 3 NF level.
V. An entity-relationship diagram is a tool to represent event model.
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!
