Division operation is ideally suited to handle queries of the type : (A) customers who have no account in any of the branches in Delhi. (B) customers who have an account at all branches in Delhi. (C) customers who have an account in atleast one branch in Delhi. (D) customers who have only joint account in any one branch in Delhi

1 Answer

Answer :

(B) customers who have an account at all branches in Delhi. 

Related questions

Description : Consider the following schemas: Branch = (Branch-name, Assets, Branch-city) Customer = (Customer-name, Bank-name, Customer-city) Borrow = (Branch-name, loan-number, customer account-number) Deposit = ... )) (C) πcustomer-name(σbalance> 10000(Borrow)) (D) σcustomer-name(σbalance> 10000(Borrow))

Last Answer : (A) πcustomer-name(σbalance> 10000(Deposit)) 

Description : The sugar industry is ideally suited for the cooperative sector. Why? -Geography

Last Answer : Sugarcane cultivation is seasonal hence the production too is seasonal. The farmers are engaged in the cultivation of the sugarcane, and when it is reaped, a cluster of farmers set up a ... together. Hence it is a cooperative sector. The cooperative formation has been successful in Maharashtra.

Description : Which industry, due to its seasonal nature, is ideally suited to the cooperative sector? -SST 10th

Last Answer : This answer was deleted by our moderators...

Description : Why is sugar industry ideally suited to the cooperative sector? -SST 10th

Last Answer : (i) The sugar industry is seasonal in nature and so is ideally suited to the cooperative sector. (ii) For entire year the farmers are engaged in producing sugarcane as it is an annual ... nature of the sugar industry is combated by setting up cooperative where farmers share the profits and losses.

Description : Pick out the wrong statement. (A) A soft magnetic material should have high permeability and small area of hysteresis loop (B) Poisson's ratio of high melting point metals is more than unity (C) ... less than 185°C (D) Steel produced by B.O.F process is ideally suited for manufacturing flat product

Last Answer : Option B

Description : Land plane is ideally suited for a) Land levelling b) Earth moving c) Final grading d) Top finishing

Last Answer : d) Top finishing

Description : Land plane is ideally suited for: a. Land leveling b. Earth moving c. Final grading d. Top finishing

Last Answer : d. Top finishing

Description : Project management is ideally suited for a business environment requiring all of the following except _________. A. Flexibility B. Innovation C. speed D. Repetability

Last Answer : A. Flexibility

Description : Given an open address hash table with load factor a < 1, the expected number of probes in a successful search is (A) Atmost 1/α ln (1-α/α) (B) Atmost 1/α ln (1/1-α) (C) Atleast 1/α ln (1/1-α) (D) Atleast 1/α ln (α/1-α)

Last Answer : (B) Atmost 1/α ln (1/1-α)

Description : For any B-tree of minimum degree t ≥2, every node other than the root must have atleast ............... keys and every node can have at most .............. keys. (A) t-1, 2t+1 (B) t+1, 2t+1 (C) t-1, 2t-1 (D) t+1, 2t-1

Last Answer : (C) t-1, 2t-1 

Description : A computer program selects an integer in the set {k : 1 ≤ k ≤ 10,00,000} at random and prints out the result. This process is repeated 1 million times. What is the probability that the value k = 1 appears in the printout atleast once ? (A) 0.5 (B) 0.704 (C) 0.632121 (D) 0.68

Last Answer : (C) 0.632121

Description : Which of the following is used to make an Abstract class ? (A) Making atleast one member function as pure virtual function (B) Making atleast one member function as virtual function (C) Declaring as Abstract class using virtual keyword (D) Declaring as Abstract class using static keyword

Last Answer : (A) Making atleast one member function as pure virtual function

Description : Which of the following is/are the Database server functions? i) Data management ii) Transaction management iii) Compile queries iv) Query optimization A) i, ii, and iv only B) i, ii and iii only C) ii, iii and iv only D) All i, ii, iii, and iv

Last Answer : A) i, ii, and iv only

Description : Preparedstatement Object in JDBC is used to execute ........................... queries. A) executable B) simple C) high level D) parameterized

Last Answer : D) parameterized

Description : Prepared Statement object in JDBC used to execute........... queries. A) Executable B) Simple C) High level D) Parameterized

Last Answer : D) Parameterized

Description : Which of the following is not the function of client? A) Compile queries B) Query optimization C) Receive queries D) Result formatting and presentation

Last Answer : B) Query optimization

Description : In a relational schema, each tuple is divided into fields called A) Relations B) Domains C) Queries D) All of the above

Last Answer : B) Domains

Description : Consider the table Student(stuid, name, course, marks). Which one of the following two queries is correct to find the highest marks student in course 5? Q.1. Select S.stuid From student S Where not exists (select * from student ... ) Q.1 (B) Q.2 (C) Both Q.1 and Q.2 (D) Neither Q.1 nor Q.2

