The cost of reading and writing temporary files while evaluating a query can be reduced by
building indices
pipelining
join ordering
none of the above
Also checkout these categories
Stocks and Shares MCQ Networking MCQ p-Block Element MCQ Airport Engineering MCQ The Living World MCQ Rearrangement Set 11 MCQ Nuclear Chemistry MCQ C++ Programming MCQ Alkyl and Aryl Halides MCQ Industrial Engineering & Production Management Test MCQ Permutation MCQ Chemical Engineering Plant Economics MCQ
- _____is a full form of SQL.
- The collection of information stored in a database at a particular moment is called as ......
- Grant and revoke are _____ statements.
- It is an abstraction through which relationships are treated as higher level entities
- A weak entity has an ______ dependency on its owner entity, which can be used for both ON UPDATE and…
- Processed data is called _____
- In an E-R diagram double lines indicate
- If both the functional dependencies : Xï®Y and Yï®X hold for two attributes X and Y then the relationship…
- The default level of consistency in SQL is
- The fact that information in the data warehouse changes far less often and may be regarded as non-real-time…
- Checkpoints are a part of
- Which of the following relational algebraic operations is not from set theory?
- Which two files are used during operation of the DBMS?
- The normalization was first proposed by .
- Which one is correct statement?Logical data independence provides following without changing application…
- The ______ language consists of SQL statements for operating on the data (insert, Modify, Delete) in…
- Which of the following is not a logical database structure?
- ____specifies a search condition for a group or an aggregate.
- A ______ module is typically designed so that it will run on a user workstation or personal computer.
- If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
- Key to represent relationship between tables is called
- The _______ is a set of programs to use and / or modify this data.
- Relations produced from an E-R model will always be
- Wait-for graph is used for
- A _____ is used to define overall design of the database
- _____clause is an additional filter that is applied to the result.
- Which is the best file organization when data is frequently added or deleted from a file?
- The data models defined by ANSI/SPARC architecture are
- A data type or format is specified for each _________
- Which of the following aggregate functions does not ignore nulls in its results?.