logo

CuriousTab

CuriousTab

Discussion


Home Certification Oracle Certification Comments

  • Question
  • What is an Oracle index?


  • Correct Answer
  • An index is an optional structure associated with a table to have direct access to rows, which can be created to increase the performance of data retrieval Index can be created on one or more columns of a table 

  • Tags: Database Administrator

    Oracle Certification problems


    Search Results


    • 1. What command would you use to create a backup control file?
    • Discuss
    • 2. How many joining conditions are required to join 4 tables in SQL?

    • Options
    • A. 1
    • B. 2
    • C. 3
    • D. 4
    • Discuss
    • 3. What are the different types of SQL statements ?
    • Discuss
    • 4. In R-DBMS, the data is organized in the form of _____.

    • Options
    • A. Hierarchical structure
    • B. Tabular structure
    • C. Linked structure
    • D. All of the above
    • Discuss
    • 5. Insert command falls in which sub-language of SQL ?

    • Options
    • A. DCL
    • B. DQL
    • C. DML
    • D. DDL
    • Discuss
    • 6. What is the default return value of a function?

    • Options
    • A. int
    • B. char
    • C. string
    • D. None of the above
    • Discuss
    • 7. what will be the output of the following code? class Value { public int i = 15; } public class Test { public static void main(String argv[]) { Test t = new Test(); t.first(); } public void first() { int i = 5; Value v = new Value(); v.i = 25; second(v, i); System.out.println(v.i); } public void second(Value v, int i) { i = 0; v.i = 20; Value val = new Value(); v = val; System.out.println(v.i + " " + i); } }

    • Options
    • A. 15 0 2
    • B. 15 0 0
    • C. 15 20 0
    • D. 15 0 20
    • Discuss
    • 8. MOV extension refers usually to what kind of files?

    • Options
    • A. Audio
    • B. Movies or other Videos
    • C. Images
    • D. Documents
    • Discuss
    • 9. Explain Data Control Language
    • Discuss
    • 10. Which among the following keys are used to identify each row of the table uniquely?

    • Options
    • A. Primary key
    • B. Unique key
    • C. Partial key
    • D. None of the above
    • Discuss


    Comments

    There are no comments.

Enter a new Comment