logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ Database Redesign See What Others Are Saying!
  • Question

  • What SQL command can be used to delete columns from a table?


  • Options
  • A. MODIFY TABLE TableName DROP COLUMN ColumnName
  • B. MODIFY TABLE TableName DROP ColumnName
  • C. ALTER TABLE TableName DROP COLUMN ColumnName
  • D. ALTER TABLE TableName DROP ColumnName

  • Correct Answer
  • ALTER TABLE TableName DROP COLUMN ColumnName 

    • More questions

    • 1. What SQL command can be used to add columns to a table?

    • Options
    • A. MODIFY TABLE TableName ADD COLUMN ColumnName
    • B. MODIFY TABLE TableName ADD ColumnName
    • C. ALTER TABLE TableName ADD COLUMN ColumnName
    • D. ALTER TABLE TableName ADD ColumnName
      • Discuss
    • 2. A homogenous distributed database is which of the following?

    • Options
    • A. The same DBMS is used at each location and data are not distributed across all nodes.
    • B. The same DBMS is used at each location and data are distributed across all nodes.
    • C. A different DBMS is used at each location and data are not distributed across all nodes.
    • D. A different DBMS is used at each location and data are distributed across all nodes.
      • Discuss
    • 3. For some relations, changing the data can have undesirable consequences called:

    • Options
    • A. referential integrity constraints.
    • B. modification anomalies.
    • C. normal forms.
    • D. transitive dependencies.
      • Discuss
    • 4. An on-line commercial site such as Amazon.com is an example of a(n) ________ .

    • Options
    • A. single-user database application
    • B. multiuser database application
    • C. e-commerce database application
    • D. data mining database application
      • Discuss
    • 5. Location transparency allows for which of the following?

    • Options
    • A. Users to treat the data as if it is at one location
    • B. Programmers to treat the data as if it is at one location
    • C. Managers to treat the data as if it is at one location
    • D. All of the above.
      • Discuss
    • 6. Which of the following is not one of the three ways to classify an action assertion?

    • Options
    • A. Condition
    • B. Integrity Control
    • C. Authorization
    • D. Enabler
      • Discuss
    • 7. Every key used to join the fact table with a dimensional table should be a surrogate key.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. Which of the following is true concerning a global transaction?

    • Options
    • A. The required data are at one local site and the distributed DBMS routes requests as necessary.
    • B. The required data are located in at least one nonlocal site and the distributed DBMS routes requests as necessary.
    • C. The required data are at one local site and the distributed DBMS passes the request to only the local DBMS.
    • D. The required data are located in at least one nonlocal site and the distributed DBMS passes the request to only the local DBMS.
      • Discuss
    • 9. An operational system is which of the following?

    • Options
    • A. A system that is used to run the business in real time and is based on historical data.
    • B. A system that is used to run the business in real time and is based on current data.
    • C. A system that is used to support decision making and is based on current data.
    • D. A system that is used to support decision making and is based on historical data.
      • Discuss
    • 10. In a one-to-many relationship, the entity that is on the many side of the relationship is called a(n) ________ entity.

    • Options
    • A. parent
    • B. child
    • C. instance
    • D. subtype
      • Discuss

    Comments

    There are no comments.
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.