If nested loop join is done on a per block basis rather than on a per tuple basis, it is called as(a) Equi join(b) Hash join(c) Nested loop join(d) Block nested loop joinI have been asked this question in a job interview.I want to ask this question from Join and Other Operations in section Query Processing and Optimization of RDBMS

If nested loop join is done on a per block basis rather than on a per

1.	If nested loop join is done on a per block basis rather than on a per tuple basis, it is called as(a) Equi join(b) Hash join(c) Nested loop join(d) Block nested loop joinI have been asked this question in a job interview.I want to ask this question from Join and Other Operations in section Query Processing and Optimization of RDBMS
Answer» Right option is (d) BLOCK nested loop JOIN The explanation is: If nested loop join is done on a per block basis rather than on a per tuple basis, it is called as Block nested loop join. Within each PAIR of blocks, every tuple in one block is paired with every tuple in the other block to generate all POSSIBLE COMBINATIONS.

Discussion

No Comment Found

Related InterviewSolutions

If a query is optimized without providing specific values for its parameters the technique is called __________(a) Complex query handling(b) Multi query optimization(c) Complex query optimization(d) Parametric query optimizationI had been asked this question during an interview.My query is from Materialized Views and Advanced Topics in Query Optimization in section Query Processing and Optimization of RDBMS
Which of the following is a multi-query optimization technique(a) Shared scan optimization(b) Parametric query optimization(c) Index optimization(d) All of the mentionedThe question was asked during an interview.I want to ask this question from Materialized Views and Advanced Topics in Query Optimization topic in chapter Query Processing and Optimization of RDBMS
Reducing the complexity of complex queries by similarly handling sub-queries is known as ______(a) Complex query handling(b) Multi query optimization(c) Complex query optimization(d) Parametric query optimizationThis question was addressed to me in semester exam.The query is from Materialized Views and Advanced Topics in Query Optimization topic in portion Query Processing and Optimization of RDBMS
The problem of an update affecting the execution of a query associated with the update is known as the _________(a) Updation problem(b) Incremental problem(c) Halloween problem(d) Optimization problemThe question was posed to me by my college professor while I was bunking the class.Enquiry is from Materialized Views and Advanced Topics in Query Optimization topic in section Query Processing and Optimization of RDBMS
The sequence of queries that reflect the typical load on the system are known as ________(a) Efficacies(b) Workload(c) Selection(d) BalancersThis question was posed to me during an interview.My enquiry is from Materialized Views and Advanced Topics in Query Optimization in division Query Processing and Optimization of RDBMS
What are differentials in view management?(a) The differences between relations(b) The changes made to a relation(c) Thechanges made to an expression(d) More than one of the mentionedI had been asked this question in a national level competition.This question is from Materialized Views and Advanced Topics in Query Optimization in section Query Processing and Optimization of RDBMS
Which of the following is a type of materialized view management?(a) Incremental view management(b) Immediate view management(c) Deferred view management(d) All of the mentionedThe question was asked in an interview.Question is from Materialized Views and Advanced Topics in Query Optimization topic in chapter Query Processing and Optimization of RDBMS
What is incremental materialized view maintenance?(a) Modifying all the parts of the view(b) Modifying only the affected parts of the view(c) Not modifying the view(d) None of the mentionedThis question was addressed to me in an interview.I'm obligated to ask this question of Materialized Views and Advanced Topics in Query Optimization topic in chapter Query Processing and Optimization of RDBMS
The task of keeping a view up to date with the underlying data is called as ________(a) View handling(b) View maintenance(c) View management(d) None of the mentionedThis question was addressed to me during an internship interview.I'm obligated to ask this question of Materialized Views and Advanced Topics in Query Optimization in chapter Query Processing and Optimization of RDBMS
A view whose contents are computed and stored is called as _______(a) Storage view(b) Backup view(c) Materialized view(d) Advanced viewI got this question in an online interview.My doubt stems from Materialized Views and Advanced Topics in Query Optimization in portion Query Processing and Optimization of RDBMS

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment