GATE Data Science & AI
130 questions · 3 years · 13 subjects
Public preview: use this branch page to find high-signal topics and keyed questions. Explanations are being added selectively, starting with recent and recurring concepts.
Subjects
By Year
High-yield topics
All trends →Practice Data Science & AI PYQs
7 questions shown in Database Management System and Warehousing. Filter for cleaner practice sessions.
Consider the following two relations, named Customer and Person, in a database: Person ( aadhaar CHAR(12) PRIMARY KEY, name VARCHAR(32)); Customer ( name VARCHAR(32), email VARCHAR...
Consider a database relation $R$ with attributes ABCDEFG , and having the following functional dependencies: $$ \mathrm{A} \rightarrow \mathrm{BCEF} \quad \mathrm{E} \rightarrow \m...
If a relational decomposition is not dependency-preserving, which one of the following relational operators will be executed more frequently in order to maintain the dependencies?
Consider the following three relations: Car (model, year, serial, color) Make (maker, model) Own (owner, serial) A tuple in Car represents a specific car of a given model, made in...
Consider the following tables, Loan and Borrower, of a bank. Loan loan_num branch_name amount L11 Banjara Hills 90000 L14 Kondapur 50000 L15 SR Nagar 40000 L22 SR Nagar 25000 L23 B...
Consider a fact table in an OLAP application: Facts (D1, D2, val), where D1 and D2 are its dimension attributes and val is a dependent attribute. Suppose attribute D1 takes 3 value...
$$ \text { On a relation named Loan of a bank: } $$ Loan Loan_number Branch_name Amount L11 Banjra Hills 90000 L14 Kondapur 50000 L15 SR Nagar 4000 L22 SR Nagar 25000 L23 Balanagar...