Home

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

Please do not use chat terms. Example: avoid using "grt" instead of "great".

You can do it
  1. _____is a full form of SQL.
  2. The collection of information stored in a database at a particular moment is called as ......
  3. Grant and revoke are _____ statements.
  4. It is an abstraction through which relationships are treated as higher level entities
  5. A weak entity has an ______ dependency on its owner entity, which can be used for both ON UPDATE and…
  6. Processed data is called _____
  7. In an E-R diagram double lines indicate
  8. If both the functional dependencies : XY and YX hold for two attributes X and Y then the relationship…
  9. The default level of consistency in SQL is
  10. The fact that information in the data warehouse changes far less often and may be regarded as non-real-time…
  11. Checkpoints are a part of
  12. Which of the following relational algebraic operations is not from set theory?
  13. Which two files are used during operation of the DBMS?
  14. The normalization was first proposed by .
  15. Which one is correct statement?Logical data independence provides following without changing application…
  16. The ______ language consists of SQL statements for operating on the data (insert, Modify, Delete) in…
  17. Which of the following is not a logical database structure?
  18. ____specifies a search condition for a group or an aggregate.
  19. A ______ module is typically designed so that it will run on a user workstation or personal computer.
  20. If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
  21. Key to represent relationship between tables is called
  22. The _______ is a set of programs to use and / or modify this data.
  23. Relations produced from an E-R model will always be
  24. Wait-for graph is used for
  25. A _____ is used to define overall design of the database
  26. _____clause is an additional filter that is applied to the result.
  27. Which is the best file organization when data is frequently added or deleted from a file?
  28. The data models defined by ANSI/SPARC architecture are
  29. A data type or format is specified for each _________
  30. Which of the following aggregate functions does not ignore nulls in its results?.