Home

Change Staff table by removing default of Assistant for position column

A. ALTER TABLE Staff ALTER position DROP DEFAULT;

B. ALTER TABLE Staff ALTER position DEFAULT;

C. ALTER TABLE Staff ALTER DROP DEFAULT;

D. MODIFY Staff ALTER position DROP DEFAULT;

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

You can do it
  1. A ____ key specifies a uniqueness constraint that no two distinct tuples in any state r of relation…
  2. Which normal form is considered adequate for normal relational database design?
  3. The one guideline to be followed while designing the database is
  4. Relational Algebra is
  5. Protection of data from unauthorized Disclosure results in loss of _______
  6. The common column is eliminated in
  7. Cascading rollback is avoided in all protocol except
  8. A top-to-bottom relationship among the items in a database is established by a
  9. Which of the following is not a recovery technique?
  10. Which of the following constitutes a basic set of operations for manipulating relational data?
  11. DFD stands for
  12. If an entity can belong to only one lower level entity then the constraint is
  13. The rule that a value of a foreign key must appear as a value of some specific table is called a
  14. The relational model is based on the concept that data is organized and stored in two-dimensional tables…
  15. Which of the following statement on the view concept in SQL is invalid?
  16. DROP is a statement in SQL.
  17. Relationships among relationships can be represented in an-E-R model using
  18. _____ command can be used to modify a column in a table
  19. Employees in a company are each assigned their own office, i.e. for each employee there exists a unique…
  20. Which of the following relational algebraic operations is not from set theory?
  21. Relations produced from an E-R model will always be
  22. The transactions like adding an employee, enrolling a student in a course are examples of _______
  23. The normalization was first proposed by .
  24. In a multi-user database, if two users wish to update the same record at the same time, they are prevented…
  25. The part of a database management system which ensures that the data remains in a consistent state is
  26. ______is a preferred method for enforcing data integrity
  27. What is a disjoint less constraint?
  28. In an ER model,_____ is described in the database by storing its data.
  29. If both the functional dependencies : XY and YX hold for two attributes X and Y then the relationship…
  30. Change Staff table by removing default of Assistant for position column