Home

_____ command can be used to modify a column in a table

A. alter

B. update

C. set

D. create

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

General Biology Set 2 MCQ General Software MCQ Rearrangement Set 2 MCQ Software Engineering MCQ Electro-Chemistry MCQ Respiratory System MCQ Electronics MCQ Alphabetical Series MCQ Direction MCQ Chemical Engineering Plant Economics MCQ Height and Distance MCQ Phylum - Reptilia MCQ

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

Submit
Load More..
You can do it
  1. Cascading rollback is avoided in all protocol except
  2. The relational model is based on the concept that data is organized and stored in two-dimensional tables…
  3. The full form of GUI is _________
  4. Drop Table cannot be used to drop a table referenced by a ______ constraint.
  5. The drawback of shadow paging technique are
  6. The values of the attribute describes a particular
  7. ____specifies a search condition for a group or an aggregate.
  8. A _____ is used to define overall design of the database
  9. Between DRAM and magnetic disk storage another form of memory, called ______ memory is becoming common…
  10. operator is used to compare a value to a list of literals values that have been specified.
  11. Whenever two independent one-to-many relationships are mixed in the same relation, a __________ arises.
  12. Which two files are used during operation of the DBMS?
  13. Which of the following addressing modes permits relocation without any change over in the code?
  14. The set of all values that can be taken by the attribute is called as _______ of the attribute.
  15. Wait-for graph is used for
  16. The cost of reading and writing temporary files while evaluating a query can be reduced by
  17. Which one is true statement :
  18. Immediate database modification technique uses
  19. The ______ indexes are forced to store only record IDs in the data structure and require at least one…
  20. A transaction is in state after the final statement has been executed.
  21. In b-tree the number of keys in each node is than the number of its children.
  22. Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
  23. What is a disjoint less constraint?
  24. An advantage of views is
  25. When an E-R diagram is mapped to tables, the representation is redundant for
  26. _____is a full form of SQL.
  27. Data independence means
  28. SQL server stores index information in the _____system table
  29. ____ table store information about database or about the system.
  30. Which of the following concurrency control schemes is not based on the serializability property?