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 = (Branch-name, Account-number, Customer-name, Balance) Using relational Algebra, the query that finds customers who have balance more than 10,000 is ................. (A) πcustomer-name(σbalance> 10000(Deposit)) (B) σcustomer-name(σbalance> 10000(Deposit)) (C) πcustomer-name(σbalance> 10000(Borrow)) (D) σcustomer-name(σbalance> 10000(Borrow))

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 = (Branch-name, Account-number, Customer-name, Balance)

Using relational Algebra, the query that finds customers who have balance more than 10,000 is .................

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

(B) σcustomer-name(σbalance> 10000(Deposit))

(C) πcustomer-name(σbalance> 10000(Borrow))

(D) σcustomer-name(σbalance> 10000(Borrow))
by

1 Answer

Answer :

(A) πcustomer-name(σbalance> 10000(Deposit)) 
by

Related questions

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 the column B in table R. One can determine that: (A) I, III and IV are the same query. (B) II, III and IV are the same query. (C) I, II and IV are the same query. (D) I, III and III are the same query.

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.

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, is: (A) Select *from customers where city=’%GAR%’; (B) Select *from customers where city=’$GAR$’; (C) Select *from customers where city like ‘%GAR%’; (D) Select *from customers where city as ’%GAR’;

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

The “PROJECT” operator of a relational algebra creates a new table that has always (A) More columns than columns in original table (B) More rows than original table (C) Same number of rows as the original table (D) Same number of columns as the original table

Description : The “PROJECT” operator of a relational algebra creates a new table that has always (A) More columns than columns in original table (B) More rows than original table (C) Same number of rows as the original table (D) Same number of columns as the original table

Last Answer : (C) Same number of rows as the original table

Relational database schema normalization is NOT for: (A) reducing the number of joins required to satisfy a query. (B) eliminating uncontrolled redundancy of data stored in the database. (C) eliminating number of anomalies that could otherwise occur with inserts and deletes. (D) ensuring that functional dependencies are enforced.

Description : Relational database schema normalization is NOT for: (A) reducing the number of joins required to satisfy a query. (B) eliminating uncontrolled redundancy of data stored in the database. (C) ... could otherwise occur with inserts and deletes. (D) ensuring that functional dependencies are enforced. 

Last Answer : reducing the number of joins required to satisfy a query.

Which of the following is not a binary operator in relational algebra? A) Join B) Semi-Join C) Assignment D) Project

Description : Which of the following is not a binary operator in relational algebra? A) Join B) Semi-Join C) Assignment D) Project

Last Answer : D) Project

Cartesian product in relational algebra is (A) a Unary operator. (B) a Binary operator. (C) a Ternary operator. (D) not defined.

Description : Cartesian product in relational algebra is (A) a Unary operator. (B) a Binary operator. (C) a Ternary operator. (D) not defined.

Last Answer : (B) a Binary operator.

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 equivalent. (A) I and II are correct. (B) II and III are correct. (C) Only III is correct. (D) Only I is correct.

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.

The permission given to a bank customer to draw cheques in excess of his current account balance is called - (1) a personal loan (2) an ordinary loan (3) discounting a bill of exchange (4) an overdraft

Description : The permission given to a bank customer to draw cheques in excess of his current account balance is called - (1) a personal loan (2) an ordinary loan (3) discounting a bill of exchange (4) an overdraft

Last Answer : (4) an overdraft Explanation: Overdrafts is an extension of credit from a lending institution when an account reaches zero. An overdraft allows the individual to continue withdrawing money even if the ... available balance goes below zero. In this situation the account is said to be "overdrawn."

The permission given to a bank customer to draw cheques in excess of his current account balance is called (1) a personal loan (2) an ordinary loan (3) discounting a bill of exchange (4) an overdraft

Description : The permission given to a bank customer to draw cheques in excess of his current account balance is called (1) a personal loan (2) an ordinary loan (3) discounting a bill of exchange (4) an overdraft

Last Answer : an overdraft

