logo

CuriousTab

CuriousTab

Discussion


Home Database Introduction to SQL See What Others Are Saying!
  • Question
  • The command to eliminate a table from a database is:


  • Options
  • A. REMOVE TABLE CUSTOMER;
  • B. DROP TABLE CUSTOMER;
  • C. DELETE TABLE CUSTOMER;
  • D. UPDATE TABLE CUSTOMER;

  • Correct Answer
  • DROP TABLE CUSTOMER; 


  • More questions

    • 1. The object-oriented development life cycle is which of the following?

    • Options
    • A. Analysis, design, and implementation steps in the given order and using multiple iterations.
    • B. Analysis, design, and implementation steps in the given order and going through the steps no more than one time.
    • C. Analysis, design, and implementation steps in any order and using multiple iterations.
    • D. Analysis, design, and implementation steps in any order and going through the steps no more than one time.
    • Discuss
    • 2. The SQL command to create a table is:

    • Options
    • A. MAKE TABLE.
    • B. ALTER TABLE.
    • C. DEFINE TABLE.
    • D. CREATE TABLE.
    • Discuss
    • 3. A class is a concept, abstraction, or thing that makes sense in an application context.

    • Options
    • A. True
    • B. False
    • Discuss
    • 4. A ________ is a program that performs some common action on database data and that is stored in the database.

    • Options
    • A. trigger
    • B. stored procedure
    • C. pseudofile
    • D. None of the above is correct.
    • Discuss
    • 5. Which of the following is an advantage of partitioning?

    • Options
    • A. Complexity
    • B. Inconsistent access speed
    • C. Extra space
    • D. Security
    • Discuss
    • 6. An entity class is a collection of entities and is described by the structure of the entities in that class.

    • Options
    • A. True
    • B. False
    • Discuss
    • 7. An attribute that names or identifies entity instances is a(n):

    • Options
    • A. entity.
    • B. attribute.
    • C. identifier.
    • D. relationship.
    • Discuss
    • 8. In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed.

    • Options
    • A. Read committed
    • B. Read uncommitted
    • C. Repeatable read
    • D. Serializable
    • Discuss
    • 9. Which of the following occurs when a transaction rereads data and finds new rows that were inserted by a command transaction since the prior read?

    • Options
    • A. Nonrepeatable read
    • B. Phantom read
    • C. Dirty read
    • D. Consistent read
    • Discuss
    • 10. Business Intelligence (BI) reporting systems cannot do which of the following operations?

    • Options
    • A. Filter data
    • B. Group data
    • C. Modify data
    • D. Both filter and group data
    • Discuss


    Comments

    There are no comments.

Enter a new Comment