If a relational decomposition is not dependency-preserving, which one of the following relational operators will be executed more …
Consider the following three relations: Car (model, year, serial, color) Make (maker, model) Own (owner, serial) A tuple in Car re…
On a relation named Loan of a bank: The following SQL query is executed: SELECT L1.loan_number FROM Loan L1 WHERE L1.amount \(>\) …
Consider a fact table in an OLAP application: Facts(D1, D2, val), where D1 and D2 are its dimension attributes and val is a depend…
Consider the following two relations, named Customer and Person, in a database: Which of the following statements is/are correct?
Consider the following tables of a bank. | Loan number | Branch name | Amount | | --- | --- | --- | | L11 | Banjara Hills | 90000…
Free account benefits
Public PYQs and reference pages stay free. Sign in when you want GATEverse to remember what you studied and guide what to practise next.