Last Answer : (B) Q.2 Explanation: First query gives stuid of students whose marks are greater than all students taking course 5. Second query gives stuid of students whose marks are greater than any student taking ... comparison is between maximum of marks by any student in course 5. So the answer is option D.

Description : Consider the following three SQL queries (Assume the data in the people table) : (a) Select Name from people where Age>21; (b) Select Name from people where Height>180; (c) Select Name from people where (Age>21) or (Height ... number of rows returned by the SQL query (c) ? (A) 3 (B) 7 (C) 10 (D) 21

Last Answer : (C) 10

Description : Suppose ORACLE relation R(A, B) currently has tuples {(1, 2), (1, 3), (3, 4)} and relation S(B, C) currently has {(2, 5), (4, 6), (7, 8)}. Consider the following two SQL queries SQ1 and SQ2 ... (A) 2 and 6 respectively (B) 6 and 2 respectively (C) 2 and 4 respectively (D) 4 and 2 respectively

Last Answer : (D) 4 and 2 respectively

Description : Consider the relations R(A,B) and S(B,C) and the following four relational algebra queries over R and S: I. πA,B(R⋈S) II. R⋈πB(S) III. R∩(πA(R) Χ πB(S)) IV. πA,R.B(R Χ S) where R.B refers to ... IV are the same query. (C) I, II and IV are the same query. (D) I, III and III are the same query.

Last Answer : (D) I, III and III are the same query.

Description : Consider a database table R with attributes A and B. Which of the following SQL queries is illegal ? (A) SELECT A FROM R; (B) SELECT A, COUNT(*) FROM R; (C) SELECT A, COUNT(*) FROM R GROUP BY A; (D) SELECT A, B, COUNT(*) FROM R GROUP BY A, B;

Last Answer : (B) SELECT A, COUNT(*) FROM R;

Description : A 'Call' centre means ______________ 1. A place where Salesmen meet everyday 2. A Training Centre 3. A bank office setup where customer queries are answered 4. Customers meeting place 5. All the above

Last Answer : A bank office setup where customer queries are answered

Description : Two basic types of pruning are heading-back and thinning-out. Which of the following is true about these pruning methods? a. Thinning cuts leave behind a good portion of the stem and many axillary buds. ... leave no buds. d. Heading cuts remove a portion of the stem and only terminal buds are lef

Last Answer : Thinning cuts are made close to a main branch or ground and few axillary buds are left

Description : ................ is used in game trees to reduce the number of branches of the search tree to be traversed without affecting the solution. (A) Best first search (B) Goal stack planning (C) Alpha-beta pruning procedure (D) Min-max search

Last Answer : (C) Alpha-beta pruning procedure

Description : What are the advantages of neural networks over conventional computers? (i) They have the ability to learn by example (ii) They are more fault tolerant (iii)They are more suited for real time operation due to their high ... true b) (i) and (iii) are true c) Only (i) d) All of the mentioned

Last Answer : d) All of the mentioned

Description : What are the advantages of neural networks over conventional computers? (i) They have the ability to learn by example (ii) They are more fault tolerant (iii)They are more suited for real time operation due to their high ... true b) (i) and (iii) are true c) Only (i) d) All of the mentioned

Last Answer : d) All of the mentioned

Description : A …………… is an acyclic digraph, which has only one node with indegree 0, and other nodes have indegree 1. A) Directed tree B) Undirected tree C) Dis-joint tree D) Direction oriented tree

Last Answer : A) Directed tree

Description : Which of the following statements is true for Branch-and-Bound search? (A) Underestimates of remaining distance may cause deviation from optimal path. (B) Overestimates can't cause right path to be ... Dynamic programming principle can be used to discard redundant partial paths. (D) All of the above

Last Answer : (C) Dynamic programming principle can be used to discard redundant partial paths.

Description : The travelling salesman problem can be solved in: (A) Polynomial time using dynamic programming algorithm (B) Polynomial time using branch-and-bound algorithm (C) Exponential time using dynamic programming algorithm or branch-andbound algorithm. (D) Polynomial time using backtracking algorithm.

Last Answer : (C) Exponential time using dynamic programming algorithm or branch-andbound algorithm.

Description : Changing the relationship with and services provided to customers in such a way that they will not think of changing suppliers is called …………. A) Lock in customers B) Lock out customers C) Lock in competitors D) Lock out competitors

Last Answer : A) Lock in customers

Description : ............... model is designed to bring prices down by increasing the number of customers who buy a particular product at once. (A) Economic Order Quantity (B) Inventory (C) Data Mining (D) Demand-Sensitive Pricing

Last Answer : (D) Demand-Sensitive Pricing

Description : Consider a CUSTOMERS database table having a column CITY filled with all the names of Indian cities (in capital letters). The SQL statement that finds all cities that have GAR somewhere in its name, ... *from customers where city like %GAR%'; (D) Select *from customers where city as '%GAR';

