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;

Share this question with your friends

Correct Answer : A.


Download Objective type questions of DBMS PDF

Visit our PDF store

Get all objective type questions of DBMS MCQ

Also checkout these categories

Course of Action MCQ Microsoft Excel MCQ Windows 2000 Server MCQ Change of State MCQ Viruses MCQ Animal Kingdom MCQ Problems on Trains MCQ Fluid Mechanics MCQ Machine Input MI MCQ Rearrangement Set 8 MCQ General Biology Set 2 MCQ Fungi and Lichens MCQ

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

Submit
Load More..
You can do it
  1. Which of the following is true for network structure?
  2. _____ database is used to provide statistical information or summaries of values based on various criteria.
  3. In multiple granularity of locks SIX lock is compatible with
  4. The data models defined by ANSI/SPARC architecture are
  5. The size of a data item is called its _______, which can be a field of some record or may be a larger…
  6. The set of all values that can be taken by the attribute is called as _______ of the attribute.
  7. In an E-R diagram double lines indicate
  8. Wait-for graph is used for
  9. Which of the following relational algebra operations do not require the participating tables to be union-compatible?
  10. Precedence graphs help to find a
  11. DBMS helps achieve
  12. Which of the following is not a characteristic of a relational database model?
  13. In a multi-user database, if two users wish to update the same record at the same time, they are prevented…
  14. Immediate database modification technique uses
  15. If a transaction T has obtained an exclusive lock on item Q, then T can
  16. By ______ an area on disk in certain ways, one can make it represent a bit value of either zero (0)…
  17. Which one is true statement :
  18. A table can have only one
  19. Which of the following addressing modes permits relocation without any change over in the code?
  20. The values of the attribute describes a particular
  21. A list consists of last names, first names, addresses and pin codes. If all people in the list have…
  22. If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
  23. What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are…
  24. DBMS is a collection of _____ that enables user to create and maintain a database.
  25. Which normal form is considered adequate for normal relational database design?
  26. Which of the following ensures the atomicity of the transaction?
  27. A _____ is used to define overall design of the database
  28. A data type or format is specified for each _________
  29. The clause in SQL that specifies that the query result should be sorted in ascending or descending order…
  30. As per equivalence rules for query transformation, selection operation distributes over