The relation schemas R1 and R2 form a Lossless join decomposition of R if and only if: (a) R1⋂R2→(R1-R2) (b) R1→R2 (c) R1⋂R2→(R2-R1) (d) R2→R1⋂R2 (A) (a) and (b) happens (B) (a) and (d) happens (C) (a) and (c) happens (D) (b) and (c) happens

Description : The relation schemas R1 and R2 form a Lossless join decomposition of R if and only if: (a) R1⋂R2→(R1-R2) (b) R1→R2 (c) R1⋂R2→(R2-R1) (d) R2→R1⋂R2 (A) (a) and (b) happens (B) (a) and (d) happens (C) (a) and (c) happens (D) (b) and (c) happens

Last Answer : (C) (a) and (c) happens 

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

Description : 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. ( ... atleast one branch in Delhi. (D) customers who have only joint account in any one branch in Delhi

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

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>180); If the SQL queries (a) and (b) above, return 10 rows and 7 rows in the result set respectively, then what is one possible number of rows returned by the SQL query (c) ? (A) 3 (B) 7 (C) 10 (D) 21

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

Is it legal to take a loan from a company when your mobile balance is exhausted ? When we run out of mobile balance, we usually borrow some money from the office. In the eyes of the law, will it be permissible to use that money ?

Description : Is it legal to take a loan from a company when your mobile balance is exhausted ? When we run out of mobile balance, we usually borrow some money from the office. In the eyes of the law, will it be permissible to use that money ?

Last Answer : It is a type of loan. Debt is valid , as evidenced by the Sunnah and Ijma (consensus). [Mughni , Ibn Kudamah , 6/429]

10. Manav needs a loan to set up a small business. On what basis will Manav decide whether to borrow from the bank or the moneylender? Discuss. -Economics 10th

Description : 10. Manav needs a loan to set up a small business. On what basis will Manav decide whether to borrow from the bank or the moneylender? Discuss. -Economics 10th

Last Answer : Manav wants to set up a small business. He needs to keep the below-mentioned things in mind while deciding whether to borrow money from a bank or money lender: He needs to compare the interest ... eligible documents required by the banks to get his loan approved. How he wishes to repay the lender.

Banks in the US, active with the FDIC, only insure $100,000. So if a person has, for example, 10 million dollars and wants to deposit the money in a bank, does he have to look for 100 banks or is there another way to invest that is as low risk as a savings account?

Description : Banks in the US, active with the FDIC, only insure $100,000. So if a person has, for example, 10 million dollars and wants to deposit the money in a bank, does he have to look for 100 banks or is there another way to invest that is as low risk as a savings account?

Last Answer : A person with 10 million dollars probably has a diversified investment portfolio with a variety of risk levels and return levels. As a result, his insurance is that not everything will collapse at the ... 10% above inflation, banks are a very poor choice for someone with lots of money to invest.

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 : SQ1 : Select * From R Full Join S On R.B=S.B; SQ2 : Select * From R Inner Join S On R.B=S.B; The numbers of tuples in the result of the SQL query SQ1 and the SQL query SQ2 are given by : (A) 2 and 6 respectively (B) 6 and 2 respectively (C) 2 and 4 respectively (D) 4 and 2 respectively

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

In a Bank’s database, there are two tables ‘Customer’ and ‘Transaction’ as shown below. Write a query to display customer’s name who has -Technology

Description : In a Bank’s database, there are two tables ‘Customer’ and ‘Transaction’ as shown below. Write a query to display customer’s name who has -Technology

Last Answer : (i) Select cust_name from customer c,transaction t where c.Acc_No=t.Acc_No and Transaction_Type= 'Debit';(ii)Select cust_name, t.* from customer c, transaction t where c.Acc_No=t.Acc_No;(iii) ... total amount of all type of transactions, it will only display the total of credit transactions only.

What is 'Bank rate'? a) The rate at which commercial banks borrow money from RBI b) The rate at which commercial banks lend money to customers c) The rate at which commercial banks lend money to RBI d) none of the above

Description : What is 'Bank rate'? a) The rate at which commercial banks borrow money from RBI b) The rate at which commercial banks lend money to customers c) The rate at which commercial banks lend money to RBI d) none of the above

