logo

CuriousTab

CuriousTab

Discussion


Home Database Object-Oriented Database Comments

  • Question
  • Using ODL, you can define which of the following?


  • Options
  • A. Attribute
  • B. Structure
  • C. Operation
  • D. All of the above.

  • Correct Answer
  • All of the above. 


  • Object-Oriented Database problems


    Search Results


    • 1. ODL supports which of the following types of association relationships?

    • Options
    • A. Unary
    • B. Unary and Binary
    • C. Unary and Binary and Ternary
    • D. Unary and Binary and Ternary and higher
    • Discuss
    • 2. Which of the following is true concerning an ODBMS?

    • Options
    • A. They have the ability to store complex data types on the Web.
    • B. They are overtaking RDBMS for all applications.
    • C. They are most useful for traditional, two-dimensional database table applications.
    • D. All of the above.
    • Discuss
    • 3. An extent is which of the following?

    • Options
    • A. A keyword that indicates that the subclass inherits from a superclass
    • B. A keyword that indicates that the superclass inherits from a subclass
    • C. The set of all instances of a class within a database
    • D. Only one instance of a class within a database
    • Discuss
    • 4. Which of the following is true concerning the following statement: class Manager extends Employee

    • Options
    • A. Manager is a concrete class and a superclass.
    • B. Manager is a concrete class and a subclass.
    • C. Manager is an abstract class and a superclass.
    • D. Manager is an abstract class and a subclass.
    • Discuss
    • 5. Identify the class name for the following code: ABC123 course();

    • Options
    • A. ABC123
    • B. course
    • C. course()
    • D. All of the above.
    • Discuss
    • 6. A view is which of the following?

    • Options
    • A. A virtual table that can be accessed via SQL commands
    • B. A virtual table that cannot be accessed via SQL commands
    • C. A base table that can be accessed via SQL commands
    • D. A base table that cannot be accessed via SQL commands
    • Discuss
    • 7. In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:

    • Options
    • A. all columns of the table are to be returned.
    • B. all records meeting the full criteria are to be returned.
    • C. all records with even partial criteria met are to be returned.
    • D. None of the above is correct.
    • Discuss
    • 8. 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;
    • Discuss
    • 9. A subquery in an SQL SELECT statement:

    • Options
    • A. can only be used with two tables.
    • B. can always be duplicated by a join.
    • C. has a distinct form that cannot be duplicated by a join.
    • D. cannot have its results sorted using ORDER BY.
    • Discuss
    • 10. To define what columns should be displayed in an SQL SELECT statement:

    • Options
    • A. use FROM to name the source table(s) and list the columns to be shown after SELECT.
    • B. use USING to name the source table(s) and list the columns to be shown after SELECT.
    • C. use SELECT to name the source table(s) and list the columns to be shown after USING.
    • D. use USING to name the source table(s) and list the columns to be shown after WHERE.
    • Discuss


    Comments

    There are no comments.

Enter a new Comment