Earn $100 Online Daily. Work From Home. Click Here

What is the correct answer?


The cost of reading and writing temporary files while evaluating a query can be reduced by

A. building indices

B. pipelining

C. join ordering

D. none of the above

Related Questions

Which one is true statement : The concept of mapping of ______ entity types is the concept in which… Immediate database modification technique uses The common column is eliminated in The metadata is created by the Which of the following relational algebra operations do not require the… Drop Table cannot be used to drop a table referenced by a ______ constraint. The normalization was first proposed by . A table can have only one operator is used to compare a value to a list of literals values that… Data independence means A _____ is a logical unit of database processing that includes one or… In a relational schema, each tuple is divided into fields called Key to represent relationship between tables is called Which of the following concurrency control schemes is not based on the… An outstanding functionality of SQL is its support for automatic_____… The division operator divides a dividend A of degree m+n by a divisor… Which two files are used during operation of the DBMS? DBMS helps achieve If a transaction T has obtained an exclusive lock on item Q, then T can SQL server stores index information in the _____system table Use of UNIQUE while defining an attribute of a table in SQL means that… HSAM stands for ………. The _______ is a set of programs to use and / or modify this data. The full form of GUI is _________ A list consists of last names, first names, addresses and pin codes. If… If two relations R and S are joined, then the non matching tuples of both… Relations produced from an E-R model will always be The statement that is executed automatically by the system as a side effect… In E-R Diagram total participation is represented by