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

You can do it
  1. Data items grouped together for storage purposes are called a
  2. In a multi-user database, if two users wish to update the same record at the same time, they are prevented…
  3. The division operator divides a dividend A of degree m+n by a divisor relation B of degree n and produces…
  4. Which of the following is not a logical database structure?
  5. The transactions like adding an employee, enrolling a student in a course are examples of _______
  6. ______is a special type of integrity constraint that relates two relations & maintains consistency across…
  7. DBMS is a collection of _____ that enables user to create and maintain a database.
  8. Drop Table cannot be used to drop a table referenced by a ______ constraint.
  9. What is data integrity?
  10. Precedence graphs help to find a
  11. In a relational schema, each tuple is divided into fields called
  12. An outstanding functionality of SQL is its support for automatic_____ to the target data.
  13. Union operator is a :
  14. Which one is true statement :
  15. Wait-for graph is used for
  16. Which normal form is considered adequate for normal relational database design?
  17. As per equivalence rules for query transformation, selection operation distributes over
  18. HSAM stands for ……….
  19. The ______ language consists of SQL statements for operating on the data (insert, Modify, Delete) in…
  20. In an ER model,_____ is described in the database by storing its data.
  21. A ______ module is typically designed so that it will run on a user workstation or personal computer.
  22. The data in the database at a particular moment of time is called the _______
  23. The cost of reading and writing temporary files while evaluating a query can be reduced by
  24. _____ command can be used to modify a column in a table
  25. Which of the following aggregate functions does not ignore nulls in its results?.
  26. If an entity can belong to only one lower level entity then the constraint is
  27. A relation is in attribute of other composite key. if an attribute of a composite key is dependent on…
  28. In SQL, testing whether a subquery is empty is done using
  29. The data models defined by ANSI/SPARC architecture are
  30. What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are…