Last Answer : a) The rate at which commercial banks borrow money from RBI Bank rate is the rate at which commercial banks can borrow money from the RBI. If the rate is higher, then taking money from RBI becomes difficult, so the banks will lend less to public. And vice-versa.

The Aadhaar-Enabled Payment Systems(AEPS) is a bank led model that facilitates banking facilities by allowing transactions at Point of Sale through the Business Correspondent (BC) using the Aadhaar authentication number. Aadhaar enabled basic types of banking do not include A. Balance Enquiry B. Cash Withdrawal C. Online Payment D. Cash Deposit E. Aadhaar to Aadhaar funds transfer

Description : The Aadhaar-Enabled Payment Systems(AEPS) is a bank led model that facilitates banking facilities by allowing transactions at Point of Sale through the Business Correspondent (BC) using the Aadhaar ... . Cash Withdrawal C. Online Payment D. Cash Deposit E. Aadhaar to Aadhaar funds transfer

Last Answer : C. Online Payment Explanation: Services Offered by AEPS: Balance Enquiry Cash Withdrawal Cash Deposit Aadhaar to Aadhaar Fund Transfer Gateway Authentication Services

With regard to the expressive power of the formal relational Query languages, which of the following statements is TRUE?

Description : With regard to the expressive power of the formal relational Query languages, which of the following statements is TRUE?  A) relational algebra is more powerful than relational calculus B) relational ... calculus C) relational algebra has the same power as safe relational calculus D) None of these

Last Answer : relational algebra has the same power as safe relational calculus

A Robber is robbing a bank. He steals all the customer's money when he sees a safe. He threatens the clerk to tell him the code for the safe. She says ' Sorry I can't. The code is changing every day.' But the robber finds out the code. How did he find it out? -Riddles

Description : A Robber is robbing a bank. He steals all the customer's money when he sees a safe. He threatens the clerk to tell him the code for the safe. She says ' Sorry I can't. The code is changing every day.' But the robber finds out the code. How did he find it out? -Riddles

Last Answer : The code is CHANGING everyday.

Up to what amount payment order for withdrawal from saving account may be sanctioned by a branch postmaster? a) Rs 500/- b) Rs 2500/- c) Rs 5000/- d) Rs 10000/

Description : Up to what amount payment order for withdrawal from saving account may be sanctioned by a branch postmaster? a) Rs 500/- b) Rs 2500/- c) Rs 5000/- d) Rs 10000/

Last Answer : c) Rs 5000/

What are the unary operations in Relational Algebra?

Description : What are the unary operations in Relational Algebra?

Last Answer : PROJECTION and SELECTION.

What is Relational Algebra?

Description : What is Relational Algebra?

Last Answer : It is procedural query language. It consists of a set of operations that take one or two relations as input and produce a new relation.

Suppose I borrow money from X and I authorize my bank to make monthly payments directly from my checking account. Now, I want more flexibility by paying either online or by check. X refuses to let me do this. But my bank refuses to "stop payment" on these tranfers even though its my money and it has no obligation to X. What's the law on this?

Description : Suppose I borrow money from X and I authorize my bank to make monthly payments directly from my checking account. Now, I want more flexibility by paying either online or by check. X refuses to let me do ... tranfers even though its my money and it has no obligation to X. What's the law on this?

Last Answer : answer:Hmm, I suppose you're from USA. Don't know the laws there, but here in Slovenia, we handle things like this by calling and yelling at the lady on the other side and things get fixed eventually. But ... what you can't do with you money. I'd threaten them I'm gonna change the bank or smthng.

Which of the following statements concerning Object-Oriented databases is FALSE? (A) Objects in an object-oriented database contain not only data but also methods for processing the data. (B) Object-oriented databases store computational instructions in the same place as the data. (C) Object-oriented databases are more adapt at handling structures (analytical) data than relational databases. (D) Object-oriented databases store more types of data than relational databases and access that data faster.

