Home

The clause alter table in SQL can be used to

A. add an attribute

B. delete an attribute

C. alter the default values of an attribute

D. all of the above

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

You can do it
  1. Which one is correct statement?Logical data independence provides following without changing application…
  2. ______is a special type of integrity constraint that relates two relations & maintains consistency across…
  3. The fact that all employees of a particular organization should not have salaries more than $10000 is…
  4. ______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.
  5. ______ keyword is used to find the number of values in a column.
  6. Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are
  7. In 2NF
  8. According to the levels of abstraction, the schema at the intermediate level is called
  9. Drop Table cannot be used to drop a table referenced by a ______ constraint.
  10. Change Staff table by removing default of Assistant for position column
  11. In SQL the statement select * from R, S is equivalent to
  12. The _______ is a set of programs to use and / or modify this data.
  13. As per equivalence rules for query transformation, selection operation distributes over
  14. ______is a preferred method for enforcing data integrity
  15. The full form of GUI is _________
  16. Isolation of the transactions is ensured by
  17. Data independence means
  18. _____is a full form of SQL.
  19. Data items grouped together for storage purposes are called a
  20. A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer…
  21. In an ER model,_____ is described in the database by storing its data.
  22. A relational database developer refers to a record as
  23. The division operator divides a dividend A of degree m+n by a divisor relation B of degree n and produces…
  24. A list consists of last names, first names, addresses and pin codes. If all people in the list have…
  25. The statement that is executed automatically by the system as a side effect of the modification of the…
  26. Whenever two independent one-to-many relationships are mixed in the same relation, a __________ arises.
  27. A _____ is used to define overall design of the database
  28. The drawback of shadow paging technique are
  29. The normal form that is not necessarily dependency preserving is
  30. A data type or format is specified for each _________