logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ Managing Databases with Oracle See What Others Are Saying!
  • Question

  • Which of the following is not true about modifying table columns?


  • Options
  • A. You can drop a column at any time.
  • B. You can add a column at any time as long as it is a NULL column.
  • C. You can increase the number of characters in character columns or the number of digits in numeric columns
  • D. You cannot increase or decrease the number of decimal places.

  • Correct Answer
  • You cannot increase or decrease the number of decimal places. 

    • More questions

    • 1. A time stamp is a time value that is associated with a data value.

    • Options
    • A. True
    • B. False
      • Discuss
    • 2. Database objects are almost always transient.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. In ODBC, a file that can be shared among database users is called a:

    • Options
    • A. system data source.
    • B. file data source.
    • C. user data source.
    • D. SQL text file.
      • Discuss
    • 4. What is an SQL virtual table that is constructed from other tables?

    • Options
    • A. Just another table
    • B. A view
    • C. A relation
    • D. Query results
      • Discuss
    • 5. ________ was adopted as a national standard by ANSI in 1992.

    • Options
    • A. Oracle
    • B. SQL
    • C. Microsoft Access
    • D. DBase
      • Discuss
    • 6. The most popular way to materialize XML documents is to use:

    • Options
    • A. DTD.
    • B. XSLT.
    • C. HTML.
    • D. SOAP.
      • Discuss
    • 7. When the parent entity is required, a new parent row can always be inserted.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. Table is synonymous with the term:

    • Options
    • A. record.
    • B. relation.
    • C. column.
    • D. field.
      • Discuss
    • 9. Proper normalization eliminates duplicated data.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. JDBC stands for Java Database Connectivity

    • Options
    • A. True
    • B. False
      • Discuss

    Comments

    There are no comments.
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.