logo

CuriousTab

CuriousTab

Discussion

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

  • Which of the following is not true of SQL views?


  • Options
  • A. Oracle views cannot use the ORDER BY clause in view definitions.
  • B. Oracle views are created using the standard SQL-92 CREATE VIEW command.
  • C. Oracle views can by queried.
  • D. The SQL-92 standard does not allow the use of the ORDER BY clause in view definitions.

  • Correct Answer
  • Oracle views cannot use the ORDER BY clause in view definitions. 

    • More questions

    • 1. If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.

    • Options
    • A. the primary key
    • B. any alternate key
    • C. a surrogate key
    • D. a foreign key
      • Discuss
    • 2. Multiple inheritance allows a class to inherit features from more than one superclass.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. A database design may be based on existing data.

    • Options
    • A. True
    • B. False
      • Discuss
    • 4. If both data and database administration exist in an organization, the database administrator is responsible for which of the following?

    • Options
    • A. Data modeling
    • B. Database design
    • C. Metadata
    • D. All of the above.
      • Discuss
    • 5. The degree of a relationship refers to the number of entity classes in the relationship.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. After a table has been created, its structure can be modified using the SQL command:

    • Options
    • A. UPDATE TABLE [TableName].
    • B. MODIFY TABLE [TableName].
    • C. ALTER TABLE [TableName].
    • D. CHANGE TABLE [TableName].
      • Discuss
    • 7. Which statement about sequences is not true?

    • Options
    • A. A sequence is an object that generates a sequential series of unique numbers.
    • B. Sequences are most often used to provide values for surrogate keys.
    • C. NextVal and CurrVal are both sequence methods.
    • D. Sequences guarantee valid surrogate key values.
      • Discuss
    • 8. Of the three ways to create an Oracle database, which one is the easiest and most recommended?

    • Options
    • A. Using the Oracle Database Configuration Assistant.
    • B. Using the Oracle-supplied database creation procedures.
    • C. Using the SQL CREATE DATABASE command.
    • D. None of the above is correct.
      • Discuss
    • 9. JDBC stands for:

    • Options
    • A. Java Database Connectivity
    • B. Java Database Components
    • C. Java Database Control
    • D. None of the above is correct.
      • Discuss
    • 10. What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles?

    • Options
    • A. Full backup
    • B. Consistent backup
    • C. Inconsistent backup
    • D. Differential backup
      • Discuss

    Comments

    There are no comments.
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.