Description : Which of the following statements concerning Object-Oriented databases is FALSE? (A) Objects in an object-oriented database contain not only data but also methods for processing the data. (B ... Object-oriented databases store more types of data than relational databases and access that data faster.

Last Answer : (C) Object-oriented databases are more adapt at handling structures (analytical) data than relational databases.

In a digital transmission, the receiver clock is 0.1 percent faster than the sender clock. How many extra bits per second does the receiver receive if the data rate is 1 Mbps ? (A) 10 bps (B) 100 bps (C) 1000 bps (D) 10000 bps

Description : In a digital transmission, the receiver clock is 0.1 percent faster than the sender clock. How many extra bits per second does the receiver receive if the data rate is 1 Mbps ? (A) 10 bps (B) 100 bps (C) 1000 bps (D) 10000 bps

Last Answer : (C) 1000 bps 

In the relational modes, cardinality is termed as: (A) Number of tuples. (B) Number of attributes. (C) Number of tables. (D) Number of constraints

Description : In the relational modes, cardinality is termed as: (A) Number of tuples. (B) Number of attributes. (C) Number of tables. (D) Number of constraints

Last Answer : (A) Number of tuples

Let E1 and E2 be two entities in E-R diagram with simple single valued attributes. R1 and R2 are two relationships between E1 and E2 where R1 is one-many and R2 is many-many. R1 and R2 do not have any attributes of their own. How many minimum number of tables are required to represent this situation in the Relational Model? (A) 4 (B) 3 (C) 2 (D) 1

Description : Let E1 and E2 be two entities in E-R diagram with simple single valued attributes. R1 and R2 are two relationships between E1 and E2 where R1 is one-many and R2 is many-many. R1 and R2 do not have any ... are required to represent this situation in the Relational Model? (A) 4 (B) 3 (C) 2 (D) 1

Last Answer : (B) 3 

Let M and N be two entities in an E-R diagram with simple single vale attributes. R1 and R2 are two relationship between M and N, whereas R1 is one-to-many and R2 is many-to-many. The minimum number of tables required to represent M, N, R1 and R2 in the relational model are .......... (1) 4 (2) 6 (3) 7 (4) 3

Description : Let M and N be two entities in an E-R diagram with simple single vale attributes. R1 and R2 are two relationship between M and N, whereas R1 is one-to-many and R2 is many-to-many. The minimum number of tables required to ... and R2 in the relational model are .......... (1) 4 (2) 6 (3) 7 (4) 3

Last Answer : Answer: 4

The period of a signal is 10 ms. What is its frequency in Hertz ? (A) 10 (B) 100 (C) 1000 (D) 10000

Description : The period of a signal is 10 ms. What is its frequency in Hertz ? (A) 10 (B) 100 (C) 1000 (D) 10000

Last Answer : (B) 100

Kirti Co’s Balance Sheet shows Fixed Asset Rs. 3,60,000. At the time of absorption calculation of Net Assets is 10% less than the market value, then market value of such fixed assets is ............ (A) Rs. 3,24,000 (B) Rs. 4,00,000 (C) Rs. 4,20,000 (D) None of these

Description : Kirti Co’s Balance Sheet shows Fixed Asset Rs. 3,60,000. At the time of absorption calculation of Net Assets is 10% less than the market value, then market value of such fixed assets is ............ (A) Rs. 3,24,000 (B) Rs. 4,00,000 (C) Rs. 4,20,000 (D) None of these

Last Answer : (B) Rs. 4,00,000

The relational model is based on the concept that data is organized and stored in two-dimensional tables called ………………………A) Fields B) Records C) Relations D) Keys

Description : The relational model is based on the concept that data is organized and stored in two-dimensional tables called ………………………A) Fields B) Records C) Relations D) Keys

Last Answer : C) Relations

Which of the following is not a logical database structure? A) Chain B) Network C) Tree D) Relational

Description : Which of the following is not a logical database structure? A) Chain B) Network C) Tree D) Relational

Last Answer : A) Chain

A top-to-bottom relationship among the items in a database is established by a A) Hierarchical schema B) Network schema C) Relational Schema D) All of the above

Description : A top-to-bottom relationship among the items in a database is established by a A) Hierarchical schema B) Network schema C) Relational Schema D) All of the above

Last Answer : A) Hierarchical schema

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

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

A relational database developer refers to a record as (A) a criteria. (B) a relation. (C) a tuple. (D) an attribute.

