Home

In SQL, testing whether a subquery is empty is done using

A. DISTINCT

B. UNIQUE

C. NULL

D. EXISTS

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

You can do it
  1. Relational Algebra does not have
  2. Which of the following is not a logical database structure?
  3. The language that requires a user to specify the data to be retrieved without specifying exactly how…
  4. Which of the following statement on the view concept in SQL is invalid?
  5. The cost of reading and writing temporary files while evaluating a query can be reduced by
  6. Change Staff table by removing default of Assistant for position column
  7. In SQL, testing whether a subquery is empty is done using
  8. Grant and revoke are _____ statements.
  9. Which of the following concurrency control schemes is not based on the serializability property?
  10. The _______ is a set of programs to use and / or modify this data.
  11. Create a table with the following attributes: Employee(EMPNO integer, EMPNAME of 10 characters)
  12. ____ table store information about database or about the system.
  13. Which of the following is a reason to model data?
  14. Cascading rollback is avoided in all protocol except
  15. What is a disjoint less constraint?
  16. Between DRAM and magnetic disk storage another form of memory, called ______ memory is becoming common…
  17. Shadow paging has
  18. For correct behaviour during recovery, undo and redo operation must be
  19. ____specifies a search condition for a group or an aggregate.
  20. In multiple granularity of locks SIX lock is compatible with
  21. Relationships among relationships can be represented in an-E-R model using
  22. The rule that a value of a foreign key must appear as a value of some specific table is called a
  23. The values of the attribute describes a particular
  24. Which one is correct statement?Logical data independence provides following without changing application…
  25. By ______ an area on disk in certain ways, one can make it represent a bit value of either zero (0)…
  26. Wait-for graph is used for
  27. ______is a preferred method for enforcing data integrity
  28. An outstanding functionality of SQL is its support for automatic_____ to the target data.
  29. The part of a database management system which ensures that the data remains in a consistent state is
  30. Which of the syntax is correct for insert statement? i) insert into values ii) insert into (column list)…