logo

CuriousTab

CuriousTab

Discussion

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

  • If there is only one statement and no ambiguity about what is wanted, Oracle will treat the semicolon and slash as the same.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • True 

    • More questions

    • 1. The SQL statement to create a view is:

    • Options
    • A. CREATE VIEW.
    • B. MAKE VIEW.
    • C. SELECT VIEW.
    • D. INSERT VIEW.
      • Discuss
    • 2. When using the SQL INSERT statement:

    • Options
    • A. rows can be modified according to criteria only.
    • B. rows cannot be copied in mass from one table to another only.
    • C. rows can be inserted into a table only one at a time only.
    • D. rows can either be inserted into a table one at a time or in groups.
      • Discuss
    • 3. An application where only one user accesses the database at a given time 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
    • 4. When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):

    • Options
    • A. transitive dependency.
    • B. insertion anomaly.
    • C. referential integrity constraint.
    • D. normal form.
      • Discuss
    • 5. Which type of entity represents a logical generalization whose actual occurrence is represented by a second, associated entity?

    • Options
    • A. Supertype entity
    • B. Subtype entity
    • C. Archetype entity
    • D. Instance entity
      • Discuss
    • 6. In a one-to-many relationship, the entity that is on the one side of the relationship is called a(n) ________ entity.

    • Options
    • A. parent
    • B. child
    • C. instance
    • D. subtype
      • Discuss
    • 7. Which type of entity represents an actual occurrence of an associated generalized entity?

    • Options
    • A. Supertype entity
    • B. Subtype entity
    • C. Archetype entity
    • D. Instance entity
      • Discuss
    • 8. Which type of entity is related to two or more associated entities that each contain specialized attributes that apply to some but not all of the instances of the entity?

    • Options
    • A. Supertype entity
    • B. Subtype entity
    • C. Archetype entity
    • D. Instance entity
      • Discuss
    • 9. Which JDBC driver Type(s) can you use in a three-tier architecture and if the Web server and the DBMS are running on the same machine?

    • Options
    • A. Type 1 only
    • B. Type 2 only
    • C. Both Type 3 and Type 4
    • D. All of Type 1, Type 2, Type 3 and Type 4
      • Discuss
    • 10. Which type of entity cannot exist in the database unless another type of entity also exists in the database, but does not require that the identifier of that other entity be included as part of its own identifier?

    • Options
    • A. Weak entity
    • B. Strong entity
    • C. ID-dependent entity
    • D. ID- independent entity
      • Discuss

    Comments

    There are no comments.
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.