Last Answer : Answer: C

Description : Which of the following are the functions of operating system? i) recovering from errors ii) facilitating input/output iii) facilitating parallel operation iv) sharing hardware among users v) implementing user interface A) i, ii, ... only C) ii, iii, iv and v only D) All i, ii, iii, iv and v

Last Answer : D) All i, ii, iii, iv and v

Description : ………………. is not an operation performed on linear list Get More Mcqs from http://www.siteforinfotech.com/p/mcqs.html a) Insertion b) Deletion c) Retrieval d) Traversal A) only a,b and c B) only a and b C) All of the above D) None of the above

Last Answer : D) None of the above

Description : Which of the following operation is used if we are interested in only certain columns of a table? (A) PROJECTION (B) SELECTION (C) UNION (D) JOIN

Last Answer : (A) PROJECTION

Description : Which of the following is true ? I. Implementation of self-join is possible in SQL with table alias. II. Outer-join operation is basic operation in relational algebra. III. Natural join and outer join operations are ... (B) II and III are correct. (C) Only III is correct. (D) Only I is correct.

Last Answer : (D) Only I is correct.

Description : A power tiller is most suited for : A. Draft operation with rigid tools B. Rotary cultivation C. Stationary operation D. Transport work

Last Answer : B. Rotary cultivation

Description : Malcolm has come up with the idea of a well -devised system for picking up peoples' cars while they are at work, washing and waxing them, and returning them for a fee. Having been a big ... : A)direct marketing. B)franchising. C)door-to -door retailing. D)licensing. E)speciality retailing.

Last Answer : B)franchising

Description : A farmer in California owns a beautiful pear tree. He supplies the fruit to a nearby grocery store. The store owner has called the farmer to see how much fruit is available for him to purchase. The ... each twig bears one piece of fruit, how many plums will the farmer be able to deliver? -Riddles

Last Answer : None. A pear tree does not bear plums

Description : A farmer owned a beautiful pear tree. He supplies the fruit to a nearby grocery store. The store has called the farmer to see how much fruit is available for him to purchase. The farmer knows that ... each twig bears one piece of fruit, how many plums will the farmer be able to deliver? -Riddles

Last Answer : None. A pear tree does not bear plums.

Description : A farmer in California owns a beautiful pear tree. He supplies the fruit to a nearby grocery store. The store owner has called the farmer to see how much fruit is available for him to purchase. The ... each twig bears one piece of fruit, how many plums will the farmer be able to deliver? -Riddles

Last Answer : None. A pear tree does not bear plums.

Description : Assertion: Paleobiology is that branch which deals with the study of fossil organisms. Reason: Paleobotany and paleozoology are the branches of paleob

Last Answer : Assertion: Paleobiology is that branch which deals with the study of fossil organisms. Reason: Paleobotany and ... D. If both As and R are wrong.

Description : How do the judicial branch check on other branches?

Last Answer : they chec on pother branches by watching themfailklihbkjydfifuhv;dfuigbdlfkhb;ofsugbgfrustrationvxvfh

Description : In the lighting distribution circuit shown in the illustration, if all switches are closed and fuse 'F2' were to open, all lights on branches ____________. EL-0013 A. '1', '2', and '3' would go out B. '1' ... and '3' would burn dimly D. '1' and '3' would go out, while branch '2' would remain lit

Last Answer : Answer: D

Description : The total resistance of a parallel circuit is always ____________. A. larger than that of the branch with the greatest resistance B. smaller than that of the branch with the lowest resistance C ... resistances D. equal to the sum of the individual branch resistances divided by the number of branches

Last Answer : Answer: B

Description : If one branch of a parallel network is shorted, what portion of circuit current flows through the remaining branches?

Last Answer : None.

Description : Consider a circuit with three parallel branches connected across a DC supply. What is the ratio of the branch currents I1 : I2 : I3 if the branch resistances are in the ratio of 2 : 3 : 4 respectively? A) 2 : 3 : 4 B) 6 : 4 : 3 C) 4 : 3 : 2 D) None of these

Last Answer : Consider a circuit with three parallel branches connected across a DC supply. What is the ratio of the branch currents I1 : I2 : I3 if the branch resistances are in the ratio of 2 : 3 : 4 respectively? A) 2 : 3 : 4 B) 6 : 4 : 3 C) 4 : 3 : 2 D) None of these

Description : What is the role of "Ombudsman" in a bank? (1) To provide quality and speedy redressal of grievances of customers. (2) To provide suggestions for innovative schemes in the banks. (3) To ... the branches. (4) To monitor the poverty alleviation programmes under-taken by or implemented by the bank.

Last Answer : (1) To provide quality and speedy redressal of grievances of customers. Explanation: The Banking Ombudsman Scheme enables an expeditious and inexpensive forum to bank customers for resolution of complaints relating ... Section 35 A of the Banking Regulation Act, 1949 by RBI with effect from 1995.