Description : A relational database developer refers to a record as (A) a criteria. (B) a relation. (C) a tuple. (D) an attribute.

Last Answer : C) a tuple

In a relational model, relations are termed as (A) Tuples. (B) Attributes (C) Tables. (D) Rows.

Description : In a relational model, relations are termed as (A) Tuples. (B) Attributes (C) Tables. (D) Rows.

Last Answer : (C) Tables

If D1, D2,…. Dn are domains in a relational model, then the relation is a table, which is a subset of (A) D1+D2+…. +Dn (B) D1x D2x… xDn (C) D1U D2U….UDn (D) D1- D2-….-Dn

Description : If D1, D2,…. Dn are domains in a relational model, then the relation is a table, which is a subset of (A) D1+D2+…. +Dn (B) D1x D2x… xDn (C) D1U D2U….UDn (D) D1- D2-….-Dn

Last Answer : (B) D1x D2x… xDn

Which of the following is not a type of Database Management System? (A) Hierarchical (B) Network (C) Relational (D) Sequential

Description : Which of the following is not a type of Database Management System? (A) Hierarchical (B) Network (C) Relational (D) Sequential 

Last Answer : (D) Sequential

In a relational database model, NULL values can be used for all but which one of the following? (A) To allow duplicate tuples in the table by filling the primary key column(s) with NULL. (B) To avoid confusion with actual legitimate data values like 0 (zero) for integer columns and ‘’ (the empty string) for string columns. (C) To leave columns in a tuple marked as “unknown” when the actual value is unknown. (D) To fill a column in a tuple when that column does not really “exist” for that particular tuple.

Description : In a relational database model, NULL values can be used for all but which one of the following? (A) To allow duplicate tuples in the table by filling the primary key column(s) with NULL. (B) To ... D) To fill a column in a tuple when that column does not really exist for that particular tuple.

Last Answer : (A) To allow duplicate tuples in the table by filling the primary key column(s) with NULL.

How can a firm provide a margin of safety if it cannot borrow on short notice to meet its needs? A. Maintain a low level of current assets (especially cash and marketable securities). B. Shorten the maturity schedule of financing. C. Increasing the level of fixed assets (especially plant and equipmentD. Lengthening the maturity schedule of financing

Description : How can a firm provide a margin of safety if it cannot borrow on short notice to meet its  needs? A. Maintain a low level of current assets (especially cash and marketable securities) ... the level of fixed assets (especially plant and equipment D. Lengthening the maturity schedule of financing

Last Answer : D. Lengthening the maturity schedule of financing

Assume that the required ratio is 10 percent and bank receives $1,000 deposit. What is the excess reserves ? (a) $100 (b) $9,000 (c) $900 (d) $10,000

Description : Assume that the required ratio is 10 percent and bank receives $1,000 deposit. What is the excess reserves ? (a) $100 (b) $9,000 (c) $900 (d) $10,000

Last Answer : (c) $900

Fixed assets are double the current assets and half the capital. The current assets are Rs.3,00,000 andinvestments are Rs.4,00,000. Then the current liabilities recorded in balance sheet will be a) 2,00,000 b) 1,00,000 c) 3,00,000 d) 4,00,000

Description : Fixed assets are double the current assets and half the capital. The current assets are Rs.3,00,000 andinvestments are Rs.4,00,000. Then the current liabilities recorded in balance sheet will be a) 2,00,000 b) 1,00,000 c) 3,00,000 d) 4,00,000

Last Answer : b) 1,00,000

Mark the correct option a) Withdrawal will be allowed 50% deposited amount in RD account after one year and after 12 monthly deposit. b) No withdrawal is allowed in discontinued RD accounts c) 10% interest will be charged on loan amount d) If the repayment with interest is made on or before the 10th of the month, no interest shall be payable for that monthe) All the above

Description : Mark the correct option a) Withdrawal will be allowed 50% deposited amount in RD account after one year and after 12 monthly deposit. b) No withdrawal is allowed in discontinued RD accounts c) 10% interest ... the 10th of the month, no interest shall be payable for that month e) All the above

Last Answer : e) All the above