Home

A _____ is used to define overall design of the database

A. code

B. data definition language

C. application program

D. schema

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

You can do it
  1. Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are
  2. By ______ an area on disk in certain ways, one can make it represent a bit value of either zero (0)…
  3. For using a specific database …………… command is used.
  4. As per equivalence rules for query transformation, selection operation distributes over
  5. An advantage of the database management approach is
  6. _____ is a utility to capture a continuous record of server activity and provide auditing capability.
  7. The keyword to eliminate duplicate rows from the query result in SQL is
  8. The division operator divides a dividend A of degree m+n by a divisor relation B of degree n and produces…
  9. Tree structures are used to store data in
  10. In SQL, testing whether a subquery is empty is done using
  11. A list consists of last names, first names, addresses and pin codes. If all people in the list have…
  12. Relational Algebra does not have
  13. ____specifies a search condition for a group or an aggregate.
  14. Drop Table cannot be used to drop a table referenced by a ______ constraint.
  15. Cascading rollback is avoided in all protocol except
  16. The collection of information stored in a database at a particular moment is called as ......
  17. Which of the following aggregate functions does not ignore nulls in its results?.
  18. Relations produced from an E-R model will always be
  19. If the closure of an attribute set is the entire relation then the attribute set is a
  20. An outstanding functionality of SQL is its support for automatic_____ to the target data.
  21. The fact that all employees of a particular organization should not have salaries more than $10000 is…
  22. Which of the following is not a characteristic of a relational database model?
  23. A _____ is a logical unit of database processing that includes one or more data access operations that…
  24. DBMS helps achieve
  25. E-R Modeling is achieved by using ____ diagrams
  26. What is a disjoint less constraint?
  27. In multiple granularity of locks SIX lock is compatible with
  28. The clause alter table in SQL can be used to
  29. _____clause is an additional filter that is applied to the result.
  30. Which of the following is not a consequence of concurrent operations?